Project Change Order - Sage Intacct REST Data Target Requirements
DataBlend supports the standard API calls to Create, Update, and Delete Project Change Order 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 |
| PROJ-001 | projectid | Yes — Create | ID of the project this change order belongs to. Use projectid or projectkey — not both. |
| 7701 | projectkey | No | Key of the project. |
| ITEM-001 | itemid | Yes — Create | ID of the item for this change order. Use itemid or itemkey — not both. |
| 7801 | itemkey | No | Key of the item. |
| 09/01/2026 | projectchangeorderdate | Yes — Create | Date of the change order. Format: YYYY-MM-DD. |
| 09/15/2026 | priceeffectivedate | Yes — Create | Effective date for pricing on this change order. Format: YYYY-MM-DD. |
| 9901 | key | Yes — Update, Delete | System-assigned key of the change order record. Required to identify the record for Update or Delete operations. |
| PCO-001 | id | No | User-defined ID of the change order. |
| Additional foundation work | description | No | Description of the change order. |
| Open | state | No | State of the change order. |
| Active | status | No | Status of the change order. |
| Foundation and excavation scope | scope | No | Scope description for the change order. |
| Includes site prep | inclusions | No | Description of what is included in the change order. |
| Excludes landscaping | exclusions | No | Description of what is excluded from the change order. |
| Payment within 30 days | terms | No | Payment terms for the change order. |
| CRSTATUS-001 | changerequeststatusid | No | ID of the change request status. Use changerequeststatusid or changerequeststatuskey — not both. |
| 6601 | changerequeststatuskey | No | Key of the change request status. |
| CONTACT-001 | sendtocontactid | No | ID of the contact to send the change order to. Use sendtocontactid or sendtocontactkey — not both. |
| 6701 | sendtocontactkey | No | Key of the send-to contact. |
| Columbus | target_entity | No | Target entity ID for multi-entity Sage Intacct environments. |
| PC-001 | projectcontractid | No | ID of the associated project contract. Use projectcontractid or projectcontractkey — not both. |
| 8801 | projectcontractkey | No | Key of the project contract. |
| LINE-001 | projectcontractlineid | No | ID of the associated project contract line. Use projectcontractlineid or projectcontractlinekey — not both. |
| 8901 | projectcontractlinekey | No | Key of the project contract line. |
| 09/10/2026 | scheduleresponseduedate | No | Date by which a response is due. Format: YYYY-MM-DD. |
| 09/15/2026 | schedulenoticetoproceeddate | No | Notice to proceed date. Format: YYYY-MM-DD. |
| 09/01/2026 | schedulescheduledstartdate | No | Scheduled start date. Format: YYYY-MM-DD. |
| 12/31/2026 | schedulescheduledcompletiondate | No | Scheduled completion date. Format: YYYY-MM-DD. |
| 01/31/2027 | schedulerevisedcompletiondate | No | Revised completion date. Format: YYYY-MM-DD. |
| 09/05/2026 | scheduleactualstartdate | No | Actual start date. Format: YYYY-MM-DD. |
| 01/15/2027 | scheduleactualcompletiondate | No | Actual completion date. Format: YYYY-MM-DD. |
| 12/15/2026 | schedulesubstantialcompletiondate | No | Substantial completion date. Format: YYYY-MM-DD. |
| 09/18/2026 | scheduleexecutedondate | No | Date the change order was executed. Format: YYYY-MM-DD. |
| 14 days | schedulescheduleimpact | No | Description of the schedule impact. |
| INT-REF-001 | internalreferencereferencenumber | No | Internal reference number. |
| Owner request | internalreferencesource | No | Source of the internal reference. |
| SRC-REF-001 | internalreferencesourcereferencenumber | No | Source reference number for the internal reference. |
| EMP-001 | internalreferenceinitiatedbyid | No | ID of the employee who initiated the change order. Use internalreferenceinitiatedbyid or internalreferenceinitiatedbykey — not both. |
| 5501 | internalreferenceinitiatedbykey | No | Key of the initiating employee. |
| EMP-002 | internalreferenceissuedbyid | No | ID of the employee who issued the change order. Use internalreferenceissuedbyid or internalreferenceissuedbykey — not both. |
| 5601 | internalreferenceissuedbykey | No | Key of the issuing employee. |
| 09/03/2026 | internalreferenceissuedondate | No | Date the change order was issued internally. Format: YYYY-MM-DD. |
| EMP-003 | internalreferenceapprovedbyid | No | ID of the employee who approved internally. Use internalreferenceapprovedbyid or internalreferenceapprovedbykey — not both. |
| 5701 | internalreferenceapprovedbykey | No | Key of the internal approving employee. |
| 09/05/2026 | internalreferenceapprovedondate | No | Date of internal approval. Format: YYYY-MM-DD. |
| EMP-004 | internalreferencesignedbyid | No | ID of the employee who signed internally. Use internalreferencesignedbyid or internalreferencesignedbykey — not both. |
| 5801 | internalreferencesignedbykey | No | Key of the internally signing employee. |
| 09/06/2026 | internalreferencesignedondate | No | Date of internal signature. Format: YYYY-MM-DD. |
| EMP-005 | internalreferenceverbalapprovalbyid | No | ID of the employee who gave verbal approval internally. Use internalreferenceverbalapprovalbyid or internalreferenceverbalapprovalbykey — not both. |
| 5901 | internalreferenceverbalapprovalbykey | No | Key of the internal verbal approver. |
| EXT-REF-001 | externalreferencereferencenumber | No | External reference number. |
| CONTACT-001 | externalreferenceapprovedbyid | No | ID of the external contact who approved the change order. Use externalreferenceapprovedbyid or externalreferenceapprovedbykey — not both. |
| 6001 | externalreferenceapprovedbykey | No | Key of the external approving contact. |
| 09/08/2026 | externalreferenceapprovedondate | No | Date of external approval. Format: YYYY-MM-DD. |
| CONTACT-002 | externalreferencesignedbyid | No | ID of the external contact who signed. Use externalreferencesignedbyid or externalreferencesignedbykey — not both. |
| 6101 | externalreferencesignedbykey | No | Key of the external signing contact. |
| 09/09/2026 | externalreferencesignedondate | No | Date of external signature. Format: YYYY-MM-DD. |
| CONTACT-003 | externalreferenceverbalapprovalbyid | No | ID of the external contact who gave verbal approval. Use externalreferenceverbalapprovalbyid or externalreferenceverbalapprovalbykey — not both. |
| 6201 | externalreferenceverbalapprovalbykey | No | Key of the external verbal approver. |
| ATT-001 | attachmentid | No | ID of an attachment to associate with this change order. Use attachmentid or attachmentkey — not both. |
| 6301 | attachmentkey | No | Key of the attachment. |
| 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/change-requests-and-orders/tags/construction_project-change-orders.