OESTDLINE FILE
Standard Order Line
The Standard Order Line file contains the individual lines for a standard
order. These can either be copied in full or selectively copied when placing
a new order.
REFERENCED BY
OE10.6 OE14.4 OE254
UPDATED BY
OE54.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSL-COMPANY Numeric 4 OE54.1
Element: Company This field contains the company number.
OSL-CUSTOMER Alpha 9 (Right Justified) OE54.1
Element: Customer NumbeThis field contains the number that
represents a customer.
OSL-STD-ORDER-NBR Alpha 22 OE54.1
Standard Order This field contains the number of the
Number standard order.
OSL-LINE-NBR Numeric 6 OE54.1
Element: Line Number This field contains the line number.
OSL-ITEM Alpha 32 OE54.1
Element: Item Number This field contains the item
identifier.
OSL-QUANTITY Signed 13.4 OE54.1
Element: Quantity This field contains the quantity added
to the line.
OSL-SELL-UOM Alpha 4 OE54.1
Element: Unit of MeasurThis field contains the stock unit of
measure for the item.
OSL-STD-COMM Alpha 4 OE54.1
Element: Standard CommeThis field contains the standard
comment code added to the line.
OSL-ITEM-16 Derived
Element: Item 16 This field contains the first 16
characters of the item's identifier.
This information is used by inquiries
and reports.
OESTDLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSLSET1 COMPANY OE10.6 OE14.4
CUSTOMER OE254 OE54.1
STD-ORDER-NBR
LINE-NBR
OESTDLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
OSL-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
OSL-ITEM -> ITE-ITEM
Oestdorder OESTDORDER Required
OSL-COMPANY -> OSO-COMPANY
OSL-CUSTOMER -> OSO-CUSTOMER
OSL-STD-ORDER-NBR -> OSO-STD-ORDER-NBR
OESTDLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oeordcmnt OEORDCMNT
OSL-COMPANY -> OOC-COMPANY
OSL-CUSTOMER -> OOC-CUSTOMER
OSL-STD-ORDER-NBR -> OOC-STD-ORDER-NBR
Zeroes -> OOC-ORDER-NBR
OSL-LINE-NBR -> OOC-LINE-NBR
OOC-SEQ
Oestdcomm OESTDCOMM Required
When OSL-STD-COMM != Spaces
OSL-COMPANY -> OSC-COMPANY
OSL-STD-COMM -> OSC-STD-COMM
OSC-LANGUAGE-CODE
OSC-SEQ
|