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