Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETADVDTL


                             ETADVDTL FILE

REFERENCED BY

ET545     ET542

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DTL-AVDTL-ID           Numeric 10
Element: Numeric 1

DTL-AVDTL-ERPT-ID      Numeric 10
Element: Numeric 1

DTL-AVDTL-ADVID        Numeric 10
Element: Numeric 1

DTL-AVDTL-TYPE         Numeric 5
Element: Numeric

DTL-AVDTL-STATUS       Numeric 5
Element: Numeric

DTL-AVDTL-DATE         Numeric 8  (yyyymmdd)
Element: Date

DTL-AVDTL-AMT          Signed 15.2
Element: Tran Inv Amt

DTL-AVDTL-CURR         Numeric 10
Element: Numeric 1

DTL-AVDTL-FXRATE       Signed 18.7
Element: Psa Rate52

DTL-AVDTL-BASEAMT      Signed 15.2
Element: Tran Inv Amt

DTL-AVDTL-BASECURR     Numeric 10
Element: Numeric 1

DTL-AVDTL-REIMAMT      Signed 15.2
Element: Tran Inv Amt

DTL-AVDTL-REIMCURR     Numeric 10
Element: Numeric 1

DTL-AVDTL-REIMRATE     Signed 18.7
Element: Psa Rate52

DTL-AVDTL-CREATID      Numeric 10
Element: Numeric 1

DTL-AVDTL-CREATDAT     Numeric 8  (yyyymmdd)
Element: Date

DTL-AVDTL-SENT         Numeric 5
Element: Numeric

DTL-AVDTL-INVOICE      Alpha 30
Element: Alpha 30

                         ETADVDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DTLSET1   AVDTL-ID                                               ET545

DTLSET2   AVDTL-ERPT-ID                                          ET542
          AVDTL-ID

DTLSET3   AVDTL-SENT                                             ET545
          AVDTL-ID