Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OESTDLINE


                             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