Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETEXPCODE


                             ETEXPCODE FILE

REFERENCED BY

ET175     ET542     ET545

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ETE-ECODE-ID           Numeric 10
Element: Numeric 1

ETE-ECODE-CODE         Alpha 30
Element: Alpha 30

ETE-ECODE-DESC         Alpha 30  (Lower Case)
Element: Description

ETE-ECODE-TYPE         Numeric 10
Element: Numeric 1

ETE-ECODE-CATEGORY     Numeric 5
Element: Numeric

ETE-ECODE-COUNTRY      Numeric 10
Element: Numeric 1

ETE-ECODE-ACCT         Numeric 6
Element: Account

ETE-ECODE-SUBACCT      Numeric 4
Element: Sub Acct

ETE-ECODE-RATE         Signed 18.7
Element: Psa Rate52

ETE-ECODE-CURRENCY     Numeric 10
Element: Numeric 1

ETE-ECODE-UOM          Numeric 10
Element: Numeric 1

ETE-ECODE-INFO-FL      Numeric 10
Element: Numeric 1

ETE-ECODE-STATUS       Numeric 10
Element: Numeric 1

ETE-ECODE-PEREXP       Numeric 10
Element: Numeric 1

ETE-ECODE-TEMPID       Alpha 40
Element: Alpha 40

ETE-ECODE-ACCTB        Numeric 6
Element: Account

ETE-ECODE-SUBACCTB     Numeric 4
Element: Sub Acct

ETE-ECODE-DEDCD        Alpha 4
Element: Ded Code

ETE-ECODE-PAYCD        Alpha 4
Element: Pay Code

ETE-ECODE-ECTYPE       Numeric 10
Element: Numeric 1

ETE-ECODE-ACCTCAT      Alpha 5
Element: Acct Cat

ETE-ECODE-DEDCD-ID     Numeric 10
Element: Numeric 1

ETE-ECODE-PAYCD-ID     Numeric 10
Element: Numeric 1

                         ETEXPCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETESET1   ECODE-ID

ETESET2   ECODE-CODE                                             ET175   ET542
                                                                 ET545