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
EX175 EX20.2
EXXM.1
XPD-REIM-AMT
Element: Intl Amt
Signed 18.2
EX175 EX20.2
EX542 EXXM.1
XPD-REIMRATE
Element: Baserate
Signed 14.7
EX20.2 EXXM.1
XPD-BASE-CURRENCY
Element: To Base Curr
Alpha 5
EX20.2 EX542
EXXM.1
XPD-BASE-AMT
Element: Intl Amt
Signed 18.2
EX20.2 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 EX542
EXXM.1
XPD-REIM-TAX-AMT1
Element: Intl Amt
Signed 18.2
EX175 EX20.2
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 EX542
EXXM.1
XPD-REIM-TAX-AMT2
Element: Intl Amt
Signed 18.2
EX175 EX20.2
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
XPDSET4 DOCUMENT
COMPANY
EMPLOYEE
SEQ
EX20.2


File created: Thu Jun 09 02:07:47 2016

Home
Contact Us



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