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 |