Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETCOMMENT


                             ETCOMMENT FILE

REFERENCED BY

ET175     ET540     ET542

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ETK-ECOMM-ID           Numeric 10
Element: Numeric 1

ETK-ECOMM-CAT          Numeric 10
Element: Numeric 1

ETK-ECOMM-ENT-ID       Numeric 10
Element: Numeric 1

ETK-ECOMM-ENT-TYPE     Numeric 10
Element: Numeric 1

ETK-ECOMM-SUBJECT      Alpha 255
Element: Alpha 255

ETK-ECOMM-DATE         Numeric 8  (yyyymmdd)
Element: Date

ETK-ECOMM-COMMENT      Alpha 2000
Element: Alpha 2000

ETK-ECOMM-ERES-ID      Numeric 10
Element: Numeric 1

ETK-ECOMM-STATUS       Numeric 10
Element: Numeric 1

ETK-ECOMM-COMMTYPE     Numeric 10
Element: Numeric 1

ETK-ECOMM-ACT-ID       Numeric 10
Element: Numeric 1

ETK-ECOMM-UPD-FLAG     Numeric 10
Element: Numeric 1

ETK-ECOMM-PRNTABLE     Numeric 10
Element: Numeric 1

ETK-ECOMM-OWNER-ID     Numeric 10
Element: Numeric 1

                         ETCOMMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETKSET1   ECOMM-ID

ETKSET2   ECOMM-ENT-TYPE                                         ET175   ET540
          ECOMM-ENT-ID                                           ET542
          ECOMM-ID