Employee - Sage Intacct Data Target Requirements

DataBlend supports the API calls to Create and Update Employee records within Sage Intacct leveraging the Sage Intacct SDK. In addition, Custom Fields can be added for data that is unique to your business practices.

An employee is a resource that executes work for a company and is associated with a financial transaction such as a timesheet entry or expense transaction.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
1099BOX	FORM1099BOX	Form 1099 box	Optional	Expected value is free text (4)
1099NAME	NAME1099	1099 name	Optional	Expected value is free text (100)
1099TYPE	FORM1099TYPE	Form 1099 type	Optional	Expected value is free text (4)
ACHENABLED	ACHENABLED	Enable ACH	Optional	Check box. Use `false` for No, `true` for Yes. (Default: `false`)
ACTIVE	STATUS	Status	Optional	Use `TRUE` for Active otherwise use `FALSE` for Inactive (Default: `TRUE`)
ATTACHMENTFOLDERNAME	SUPDOCFOLDERNAME	Attachment folder	Optional	Expected value is free text
BANKACCOUNTTYPE	ACHACCOUNTTYPE	Account type	Optional	Expected value is free text
BANKACCOUNTCLASS	ACHREMITTANCETYPE	Account classification	Optional	Expected value is free text
BANKACCOUNTNO	ACHACCOUNTNUMBER	Account number	Optional	Expected value is free text (17)
BANKACCOUNTROUTINGNO	ACHBANKROUTINGNUMBER	ACH bank routing number	Optional	Expected value is free text (9)
BIRTHDATE	BIRTHDATE	Birth date	Optional	Birth date in format `mm/dd/yyyy`
CLASSID	CLASSID	Class ID	Optional	Expected value is free text
CONTACTNAME	CONTACTNAME	Primary contact name	Yes	Expected value is free text (200)
DEFAULTCURRENCY	CURRENCY	Default currency	Optional	Expected value is free text
DEPARTMENTID	DEPARTMENTID	Department ID	Optional	Expected value is free text
EARNINGTYPENAME	EARNINGTYPENAME	Earning type	Optional	Expected value is free text
EMPLOYEEID	EMPLOYEEID	Employee ID	Yes	Unique ID for the employee. Required if company does not use document sequencing, or you can provide a value to use instead of the document sequence value.
EMPLOYEETYPE	EMPLOYEETYPE	Employee type	Optional	Expected value is free text (20)
ENDDATE	ENDDATE	End date	Optional	Expected value is date
GENDER	GENDER	Gender	Optional	Expected value is free text
LOCATIONID	LOCATIONID	Location ID	Optional	`LOCATIONID` of an active location. Required if company is multi-entity enabled
MANAGEREMPLOYEEID	SUPERVISORID	Manager	Optional	Expected value is free text (20)
MERGEPAYMENTREQUESTS	MERGEPAYMENTREQ	Merge payment requests	Optional	Check box. Use `false` for No, `true` for Yes. (Default: `true`)
PLACEHOLDERRESOURCE	GENERIC	Placeholder resource	Optional	Check box
POSTACTUALCOST	POSTACTUALCOST	Post actual labor costs with variance	Optional	Check box. Use `false` for No, `true` for Yes. (Default: `false`)
PREFERREDPAYMENT	PAYMETHODKEY	Preferred payment method	Optional	Expected value is free text
RECORDNO	RECORDNO	Record number	Yes/Optional	Yes for Update. Expected value is integer
SENDAUTOMATICPAYMENTNOTIFICATION	PAYMENTNOTIFY	Send automatic payment notification	Optional	Check box. Use `false` for No, `true` for Yes. (Default: `false`)
SSN	SSN	Social security number	Optional	Do not include dashes
STARTDATE	STARTDATE	Start date	Optional	Expected value is date
TERMINATIONTYPE	TERMINATIONTYPE	Termination type	Optional	Expected value is free text
TITLE	TITLE	Title	Optional	Expected value is free text (30)