Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            STCOMMENTS FILE

                          PO Standard Comments

This is a file of comments. These comments are identified by a standard
comment code, and they can be copied to a purchase order.

REFERENCED BY

MA00.1    PO120     PO121     PO123     PO20.1    PO212
PO25.1    PO31.1    PO820     PO821     RQ10.4    RQ10.5
RQ500

UPDATED BY

PO12.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

STC-COMMENT-CODE     Alpha 4                                     PO12.1
Comment Code         This is the standard comment code for
                     this comment line.

STC-SEQ              Numeric 3                                   PO12.1
Sequence Number      This field contains the record sequence
                     number.

STC-COMMENT          Alpha 40  (Lower Case)                      PO12.1
Comment Text         This field contains the comment
                     narrative.

STC-LANGUAGE-CODE    Alpha 10                                    PO12.1
Language Code        The code representing the language in
                     which the comments are written. Spaces
                     indicate the base language used at the
                     site.

                         STCOMMENTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

STCSET1   COMPANY                                                MA00.1  PO12.1
          COMMENT-CODE                                           PO120   PO121
          LANGUAGE-CODE                                          PO123   PO20.1
          SEQ                                                    PO212   PO25.1
                                                                 PO31.1  PO820
                                                                 PO821   RQ10.4
                                                                 RQ10.5  RQ500

                         STCOMMENTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pocompany      POCOMPANY    Required

                            STC-COMPANY         -> PCY-COMPANY

Stcommcode     STCOMMCODE   Required

                            STC-COMPANY         -> SCM-COMPANY
                            STC-COMMENT-CODE    -> SCM-COMMENT-CODE