Recurring Order Entry - REST Sage Intacct Data Target Requirements
DataBlend supports the API calls to create Recurring Order entry within Sage Intacct leveraging the Sage Intacct SDK. In addition, custom fields can be added for data that is unique to your business practices.
Header
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Required | Notes |
| documentname | documentname | Create/Update | Transaction definition name (e.g. "Sales Invoice", "Sales Order"). Used as the URL discriminator: objects/order-entry/recurring-document::<documentname>. Must match an OE transaction definition configured in the target entity. Missing/blank values cause a REST-1033 error. |
| schedulerepeatby | schedulerepeatby | Create | Enum: "days", "weeks", "months", "years". Maps to schedule.repeatBy |
| schedulerepeatinterval | schedulerepeatinterval | Create | Numeric interval (e.g. "2" for every 2 weeks). Maps to schedule.repeatInterval |
| schedulestartdate | schedulestartdate | Create | Date format: yyyy-MM-dd. Maps to schedule.startDate |
| key | key | Update | System-assigned key. Used for Update/Delete operations. |
| basecurrency | basecurrency | Source/base currency code for the document | |
| contactsbilltoid | contactsbilltoid | Maps to contacts.billTo.id | |
| contactsbilltokey | contactsbilltokey | Maps to contacts.billTo.key | |
| contactsprimaryid | contactsprimaryid | Maps to contacts.primary.id | |
| contactsprimarykey | contactsprimarykey | Maps to contacts.primary.key | |
| contactsshiptoid | contactsshiptoid | Maps to contacts.shipTo.id | |
| contactsshiptokey | contactsshiptokey | Maps to contacts.shipTo.key | |
| contractdescription | contractdescription | ||
| contractid | contractid | ||
| custom.entry | custom.entry | Custom fields applied to each line entry. Suffix with .<fieldName> per custom field. | |
| custom.header | custom.header | Custom fields applied to the document header. Suffix with .<fieldName> per custom field. | |
| customerid | customerid | Maps to customer.id | |
| customerkey | customerkey | Maps to customer.key | |
| customerponumber | customerponumber | Customer purchase order number | |
| entry_conversiontype | entry_conversiontype | Line: conversion type | |
| entry_dimensionaffiliateentityid | entry_dimensionaffiliateentityid | Maps to line.dimensions.affiliateEntity.id | |
| entry_dimensionaffiliateentitykey | entry_dimensionaffiliateentitykey | Maps to line.dimensions.affiliateEntity.key | |
| entry_dimensionassetid | entry_dimensionassetid | Maps to line.dimensions.asset.id | |
| entry_dimensionassetkey | entry_dimensionassetkey | Maps to line.dimensions.asset.key | |
| entry_dimensionclassid | entry_dimensionclassid | Maps to line.dimensions.class.id | |
| entry_dimensionclasskey | entry_dimensionclasskey | Maps to line.dimensions.class.key | |
| entry_dimensioncontractid | entry_dimensioncontractid | Maps to line.dimensions.contract.id | |
| entry_dimensioncontractkey | entry_dimensioncontractkey | Maps to line.dimensions.contract.key | |
| entry_dimensioncosttypeid | entry_dimensioncosttypeid | Maps to line.dimensions.costType.id | |
| entry_dimensioncosttypekey | entry_dimensioncosttypekey | Maps to line.dimensions.costType.key | |
| entry_dimensioncustomerid | entry_dimensioncustomerid | Maps to line.dimensions.customer.id | |
| entry_dimensioncustomerkey | entry_dimensioncustomerkey | Maps to line.dimensions.customer.key | |
| entry_dimensiondepartmentid | entry_dimensiondepartmentid | Maps to line.dimensions.department.id | |
| entry_dimensiondepartmentkey | entry_dimensiondepartmentkey | Maps to line.dimensions.department.key | |
| entry_dimensionemployeeid | entry_dimensionemployeeid | Maps to line.dimensions.employee.id | |
| entry_dimensionemployeekey | entry_dimensionemployeekey | Maps to line.dimensions.employee.key | |
| entry_dimensionitemid | entry_dimensionitemid | Maps to line.dimensions.item.id | |
| entry_dimensionitemkey | entry_dimensionitemkey | Maps to line.dimensions.item.key | |
| entry_dimensionlocationid | entry_dimensionlocationid | Maps to line.dimensions.location.id | |
| entry_dimensionlocationkey | entry_dimensionlocationkey | Maps to line.dimensions.location.key | |
| entry_dimensionprojectid | entry_dimensionprojectid | Maps to line.dimensions.project.id | |
| entry_dimensionprojectkey | entry_dimensionprojectkey | Maps to line.dimensions.project.key | |
| entry_dimensiontaskid | entry_dimensiontaskid | Maps to line.dimensions.task.id | |
| entry_dimensiontaskkey | entry_dimensiontaskkey | Maps to line.dimensions.task.key | |
| entry_dimensionvendorid | entry_dimensionvendorid | Maps to line.dimensions.vendor.id | |
| entry_dimensionvendorkey | entry_dimensionvendorkey | Maps to line.dimensions.vendor.key | |
| entry_dimensionwarehouseid | entry_dimensionwarehouseid | Maps to line.dimensions.warehouse.id | |
| entry_dimensionwarehousekey | entry_dimensionwarehousekey | Maps to line.dimensions.warehouse.key | |
| entry_discountmemo | entry_discountmemo | Line: discount memo | |
| entry_discountpercent | entry_discountpercent | Line: discount percent (decimal string) | |
| entry_enabletax | entry_enabletax | Line: Boolean (true/false) | |
| entry_id | entry_id | Line: user-defined line identifier | |
| entry_isbillable | entry_isbillable | Line: Boolean (true/false) | |
| entry_ispriceprorated | entry_ispriceprorated | Line: Boolean (true/false) | |
| entry_itemaliasid | entry_itemaliasid | Maps to line.itemAlias.id | |
| entry_itemaliaskey | entry_itemaliaskey | Maps to line.itemAlias.key | |
| entry_itemid | entry_itemid | Maps to line.item.id | |
| entry_itemkey | entry_itemkey | Maps to line.item.key | |
| entry_key | entry_key | Line: system-assigned key (for line-level Update/Delete) | |
| entry_memo | entry_memo | Line: memo | |
| entry_priceintxncurrency | entry_priceintxncurrency | Line: price in transaction currency (decimal string) | |
| entry_recurringdocumentheaderid | entry_recurringdocumentheaderid | Maps to line.recurringDocumentHeader.id | |
| entry_recurringdocumentheaderkey | entry_recurringdocumentheaderkey | Maps to line.recurringDocumentHeader.key | |
| entry_recurringstatus | entry_recurringstatus | Line: recurring status | |
| entry_revenuerecognitionenddate | entry_revenuerecognitionenddate | Line: date format yyyy-MM-dd | |
| entry_revenuerecognitionstartdate | entry_revenuerecognitionstartdate | Line: date format yyyy-MM-dd | |
| entry_status | entry_status | Line: status | |
| entry_unit | entry_unit | Line: unit (e.g. "Each", "10 Pack") | |
| entry_unitprice | entry_unitprice | Line: unit price (decimal string) | |
| entry_unitquantity | entry_unitquantity | Line: unit quantity (decimal string) | |
| exchangeratedate | exchangeratedate | Date format: yyyy-MM-dd | |
| exchangeraterate | exchangeraterate | Decimal string (e.g. "1.0") | |
| exchangeratetypeid | exchangeratetypeid | Maps to exchangeRate.typeId | |
| exchangeratetypename | exchangeratetypename | Maps to exchangeRate.typeName | |
| id | id | User-defined identifier for the source record | |
| memo | memo | ||
| notes | notes | ||
| paymenttermid | paymenttermid | Maps to paymentTerm.id | |
| paymenttermkey | paymenttermkey | Maps to paymentTerm.key | |
| referencenumber | referencenumber | Document reference number | |
| scheduleenddate | scheduleenddate | Date format: yyyy-MM-dd. Maps to schedule.endDate | |
| schedulenextexecutiondate | schedulenextexecutiondate | Date format: yyyy-MM-dd. Maps to schedule.nextExecutionDate | |
| schedulerecurringduedate | schedulerecurringduedate | Date format: yyyy-MM-dd. Maps to schedule.recurringDueDate | |
| schedulerepeatcount | schedulerepeatcount | Maps to schedule.repeatCount | |
| shippingmethodid | shippingmethodid | Maps to shippingMethod.id | |
| shippingmethodkey | shippingmethodkey | Maps to shippingMethod.key | |
| state | state | ||
| subtotal_absolutevalue | subtotal_absolutevalue | Subtotal: absolute value (decimal string). Row is only emitted if subtotal_description is non-empty. | |
| subtotal_description | subtotal_description | Subtotal: description. REQUIRED to include this subtotal in the payload. | |
| subtotal_dimensionaffiliateentityid | subtotal_dimensionaffiliateentityid | Maps to subtotal.dimensions.affiliateEntity.id | |
| subtotal_dimensionaffiliateentitykey | subtotal_dimensionaffiliateentitykey | Maps to subtotal.dimensions.affiliateEntity.key | |
| subtotal_dimensionassetid | subtotal_dimensionassetid | Maps to subtotal.dimensions.asset.id | |
| subtotal_dimensionassetkey | subtotal_dimensionassetkey | Maps to subtotal.dimensions.asset.key | |
| subtotal_dimensionclassid | subtotal_dimensionclassid | Maps to subtotal.dimensions.class.id | |
| subtotal_dimensionclasskey | subtotal_dimensionclasskey | Maps to subtotal.dimensions.class.key | |
| subtotal_dimensioncontractid | subtotal_dimensioncontractid | Maps to subtotal.dimensions.contract.id | |
| subtotal_dimensioncontractkey | subtotal_dimensioncontractkey | Maps to subtotal.dimensions.contract.key | |
| subtotal_dimensioncosttypeid | subtotal_dimensioncosttypeid | Maps to subtotal.dimensions.costType.id | |
| subtotal_dimensioncosttypekey | subtotal_dimensioncosttypekey | Maps to subtotal.dimensions.costType.key | |
| subtotal_dimensioncustomerid | subtotal_dimensioncustomerid | Maps to subtotal.dimensions.customer.id | |
| subtotal_dimensioncustomerkey | subtotal_dimensioncustomerkey | Maps to subtotal.dimensions.customer.key | |
| subtotal_dimensiondepartmentid | subtotal_dimensiondepartmentid | Maps to subtotal.dimensions.department.id | |
| subtotal_dimensiondepartmentkey | subtotal_dimensiondepartmentkey | Maps to subtotal.dimensions.department.key | |
| subtotal_dimensionemployeeid | subtotal_dimensionemployeeid | Maps to subtotal.dimensions.employee.id | |
| subtotal_dimensionemployeekey | subtotal_dimensionemployeekey | Maps to subtotal.dimensions.employee.key | |
| subtotal_dimensionitemid | subtotal_dimensionitemid | Maps to subtotal.dimensions.item.id | |
| subtotal_dimensionitemkey | subtotal_dimensionitemkey | Maps to subtotal.dimensions.item.key | |
| subtotal_dimensionlocationid | subtotal_dimensionlocationid | Maps to subtotal.dimensions.location.id | |
| subtotal_dimensionlocationkey | subtotal_dimensionlocationkey | Maps to subtotal.dimensions.location.key | |
| subtotal_dimensionprojectid | subtotal_dimensionprojectid | Maps to subtotal.dimensions.project.id | |
| subtotal_dimensionprojectkey | subtotal_dimensionprojectkey | Maps to subtotal.dimensions.project.key | |
| subtotal_dimensiontaskid | subtotal_dimensiontaskid | Maps to subtotal.dimensions.task.id | |
| subtotal_dimensiontaskkey | subtotal_dimensiontaskkey | Maps to subtotal.dimensions.task.key | |
| subtotal_dimensionvendorid | subtotal_dimensionvendorid | Maps to subtotal.dimensions.vendor.id | |
| subtotal_dimensionvendorkey | subtotal_dimensionvendorkey | Maps to subtotal.dimensions.vendor.key | |
| subtotal_dimensionwarehouseid | subtotal_dimensionwarehouseid | Maps to subtotal.dimensions.warehouse.id | |
| subtotal_dimensionwarehousekey | subtotal_dimensionwarehousekey | Maps to subtotal.dimensions.warehouse.key | |
| subtotal_percentvalue | subtotal_percentvalue | Subtotal: percent value (decimal string) | |
| subtotal_status | subtotal_status | Subtotal: status | |
| subtotal_txnabsolutevalue | subtotal_txnabsolutevalue | Subtotal: absolute value in transaction currency (decimal string) | |
| target_entity | target_entity | Target Sage Intacct entity ID (multi-entity scenarios) | |
| txncurrency | txncurrency | Transaction currency code | |
| txndefinitionid | txndefinitionid | Maps to txnDefinition.id | |
| txndefinitionkey | txndefinitionkey | Maps to txnDefinition.key |
Line Items
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Required | Notes |
| key | key | Delete | System-assigned key. NOTE: The Recurring Order Entry Line endpoint does NOT support Update - use Create or Delete only. Required for Delete. |
| conversiontype | conversiontype | ||
| custom | custom | Custom fields applied to the line. Suffix with .<fieldName> per custom field. | |
| dimensionaffiliateentityid | dimensionaffiliateentityid | Maps to dimensions.affiliateEntity.id | |
| dimensionaffiliateentitykey | dimensionaffiliateentitykey | Maps to dimensions.affiliateEntity.key | |
| dimensionassetid | dimensionassetid | Maps to dimensions.asset.id | |
| dimensionassetkey | dimensionassetkey | Maps to dimensions.asset.key | |
| dimensionclassid | dimensionclassid | Maps to dimensions.class.id | |
| dimensionclasskey | dimensionclasskey | Maps to dimensions.class.key | |
| dimensioncontractid | dimensioncontractid | Maps to dimensions.contract.id | |
| dimensioncontractkey | dimensioncontractkey | Maps to dimensions.contract.key | |
| dimensioncosttypeid | dimensioncosttypeid | Maps to dimensions.costType.id | |
| dimensioncosttypekey | dimensioncosttypekey | Maps to dimensions.costType.key | |
| dimensioncustomerid | dimensioncustomerid | Maps to dimensions.customer.id | |
| dimensioncustomerkey | dimensioncustomerkey | Maps to dimensions.customer.key | |
| dimensiondepartmentid | dimensiondepartmentid | Maps to dimensions.department.id | |
| dimensiondepartmentkey | dimensiondepartmentkey | Maps to dimensions.department.key | |
| dimensionemployeeid | dimensionemployeeid | Maps to dimensions.employee.id | |
| dimensionemployeekey | dimensionemployeekey | Maps to dimensions.employee.key | |
| dimensionitemid | dimensionitemid | Maps to dimensions.item.id | |
| dimensionitemkey | dimensionitemkey | Maps to dimensions.item.key | |
| dimensionlocationid | dimensionlocationid | Maps to dimensions.location.id | |
| dimensionlocationkey | dimensionlocationkey | Maps to dimensions.location.key | |
| dimensionprojectid | dimensionprojectid | Maps to dimensions.project.id | |
| dimensionprojectkey | dimensionprojectkey | Maps to dimensions.project.key | |
| dimensiontaskid | dimensiontaskid | Maps to dimensions.task.id | |
| dimensiontaskkey | dimensiontaskkey | Maps to dimensions.task.key | |
| dimensionvendorid | dimensionvendorid | Maps to dimensions.vendor.id | |
| dimensionvendorkey | dimensionvendorkey | Maps to dimensions.vendor.key | |
| dimensionwarehouseid | dimensionwarehouseid | Maps to dimensions.warehouse.id | |
| dimensionwarehousekey | dimensionwarehousekey | Maps to dimensions.warehouse.key | |
| discountmemo | discountmemo | ||
| discountpercent | discountpercent | Decimal string | |
| enabletax | enabletax | Boolean (true/false) | |
| id | id | User-defined identifier for the source record | |
| isbillable | isbillable | Boolean (true/false) | |
| ispriceprorated | ispriceprorated | Boolean (true/false) | |
| itemaliasid | itemaliasid | Maps to itemAlias.id | |
| itemaliaskey | itemaliaskey | Maps to itemAlias.key | |
| itemid | itemid | Maps to item.id | |
| itemkey | itemkey | Maps to item.key | |
| memo | memo | ||
| priceintxncurrency | priceintxncurrency | Price in transaction currency (decimal string) | |
| recurringdocumentheaderid | recurringdocumentheaderid | Maps to recurringDocumentHeader.id | |
| recurringdocumentheaderkey | recurringdocumentheaderkey | Maps to recurringDocumentHeader.key | |
| recurringstatus | recurringstatus | ||
| revenuerecognitionenddate | revenuerecognitionenddate | Date format: yyyy-MM-dd | |
| revenuerecognitionstartdate | revenuerecognitionstartdate | Date format: yyyy-MM-dd | |
| status | status | ||
| target_entity | target_entity | Target Sage Intacct entity ID (multi-entity scenarios) | |
| unit | unit | e.g. "Each", "10 Pack" | |
| unitprice | unitprice | Decimal string | |
| unitquantity | unitquantity | Decimal string |
To learn more about Sage Intacct API requirements, please visit https://developer.sage.com/intacct/apis/intacct/1/intacct-openapi/groups/order-entry/tags/order_entry_recurring-schedules/paths/get-order-entry-recurring-schedule-key.