ETEXPDTL FILE
REFERENCED BY
ET175 ET542
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EXD-EDTL-ID Numeric 10
Element: Numeric 1
EXD-EDTL-ERPT-ID Numeric 10
Element: Numeric 1
EXD-EDTL-ELINE-ID Numeric 10
Element: Numeric 1
EXD-EDTL-RES-ID Numeric 10
Element: Numeric 1
EXD-EDTL-EXP-CODE Alpha 30
Element: Alpha 30
EXD-EDTL-LOCATION Alpha 12
Element: Alpha 12
EXD-EDTL-DESC Alpha 30 (Lower Case)
Element: Description
EXD-EDTL-TRANDATE Numeric 8 (yyyymmdd)
Element: Date
EXD-EDTL-ACTIVITY Numeric 10
Element: Numeric 1
EXD-EDTL-GLCOMPANY Numeric 10
Element: Numeric 1
EXD-EDTL-ACCT-UNIT Alpha 15
Element: Acct Unit
EXD-EDTL-BILLABLE Numeric 10
Element: Numeric 1
EXD-EDTL-COMMFLAG Numeric 10
Element: Numeric 1
EXD-EDTL-DEPT Alpha 12
Element: Alpha 12
EXD-EDTL-PAYMETHOD Numeric 10
Element: Numeric 1
EXD-EDTL-RECEIPT Numeric 10
Element: Numeric 1
EXD-EDTL-STATUS Numeric 10
Element: Numeric 1
EXD-EDTL-SENT Numeric 10
Element: Numeric 1
EXD-EDTL-INVOICE Alpha 30
Element: Alpha 30
EXD-EDTL-AC-UPD Alpha 1
Element: Flag1
EXD-EDTL-AP-PR-UPD Alpha 1
Element: Flag1
EXD-EDTL-REIMAMT Signed 15.2
Element: Tran Inv Amt
EXD-EDTL-REIMPER Signed 15.2
Element: Tran Inv Amt
EXD-EDTL-REIMCO Signed 15.2
Element: Tran Inv Amt
EXD-EDTL-REIMCURR Numeric 10
Element: Numeric 1
EXD-EDTL-REIMRATE Signed 18.7
Element: Psa Rate52
EXD-EDTL-TRANAMT Signed 15.2
Element: Tran Inv Amt
EXD-EDTL-TRANCURR Numeric 10
Element: Numeric 1
EXD-EDTL-TRANPER Signed 15.2
Element: Tran Inv Amt
EXD-EDTL-TRANCO Signed 15.2
Element: Tran Inv Amt
EXD-EDTL-TRANRATE Signed 18.7
Element: Psa Rate52
EXD-EDTL-BASEAMT Signed 15.2
Element: Tran Inv Amt
EXD-EDTL-BASEPER Signed 15.2
Element: Tran Inv Amt
EXD-EDTL-BASECO Signed 15.2
Element: Tran Inv Amt
EXD-EDTL-BASECURR Numeric 10
Element: Numeric 1
EXD-EDTL-BASERATE Signed 18.7
Element: Psa Rate52
EXD-EDTL-PROJAMT Signed 15.2
Element: Tran Inv Amt
EXD-EDTL-PROJCURR Numeric 10
Element: Numeric 1
EXD-EDTL-PROJRATE Signed 18.7
Element: Psa Rate52
EXD-EDTL-TRAN-TAX1 Signed 15.2 ET175
Element: Tran Inv Amt
EXD-EDTL-BASE-TAX1 Signed 15.2 ET175
Element: Tran Inv Amt
EXD-EDTL-REIM-TAX1 Signed 15.2 ET542
Element: Tran Inv Amt
EXD-EDTL-TAX-CODE1 Alpha 10
Element: Tax Code
EXD-EDTL-TRAN-TAX2 Signed 15.2 ET175
Element: Tran Inv Amt
EXD-EDTL-BASE-TAX2 Signed 15.2 ET175
Element: Tran Inv Amt
EXD-EDTL-REIM-TAX2 Signed 15.2 ET542
Element: Tran Inv Amt
EXD-EDTL-TAX-CODE2 Alpha 10
Element: Tax Code
EXD-EDTL-CREATORID Numeric 10
Element: Numeric 1
EXD-EDTL-CREATEDAT Numeric 8 (yyyymmdd)
Element: Date
EXD-EDTL-MERCHANT Numeric 10
Element: Numeric 1
EXD-EDTL-REF-ID Numeric 10
Element: Numeric 1
EXD-EDTL-TEMPID Alpha 80
Element: Alpha 80
EXD-EDTL-RTE-STEP Numeric 10
Element: Numeric 1
EXD-EDTL-RTE-RESID Numeric 10
Element: Numeric 1
EXD-EDTL-RTE-ID Numeric 10
Element: Numeric 1
EXD-EDTL-RTE-TYPE Numeric 10
Element: Numeric 1
EXD-EDTL-ERRFLAG Numeric 10
Element: Numeric 1
EXD-EDTL-RTE-LDATE Numeric 8 (yyyymmdd)
Element: Date
EXD-EDTL-MOD-ID Numeric 10
Element: Numeric 1
EXD-EDTL-MOD-DATE Numeric 8 (yyyymmdd)
Element: Date
EXD-EDTL-ASGN-ID Numeric 10
Element: Numeric 1
EXD-EDTL-ATN-OBJID Numeric 12
Element: Obj Id
EXD-EDTL-GLT-OBJID Numeric 12
Element: Obj Id
EXD-EDTL-INVC-STS Numeric 10
Element: Numeric 1
EXD-EDTL-INTERR Numeric 10
Element: Numeric 1
EXD-EDTL-ACCT-CAT Alpha 5 ET175
Element: Acct Cat
ETEXPDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EXDSET1 EDTL-ID ET175 ET542
EXDSET2 EDTL-SENT ET542
EDTL-ID
EXDSET3 EDTL-PAYMETHOD ET175
EDTL-ID
|
