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    OE15.4    OE15.7    OE254

UPDATED BY

OE54.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OSL-COMPANY          Numeric 4                                   OE54.1
Company              This field contains the company number.

OSL-CUSTOMER         Alpha 9  (Right Justified)                  OE54.1
Customer             This field contains the number that
                     represents a customer.

OSL-STD-ORDER-NBR    Alpha 10                                    OE54.1
Standard Order       This field contains the number of the
Number               standard order.

OSL-LINE-NBR         Numeric 6                                   OE54.1
Line Number          This field contains the line number.

OSL-ITEM             Alpha 32                                    OE54.1
Item                 This field contains the item
                     identifier.

OSL-QUANTITY         Signed 13.4                                 OE54.1
Quantity             This field contains the quantity added
                     to the line.

OSL-SELL-UOM         Alpha 4                                     OE54.1
Sell Unit of Measure This field contains the stock unit of
                     measure for the item.

OSL-STD-COMM         Alpha 4                                     OE54.1
Standard Comment     This field contains the standard
Code                 comment code added to the line.

OSL-ITEM-16          Derived
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                                               OE15.4  OE15.7
          STD-ORDER-NBR                                          OE254   OE54.1
          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