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 |