Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            STCOMMCODE FILE

                       PO Standard Comment Codes

This is a file of valid standard comment codes. These codes can be used to
add comments to a purchase order.

REFERENCED BY

BL92.1    DR100     IC141     IC142     IC83.1    IN20.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     PO20.1    PO212     PO22.2    PO22.3
PO25.1    PO31.1    PO820     PO821     RQ10.1    RQ10.3
RQ10.4    RQ10.5    RQ11.1    RQ20.1    RQ20.3    RQ20.4
RQ35.1    RQ500     WH20.2    WH20.7

UPDATED BY

PO12.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SCM-COMPANY          Numeric 4                                   PO12.1
Company              The company number.

SCM-COMMENT-CODE     Alpha 4                                     PO12.1
Comment Code         The user-defined standard comment code.

SCM-DESCRIPTION      Alpha 30  (Lower Case)                      PO12.1
Description          This field contains the description.

SCM-PRINT-CODE       Alpha 1                                     PO12.1
Print Code           This field contains the print code,
                     which defines where comments are
                     displayed or printed.
                     B = Display and Print
                     D = Display Only
                     P = Purchase Order
                     R = Receiver

SCM-LAST-SEQ         Numeric 3                                   PO12.1
Last Sequence        The last line sequence number for this
                     standard comment.

                         STCOMMCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SCMSET1   COMPANY                                                BL92.1  DR100
          COMMENT-CODE                                           IC141   IC142
                                                                 IC83.1  IN20.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
                                                                 ...

                         STCOMMCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pocompany      POCOMPANY    Required

                            SCM-COMPANY         -> PCY-COMPANY

                         STCOMMCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Stcomments     STCOMMENTS   Delete Cascades

                            SCM-COMPANY         -> STC-COMPANY
                            SCM-COMMENT-CODE    -> STC-COMMENT-CODE
                                                   STC-LANGUAGE-CODE
                                                   STC-SEQ