Employee Expense Report Data Entry Table Formats (DEEmployeeExpense)

Follow Vision specifications for preparing a file containing employee expense report data.

Field Name	Data Type	Notes
Employee	varchar
ReportDate	datetime
ReportName	varchar
TransDate	datetime
WBS1	varchar
WBS2	varchar
WBS3	varchar
Account	varchar
Amount	decimal
DetailDescription	varchar
SuppressBill	varchar
DefaultCurrencyCode	varchar	Multicurrency only.
CurrencyCode	varchar	Multicurrency only. CurrencyCode must exist in CFGEnabledCurrencies table.
PaymentAmount	decimal	Multicurrency only. PaymentAmount cannot be zero when Amount is not zero.
Originating Vendor	varchar
TaxCodeSequence1 through TaxCodeSequence10	varchar	Vision validates that the tax codes have an active status and they are input tax codes with the Transaction Entry check box selected in Taxes Configuration.
TaxAmountSequence1 through TaxAmountSequence10	decimal