AP Advance - Sage Intacct Data Target Requirements
DataBlend supports the API calls to AP Advance within Sage Intacct leveraging the Sage Intacct SDK. In addition, Custom Fields can be added for data that is unique to your business practices.
Based on how certain items, such as vendor, are set up, specific fields may be required. Likewise, ACH must be enabled to select it as a payment method.
|
DataBlend Query Object (SDK) |
Sage Intacct Object (API) |
Required |
Notes |
|
2026-02-10 |
advancedate |
Yes |
Format: YYYY-MM-DD |
|
|
attachmentid |
|
|
|
|
attachmentkey |
|
|
|
|
currency_basecurrency |
|
|
|
|
currency_exchangerate_date |
|
|
|
|
currency_exchangerate_rate |
|
|
|
|
currency_exchangerate_typeid |
|
|
|
|
currency_txncurrency |
|
|
|
|
custom.entry |
|
|
|
|
custom.header |
|
|
|
|
description |
|
|
|
|
duedate |
|
|
|
|
entry_accountlabelid |
|
|
|
|
entry_accountlabelkey |
|
|
|
|
entry_affiliateentityid |
|
|
|
|
entry_affiliateentitykey |
|
|
|
|
entry_assetid |
|
|
|
|
entry_assetkey |
|
|
|
|
entry_baselocation |
|
|
|
3 |
entry_classid |
Yes |
Collector object type: Class |
|
|
entry_classkey |
|
|
|
|
entry_contractid |
|
|
|
|
entry_contractkey |
|
|
|
|
entry_costtypeid |
|
|
|
|
entry_costtypekey |
|
|
|
C-1020 |
entry_customerid |
Yes |
Collector object type: Customer |
|
|
entry_customerkey |
|
|
|
210 |
entry_departmentid |
Yes |
Collector object type: Department |
|
|
entry_departmentkey |
|
|
|
EMP-0003 |
entry_employeeid |
Yes |
Collector object type: Employee |
|
|
entry_employeekey |
|
|
|
1500 |
entry_glaccountid |
Yes |
Collector object type: General Ledger Account |
|
|
entry_glaccountkey |
|
|
|
|
entry_id |
|
|
|
TABLE |
entry_itemid |
Yes |
Collector object type: Item |
|
|
entry_itemkey |
|
|
|
|
entry_key |
|
|
|
|
entry_loanaccountid |
|
|
|
|
entry_loanaccountkey |
|
|
|
203 |
entry_locationid |
Yes |
Collector object type: Location |
|
|
entry_locationkey |
|
|
|
Memo in advance |
entry_memo |
|
Optional string field, can be left null or used as notes/comments. |
|
110 |
entry_projectid |
Yes |
Collector object type: Project |
|
|
entry_projectkey |
|
|
|
|
entry_taskid |
|
|
|
|
entry_taskkey |
|
|
|
100 |
entry_txnamount |
Yes |
Any number, including decimal. |
|
V132 |
entry_vendorid |
Yes |
Must be the same as vendorid. |
|
|
entry_vendorkey |
|
|
|
|
entry_warehouseid |
|
|
|
|
entry_warehousekey |
|
|
|
|
entry_workorderid |
|
|
|
|
entry_workorderkey |
|
|
|
B01 |
financialentityid |
Yes |
Collector object type: Bank |
|
|
financialentitykey |
|
|
|
|
id |
|
|
|
|
issystemgenerated |
|
|
|
|
key |
|
|
|
|
locationid |
|
|
|
|
locationkey |
|
|
|
cash |
paymentmethod |
Yes |
Options: printedCheck, creditCard, eft, cash and ach. |
|
|
reconciliationgroup_cleared |
|
|
|
|
reconciliationgroup_clearingdate |
|
|
|
|
referencenumber |
|
|
|
|
state |
|
|
|
|
target_entity |
|
|
|
V132 |
vendorid |
Yes |
Collector object type: Vendor |
|
|
vendorkey |
|
|