Project Contract Line - Sage Intacct REST Data Target Requirements
DataBlend supports the standard API calls to Create, Update, and Delete Project Contract Line records within Sage Intacct leveraging the Sage Intacct API. In addition, Custom Fields can be added for data that is unique to your business practices.
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Required | Notes |
| PC-001 | contractid | Yes — Create | ID of the parent project contract this line belongs to. Use contractid or contractkey — not both. |
| 7701 | contractkey | No | Key of the parent project contract. |
| ITEM-001 | itemid | Yes — Create | ID of the item for this contract line. Use itemid or itemkey — not both. |
| 7801 | itemkey | No | Key of the item. |
| 9901 | key | Yes — Update, Delete | System-assigned key of the contract line record. Required to identify the record for Update or Delete operations. |
| Foundation work contract line | memo | No | Memo or description for the contract line. |
| Custom item description | itemdescription | No | Override description for the item on this line. |
| Open | state | No | State of the contract line. |
| AddOn | changetype | No | Change type for the contract line. |
| NotDelivered | deliverystatus | No | Delivery status of the contract line. |
| FALSE | isrecurring | No | Whether the contract line is recurring. Use true or false. |
| 09/01/2026 | startdate | No | Start date of the contract line. Format: YYYY-MM-DD. |
| 08/31/2027 | enddate | No | End date of the contract line. Format: YYYY-MM-DD. |
| 09/07/2026 | postingdate | No | GL posting date for the contract line. Format: YYYY-MM-DD. |
| Columbus | target_entity | No | Target entity ID for multi-entity Sage Intacct environments. |
| FixedPrice | billingmethod | No | Billing method for the contract line. |
| Monthly | billingfrequency | No | Billing frequency for the contract line. |
| PerPeriod | billingamountfrequency | No | Billing amount frequency. |
| 5000 | billingflatfixedamount | No | Flat fixed billing amount for the contract line. |
| 12 | billingdurationinperiods | No | Billing duration in periods. |
| 09/01/2026 | billingstartdate | No | Billing start date. Format: YYYY-MM-DD. |
| 08/31/2027 | billingenddate | No | Billing end date. Format: YYYY-MM-DD. |
| 10 | billingquantity | No | Billing quantity for the contract line. |
| PerUnit | billingquantitytype | No | Billing quantity type. |
| 200 | billingrate | No | Billing rate for the contract line. |
| 1 | billingmultiplier | No | Billing multiplier applied to the rate. |
| 10 | billingdiscount | No | Billing discount percentage. |
| Billing notes | billingmemo | No | Billing memo for the contract line. |
| TRUE | billingproratepartialperiods | No | Whether to prorate billing for partial periods. Use true or false. |
| FALSE | billingisusagequantityrecurring | No | Whether usage quantity billing recurs. Use true or false. |
| Reset | billingusagequantityreset | No | Usage quantity reset behavior. |
| StopBilling | billingcommittedquantityendaction | No | Action taken when committed quantity is reached. |
| ChargeOverage | billingcommittedquantityexcess | No | Handling for quantity that exceeds the committed amount. |
| TMPL-001 | billingtemplateid | No | Billing template ID. Use billingtemplateid or billingtemplatekey — not both. |
| 6601 | billingtemplatekey | No | Key of the billing template. |
| ContractBillTo | billtosource | No | Source for bill-to contact on the contract line. |
| ContractShipTo | shiptosource | No | Source for ship-to contact on the contract line. |
| 09/01/2026 | currencyexchangeratedate | No | Date used to determine the exchange rate. Format: YYYY-MM-DD. |
| 1.25 | currencyexchangerate | No | Exchange rate for the contract line. |
| Deferred | revenuedeferralstatus | No | Revenue deferral status for the contract line. |
| Revenue recognition memo | revenuememo | No | Memo for revenue recognition on the contract line. |
| Expense recognition memo | expensememo | No | Memo for expense recognition on the contract line. |
| 100 | revenuetotalquantity | No | Total quantity for revenue recognition. |
| REV-TMPL-001 | revenuejournal1revenuetemplateid | No | Revenue template ID for journal 1. Use revenuejournal1revenuetemplateid or revenuejournal1revenuetemplatekey — not both. |
| 6701 | revenuejournal1revenuetemplatekey | No | Key of the revenue template for journal 1. |
| 09/01/2026 | revenuejournal1startdate | No | Start date for revenue journal 1 recognition. Format: YYYY-MM-DD. |
| 08/31/2027 | revenuejournal1enddate | No | End date for revenue journal 1 recognition. Format: YYYY-MM-DD. |
| REV-TMPL-002 | revenuejournal2revenuetemplateid | No | Revenue template ID for journal 2. Use revenuejournal2revenuetemplateid or revenuejournal2revenuetemplatekey — not both. |
| 6801 | revenuejournal2revenuetemplatekey | No | Key of the revenue template for journal 2. |
| 09/01/2026 | revenuejournal2startdate | No | Start date for revenue journal 2 recognition. Format: YYYY-MM-DD. |
| 08/31/2027 | revenuejournal2enddate | No | End date for revenue journal 2 recognition. Format: YYYY-MM-DD. |
| TRUE | renewalrenew | No | Whether this contract line renews automatically. Use true or false. |
| RENEW-TMPL-001 | renewalbillingtemplateid | No | Billing template ID to use upon renewal. Use renewalbillingtemplateid or renewalbillingtemplatekey — not both. |
| 6901 | renewalbillingtemplatekey | No | Key of the renewal billing template. |
| 9901 | customrenewalamount_key | No | Key of the custom renewal amount record. |
| 5500 | customrenewalamount_overrideamount | No | Custom override amount to use at renewal. |
| TRUE | historicalishistorical | No | Whether this contract line contains historical data. Use true or false. |
| 08/31/2026 | historicalasofdate | No | As-of date for historical data. Format: YYYY-MM-DD. |
| 10000 | historicalbilledamount | No | Historical billed amount as of the as-of date. |
| 9000 | historicalrecognizedamount | No | Historical recognized revenue amount as of the as-of date. |
| 1000 | historicaloffsetglaccountid | No | Offset GL account ID for historical entries. Use historicaloffsetglaccountid or historicaloffsetglaccountkey — not both. |
| 7001 | historicaloffsetglaccountkey | No | Key of the offset GL account for historical entries. |
| LOC-001 | dimensionslocationid | No | Location ID dimension. Use dimensionslocationid or dimensionslocationkey — not both. |
| 8001 | dimensionslocationkey | No | Key of the location dimension. |
| DEPT-001 | dimensionsdepartmentid | No | Department ID dimension. |
| 8101 | dimensionsdepartmentkey | No | Key of the department dimension. |
| PROJ-001 | dimensionsprojectid | No | Project ID dimension. |
| 8201 | dimensionsprojectkey | No | Key of the project dimension. |
| TASK-001 | dimensionstaskid | No | Task ID dimension. |
| 8301 | dimensionstaskkey | No | Key of the task dimension. |
| CLASS-A | dimensionsclassid | No | Class ID dimension. |
| 8401 | dimensionsclasskey | No | Key of the class dimension. |
| CUST-001 | dimensionscustomerid | No | Customer ID dimension. |
| 8501 | dimensionscustomerkey | No | Key of the customer dimension. |
| EMP-001 | dimensionsemployeeid | No | Employee ID dimension. |
| 8601 | dimensionsemployeekey | No | Key of the employee dimension. |
| VEND-001 | dimensionsvendorid | No | Vendor ID dimension. |
| 8701 | dimensionsvendorkey | No | Key of the vendor dimension. |
| custom.entry.{custom_field_name} | {custom_field_name} | No | Custom fields for this object. Replace {custom_field_name} with the custom field's object ID as defined in Sage Intacct. |
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/construction/groups/project-contracts/tags/construction_project-contract-lines.