EEEXPDTL

UPDATED BY
EX175 EX20.2 EX542 EXXM.1

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

1 = Not Processed
2 = In Error
9 = Sent for Reimbursement
EX175 EX20.2
EX542 EXXM.1
XPD-SENT-DATE
Element: Date
Numeric 8 (yyyymmdd)
EX175 EX20.2
EX542 EXXM.1
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
EX20.2 EXXM.1
XPD-TRAN-CURRENCY
Element: To Base Curr
Alpha 5
EX20.2 EXXM.1
XPD-TRAN-AMT
Element: Intl Amt
Signed 18.2
EX20.2 EXXM.1
XPD-REIM-CURRENCY
Element: To Base Curr
Alpha 5
EX20.2 EXXM.1
XPD-REIM-AMT
Element: Intl Amt
Signed 18.2
EX20.2 EXXM.1
XPD-REIMRATE
Element: Baserate
Signed 14.7
EX20.2 EXXM.1
XPD-BASE-CURRENCY
Element: To Base Curr
Alpha 5
EX175 EX20.2
EX542 EXXM.1
XPD-BASE-AMT
Element: Intl Amt
Signed 18.2
EX175 EX20.2
EX542 EXXM.1
XPD-BASERATE
Element: Baserate
Signed 14.7
EX20.2 EXXM.1
XPD-TRAN-PERS-AMT
Element: Intl Amt
Signed 18.2
EXXM.1
XPD-POST-COMPANY
Element: Company
Numeric 4
EX20.2 EXXM.1
XPD-ACCT-UNIT
Element: Acct Unit
Alpha 15
EX20.2 EXXM.1
XPD-ACCOUNT
Element: Account
Numeric 6
EX20.2 EXXM.1
XPD-SUB-ACCT
Element: Sub Acct
Numeric 4
EX20.2 EXXM.1
XPD-BILL-ACCOUNT
Element: Account
Numeric 6
EX20.2 EXXM.1
XPD-BILL-SUB-ACCT
Element: Sub Acct
Numeric 4
EX20.2 EXXM.1
XPD-ACTIVITY
Element: Activity
Alpha 15
EX20.2 EXXM.1
XPD-ACCT-CAT
Element: Acct Cat
Alpha 5
EX20.2 EXXM.1
XPD-TAX-CODE1
Element: Tax Code
Alpha 10
EX20.2 EXXM.1
XPD-TAX-AMT1
Element: Intl Amt
Signed 18.2
EX20.2 EXXM.1
XPD-REIM-TAX-AMT1
Element: Intl Amt
Signed 18.2
EX175 EX20.2
EX542 EXXM.1
XPD-TAX-CODE2
Element: Tax Code
Alpha 10
EX20.2 EXXM.1
XPD-TAX-AMT2
Element: Intl Amt
Signed 18.2
EX20.2 EXXM.1
XPD-REIM-TAX-AMT2
Element: Intl Amt
Signed 18.2
EX175 EX20.2
EX542 EXXM.1
XPD-RECEIPT
Element: Seq Nbr
Numeric 4

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

Y = Yes
N = No
EX20.2 EXXM.1


EEEXPDTL FILE INDEX

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


File created: Thu Jun 09 11:08:01 2016

Home
Contact Us



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