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