Employee - Sage Intacct REST Data Target Requirements
DataBlend supports the standard API calls to Create, Update, and Delete Employee 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 |
| EMP-001 | id | Yes — Create | User-defined ID for the employee record. |
| CONTACT-001 | primarycontactid | Yes — Create | ID of the primary contact linked to this employee. Use primarycontactid or primarycontactkey — not both. |
| 7701 | primarycontactkey | No | Key of the primary contact. |
| 9901 | key | Yes — Update, Delete | System-assigned key of the employee record. Required to identify the record for Update or Delete operations. |
| Jane Smith | name | No | Display name of the employee. |
| Senior Consultant | jobtitle | No | Job title of the employee. |
| active | status | No | Employment status of the employee (e.g. active, inactive). |
| Voluntary | terminationtype | No | Termination type if the employee has been terminated. |
| Female | gender | No | Gender of the employee. |
| 06/15/1985 | birthdate | No | Date of birth of the employee. Format: YYYY-MM-DD. |
| 01/01/2020 | startdate | No | Employment start date. Format: YYYY-MM-DD. |
| 12/31/2026 | enddate | No | Employment end date. Format: YYYY-MM-DD. |
| FALSE | isplaceholderresource | No | Whether this employee is a placeholder resource. Use true or false. |
| Columbus | target_entity | No | Target entity ID for multi-entity Sage Intacct environments. |
| LOC-001 | locationid | No | Location ID for the employee. Use locationid or locationkey — not both. |
| 7801 | locationkey | No | Key of the location. |
| DEPT-001 | departmentid | No | Department ID for the employee. Use departmentid or departmentkey — not both. |
| 7901 | departmentkey | No | Key of the department. |
| MGR-001 | managerid | No | Employee ID of the manager. Use managerid or managerkey — not both. |
| 8001 | managerkey | No | Key of the manager employee record. |
| CLASS-A | classid | No | Class ID for the employee. Use classid or classkey — not both. |
| 8101 | classkey | No | Key of the class. |
| POS-001 | employeepositionid | No | Employee position ID. Use employeepositionid or employeepositionkey — not both. |
| 8201 | employeepositionkey | No | Key of the employee position. |
| EMPTYPE-001 | employeetypeid | No | Employee type ID. Use employeetypeid or employeetypekey — not both. |
| 8301 | employeetypekey | No | Key of the employee type. |
| 85000 | employeerate_annualsalary | No | Annual salary for the employee. |
| 40 | employeerate_hourlyrate | No | Hourly rate for the employee. |
| 01/01/2026 | employeerate_startdate | No | Start date for this rate. Format: YYYY-MM-DD. |
| 12/31/2026 | employeerate_enddate | No | End date for this rate. Format: YYYY-MM-DD. |
| USD | defaultcurrency | No | Default currency code for the employee. |
| EARN-001 | earningtypeid | No | Default earning type ID. Use earningtypeid or earningtypekey — not both. |
| 8401 | earningtypekey | No | Key of the earning type. |
| CUST-001 | defaultcustomerid | No | Default customer ID for expense reporting. Use defaultcustomerid or defaultcustomerkey — not both. |
| 8501 | defaultcustomerkey | No | Key of the default customer. |
| VEND-001 | defaultvendorid | No | Default vendor ID linked to this employee. Use defaultvendorid or defaultvendorkey — not both. |
| 8601 | defaultvendorkey | No | Key of the default vendor. |
| ITEM-001 | defaultitemid | No | Default item ID for time entry. Use defaultitemid or defaultitemkey — not both. |
| 8701 | defaultitemkey | No | Key of the default item. |
| EXPDIST-001 | defaultexpensedistributionid | No | Default expense distribution ID. Use defaultexpensedistributionid or defaultexpensedistributionkey — not both. |
| 8801 | defaultexpensedistributionkey | No | Key of the default expense distribution. |
| TIMEALLOC-001 | defaulttimeallocationid | No | Default time allocation ID. Use defaulttimeallocationid or defaulttimeallocationkey — not both. |
| 8901 | defaulttimeallocationkey | No | Key of the default time allocation. |
| FALSE | postactualcostwithvariance | No | Whether to post actual cost with variance. Use true or false. |
| ADDR-001 | primarycontactmailingaddressid | No | Mailing address ID for the primary contact. Use primarycontactmailingaddressid or primarycontactmailingaddresskey — not both. |
| 9001 | primarycontactmailingaddresskey | No | Key of the primary contact mailing address. |
| Check | preferredpaymentmethod | No | Preferred payment method for the employee. |
| TRUE | sendautomaticpaymentnotification | No | Whether to send automatic payment notifications. Use true or false. |
| TRUE | mergepaymentrequests | No | Whether to merge payment requests for this employee. Use true or false. |
| TRUE | achenabled | No | Whether ACH payment is enabled for this employee. Use true or false. |
| Checking | achaccounttype | No | ACH bank account type (e.g. Checking, Savings). |
| 123456789 | achaccountnumber | No | ACH bank account number. |
| 21000021 | achbankroutingnumber | No | ACH bank routing number. |
| DirectDeposit | achremittancetype | No | ACH remittance type. |
| AU | bankfilepaymentcountrycode | No | Country code for bank file payment (e.g. AU, GB). |
| AUD | bankfilepaymentcurrency | No | Currency for bank file payment. |
| ABA | filepaymentservice | No | File payment service type. |
| EMP-001 | bankfilesetup_employeeid | No | Employee ID for bank file setup. Use bankfilesetup_employeeid or bankfilesetup_employeekey — not both. |
| 9101 | bankfilesetup_employeekey | No | Key of the employee for bank file setup. |
| ANZ Bank | bankfilesetup_bankaccountname | No | Bank account name for the bank file setup. |
| 987654321 | bankfilesetup_bankaccountnumber | No | Bank account number for the bank file setup. |
| ACC-001 | bankfilesetup_bankaccountcode | No | Bank account code for the bank file setup. |
| Savings | bankfilesetup_bankaccounttype | No | Bank account type for the bank file setup. |
| Personal | bankfilesetup_accountclassification | No | Account classification for the bank file setup. |
| SWIFT001 | bankfilesetup_businessidcode | No | Business identifier code (BIC/SWIFT) for the bank file setup. |
| 063-000 | bankfilesetup_bsbnumber | No | BSB number (Australia) for the bank file setup. |
| 20-00-00 | bankfilesetup_sortcode | No | Sort code (UK) for the bank file setup. |
| BR001 | bankfilesetup_branchcode | No | Branch code for the bank file setup. |
| CRED-001 | bankfilesetup_creditorcode | No | Creditor code for the bank file setup. |
| SEC-ID-001 | bankfilesetup_secondaryidentifier | No | Secondary identifier for the bank file setup. |
| PAY-REF-001 | bankfilesetup_paymentreference | No | Payment reference for the bank file setup. |
| FALSE | bankfilesetup_printpaymentproof | No | Whether to print payment proof. Use true or false. |
| 123 Bank Street | bankfilesetup_creditorbankaddressaddressline1 | No | Creditor bank address line 1. |
| Suite 100 | bankfilesetup_creditorbankaddressaddressline2 | No | Creditor bank address line 2. |
| AU | bankfilesetup_creditorbankaddresscountrycode | No | Country code for the creditor bank address. |
| New South Wales | bankfilesetup_creditorbankaddresscounty | No | County or state for the creditor bank address. |
| 2000 | bankfilesetup_creditorbankaddresspostcode | No | Postcode for the creditor bank address. |
| 123-45-6789 | ssn | No | Social Security Number of the employee. |
| 1099-NEC | form1099type | No | 1099 form type for this employee. |
| Nonemployee Compensation | form1099name | No | Name on the 1099 form. |
| 1 | form1099box | No | Box number on the 1099 form. |
| HR-FILES | attachmentfolderid | No | Attachment folder ID for documents associated with this employee. Use attachmentfolderid or attachmentfolderkey — not both. |
| 9201 | attachmentfolderkey | No | Key of the attachment folder. |
| 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/company-configuration/groups/employee-dimension/tags/company_configuration_employees.