|
|
STPURCHORD FILE
Standard Purchase Order Master
This file contains standard PO header information. Three types (skeletal,
standing, and blanket) can be used to create actual purchase orders.
REFERENCED BY
CX05.1 DR100 IC12.1 IC140 IC141 IC142
IC522 IC523 IC524 IC525 IC526 IC83.1
PC120 PC20.1 PC540 PO117 PO120 PO121
PO123 PO17.1 PO216 PO217 PO225 PO226
PO26.1 PO31.1 RQ10.1 RQ10.3 RQ11.1 RQ35.1
RQ500 SEA3.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
MA00.1 MA00.3 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE830 OE950
PO220 PO223 WH130 WH132 WH190 WH222
WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3
WH32.1 WH32.2 WH32.3 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 WO132 WO140 AP10.1 AP10.2 AP300
PO29.1 PO590 PO227 POA3.1 POA2.1
UPDATED BY
BL92.1 IN20.1 MA300 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE510 OE810 OE920 PO100
PO150 PO20.1 PO21.1 PO21.6 PO22.1 PO22.2
PO22.3 PO25.1 PO25.2 PO25.3 PO25.4 PO28.3
PO28.5 PO28.7 PO28.8 PO30.1 PO33.1 PO35.1
PO530 PO821 RQ20.1 RQ20.3 RQ20.4 WH20.2
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SPO-COMPANY Numeric 4 PO150 PO25.1
Company The company number. PO25.3 PO25.4
SPO-ORDER-NAME Alpha 10 PO150 PO25.1
Standard Order Name The user-defined standard order name. PO25.3 PO25.4
SPO-STD-ORD-TYPE Alpha 1 PO150 PO25.1
Standard Order Type This is the code or name for the
standard order type.
A Contract order is used to define a
contractual agreement with a vendor,
storing the contract number, dates, and
item costs associated with the contract.
Costs on contract orders are used to
automatically default costs to purchase
order lines when purchase orders are
created. Contract numbers are assigned
at the purchase order line level.
An override order is a contract order
that is used only with specific
requesting locations. Override orders
are assigned to requesting locations in
PO17.1 (Purchase Override Entry).
Override orders do not have a priority
assigned on PO25.1 (Standard Order),
since priority is assigned in PO17.1
(Purchase Override Entry). When a
requesting location requisitions items
that are on an override order assigned
to the location, the system will
automatically create a purchase order
for the items, regardless of the item
type. Purchasing overrides are the
highest level of price defaulting.
Contract orders may also be set up as
purchasing overrides in PO17.1 (Purchase
Override Entry). These contracts will
continue to participate in the normal
contract price defaulting as well.
A Skeletal order is used as a template
to create new purchase orders.
Statistics are not accumulated and a
purchase order number is not assigned to
the skeletal order, nor are release
numbers assigned to new purchase orders
created from skeletal orders.
A Blanket order is used most often to
define a contractual, authorized order
where statistics are maintained and
contracts can be defined. Purchase
orders created from a blanket order are
assigned a purchase order release number
to identify each one created from the
blanket order.
A standing (X) order is generally used
for cyclical services (e.g. utilities).
This order retains the purchase order
number while the system updates the
release number for each order released
against it. Statistics are not
maintained.
Note: If you enter a B (Blanket), C
(Contract) or O (Override) the system
transfers you to a Contract/Blanket
Detail subform so you can enter the
additional information that is
required. If you do not enter B, C, or O
the system transfers you to Standard
Speed to enter line detail.
B = Blanket
C = Contract
S = Skeleton
X = Standing
O = Override
SPO-PO-NUMBER Alpha 7 (Right Justified) PO25.1
PO This field contains the number
representing the purchase order.
SPO-LAST-PO-REL Numeric 6 BL92.1 IN20.1
Last Std Order The release number of the last purchase OE10.1 OE10.2
Release Number order release created from this order. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
PO22.1 PO22.3
PO25.1 RQ20.1
RQ20.3 RQ20.4
WH20.2 WH20.7
SPO-LAST-LINE-NBR Numeric 6 PO150 PO25.2
Last Line Number The last line number for lines on this
order.
SPO-BUYER-CODE Alpha 3 PO150 PO25.1
Buyer Code The user defined buyer identifier.
SPO-CURRENCY-CODE Alpha 5 PO150 PO25.1
Currency Code The base currency defined for the PO25.3
company in the General Ledger system.
SPO-CURR-TRAN-ND Numeric 1 PO150 PO25.1
Currency Transaction currency number of decimals. PO25.3
Transaction Nbr Dec
SPO-ENT-CNV-RATE Signed 12.6 PO150 PO25.1
Entered Conversion Currency conversion rate at purchase PO25.3
Rate order entry time.
SPO-PRIORITY Numeric 1 PO150 PO25.1
Priority Number Indicates order of precedence for
contracts to determine costing defaults
for items.
SPO-STOCKLESS-FL Alpha 1 PO25.1
Stockless Flag Determines whether or not stockless
processing is used. If Y (Yes) is
selected, stockless processing will be
used. If N (No) is selected, stockless
processing will not be used.
Y = Yes
N = No
SPO-ZERO-RATE-FL Alpha 1 PO150 PO25.1
Zero Rate Flag Entered currency conversion rate will PO25.3
be zero upon standard purchase order
entry.
N = No
Y = Yes
SPO-CURR-SET-FLAG Alpha 1 PO150 PO25.1
Currency Set Flag Flag defines when the currency rate has PO25.3
been set for the purchase order.
E = Entry
R = Receiving
I = Invoice
SPO-CURRENCY-FLAG Alpha 1 PO150 PO25.1
Currency Flag Conversion Method for Currency - PO25.3
Multiply/Divide.
M = Multiply
D = Divide
SPO-REVALUE-FLAG Alpha 1 PO150 PO25.1
Revalue Currency will be re-evaluated when PO25.3
Accounts Payable prints check in a
currency other than established on the
purchase order/invoice.
Y = Yes
N = No
SPO-DESCRIPTION Alpha 30 (Lower Case) PO150 PO25.1
Description This field contains the description.
SPO-DESCRIPTION2 Alpha 30 (Lower Case) PO25.1
Second Description This field contains the second line of
the description.
SPO-PRINT-DESC Alpha 30 (Lower Case) PO25.1
Print Description Standard order print description.
SPO-LOCATION Alpha 5 PO150 PO25.1
Ship To This field contains a valid stock
location within the company inventory.
SPO-VENDOR Alpha 9 PO150 PO25.1
Vendor ID The vendor's identification code.
SPO-PURCH-FR-LOC Alpha 4 PO150 PO25.1
Purchase From The vendor's purchase from location.
Location Code
SPO-FREIGHT-TERMS Alpha 1 PO150 PO25.1
Freight Terms Freight terms are used to define who
pays for freight costs incurred when
goods are shipped. Prepaid, for
instance, would normally mean that the
vendor would pay for freight. Collect
would mean the customer would pay for
freight.
A freight terms code can be entered on
a purchase order, or defaulted by vendor
or company.
SPO-FOB-CODE Alpha 2 PO150 PO25.1
Shipping Term Code The user-defined free on board code.
SPO-FOB-DESC Alpha 30 (Lower Case) PO150 PO25.1
Shipping Term The shipping term description.
Description
SPO-TAX-CODE Alpha 10 PO25.1 PO25.3
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
SPO-DFLT-TAXBL-FL Alpha 1 PO25.1 PO25.3
Default Taxable Flag This taxable flag is used for
defaulting a 'Y'es, 'N'o into Special
and Service items when applying them to
a purchase order. Non-stock and
Inventory items will have this flag
defined in the Inventory Control system.
Y = Yes
N = No
SPO-QUOTE Numeric 6
Quote Not in use.
SPO-PROCESS-LEVEL Alpha 5 PO25.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
SPO-CONTRACT-NBR Alpha 14 PO150 PO25.1
Contract Number This field contains a number to
indicate to the vendor which price
agreement an item or items are operating
under.
If this number is entered on or
defaulted to a purchase order line, it
is an indication of the vendor contract
that line is tied to. The contract
number can be defaulted to the purchase
order line by leaving the field blank
when creating the purchase order and
having the system attempt to find a
contract number from a contract type
standard order based on the item number
for the line and vendor for the purchase
order.
If no contract number is entered on or
defaulted to the line from a contract
type standard order, a contract number
entered on the purchase order header
will default to the line.
A contract number can also be tied to a
blanket type standard order, and any
purchase orders created from the blanket
order will have the contract number from
the blanket on the header and lines.
The contract number can also be
defaulted to a requisition line as the
requisition line is created. The
contract number will then be carried
over to the purchase order line that is
created from the requisition line.
SPO-LETTER-OF-CR Alpha 20 PO25.1
Letter of Credit This field contains the letter of
credit.
SPO-HDR-COMM-CODE Alpha 4 Occurs 2 Times PO25.1
Header Comment Code Last two standard comments added to
this standard order as header comments.
SPO-TRL-COMM-CODE Alpha 4 Occurs 2 Times PO25.1
Trailer Comment Code Last two standard comments added to
this standard order as trailer comments.
SPO-PURCH-MAJCL Alpha 4
Major Purchasing The user-defined major purchasing class
Class identifier.
SPO-PURCH-MINCL Alpha 4
Minor Purchasing The user-defined minor purchasing class
Class identifier.
SPO-BEG-PO-DATE Numeric 8 (yyyymmdd) PO150 PO220
Beginning PO The beginning effective date for this PO25.1 PO25.3
Effective Date contract or blanket order.
SPO-END-PO-DATE Numeric 8 (yyyymmdd) PO150 PO220
Ending PO Effective The ending effective date for this PO25.1 PO25.3
Date contract or blanket order.
SPO-BLKT-MAX-AMT Signed 15.2 PO25.1 PO25.3
Blanket Maximum Enter an amount in this field to define
Amount the maximum amount allowed to be ordered
against this blanket order or blanket
order line for the duration of the
blanket. If the amount is exceeded, an
error message will display when
attempting to release the purchase order
release, and it must be released through
PO22.1 (Authorization/Release).
SPO-ORD-MIN-AMT Signed 15.2 PO25.1 PO25.3
Order Minimum Amount This field defines the minimum dollar
amount allowed on a single purchase
order release from this blanket order.
If the total amount of the purchase
order release is less than this minimum,
an error message will display when
attempting to release the purchase order
release. It must then be released
through PO22.1 (Authorization/Release).
SPO-ORD-MAX-AMT Signed 15.2 PO25.1 PO25.3
Order Maximum Amount This field defines the maximum dollar
amount allowed on a single purchase
order release from this blanket order.
If the total amount on the purchase
order exceeds this amount, an error
message will display when attempting to
release the purchase order release. It
must then be released through PO22.1
(Authorization/Release).
SPO-BLKT-ORDERED Signed 15.2 OE10.1 OE10.2
Blanket Ordered To This field displays the total amount in OE10.3 OE10.4
Date dollars ordered on purchase orders OE10.5 OE10.6
against this standard order. OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 PO20.1
PO21.1 PO21.6
PO22.2 PO22.3
PO220 PO25.1
PO30.1 PO33.1
RQ20.1 RQ20.4
WH20.2 WH20.7
SPO-TOT-PRD-AMT Signed 15.2 PO25.2 PO28.5
Total Product Amount This is the total product amount
associated with the standard purchase
order.
SPO-QTY-BRK-FL Alpha 1 PO150 PO25.1
Quantity Break Flag If this flag is Y, the quantity breaks PO25.3
entered for this blanket order apply to
the quantities order to date. If coded
N, the quantity breaks entered for this
blanket order apply to each order
release.
N = No
Y = Yes
SPO-HOLD-FLAG Alpha 1 PO150 PO25.1
On Hold Flag If the standard order hold flag is PO25.3
coded Y, the order is on hold and
purchase orders cannot be created from
this order.
N = Active
Y = On hold
SPO-EDI-STD-FLAG Alpha 1 PO150
Edi Std Flag Defines if the standard order is to be
transmitted via EDI
Y = Yes
N = No
SPO-LAST-HDR-SEQ Numeric 3 PO25.1 PO28.7
Last Header Comment Sequence number of the last header
Sequence comment line entered for this standard
order.
SPO-LAST-TRLR-SEQ Numeric 3 PO25.1 PO28.7
Last Trailer The sequence number of the last comment
Comment Sequence trailer line entered for this standard
order.
SPO-PO-USER-FLD-1 Alpha 1 PO25.1
Purchase Order User Purchase order header user field one.
Field 1
SPO-PO-USER-FLD-3 Alpha 10 (Lower Case) PO25.1
Purchase Order User Purchase order header user field two.
Field 3
SPO-PO-USER-FLD-5 Alpha 30 (Lower Case) PO25.1
Purchase Order User Purchase order header user field three.
Field 5
SPO-AMOUNT-CL-FL Alpha 1
Amount Closed Flag Not in use.
SPO-CAPITATION-FL Alpha 1 PO25.1
Capitation Fl For Contract type standard orders,
enter a "Y" in this field if the
contract is a capitation type contract.
Y = Yes
N = No
SPO-REVIEW-DATE Numeric 8 (yyyymmdd) PO25.1
Review Date Enter a value in this field for
Contract type standard orders to
indicate what date the contract should
be reviewed.
STPURCHORD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SPOSET1 COMPANY BL92.1 CX05.1
ORDER-NAME DR100 IC12.1
IC140 IC141
IC142 IC522
IC523 IC524
IC525 IC526
IC83.1 PC120
PC20.1 PC540
IN20.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
...
SPOSET2 COMPANY Subset BL92.1 CX100
PO-NUMBER Where STD-ORD-TYPE = "B" CX20.1 CX20.2
Or STD-ORD-TYPE = "X" CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 IN20.1
MA00.1 MA00.3
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
...
SPOSET3 COMPANY KeyChange AP10.1 AP10.2
VENDOR AP300 MA300
ORDER-NAME PO29.1
SPOSET4 COMPANY KeyChange PO120 PO123
BUYER-CODE PO590
ORDER-NAME
SPOSET5 COMPANY Subset BL92.1 IN20.1
CONTRACT-NBR Where STD-ORD-TYPE = "C" OE10.1 OE10.2
VENDOR OE10.3 OE10.4
ORDER-NAME OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 PO21.1
...
SPOSET6 COMPANY Subset BL92.1 CX05.1
VENDOR Where STD-ORD-TYPE = "C" DR100 IC140
ORDER-NAME IC141 IC142
IC522 IC523
IC524 IC525
IC526 IC83.1
PC120 PC20.1
PC540 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
...
STPURCHORD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
SPO-COMPANY -> CPY-COMPANY
Buyer BUYER Required
SPO-COMPANY -> BUY-COMPANY
SPO-BUYER-CODE -> BUY-BUYER-CODE
Fobcode FOBCODE Required
SPO-COMPANY -> FOB-COMPANY
SPO-FOB-CODE -> FOB-FOB-CODE
Iccompany ICCOMPANY Required
SPO-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
SPO-COMPANY -> ICL-COMPANY
SPO-LOCATION -> ICL-LOCATION
Pocompany POCOMPANY Required
SPO-COMPANY -> PCY-COMPANY
Pofrtterms POFRTTERM Required
SPO-COMPANY -> POF-COMPANY
SPO-FREIGHT-TERMS -> POF-FREIGHT-TERMS
Povendor POVENDOR Required
SPO-COMPANY -> POV-COMPANY
SPO-VENDOR -> POV-VENDOR
Std Hdrcomment STCOMMCODE Required
When SPO-HDR-COMM-CODE != Spaces
SPO-COMPANY -> SCM-COMPANY
SPO-HDR-COMM-CODE -> SCM-COMMENT-CODE
Std Trlcomment STCOMMCODE Required
When SPO-TRL-COMM-CODE != Spaces
SPO-COMPANY -> SCM-COMPANY
SPO-TRL-COMM-CODE -> SCM-COMMENT-CODE
Vendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
SPO-VENDOR -> VEN-VENDOR
STPURCHORD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hdr Comments POCOMMENTS Delete Cascades
SPO-COMPANY -> POC-COMPANY
SPO-ORDER-NAME -> POC-ORDER-NAME
Zeroes -> POC-RETURN-NUMBER
Spaces -> POC-PO-NUMBER
Zeroes -> POC-PO-RELEASE
Zeroes -> POC-LINE-NBR
POC-SEQ
Poaocdtl POAOCDTL
SPO-COMPANY -> PAO-COMPANY
SPO-ORDER-NAME -> PAO-ORDER-NAME
SPO-PO-NUMBER -> PAO-PO-NUMBER
PAO-PO-RELEASE
PAO-LINE-NBR
PAO-AOC-CODE
Purchorder PURCHORDER Delete Restricted
SPO-COMPANY -> PCR-COMPANY
SPO-PO-NUMBER -> PCR-PO-NUMBER
PCR-PO-RELEASE
Spomiscaocdtl POAOCDTL
SPO-COMPANY -> PAO-COMPANY
SPO-ORDER-NAME -> PAO-ORDER-NAME
Spaces -> PAO-PO-NUMBER
Zeroes -> PAO-PO-RELEASE
Zeroes -> PAO-LINE-NBR
PAO-AOC-CODE
Stpoline STPOLINE Delete Cascades
SPO-COMPANY -> SPL-COMPANY
SPO-ORDER-NAME -> SPL-ORDER-NAME
SPL-LINE-NBR
Trlr Comments POCOMMENTS Delete Cascades
SPO-COMPANY -> POC-COMPANY
SPO-ORDER-NAME -> POC-ORDER-NAME
Zeroes -> POC-RETURN-NUMBER
Spaces -> POC-PO-NUMBER
Zeroes -> POC-PO-RELEASE
999999 -> POC-LINE-NBR
POC-SEQ
|