AP Disbursement Data Entry Table Formats
Follow Vision specifications for preparing a file containing AP disbursement data.
Field Name | Data Type | Notes |
---|---|---|
Vendor | varchar | |
InvoiceDate | datetime | |
Invoice | varchar | |
TransDate | datetime | |
CheckNo | varchar | |
BankCode | varchar | |
AddressCode | varchar | |
WBS1 | varchar | |
WBS2 | varchar | |
WBS3 | varchar | |
Account | varchar | |
Amount | decimal | |
DetailDescription | varchar | |
SuppressBill | varchar | |
Voucher | varchar | |
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 | |
CurrencyCode | varchar | Multicurrency only. CurrencyCode must exist in CFGEnabledCurrencies table. |
PaymentAmount | decimal | Multicurrency only. PaymentAmount cannot be zero when Amount is not zero. |
TransactionID | varchar | For use with Credit Cards. |
CreditCardPrimaryCode | varchar | For use with Credit Cards. |
CreditCardCode | varchar | For use with Credit Cards. |
Diary |