AP Voucher Data Entry Table Formats (DEVoucher)

Follow Vision 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 only. PaymentAmount cannot be zero when Amount is not zero.

CurrencyCode

varchar Multicurrency only. CurrencyCode must exist in CFGEnabledCurrencies table.

OriginatingVendor

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