Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETEXPRPT


                             ETEXPRPT FILE

REFERENCED BY

ET542

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EXR-ERPT-ID            Numeric 10
Element: Numeric 1

EXR-ERPT-DESC          Alpha 30  (Lower Case)
Element: Description

EXR-ERPT-RES-ID        Numeric 10
Element: Numeric 1

EXR-ERPT-ACTIVITY      Numeric 10
Element: Numeric 1

EXR-ERPT-GLCOMPANY     Numeric 10
Element: Numeric 1

EXR-ERPT-ACCT-UNIT     Alpha 15
Element: Acct Unit

EXR-ERPT-LOCATION      Alpha 12
Element: Alpha 12

EXR-ERPT-DEPT          Alpha 12
Element: Alpha 12

EXR-ERPT-STATUS        Numeric 10
Element: Numeric 1

EXR-ERPT-STARTDATE     Numeric 8  (yyyymmdd)
Element: Date

EXR-ERPT-FINDATE       Numeric 8  (yyyymmdd)
Element: Date

EXR-ERPT-BILLABLE      Numeric 10
Element: Numeric 1

EXR-ERPT-EXP-TOTAL     Signed 15.2
Element: Tran Inv Amt

EXR-ERPT-REIM-ADV      Signed 15.2
Element: Tran Inv Amt

EXR-ERPT-REIM-CO       Signed 15.2
Element: Tran Inv Amt

EXR-ERPT-REIM-AMT      Signed 15.2
Element: Tran Inv Amt

EXR-ERPT-REIM-CURR     Numeric 10
Element: Numeric 1

EXR-ERPT-RPT-CURR      Numeric 10
Element: Numeric 1

EXR-ERPT-COMMFLAG      Numeric 10
Element: Numeric 1

EXR-ERPT-CREATORID     Numeric 10
Element: Numeric 1

EXR-ERPT-CREATEDAT     Numeric 8  (yyyymmdd)
Element: Date

EXR-ERPT-EREQ-ID       Numeric 10
Element: Numeric 1

EXR-ERPT-TEMPID        Alpha 40
Element: Alpha 40

EXR-ERPT-RTE-ID        Numeric 10
Element: Numeric 1

EXR-ERPT-RTE-STEP      Numeric 10
Element: Numeric 1

EXR-ERPT-RTE-RESID     Numeric 10
Element: Numeric 1

EXR-ERPT-RTE-TYPE      Numeric 10
Element: Numeric 1

EXR-ERPT-PAYMETHOD     Numeric 10
Element: Numeric 1

EXR-ERPT-DISP-ID       Numeric 10
Element: Numeric 1

EXR-ERPT-ERRFLAG       Numeric 10
Element: Numeric 1

EXR-ERPT-RTE-LDATE     Numeric 8  (yyyymmdd)
Element: Date

EXR-ERPT-MOD-ID        Numeric 10
Element: Numeric 1

EXR-ERPT-MOD-DATE      Numeric 8  (yyyymmdd)
Element: Date

EXR-ERPT-INTERR        Numeric 10
Element: Numeric 1

EXR-ERPT-ACCT-CAT      Alpha 5
Element: Acct Cat

EXR-ERPT-SENT-DATE     Numeric 8  (yyyymmdd)
Element: Date

                         ETEXPRPT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EXRSET1   ERPT-ID                                                ET542