Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETADVANCE


                             ETADVANCE FILE

REFERENCED BY

ET542     ET545

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ET5-ADV-ID             Numeric 10
Element: Numeric 1

ET5-ADV-ACCRCODE       Alpha 20
Element: Alpha 1

ET5-ADV-NAME           Alpha 30  (Lower Case)
Element: Name

ET5-ADV-DESC           Alpha 80
Element: Alpha 80

ET5-ADV-RES-ID         Numeric 10
Element: Numeric 1

ET5-ADV-STATUS         Numeric 10
Element: Numeric 1

ET5-ADV-AMT            Signed 15.2
Element: Tran Inv Amt

ET5-ADV-BALAMT         Signed 15.2
Element: Tran Inv Amt

ET5-ADV-CURR           Numeric 10
Element: Numeric 1

ET5-ADV-FXRATE         Signed 18.7
Element: Psa Rate52

ET5-ADV-BASEAMT        Signed 15.2
Element: Tran Inv Amt

ET5-ADV-BASEBLAMT      Signed 15.2
Element: Tran Inv Amt

ET5-ADV-BASECURR       Numeric 10
Element: Numeric 1

ET5-ADV-CHECKNBR       Numeric 8
Element: Check Nbr

ET5-ADV-CREDMEMID      Alpha 20
Element: Alpha 1

ET5-ADV-ADVITEMS       Numeric 5
Element: Numeric

ET5-ADV-COMMENT        Alpha 20
Element: Alpha 1

ET5-ADV-CREATORID      Numeric 10
Element: Numeric 1

ET5-ADV-CREATEDAT      Numeric 8  (yyyymmdd)
Element: Date

ET5-ADV-TEMPID         Alpha 40
Element: Alpha 40

ET5-ADV-EXPREQ-ID      Numeric 10
Element: Numeric 1

ET5-ADV-RTE-ID         Numeric 10
Element: Numeric 1

ET5-ADV-RTE-STEP       Numeric 10
Element: Numeric 1

ET5-ADV-RTE-RESID      Numeric 10
Element: Numeric 1

ET5-ADV-SENT           Numeric 5
Element: Numeric

ET5-ADV-RTE-LDATE      Numeric 8  (yyyymmdd)
Element: Date

ET5-ADV-EXP-CODE       Alpha 30
Element: Alpha 30

ET5-ADV-ERRFLAG        Numeric 10
Element: Numeric 1

                         ETADVANCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ET5SET1   ADV-ID                                                 ET542   ET545

ET5SET2   ADV-SENT                                               ET545
          ADV-ID