AP Voucher Data Entry Table Formats (DEVoucher)
Follow DPS 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 feature only. PaymentAmount cannot be zero when Amount is not zero. |
| CurrencyCode | varchar | Multicurrency feature only. CurrencyCode must exist in CFGEnabledCurrencies table. |
| 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 |
