Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            SHIPTOCMNT FILE

                            Ship To Comments

The Ship To Comments file contains comments that are added to customer
ship-to records.

REFERENCED BY

BL202     BL92.1    OE10.1    OE10.2    OE10.3    OE10.4
OE10.5    OE10.6    OE10.7    OE10.8    OE11.1    OE11.4
OE11.8    OE11.9    OE110     OE113     OE114     OE129
OE14.4    OE15.1    OE15.2    OE15.3    OE15.4    OE15.5
OE15.7    OE510     OE810     OE920     WH20.7

UPDATED BY

BL02.1    BL02.2    BL802     BL902

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SPC-COMPANY          Numeric 4                                   BL02.2  BL802
Company              The company number represents an            BL902
                     established company and is entered on
                     all function codes.

SPC-CUSTOMER         Alpha 9  (Right Justified)                  BL02.2  BL802
Customer Number      This field contains the number that         BL902
                     represents a customer.

SPC-SHIP-TO          Numeric 4                                   BL02.2  BL802
Ship-to Code         Customer's ship-to number.                  BL902

SPC-SEQ              Numeric 3                                   BL02.2  BL802
Sequence Number      The record sequence number identifying      BL902
                     the line number of the comment.

SPC-COMMENT          Alpha 40  (Lower Case)                      BL02.2  BL802
Comment Line         This field contains the comment             BL902
                     narrative.

SPC-PRINT-CODE       Alpha 1                                     BL02.2  BL802
Print Code           This field contains the print code,         BL902
                     which defines where comments are
                     displayed or printed.
                     B = Both
                     D = Display
                     P = Print

                         SHIPTOCMNT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SPCSET1   COMPANY                                                BL02.1  BL02.2
          CUSTOMER                                               BL202   BL92.1
          SHIP-TO                                                OE10.1  OE10.2
          SEQ                                                    OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 OE15.2  OE15.3
                                                                 OE15.4  OE15.5
                                                                 OE15.7  OE510
                                                                 OE810   OE920
                                                                 ...

                         SHIPTOCMNT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Shipto         SHIPTO       Required

                            SPC-COMPANY     -> SHP-COMPANY
                            SPC-CUSTOMER    -> SHP-CUSTOMER
                            SPC-SHIP-TO     -> SHP-SHIP-TO