AR Payment - Sage Intacct REST Data Target Requirements
DataBlend supports the standard API calls to Create, Update, and Delete AR 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 |
| USD | txncurrencycurrency | Yes — Create | Transaction currency code (e.g. USD, EUR). |
| 09/01/2026 | paymentsummaryreceiptdate | Yes — Create | Receipt date for the payment summary. Format: YYYY-MM-DD. |
| 9901 | key | Yes — Update, Delete | System-assigned key of the payment record. Required to identify the record for Update or Delete operations. |
| CUST-001 | customerid | No | ID of the customer making the payment. Use customerid or customerkey — not both. |
| 7701 | customerkey | No | Key of the customer. |
| DataBlend | customername | No | Customer name. Informational only. |
| DataBlend | payername | No | Name of the payer if different from the customer. |
| BANK-CHK | financialentityentityid | No | Entity ID of the financial account (bank or cash account) receiving the payment. |
| cash | paymentmethod | No | Payment method. Options: printedCheck, creditCard, eft, cash, onlineChargeCard, onlineAchDebit, paymentAcceptanceService. |
| draft | state | No | State of the payment. Options: complete, reconciled, draft, reversed, reversal. |
| 09/01/2026 | paiddate | No | Date the payment was made. Format: YYYY-MM-DD. |
| REF-001 | referencenumber | No | Reference number for the payment. |
| CHECK-2026-001 | documentnumber | No | Document number (e.g. check number) for the payment. |
| September customer payment | description | No | Description of the payment. |
| 1000 | undepositedglaccountid | No | Undeposited funds GL account ID. Use undepositedglaccountid or undepositedglaccountkey — not both. |
| 8801 | undepositedglaccountkey | No | Key of the undeposited funds GL account. |
| Columbus | target_entity | No | Target entity ID for multi-entity Sage Intacct environments. |
| 500 | txncurrencyamounttopay | No | Total transaction currency amount to pay. |
| 500 | txncurrencytotalamount | No | Total transaction currency amount for the payment. |
| USD | basecurrencycurrency | No | Base currency code. Typically matches the company base currency. |
| 500 | basecurrencyamounttopay | No | Total base currency amount to pay. |
| BATCH-2026-09 | paymentsummaryid | No | ID of the payment summary (batch) this payment belongs to. Use paymentsummaryid or paymentsummarykey — not both. |
| 6601 | paymentsummarykey | No | Key of the payment summary. |
| September Receipts | paymentsummarytitle | No | Title of the payment summary batch. |
| September cash receipts batch | paymentsummaryname | No | Name of the payment summary batch. |
| PAYTO-001 | contactspaytoid | No | ID of the pay-to contact. Use contactspaytoid or contactspaytokey — not both. |
| 6701 | contactspaytokey | No | Key of the pay-to contact. |
| MEPAY-001 | multientitypaymentid | No | ID of an associated multi-entity payment. Use multientitypaymentid or multientitypaymentkey — not both. |
| 6801 | multientitypaymentkey | No | Key of the multi-entity payment. |
| ATT-001 | attachmentid | No | ID of an attachment to associate with this payment. Use attachmentid or attachmentkey — not both. |
| 6901 | attachmentkey | No | Key of the attachment. |
| INV-2026-001 | paymentdetail_arinvoiceid | Yes — Create | ID of the AR invoice being paid. Use paymentdetail_arinvoiceid or paymentdetail_arinvoicekey — not both. |
| 4501 | paymentdetail_arinvoicekey | No | Key of the AR invoice. |
| LINE-001 | paymentdetail_arinvoicelineid | No | ID of a specific invoice line to pay. Omit to pay all lines. |
| 4502 | paymentdetail_arinvoicelinekey | No | Key of the invoice line. |
| 500 | paymentdetail_txncurrencypaymentamount | No | Transaction currency amount being applied to the invoice. |
| 500 | paymentdetail_basecurrencypaymentamount | No | Base currency amount being applied to the invoice. |
| 09/10/2026 | paymentdetail_discountdate | No | Discount date for early payment terms. Format: YYYY-MM-DD. |
| 25 | paymentdetail_txncurrencyadjustmentamount | No | Adjustment amount in the transaction currency (e.g. discount taken). |
| 10 | paymentdetail_txncurrencyinlineamount | No | Inline credit amount in the transaction currency. |
| 5 | paymentdetail_txncurrencypostedadvanceamount | No | Posted advance amount in the transaction currency. |
| 20 | paymentdetail_txncurrencypostedoverpaymentamount | No | Posted overpayment amount in the transaction currency. |
| 15 | paymentdetail_txncurrencynegativeinvoiceamount | No | Negative invoice amount in the transaction currency. |
| ADJ-001 | paymentdetail_aradjustmentid | No | ID of an AR adjustment to apply. Use paymentdetail_aradjustmentid or paymentdetail_aradjustmentkey — not both. |
| 5501 | paymentdetail_aradjustmentkey | No | Key of the AR adjustment. |
| LINE-ADJ-001 | paymentdetail_aradjustmentlineid | No | ID of a specific AR adjustment line to apply. |
| 5502 | paymentdetail_aradjustmentlinekey | No | Key of the AR adjustment line. |
| ADV-001 | paymentdetail_aradvanceid | No | ID of an AR advance to apply. Use paymentdetail_aradvanceid or paymentdetail_aradvancekey — not both. |
| 5601 | paymentdetail_aradvancekey | No | Key of the AR advance. |
| LINE-ADV-001 | paymentdetail_aradvancelineid | No | ID of a specific AR advance line to apply. |
| 5602 | paymentdetail_aradvancelinekey | No | Key of the AR advance line. |
| OVP-001 | paymentdetail_arpostedoverpaymentid | No | ID of a posted overpayment to apply. Use paymentdetail_arpostedoverpaymentid or paymentdetail_arpostedoverpaymentkey — not both. |
| 5701 | paymentdetail_arpostedoverpaymentkey | No | Key of the posted overpayment. |
| LINE-OVP-001 | paymentdetail_arpostedoverpaymentlineid | No | ID of a specific posted overpayment line to apply. |
| 5702 | paymentdetail_arpostedoverpaymentlinekey | No | Key of the posted overpayment line. |
| POSADJ-001 | paymentdetail_positiveadjustmentid | No | ID of a positive adjustment to apply. Use paymentdetail_positiveadjustmentid or paymentdetail_positiveadjustmentkey — not both. |
| 5801 | paymentdetail_positiveadjustmentkey | No | Key of the positive adjustment. |
| LINE-POSADJ-001 | paymentdetail_positiveadjustmentlineid | No | ID of a specific positive adjustment line to apply. |
| 5802 | paymentdetail_positiveadjustmentlinekey | No | Key of the positive adjustment line. |
| NEGINV-001 | paymentdetail_negativeinvoiceid | No | ID of a negative invoice to apply. Use paymentdetail_negativeinvoiceid or paymentdetail_negativeinvoicekey — not both. |
| 5901 | paymentdetail_negativeinvoicekey | No | Key of the negative invoice. |
| LINE-NEGINV-001 | paymentdetail_negativeinvoicelineid | No | ID of a specific negative invoice line to apply. |
| 5902 | paymentdetail_negativeinvoicelinekey | No | Key of the negative invoice line. |
| INLINE-001 | paymentdetail_inlinetxnid | No | ID of an inline transaction to apply. Use paymentdetail_inlinetxnid or paymentdetail_inlinetxnkey — not both. |
| 6001 | paymentdetail_inlinetxnkey | No | Key of the inline transaction. |
| LINE-INLINE-001 | paymentdetail_inlinetxnlineid | No | ID of a specific inline transaction line to apply. |
| 6002 | paymentdetail_inlinetxnlinekey | No | Key of the inline transaction line. |
| 50 | overpaymentamount | No | Overpayment amount for this payment. |
| LOC-001 | overpaymentdimensionslocationid | No | Location ID dimension for the overpayment. |
| DEPT-001 | overpaymentdimensionsdepartmentid | No | Department ID dimension for the overpayment. |
| CLASS-A | overpaymentdimensionsclassid | No | Class ID dimension for the overpayment. |
| CUST-001 | overpaymentdimensionscustomerid | No | Customer ID dimension for the overpayment. |
| PROJ-001 | overpaymentdimensionsprojectid | No | Project ID dimension for the overpayment. |
| GL note | line_memo | No | Memo for the payment line. |
| 4000 | line_glaccountid | No | GL account ID for the line. Use line_glaccountid or line_glaccountkey — not both. |
| 7001 | line_glaccountkey | No | Key of the GL account. |
| Accounts Receivable | line_glaccountname | No | Name of the GL account. Informational only. |
| 1100 | line_offsetglaccountid | No | Offset GL account ID. Use line_offsetglaccountid or line_offsetglaccountkey — not both. |
| 7101 | line_offsetglaccountkey | No | Key of the offset GL account. |
| ALLOC-001 | line_allocationid | No | Allocation ID for the line. Use line_allocationid or line_allocationkey — not both. |
| 7201 | line_allocationkey | No | Key of the allocation. |
| LOC-001 | line_dimensionslocationid | No | Location ID dimension. Use line_dimensionslocationid or line_dimensionslocationkey — not both. |
| 8001 | line_dimensionslocationkey | No | Key of the location dimension. |
| New York | line_dimensionslocationname | No | Name of the location. Informational only. |
| DEPT-001 | line_dimensionsdepartmentid | No | Department ID dimension. |
| 8101 | line_dimensionsdepartmentkey | No | Key of the department dimension. |
| Finance | line_dimensionsdepartmentname | No | Name of the department. Informational only. |
| ENTITY-B | line_dimensionsaffiliateentityid | No | Affiliate entity ID dimension. |
| 8201 | line_dimensionsaffiliateentitykey | No | Key of the affiliate entity dimension. |
| ASSET-001 | line_dimensionsassetid | No | Asset ID dimension. |
| 8301 | line_dimensionsassetkey | No | Key of the asset dimension. |
| CLASS-A | line_dimensionsclassid | No | Class ID dimension. |
| 8401 | line_dimensionsclasskey | No | Key of the class dimension. |
| CONTRACT-001 | line_dimensionscontractid | No | Contract ID dimension. |
| 8501 | line_dimensionscontractkey | No | Key of the contract dimension. |
| COSTYPE-001 | line_dimensionscosttypeid | No | Cost type ID dimension. |
| 8601 | line_dimensionscosttypekey | No | Key of the cost type dimension. |
| CUST-001 | line_dimensionscustomerid | No | Customer ID dimension. |
| 8701 | line_dimensionscustomerkey | No | Key of the customer dimension. |
| EMP-001 | line_dimensionsemployeeid | No | Employee ID dimension. |
| 8801 | line_dimensionsemployeekey | No | Key of the employee dimension. |
| ITEM-001 | line_dimensionsitemid | No | Item ID dimension. |
| 8901 | line_dimensionsitemkey | No | Key of the item dimension. |
| LOAN-001 | line_dimensionsloanaccountid | No | Loan account ID dimension. |
| 9001 | line_dimensionsloanaccountkey | No | Key of the loan account dimension. |
| PROJ-001 | line_dimensionsprojectid | No | Project ID dimension. |
| 9101 | line_dimensionsprojectkey | No | Key of the project dimension. |
| TASK-001 | line_dimensionstaskid | No | Task ID dimension. |
| 9201 | line_dimensionstaskkey | No | Key of the task dimension. |
| VEND-001 | line_dimensionsvendorid | No | Vendor ID dimension. |
| 9301 | line_dimensionsvendorkey | No | Key of the vendor dimension. |
| WH-001 | line_dimensionswarehouseid | No | Warehouse ID dimension. |
| 9401 | line_dimensionswarehousekey | No | Key of the warehouse dimension. |
| WO-001 | line_dimensionsworkorderid | No | Work order ID dimension. |
| 9501 | line_dimensionsworkorderkey | No | Key of the work order 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-receivable/groups/payments/tags/accounts_receivable_payments.