AP Payment - Sage Intacct REST Data Target Requirements
DataBlend supports the standard API calls to Create, Update, and Delete AP Payment records within Sage Intacct leveraging the Sage Intacct API. In addition, a target entity can be specified for multi-entity environments.
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Required | Notes |
| BANK-CHK | financialentityentityid | Yes — Create | ID of the financial entity (checking account or cash account) used to make the payment. |
| 1234 | financialentityid | No | Key of the financial entity. Use financialentityentityid or financialentityid — not both. |
| ACME-001 | vendorid | Yes — Create | ID of the vendor being paid. |
| 5678 | vendorkey | No | Key of the vendor. Use vendorid or vendorkey — not both. |
| 09/01/2026 | paymentdate | Yes — Create | Date of the payment. Format: YYYY-MM-DD. |
| USD | txncurrencycurrency | Yes — Create | Transaction currency code (e.g. USD, EUR). |
| EFT | paymentmethod | Yes — Create | Payment method. Common values: Printed Check, EFT, Cash, Online, Credit Card, ACH. |
| 9001 | key | Yes — Update, Delete | System-assigned key of the payment record. Required to identify the record for Update or Delete operations. |
| draft | action | No | Submission action. Options: draft, submit. |
| CHECK-2026-001 | documentnumber | No | Document number for the payment (e.g. check number). |
| REF-001 | documentid | No | Document ID reference for the payment. |
| September vendor payment | description | No | Description of the payment. |
| approved | state | No | Payment state. Options: partiallyApproved, submitted, voided, confirmed, approved, draft, declined, delivered, printVoided, quickDelivery. |
| generateOneRequestPerBill | paymentrequestmethod | No | Controls how payment requests are generated. Options: useVendorPreference, generateOneRequestPerBill, mergeRequestsIntoOnePerVendor, mergeRequestIntoOnePerVendorPayToContact. |
| apBill | recordtype | No | Record type being paid. Options include: apAdjustments, apBill, apDiscount, apAppliedAdvance, apPayment, apAdvance, arAdjustments, arDiscount, interEntityReceivable, arInvoice, arRealizedMultiCurrencyGainLoss, arAppliedAdvanceOverpayment, arReceipts, arAdvance, employeeExpenses, employeeReimbursements, expenseAdjustment, manualCheck, cmPrintedQuickCheck. |
| Columbus | target_entity | No | Target entity ID for multi-entity Sage Intacct environments. |
| 500 | txncurrencyamounttopay | No | Total transaction currency amount to pay. |
| USD | basecurrencycurrency | No | Base currency code. Typically matches your company's base currency. |
| 500 | basecurrencyamounttopay | No | Total base currency amount to pay. |
| 09/01/2026 | exchangeratedate | No | Date used to determine the exchange rate. Format: YYYY-MM-DD. |
| Intacct Daily Rate | exchangeratetypeid | No | Exchange rate type ID as configured in Sage Intacct. |
| BILL-2026-001 | paymentdetail_billid | Yes — Create | ID of the bill being paid. Use paymentdetail_billid or paymentdetail_billkey — not both. |
| 4501 | paymentdetail_billkey | No | Key of the bill being paid. |
| LINE-001 | paymentdetail_billlineid | No | ID of a specific bill line to pay. Omit to pay all lines. |
| 9901 | paymentdetail_billlinekey | No | Key of the bill line. |
| 500 | paymentdetail_txncurrencypaymentamount | Yes — Create | Transaction currency amount being applied to the bill. |
| 09/10/2026 | paymentdetail_discountdate | No | Discount date for early payment terms. Format: YYYY-MM-DD. |
| 25 | paymentdetail_txncurrencyadjustmentamount | No | Adjustment amount applied in the transaction currency (e.g. discount taken). |
| 10 | paymentdetail_txncurrencyinlineamount | No | Inline credit amount applied in the transaction currency. |
| 5 | paymentdetail_txncurrencypostedadvanceamount | No | Posted advance amount applied in the transaction currency. |
| ADV-001 | paymentdetail_apadvanceid | No | ID of an AP advance to apply to this payment. |
| 3301 | paymentdetail_apadvancekey | No | Key of the AP advance. |
| LINE-ADV-001 | paymentdetail_apadvancelineid | No | ID of a specific AP advance line to apply. |
| 3302 | paymentdetail_apadvancelinekey | No | Key of the AP advance line. |
| CRADJ-001 | paymentdetail_apcreditadjustmentid | No | ID of an AP credit adjustment to apply. |
| 4401 | paymentdetail_apcreditadjustmentkey | No | Key of the AP credit adjustment. |
| LINE-CRADJ-001 | paymentdetail_apcreditadjustmentlineid | No | ID of a specific AP credit adjustment line. |
| 4402 | paymentdetail_apcreditadjustmentlinekey | No | Key of the AP credit adjustment line. |
| DBADJ-001 | paymentdetail_apdebitadjustmentid | No | ID of an AP debit adjustment to apply. |
| 4501 | paymentdetail_apdebitadjustmentkey | No | Key of the AP debit adjustment. |
| LINE-DBADJ-001 | paymentdetail_apdebitadjustmentlineid | No | ID of a specific AP debit adjustment line. |
| 4502 | paymentdetail_apdebitadjustmentlinekey | No | Key of the AP debit adjustment line. |
| PAY-001 | paymentdetail_appaymentid | No | ID of an existing AP payment to apply. |
| 5601 | paymentdetail_appaymentkey | No | Key of the AP payment. |
| LINE-PAY-001 | paymentdetail_appaymentlineid | No | ID of a specific AP payment line to apply. |
| 5602 | paymentdetail_appaymentlinekey | No | Key of the AP payment line. |
| INBILL-001 | paymentdetail_inlinebillid | No | ID of an inline bill to apply to this payment. |
| 6601 | paymentdetail_inlinebillkey | No | Key of the inline bill. |
| LINE-INBILL-001 | paymentdetail_inlinebilllineid | No | ID of a specific inline bill line. |
| 6602 | paymentdetail_inlinebilllinekey | No | Key of the inline bill line. |
| Intercompany note | line_description | No | Description for the payment line. |
| ENTITY-B | line_dimensionsaffiliateentityid | No | Affiliate entity ID dimension. |
| 101 | line_dimensionsaffiliateentitykey | No | Affiliate entity key dimension. |
| ASSET-001 | line_dimensionsassetid | No | Asset ID dimension. |
| 201 | line_dimensionsassetkey | No | Asset key dimension. |
| CLASS-A | line_dimensionsclassid | No | Class ID dimension. |
| 301 | line_dimensionsclasskey | No | Class key dimension. |
| CONTRACT-001 | line_dimensionscontractid | No | Contract ID dimension. |
| 401 | line_dimensionscontractkey | No | Contract key dimension. |
| COSTYPE-001 | line_dimensionscosttypeid | No | Cost type ID dimension. |
| 501 | line_dimensionscosttypekey | No | Cost type key dimension. |
| CUST-001 | line_dimensionscustomerid | No | Customer ID dimension. |
| 601 | line_dimensionscustomerkey | No | Customer key dimension. |
| EMP-001 | line_dimensionsemployeeid | No | Employee ID dimension. |
| 701 | line_dimensionsemployeekey | No | Employee key dimension. |
| ITEM-001 | line_dimensionsitemid | No | Item ID dimension. |
| 801 | line_dimensionsitemkey | No | Item key dimension. |
| LOAN-001 | line_dimensionsloanaccountid | No | Loan account ID dimension. |
| 901 | line_dimensionsloanaccountkey | No | Loan account key dimension. |
| PROJ-001 | line_dimensionsprojectid | No | Project ID dimension. |
| 1001 | line_dimensionsprojectkey | No | Project key dimension. |
| TASK-001 | line_dimensionstaskid | No | Task ID dimension. |
| 1101 | line_dimensionstaskkey | No | Task key dimension. |
| VEND-001 | line_dimensionsvendorid | No | Vendor ID dimension. |
| 1201 | line_dimensionsvendorkey | No | Vendor key dimension. |
| WH-001 | line_dimensionswarehouseid | No | Warehouse ID dimension. |
| 1301 | line_dimensionswarehousekey | No | Warehouse key dimension. |
| WO-001 | line_dimensionsworkorderid | No | Work order ID dimension. |
| 1401 | line_dimensionsworkorderkey | No | Work order key dimension. |
More questions about Sage Intacct API requirements? Please visit the Sage Intacct API site https://developer.sage.com/intacct/apis/intacct/1/intacct-openapi/groups/accounts-payable/groups/payments/tags/accounts_payable_payments.