ADO.NET Provider for Sage Intacct

Build 26.0.9655

Employee

Represents employees, including personal details, ACH payment settings, bank file configuration, position and type assignments, contact information, and expense defaults.

Columns

Name Type ReadOnly Description
SSN String False

The Social Security Number of the employee.

achAccountNumber String False

The ACH bank account number for the employee.

achAccountType String False

The ACH bank account type for the employee, such as checking or savings.

achBankRoutingNumber String False

The ACH bank routing number for the employee.

achEnabled Bool False

Indicates whether ACH payment is enabled for this employee.

achRemittanceType String False

The ACH remittance type for the employee, controlling how remittance information is delivered.

attachmentFolder_Href String True

The URL of the attachment folder associated with this employee.

attachmentFolder_Id String False

The Id of the attachment folder associated with this employee.

attachmentFolder_Key String False

The system-assigned key of the attachment folder associated with this employee.

auditCreatedBy String True

The user who created the employee record.

auditCreatedDateTime Datetime True

The date and time when the employee record was created.

auditModifiedBy String True

The user who last modified the employee record.

auditModifiedDateTime Datetime True

The date and time when the employee record was last modified.

bankFilePaymentCountryCode String False

The country code used for bank file payments for this employee.

bankFilePaymentCurrency String False

The payment currency used for bank file payments for this employee.

birthDate Date False

The date of birth of the employee.

class_Href String True

The URL of the class associated with this employee.

class_Id String False

The Id of the class associated with this employee.

class_Key String False

The system-assigned key of the class associated with this employee.

defaultCurrency String False

The default currency used for this employee's transactions.

defaultCustomer_Href String True

The URL of the default customer associated with this employee.

defaultCustomer_Id String False

The Id of the default customer associated with this employee.

defaultCustomer_Key String False

The system-assigned key of the default customer associated with this employee.

defaultExpenseDistribution_Href String True

The URL of the default expense distribution associated with this employee.

defaultExpenseDistribution_Id String False

The Id of the default expense distribution associated with this employee.

defaultExpenseDistribution_Key String False

The system-assigned key of the default expense distribution associated with this employee.

defaultItem_Href String True

The URL of the default item associated with this employee.

defaultItem_Id String False

The Id of the default item associated with this employee.

defaultItem_Key String False

The system-assigned key of the default item associated with this employee.

defaultTimeAllocation_Href String True

The URL of the default time allocation associated with this employee.

defaultTimeAllocation_Id String False

The Id of the default time allocation associated with this employee.

defaultTimeAllocation_Key String False

The system-assigned key of the default time allocation associated with this employee.

defaultVendor_Href String True

The URL of the default vendor associated with this employee.

defaultVendor_Id String False

The Id of the default vendor associated with this employee.

defaultVendor_Key String False

The system-assigned key of the default vendor associated with this employee.

department_Href String True

The URL of the department associated with this employee.

department_Id String False

The Id of the department associated with this employee.

department_Key String False

The system-assigned key of the department associated with this employee.

earningType_Href String True

The URL of the earning type associated with this employee.

earningType_Id String False

The Id of the earning type associated with this employee.

earningType_Key String False

The system-assigned key of the earning type associated with this employee.

employeePosition_Href String True

The URL of the employee position associated with this employee.

employeePosition_Id String False

The Id of the employee position associated with this employee.

employeePosition_Key String False

The system-assigned key of the employee position associated with this employee.

employeeType_Href String True

The URL of the employee type associated with this employee.

employeeType_Id String False

The Id of the employee type associated with this employee.

employeeType_Key String False

The system-assigned key of the employee type associated with this employee.

endDate Date False

The employment end date for this employee.

entity_Href String True

The URL of the entity associated with this employee.

entity_Id String True

The Id of the entity associated with this employee.

entity_Key String True

The system-assigned key of the entity associated with this employee.

filePaymentService String False

The file payment service used for processing payments for this employee.

form1099Box String False

The Form 1099 box number applicable to this employee.

form1099Type String False

The Form 1099 type applicable to this employee.

gender String False

The gender of the employee.

href String True

The URL of the employee resource.

id String False

The unique identifier of the employee.

isPlaceholderResource Bool False

Indicates whether this employee is a placeholder resource used for project planning.

jobTitle String False

The job title of the employee.

key [KEY] String True

The system-assigned key that uniquely identifies the employee record.

location_Href String True

The URL of the location associated with this employee.

location_Id String False

The Id of the location associated with this employee.

location_Key String False

The system-assigned key of the location associated with this employee.

manager_Href String True

The URL of the manager associated with this employee.

manager_Id String False

The Id of the manager associated with this employee.

manager_Key String False

The system-assigned key of the manager associated with this employee.

mergePaymentRequests Bool False

Indicates whether payment requests for this employee are merged into a single payment.

nsp_r367282_Key String False

The system-assigned key of the nsp r367282 relationship for this employee.

postActualCostWithVariance Bool False

Indicates whether actual costs are posted with variance for this employee.

preferredPaymentMethod String False

The preferred payment method for this employee, such as check or ACH.

primaryContact_Email1 String True

The primary email address of the employee's primary contact.

primaryContact_Email2 String True

The secondary email address of the employee's primary contact.

primaryContact_Fax String True

The fax number of the employee's primary contact.

primaryContact_Href String True

The URL of the employee's primary contact record.

primaryContact_Id String False

The Id of the employee's primary contact record.

primaryContact_Key String False

The system-assigned key of the employee's primary contact record.

primaryContact_Mobile String True

The mobile phone number of the employee's primary contact.

primaryContact_Pager String True

The pager number of the employee's primary contact.

primaryContact_Phone1 String True

The primary phone number of the employee's primary contact.

primaryContact_Phone2 String True

The secondary phone number of the employee's primary contact.

primaryContact_Prefix String True

The name prefix of the employee's primary contact.

primaryContact_PrintAs String True

The formatted display name used for printing for the employee's primary contact.

primaryContact_URL1 String True

The primary URL of the employee's primary contact.

primaryContact_URL2 String True

The secondary URL of the employee's primary contact.

sendAutomaticPaymentNotification Bool False

Indicates whether automatic payment notifications are sent to this employee.

startDate Date False

The employment start date for this employee.

status String False

The current status of the employee, such as active or inactive.

terminationType String False

The reason for the employee's termination, such as voluntary or involuntary.

ListAggregate_BankFileSetup String False

The aggregate list of bank file setup records associated with this employee.

ListAggregate_EmployeeRates String False

The aggregate list of employee rate records associated with this employee.

ListAggregate_PositionSkills String False

The aggregate list of position skill records associated with this employee.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655