STPOLINE FILE
Standard PO Line Items
This file contains line items for a standard purchase order.
REFERENCED BY
DR100 IC141 IC142 IC83.1 PO120 PO123
PO225 PO227 RQ10.1 RQ10.3 RQ11.1 RQ35.1
RQ500 CX05.1 IC11.1 IC12.1 IC140 IC522
IC523 IC524 IC525 IC526 PC120 PC20.1
PC540 PO100 PO216 PO26.1 PO31.1 SEA3.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 PO121
PO125 PO150 PO20.1 PO21.1 PO21.6 PO22.2
PO22.3 PO25.1 PO25.2 PO28.3 PO28.4 PO28.5
PO28.6 PO28.7 PO28.8 PO30.1 PO33.1 PO35.1
PO530 PO821 PO990 RQ20.1 RQ20.4 WH20.2
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SPL-COMPANY Numeric 4 PO150 PO25.2
Company The company number. PO28.5 PO28.8
SPL-ORDER-NAME Alpha 10 PO150 PO25.1
Standard Order Name The user-defined standard order name. PO25.2 PO28.5
PO28.8
SPL-LINE-NBR Numeric 6 PO150 PO25.2
Line Number This field contains the line number. PO28.5
SPL-ITEM-TYPE Alpha 1 PO25.2
Item Type This field identifies the line item
type.
I = Inventory
S = Service
X = Special
N = Non-stock
SPL-ITEM Alpha 32 PO150 PO25.2
Item Number This field contains the item
identifier.
SPL-DESCRIPTION Alpha 30 (Lower Case) PO125 PO150
Description This field contains the description. PO25.2
SPL-ENT-BUY-UOM Alpha 4 PO150 PO25.1
Entered Buy Unit Of Entered Buy Unit Of Measure. PO25.2
Measure
SPL-EBUY-UOM-MULT Signed 13.7 PO150 PO25.1
Entered Buy UOM Entered buy unit of measure conversion PO25.2 PO33.1
Multiplier multiplier.
SPL-VPRI-UOM Alpha 4 PO150 PO25.1
Vendor Price Unit This is the vendor pricing unit of PO25.2
of Measure measure.
SPL-VPRI-UOM-MULT Signed 13.7 PO150 PO25.1
Vendor Price UOM This is the vendor pricing unit of PO25.2
Multiplier measure multiplier. It is used to
convert unit cost to stock unit of
measure terms.
SPL-QUANTITY Signed 13.4 PO25.2
Quantity The standard order quantity for this
line item.
SPL-VPRI-QUANTITY Signed 13.4 PO25.2
Vendor Price The entered line quantity system
Quantity converted to vendor pricing terms.
SPL-ENT-UNIT-CST Signed 13.5 PO150 PO25.2
Entered Unit Cost This is the unit cost agreed upon with PO28.5
the vendor under the terms of the
standard order. It will default to any
purchase order lines created from the
standard order unless it is overridden.
If the unit cost field on the standard
order is blank, normal purchase order
unit cost defaults will apply.
SPL-DIST-CODE Alpha 9 PO28.6
Distribution Code A user-defined code that may be used to
set up common distribution attributes.
SPL-BLANKET-QTY Signed 13.4 BL92.1 IN20.1
Blanket Quantity Ordered To Date Quantity. 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
PO20.1 PO21.1
PO21.6 PO22.2
PO22.3 PO25.1
PO30.1 PO33.1
PO821 RQ20.1
RQ20.4 WH20.2
WH20.7
SPL-BLANKET-COST Signed 15.2 OE10.1 OE10.2
Blanket Cost This displays the amount in dollars OE10.3 OE10.4
that has been ordered to date on OE10.5 OE10.6
purchase orders against this standard OE10.7 OE10.8
order line. 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
PO25.1 PO30.1
PO33.1 RQ20.1
RQ20.4 WH20.2
WH20.7
SPL-BLKT-MAX-QTY Signed 13.4 PO25.1 PO28.3
Blanket Maximum Enter a quantity in this field to
Quantity define the maximum quantity allowed to
be ordered from this blanket order line
for the duration of the blanket. If the
quantity 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).
SPL-BLKT-MAX-AMT Signed 15.2 PO25.1 PO28.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).
SPL-REL-MIN-QTY Signed 13.4 PO25.1 PO28.3
Release Minimum The minimum quantity per release for
Quantity this blanket order line item.
SPL-REL-MAX-QTY Signed 13.4 PO25.1 PO28.3
Release Maximum Maximum quantity per order.
Quantity
SPL-REL-MIN-AMT Signed 15.2 PO25.1 PO28.3
Release Minimum The minimum amount per release for this
Amount blanket order line item.
SPL-REL-MAX-AMT Signed 15.2 PO25.1 PO28.3
Release Maximum The maximum amount per release for this
Amount blanket order line item.
SPL-DISC-QTY Signed 9.0 Occurs 5 Times PO25.1 PO28.5
Discount Quantity Discount quantity used on the standard
purchase order.
SPL-DISC-COST Signed 13.5 Occurs 5 Times PO25.1 PO28.5
Discount Unit Cost This is the discount (quantity break)
unit cost for the Quantity field in the
Quantity Breaks subform. To open the
subform, choose the PO25.2 (Standard
Order Lines) More button and then choose
the Quantity Brks button.
SPL-NO-CHARGE-FL Alpha 1 PO150 PO25.2
No Charge Flag The no charge flag for this line item. PO28.3
N = Charge
Y = No charge
SPL-TAX-CODE Alpha 10 PO25.2 PO28.3
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
SPL-TAXABLE-FLAG Alpha 1 PO150 PO25.2
Taxable or Defines if taxable. PO28.3
Non-Taxable Flag Y = Yes, taxable
N = No, not taxable
SPL-OSHIP-TOL-PCT Percent 5.3 (Percent) PO28.4
Overshipment Quantity overshipment tolerance
Tolerance Percent percentage.
SPL-USHIP-TOL-PCT Percent 6.3 (Percent) PO28.4
Cancel Backorder This is the quantity undership
Percent percentage for automatic back order
cancellation. If a value of 10% is
entered here, for instance, and a
quantity of 91 is shipped against an
ordered quantity of 100, that would be
considered a 9% undershipment. Since
this is less than the 10% limit, the
backordered amount would be canceled.
This process takes place at receiving
time. If a backorder is not canceled
manually, the system checks, in order,
the purchase order line, the purchase
order vendor purchase from record, the
purchase order vendor record, and the
company record. If an undershipment
percentage of a zero percent flag set to
Y is encountered at any level, that
value is used.
NOTE-The percentage can be set at 100%,
which would cancel all backorders.
SPL-COST-TOL-PCT Percent 5.3 (Percent) PO28.4
Unit Cost Tolerance This is the unit cost tolerance percent.
Percent
SPL-COMMENT-CODE Alpha 4 Occurs 2 Times
Comment Code Entering a standard comment code will
copy the standard comments setup in
purchase order into the requisition
header comment file.
SPL-LAST-COMM-SEQ Numeric 3 PO28.7
Last Comment The last comment line sequence number
Sequence Number for comments for this line item.
SPL-LAST-DST-SEQ Numeric 3 PO25.2 PO28.6
Last Distribution The last distribution line sequence PO990
Sequence Nbr number for this line item.
SPL-ZERO-OSHIP-FL Alpha 1 PO150 PO28.4
Zero Overshipment The line tolerance zero overshipment
Flag flag.
N = No
Y = Yes
SPL-ZERO-USHIP-FL Alpha 1 PO150 PO28.4
Zero Undershipment This is the line tolerance zero
Flag undershipment flag.
N = No
Y = Yes
SPL-ZERO-COST-FL Alpha 1 PO150 PO28.4
Zero Cost Flag Zero unit cost line tolerance flag.
N = No
Y = Yes
SPL-EXCL-AOC-SPRD Alpha 1 PO150 PO25.2
Exclude from AOC Exclude this line item from the add-on PO28.8
Spread Method cost spread methods.
N = Include in the Spread
Y = Do not include in the Spread
SPL-PO-USER-FLD-2 Alpha 2 PO25.2
Purchase Order User Purchase order line user defined field.
Field 2
SPL-PO-USER-FLD-4 Alpha 30 (Lower Case) PO25.2
Purchase Order User Purchase order line user defined field.
Field 4
SPL-PO-USER-FLD-6 Alpha 15 (Lower Case) PO25.2
Purchase Order User Purchase order line user defined field.
Field 6
SPL-AMOUNT-CL-FL Alpha 1
Amount Closed Flag Not in use.
STPOLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SPLSET1 COMPANY DR100 IC141
ORDER-NAME IC142 IC83.1
LINE-NBR MA300 PO120
PO121 PO123
PO22.2 PO22.3
PO225 PO227
PO25.1 PO25.2
PO28.3 PO28.4
PO28.5 PO28.6
PO28.7 PO28.8
PO990 RQ10.1
RQ10.3 RQ11.1
RQ20.1 RQ20.3
RQ20.4 RQ35.1
RQ500 WH20.7
SPLSET2 COMPANY KeyChange BL92.1 CX05.1
ITEM DR100 IC11.1
ITEM-TYPE IC12.1 IC140
ORDER-NAME 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
...
SPLSET3 COMPANY KeyChange BL92.1 CX05.1
ORDER-NAME DR100 IC140
ITEM IC141 IC142
LINE-NBR 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 OE113
...
STPOLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
SPL-COMPANY -> CPY-COMPANY
Buyer BUYER Required
SPL-COMPANY -> BUY-COMPANY
SPO-BUYER-CODE -> BUY-BUYER-CODE
Iccompany ICCOMPANY Required
SPL-COMPANY -> ICC-COMPANY
Itemloc ITEMLOC Required
When SPL-ITEM-TYPE = "I"
SPL-COMPANY -> ITL-COMPANY
SPO-LOCATION -> ITL-LOCATION
SPL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When SPL-ITEM-TYPE = "I"
Or SPL-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
SPL-ITEM -> ITE-ITEM
Poitemven POITEMVEN Not Required
SPL-COMPANY -> PIV-COMPANY
SPL-ITEM -> PIV-ITEM
SPO-VENDOR -> PIV-VENDOR
Poquotes POQUOTES Not Required
SPL-COMPANY -> POQ-COMPANY
SPO-LOCATION -> POQ-LOCATION
SPL-ITEM -> POQ-ITEM
SPO-VENDOR -> POQ-VENDOR
SPO-PURCH-FR-LOC -> POQ-PURCH-FR-LOC
Stpurchord STPURCHORD Required
SPL-COMPANY -> SPO-COMPANY
SPL-ORDER-NAME -> SPO-ORDER-NAME
Vendloc APVENLOC Not Required
CPY-VENDOR-GROUP -> VLO-VENDOR-GROUP
SPO-VENDOR -> VLO-VENDOR
SPO-PURCH-FR-LOC -> VLO-LOCATION-CODE
Vendor APVENMAST Not Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
SPO-VENDOR -> VEN-VENDOR
STPOLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mmdist MMDIST Delete Cascades
Valid When SPL-ITEM-TYPE != "I"
SPL-COMPANY -> MMD-COMPANY
"PO" -> MMD-SYSTEM-CD
Spaces -> MMD-LOCATION
"S" -> MMD-DOC-TYPE
SPL-ORDER-NAME -> MMD-DOC-NBR
Zeroes -> MMD-DOC-NBR-NUM
SPL-LINE-NBR -> MMD-LINE-NBR
Zeroes -> MMD-COMPONENT-SEQ
Spaces -> MMD-AOC-CODE
MMD-LINE-SEQ
Poaocdtl POAOCDTL Delete Cascades
SPL-COMPANY -> PAO-COMPANY
SPL-ORDER-NAME -> PAO-ORDER-NAME
Spaces -> PAO-PO-NUMBER
Zeroes -> PAO-PO-RELEASE
SPL-LINE-NBR -> PAO-LINE-NBR
PAO-AOC-CODE
Pocomments POCOMMENTS Delete Cascades
SPL-COMPANY -> POC-COMPANY
SPL-ORDER-NAME -> POC-ORDER-NAME
Zeroes -> POC-RETURN-NUMBER
Spaces -> POC-PO-NUMBER
Zeroes -> POC-PO-RELEASE
SPL-LINE-NBR -> POC-LINE-NBR
POC-SEQ
|