EEEXPDTL

UPDATED BY
EX175 EX542

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
XPD-COMPANY
Element: Company
Numeric 4
XPD-EMPLOYEE
Element: Employee
Numeric 9
XPD-DOCUMENT
Element: Invoice
Alpha 22
XPD-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
XPD-SEQ
Element: Seq Nbr
Numeric 4
XPD-EXPENSE-CODE
Element: Expense Code
Alpha 20
XPD-EXPENSE-DATE
Element: Date
Numeric 8 (yyyymmdd)
XPD-EE-COMMENT1
Element: Data
Alpha 500 (Lower Case)
XPD-EE-COMMENT2
Element: Data
Alpha 500 (Lower Case)
XPD-EE-COMMENT3
Element: Data
Alpha 500 (Lower Case)
XPD-STATUS
Element: Status
Numeric 1

1 = Not Processed
2 = In Error
9 = Sent for Reimbursement
EX175 EX542
XPD-SENT-DATE
Element: Date
Numeric 8 (yyyymmdd)
EX175 EX542
XPD-PAYMETHOD
Element: Seq Nbr
Numeric 4

0010 = Company Paid
0020 = Out of Pocket
0030 = Reimburse to Credit Card Cpy
0040 = Company Paid Credit Card
XPD-TRAN-CURRENCY
Element: To Base Curr
Alpha 5
XPD-TRAN-AMT
Element: Intl Amt
Signed 18.2
XPD-REIM-CURRENCY
Element: To Base Curr
Alpha 5
XPD-REIM-AMT
Element: Intl Amt
Signed 18.2
XPD-REIMRATE
Element: Baserate
Signed 14.7
XPD-BASE-CURRENCY
Element: To Base Curr
Alpha 5
EX175 EX542
XPD-BASE-AMT
Element: Intl Amt
Signed 18.2
EX175 EX542
XPD-BASERATE
Element: Baserate
Signed 14.7
XPD-TRAN-PERS-AMT
Element: Intl Amt
Signed 18.2
XPD-POST-COMPANY
Element: Company
Numeric 4
XPD-ACCT-UNIT
Element: Acct Unit
Alpha 15
XPD-ACCOUNT
Element: Account
Numeric 6
XPD-SUB-ACCT
Element: Sub Acct
Numeric 4
XPD-BILL-ACCOUNT
Element: Account
Numeric 6
XPD-BILL-SUB-ACCT
Element: Sub Acct
Numeric 4
XPD-ACTIVITY
Element: Activity
Alpha 15
XPD-ACCT-CAT
Element: Acct Cat
Alpha 5
XPD-TAX-CODE1
Element: Tax Code
Alpha 10
XPD-TAX-AMT1
Element: Intl Amt
Signed 18.2
XPD-REIM-TAX-AMT1
Element: Intl Amt
Signed 18.2
EX175 EX542
XPD-TAX-CODE2
Element: Tax Code
Alpha 10
XPD-TAX-AMT2
Element: Intl Amt
Signed 18.2
XPD-REIM-TAX-AMT2
Element: Intl Amt
Signed 18.2
EX175 EX542
XPD-RECEIPT
Element: Seq Nbr
Numeric 4

0010 = Has Receipt
0020 = No Receipt
XPD-PAY-CODE
Element: Pay Code
Alpha 4
XPD-ERROR-TEXT
Element: Text
Alpha 70
EX175 EX542
XPD-GLT-OBJ-ID
Element: Obj Id
Numeric 12
XPD-ATN-OBJ-ID
Element: Obj Id
Numeric 12
XPD-BILLABLE
Element: Billable
Alpha 1

Y = Yes
N = No


EEEXPDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
XPDSET1 COMPANY
EMPLOYEE
DOCUMENT
SEQ
EX175 EX542
XPDSET2 STATUS
COMPANY
EMPLOYEE
DOCUMENT
SEQ
KeyChange
EX175 EX542
XPDSET3 PAYMETHOD
COMPANY
EMPLOYEE
DOCUMENT
SEQ
EX175


File created: Wed Jun 08 20:47:37 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.