Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

COMMCODES


                             COMMCODES FILE

REFERENCED BY

IC11.1    MA43.1    MA540     PD21.1    PD235     PO115
PO15.1    PO15.2    PO150     PO23.1    PO25.6    PO25.7
PO36.2    PO536     POIJ.1    RQ10.1    RQ10.3    RQ11.1
RQ35.1    RQ500     RQID.1    RQIF.1    RQIJ.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ISC-ITEM-GROUP         Alpha 5                                   IC11.1  MA43.1
Element: Item Group    This field contains the identifier for    MA540   PD21.1
                       a group of items that can be shared by    PD235   PO115
                       one or more companies.                    PO15.1  PO15.2
                                                                 PO150   PO23.1
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ35.1  RQ500
                                                                 RQID.1  RQIF.1
                                                                 RQIJ.1

ISC-COMMODITY-CODE     Alpha 35                                  IC11.1  MA43.1
Element: Commodity Code                                          MA540   PD21.1
                                                                 PD235   PO115
                                                                 PO15.1  PO15.2
                                                                 PO150   PO23.1
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ35.1  RQ500
                                                                 RQID.1  RQIF.1
                                                                 RQIJ.1

ISC-CC-DESCRIPTION     Alpha 60  (Lower Case)                    IC11.1  MA43.1
Element: Cc Description                                          MA540   PD21.1
                                                                 PD235   PO115
                                                                 PO15.1  PO15.2
                                                                 PO150   PO23.1
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ35.1  RQ500
                                                                 RQID.1  RQIF.1
                                                                 RQIJ.1

ISC-CC-ACTIVE          Numeric 1                                 IC11.1  MA43.1
Element: Cc Active     0 = Inactive                              MA540   PD21.1
                       1 = Active                                PD235   PO115
                                                                 PO15.1  PO15.2
                                                                 PO150   PO23.1
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ35.1  RQ500
                                                                 RQID.1  RQIF.1
                                                                 RQIJ.1

                         COMMCODES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ISCSET1   ITEM-GROUP                                             IC11.1  MA43.1
          COMMODITY-CODE                                         MA540   PD21.1
                                                                 PD235   PO115
                                                                 PO15.1  PO15.2
                                                                 PO150   PO23.1
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536
                                                                 POIJ.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ35.1  RQ500
                                                                 RQID.1  RQIF.1
                                                                 RQIJ.1