AP Voucher Data Entry Table Formats (DEVoucher)

Follow DPS specifications for preparing a file containing AP voucher data.

Field Name Data Type Notes
Vendor varchar
InvoiceDate datetime
Invoice varchar
TransDate datetime
LiabilityCode varchar
BankCode varchar
PayTerms varchar
PayDate datetime
AddressCode varchar
WBS1 varchar
WBS2 varchar
WBS3 varchar
Account varchar
Amount decimal
DetailDescription varchar
SupressBill varchar
PaymentAmount decimal Multicurrency feature only. PaymentAmount cannot be zero when Amount is not zero.
CurrencyCode varchar Multicurrency feature only. CurrencyCode must exist in CFGEnabledCurrencies table.
OriginatingVendor varchar
TaxCodeSequence1 through TaxCodeSequence10 varchar DPS 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