Skip to content
English
  • There are no suggestions because the search field is empty.

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.