Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            SABOOKCOMP FILE

                           Booked Components

The Booked Components file stores booked kit components.  Only make-to-order
kits will cause creation of these records.

UPDATED BY

SA100     SA101     SA300

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SBC-COMPANY          Numeric 4                                   SA100   SA300
Company              The company number represents the
                     highest organizational level and is
                     required on all form action codes.

SBC-ORDER-NBR        Numeric 8                                   SA100   SA300
Order Number         Each order is assigned a unique number.
                     Order numbers are either manually
                     assigned or system assigned based on a
                     company-level option.

SBC-LINE-NBR         Numeric 6                                   SA100   SA300
Line Number          This field contains the line number.

SBC-COMPONENT-SEQ    Numeric 3                                   SA100   SA300
Component Sequence   This field contains the component
Number               sequence number.

SBC-ITEM             Alpha 32                                    SA100   SA300
Item Number          This field contains the item
                     identifier.

SBC-QUANTITY         Signed 13.4                                 SA100   SA300
Quantity             The quantity booked for this component
                     in stock unit of measure.

                         SABOOKCOMP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SBCSET1   COMPANY                                                SA100   SA101
          ORDER-NBR                                              SA300
          LINE-NBR
          COMPONENT-SEQ

                         SABOOKCOMP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sabookline     SABOOKLINE   Required

                            SBC-COMPANY      -> SAL-COMPANY
                            SBC-ORDER-NBR    -> SAL-ORDER-NBR
                            SBC-LINE-NBR     -> SAL-LINE-NBR