Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SABOOKCOMP


                            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
Element: Company       The company number represents the
                       highest organizational level and is
                       required on all form action codes.

SBC-ORDER-NBR          Numeric 8                                 SA100   SA300
Element: 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
Element: Line Number   This field contains the line number.

SBC-COMPONENT-SEQ      Numeric 3                                 SA100   SA300
Element: Sequence NumbeThis field contains the component
                       sequence number.

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

SBC-QUANTITY           Signed 13.4                               SA100   SA300
Element: 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