Timesheet - Sage Intacct REST Data Target Requirements
DataBlend supports the standard API calls to Create, Update, and Delete Timesheet 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 |
| 09/01/2026 | begindate | Yes — Create | Start date of the timesheet period. Format: YYYY-MM-DD. |
| 9901 | key | Yes — Update, Delete | System-assigned key of the timesheet record. Required to identify the record for Update or Delete operations. |
| EMP-001 | employeeid | No | ID of the employee submitting the timesheet. Use employeeid or employeekey — not both. |
| 7701 | employeekey | No | Key of the employee. |
| Week of September 1 | description | No | Description of the timesheet. |
| 09/07/2026 | postingdate | No | GL posting date for the timesheet. Format: YYYY-MM-DD. |
| submitted | state | No | State of the timesheet. Options: submitted, approved, partiallyApproved, declined, draft, partiallyDeclined, saved. |
| Columbus | target_entity | No | Target entity ID for multi-entity Sage Intacct environments. |
| ATT-001 | attachmentid | No | ID of an attachment to associate with this timesheet. Use attachmentid or attachmentkey — not both. |
| 6601 | attachmentkey | No | Key of the attachment. |
| 09/02/2026 | line_entrydate | No | Date of the timesheet line entry. Format: YYYY-MM-DD. |
| 8 | line_quantity | No | Number of hours (or units) for the timesheet line. |
| TIMETYPE-001 | line_timetypeid | No | Time type ID for the line. Use line_timetypeid or line_timetypekey — not both. |
| 7001 | line_timetypekey | No | Key of the time type. |
| TRUE | line_isbillable | No | Whether the timesheet line is billable. Use true or false. |
| Foundation design review | line_description | No | Description for the timesheet line. |
| Site visit notes | line_notes | No | Additional notes for the timesheet line. |
| TS-001 | line_timesheetid | No | ID of the parent timesheet for the line. Use line_timesheetid or line_timesheetkey — not both. |
| 9902 | line_timesheetkey | No | Key of the parent timesheet. |
| 500 | line_externalpayrollamount | No | External payroll amount for the line. |
| 75 | line_externalpayrollbillingrate | No | External payroll billing rate for the line. |
| 62.5 | line_externalpayrollcostrate | No | External payroll cost rate for the line. |
| 10 | line_externalpayrollemployertaxes | No | External payroll employer taxes amount for the line. |
| 5 | line_externalpayrollfringes | No | External payroll fringe amounts for the line. |
| 2.5 | line_externalpayrollcashfringes | No | External payroll cash fringes amount for the line. |
| LOC-001 | line_dimensionslocationid | No | Location ID dimension for the line. Use line_dimensionslocationid or line_dimensionslocationkey — not both. |
| 8001 | line_dimensionslocationkey | No | Key of the location dimension. |
| DEPT-001 | line_dimensionsdepartmentid | No | Department ID dimension. |
| 8101 | line_dimensionsdepartmentkey | No | Key of the department dimension. |
| PROJ-001 | line_dimensionsprojectid | No | Project ID dimension. |
| 8201 | line_dimensionsprojectkey | No | Key of the project dimension. |
| TASK-001 | line_dimensionstaskid | No | Task ID dimension. |
| 8301 | line_dimensionstaskkey | No | Key of the task dimension. |
| ENTITY-B | line_dimensionsaffiliateentityid | No | Affiliate entity ID dimension. |
| 8401 | line_dimensionsaffiliateentitykey | No | Key of the affiliate entity dimension. |
| ASSET-001 | line_dimensionsassetid | No | Asset ID dimension. |
| 8501 | line_dimensionsassetkey | No | Key of the asset dimension. |
| CLASS-A | line_dimensionsclassid | No | Class ID dimension. |
| 8601 | line_dimensionsclasskey | No | Key of the class dimension. |
| CONTRACT-001 | line_dimensionscontractid | No | Contract ID dimension. |
| 8701 | line_dimensionscontractkey | No | Key of the contract dimension. |
| COSTYPE-001 | line_dimensionscosttypeid | No | Cost type ID dimension. |
| 8801 | line_dimensionscosttypekey | No | Key of the cost type dimension. |
| CUST-001 | line_dimensionscustomerid | No | Customer ID dimension. |
| 8901 | line_dimensionscustomerkey | No | Key of the customer dimension. |
| EMP-002 | line_dimensionsemployeeid | No | Employee ID dimension. |
| 9001 | line_dimensionsemployeekey | No | Key of the employee dimension. |
| ITEM-001 | line_dimensionsitemid | No | Item ID dimension. |
| 9101 | line_dimensionsitemkey | No | Key of the item dimension. |
| LOAN-001 | line_dimensionsloanaccountid | No | Loan account ID dimension. |
| 9201 | line_dimensionsloanaccountkey | No | Key of the loan account dimension. |
| VEND-001 | line_dimensionsvendorid | No | Vendor ID dimension. |
| 9301 | line_dimensionsvendorkey | No | Key of the vendor dimension. |
| WH-001 | line_dimensionswarehouseid | No | Warehouse ID dimension. |
| 9401 | line_dimensionswarehousekey | No | Key of the warehouse dimension. |
| WO-001 | line_dimensionsworkorderid | No | Work order ID dimension. |
| 9501 | line_dimensionsworkorderkey | No | Key of the work order 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/time/tags/time_timesheets.