Employee Expense Report Data Entry Table Formats (DEEmployeeExpense)

Follow Deltek 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 feature only.
CurrencyCode	varchar	Multicurrency feature only. CurrencyCode must exist in CFGEnabledCurrencies table.
PaymentAmount	decimal	Multicurrency feature only. PaymentAmount cannot be zero when Amount is not zero.
Originating Vendor	varchar
TaxCodeSequence1 through TaxCodeSequence10	varchar	Deltek 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