AP Disbursement Data Entry Table Formats

Follow DPS 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 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
CurrencyCode varchar Multicurrency feature only. CurrencyCode must exist in CFGEnabledCurrencies table.
PaymentAmount decimal Multicurrency feature 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