Bills - Sage Intacct REST Data Target Requirements
DataBlend supports the standard API calls (non-legacy) to Create, Update, and Delete Bill records within Sage Intacct leveraging the Sage Intacct REST API. In addition, Custom Fields can be added for data that is unique to your business practices.
Accounts Payable (AP) enables you to keep track of your vendor accounts and bills.
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Sage Intacct UI Name | Required | Notes |
| vendorid | vendor.id | Vendor ID | Yes | Required on Create and Update. |
| id | id | Bill ID | Yes, for Update/Delete | System-assigned bill record ID. Required for Update and Delete if not using key. |
| key | key | Record Key | Yes, for Update/Delete | System-assigned record key (RECORDNO). Required for Update and Delete if not using id. |
| basecurrency | currency.baseCurrency | Base Currency | Expected value is free text. | |
| billnumber | billNumber | Bill Number | Expected value is free text. | |
| createddate | createdDate | Bill Date | Format: mm/dd/yyyy. |
|
| description | description | Description | Expected value is free text. | |
| discountcutoffdate | discountCutOffDate | Discount Cut-Off Date | Format: mm/dd/yyyy. |
|
| disputenotes | dispute.notes | Dispute Notes | Expected value is free text. | |
| disputereason | dispute.reason | Dispute Reason | Expected value is free text. | |
| duedate | dueDate | Due Date | Format: mm/dd/yyyy. |
|
| exchangeratedate | currency.exchangeRate.date | Exchange Rate Date | Format: mm/dd/yyyy. |
|
| exchangeraterate | currency.exchangeRate.rate | Exchange Rate | Expected value is decimal. | |
| exchangeratetypeid | currency.exchangeRate.typeId | Exchange Rate Type ID | ||
| refusenotes | refuse.notes | Refuse Notes | Expected value is free text. | |
| refusereason | refuse.reason | Refuse Reason | Expected value is free text. | |
| fullypaiddate | paymentInformation.fullyPaidDate | Fully Paid Date | Format: mm/dd/yyyy. |
|
| invoicemode | invoiceMode | Invoice Mode | ||
| invoicetype | invoiceType | Invoice Type | ||
| isonhold | isOnHold | On Hold | Use true or false. |
|
| istaxinclusive | isTaxInclusive | Tax Inclusive | Use true or false. |
|
| paymentpriority | paymentPriority | Payment Priority | ||
| postingdate | postingDate | GL Posting Date | Format: mm/dd/yyyy. |
|
| recommendedpaymentdate | recommendedPaymentDate | Recommended Payment Date | Format: mm/dd/yyyy. |
|
| referencenumber | referenceNumber | Reference Number | Expected value is free text. | |
| state | state | State | Use Draft, Pending, or Posted. |
|
| txncurrency | currency.txnCurrency | Transaction Currency | Expected value is free text. | |
| target_entity | target_entity | Target Entity | Target entity ID for multi-entity companies. Leave blank for top-level/root. |
Line Entry Fields
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Sage Intacct UI Name | Required | Notes |
| entry_glaccountid | lines.glAccount.id | GL Account ID | Yes | Required on Create and Update. |
| entry_txnamount | lines.txnAmount | Transaction Amount | Yes | Required on Create and Update. Expected value is decimal. |
| entry_key | lines.key | Line Key | System-assigned line record key. Required to update an existing line. | |
| entry_glaccountkey | lines.glAccount.key | GL Account Key | ||
| entry_hasform1099 | lines.hasForm1099 | Has Form 1099 | Use true or false. |
|
| entry_form1099box | lines.form1099.box | Form 1099 Box | ||
| entry_form1099type | lines.form1099.type | Form 1099 Type | ||
| entry_memo | lines.memo | Memo | Expected value is free text. | |
| entry_projectisbillable | lines.project.isBillable | Project Is Billable | Use true or false. |
|
| entry_releasetopay | lines.releaseToPay | Release to Pay | Use true or false. |
|
| entry_totaltxnamount | lines.totalTxnAmount | Total Transaction Amount | Expected value is decimal. | |
| entry_vendorid | lines.vendor.id | Vendor ID (Line) | Vendor override at the line level. | |
| entry_vendorkey | lines.vendor.key | Vendor Key (Line) |
Optional: Line Dimension Fields
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Sage Intacct UI Name |
| entry_dimensionaffiliateentityid | lines.dimensions.affiliateEntity.id | Affiliate Entity ID |
| entry_dimensionaffiliateentitykey | lines.dimensions.affiliateEntity.key | Affiliate Entity Key |
| entry_dimensionassetid | lines.dimensions.asset.id | Asset ID |
| entry_dimensionassetkey | lines.dimensions.asset.key | Asset Key |
| entry_dimensionclassid | lines.dimensions.class.id | Class ID |
| entry_dimensionclasskey | lines.dimensions.class.key | Class Key |
| entry_dimensioncontractid | lines.dimensions.contract.id | Contract ID |
| entry_dimensioncontractkey | lines.dimensions.contract.key | Contract Key |
| entry_dimensioncosttypeid | lines.dimensions.costType.id | Cost Type ID |
| entry_dimensioncosttypekey | lines.dimensions.costType.key | Cost Type Key |
| entry_dimensioncustomerid | lines.dimensions.customer.id | Customer ID |
| entry_dimensioncustomerkey | lines.dimensions.customer.key | Customer Key |
| entry_dimensiondepartmentid | lines.dimensions.department.id | Department ID |
| entry_dimensiondepartmentkey | lines.dimensions.department.key | Department Key |
| entry_dimensionemployeeid | lines.dimensions.employee.id | Employee ID |
| entry_dimensionemployeekey | lines.dimensions.employee.key | Employee Key |
| entry_dimensionitemid | lines.dimensions.item.id | Item ID |
| entry_dimensionitemkey | lines.dimensions.item.key | Item Key |
| entry_dimensionloanaccountid | lines.dimensions.loanAccount.id | Loan Account ID |
| entry_dimensionloanaccountkey | lines.dimensions.loanAccount.key | Loan Account Key |
| entry_dimensionlocationid | lines.dimensions.location.id | Location ID |
| entry_dimensionlocationkey | lines.dimensions.location.key | Location Key |
| entry_dimensionprojectid | lines.dimensions.project.id | Project ID |
| entry_dimensionprojectkey | lines.dimensions.project.key | Project Key |
| entry_dimensiontaskid | lines.dimensions.task.id | Task ID |
| entry_dimensiontaskkey | lines.dimensions.task.key | Task Key |
| entry_dimensionvendorid | lines.dimensions.vendor.id | Vendor ID (Dimension) |
| entry_dimensionvendorkey | lines.dimensions.vendor.key | Vendor Key (Dimension) |
| entry_dimensionwarehouseid | lines.dimensions.warehouse.id | Warehouse ID |
| entry_dimensionwarehousekey | lines.dimensions.warehouse.key | Warehouse Key |
| entry_dimensionworkorderid | lines.dimensions.workOrder.id | Work Order ID |
| entry_dimensionworkorderkey | lines.dimensions.workOrder.key | Work Order Key |
Optional: Line Tax Entry Fields
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Sage Intacct UI Name | Notes |
| entry_taxentrybasetaxamount | lines.taxEntries.baseTaxAmount | Base Tax Amount | Expected value is decimal. |
| entry_taxentryispartialexemption | lines.taxEntries.isPartialExemption | Is Partial Exemption | Use true or false. |
| entry_taxentrypurchasingtaxdetailid | lines.taxEntries.purchasingTaxDetail.id | Purchasing Tax Detail ID | |
| entry_taxentrypurchasingtaxdetailkey | lines.taxEntries.purchasingTaxDetail.key | Purchasing Tax Detail Key | |
| entry_taxentrytaxrate | lines.taxEntries.taxRate | Tax Rate | Expected value is decimal. |
| entry_taxentrytxntaxamount | lines.taxEntries.txnTaxAmount | Transaction Tax Amount | Expected value is decimal. |
Optional: Line Account Label & Allocation Fields
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Sage Intacct UI Name |
| entry_accountlabelid | lines.accountLabel.id | Account Label ID |
| entry_accountlabelkey | lines.accountLabel.key | Account Label Key |
| entry_allocationid | lines.allocation.id | Allocation ID |
| entry_allocationkey | lines.allocation.key | Allocation Key |
| entry_overrideoffsetglaccountid | lines.overrideOffsetGlAccount.id | Override Offset GL Account ID |
| entry_overrideoffsetglaccountkey | lines.overrideOffsetGlAccount.key | Override Offset GL Account Key |
Optional: Line Fixed Asset Fields
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Sage Intacct UI Name | Notes |
| entry_fixedassetassetcreationmode | lines.fixedAsset.assetCreationMode | Asset Creation Mode | |
| entry_fixedassetassetquantity | lines.fixedAsset.assetQuantity | Asset Quantity | Expected value is decimal. |
| entry_fixedassetincludetaxinassetcost | lines.fixedAsset.includeTaxInAssetCost | Include Tax in Asset Cost | Use true or false. |
| entry_fixedassetnameofacquiredasset | lines.fixedAsset.nameOfAcquiredAsset | Name of Acquired Asset | Expected value is free text. |
Optional: Line Purchasing Fields
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Sage Intacct UI Name |
| entry_purchasingdocumentid | lines.purchasing.document.id | Purchasing Document ID |
| entry_purchasingdocumentkey | lines.purchasing.document.key | Purchasing Document Key |
| entry_purchasingdocumentlineid | lines.purchasing.documentLine.id | Purchasing Document Line ID |
| entry_purchasingdocumentlinekey | lines.purchasing.documentLine.key | Purchasing Document Line Key |
Optional: Header Fields
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Sage Intacct UI Name | Notes |
| attachmentid | attachment.id | Attachment ID | |
| attachmentkey | attachment.key | Attachment Key | |
| billbacktemplateid | billBackTemplate.id | Bill Back Template ID | |
| billbacktemplatekey | billBackTemplate.key | Bill Back Template Key | |
| billsummaryid | billSummary.id | Bill Summary ID | |
| billsummarykey | billSummary.key | Bill Summary Key | |
| locationid | location.id | Location ID | |
| locationkey | location.key | Location Key | |
| paytoid | contacts.payTo.id | Pay To Contact ID | |
| paytokey | contacts.payTo.key | Pay To Contact Key | |
| paytotaxgroupid | contacts.payTo.tax.group.id | Pay To Tax Group ID | |
| paytotaxgroupkey | contacts.payTo.tax.group.key | Pay To Tax Group Key | |
| paytotaxid | contacts.payTo.tax.taxId | Pay To Tax ID | |
| purchasingid | purchasing.id | Purchasing ID | |
| purchasingkey | purchasing.key | Purchasing Key | |
| returntoid | contacts.returnTo.id | Return To Contact ID | |
| returntokey | contacts.returnTo.key | Return To Contact Key | |
| taxsolutionid | taxSolution.id | Tax Solution ID | Required for multi-jurisdiction companies. |
| taxsolutionkey | taxSolution.key | Tax Solution Key | |
| termid | term.id | Payment Term ID | |
| termkey | term.key | Payment Term Key | |
| vendorkey | vendor.key | Vendor Key |
Optional: Custom Fields
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Sage Intacct UI Name | Notes |
| custom.header | custom.header | Custom Header Fields | Custom fields applied to the bill header. Suffix with .<fieldName> per custom field. |
| custom.entry | custom.entry | Custom Line Fields | Custom fields applied to each line entry. Suffix with .<fieldName> per custom field. |
For more information, visit Bills · Intacct (1) · Sage Intacct · Developer Portal.