Excel Add-In for Sage Intacct

Build 25.0.9434

Employee

Tracks employee records, including contact details, positions, and associated operational data.

Table Specific Information

In the Employee table, INSERT and UPDATE operations have additional considerations:

INSERT-the Personalinfo_contactname column is a required input. This column is mapped to the Contactname column of Contact table, which links these two tables.

DELETE-specify the Recordno column in the WHERE statement to delete the record.

Examples

INSERT 
 INSERT INTO Employee (Employeeid, Title, Personalinfo_contactname) VALUES ('Test', 'Test', 'Valid_record_from_Contactname_in_Contact_table')
DELETE 
DELETE FROM Employee WHERE Recordno = 3

Columns

Name Type ReadOnly Description
Recordno Int64 False

The unique identifier for the employee record.

Employeeid [KEY] String False

The ID of the employee.

Title String False

The job title of the employee.

Locationid String False

The ID of the location associated with the employee.

Locationkey Int64 False

The key of the location associated with the employee.

Departmentid String False

The ID of the department associated with the employee.

Departmentkey Int64 False

The key of the department associated with the employee.

Parentkey Int64 False

The key of the parent entity associated with the employee.

Supervisorid String False

The ID of the supervisor for the employee.

Supervisorname String False

The name of the supervisor for the employee.

Birthdate Datetime False

The birth date of the employee.

Startdate Datetime False

The start date of the employee.

Enddate Datetime False

The end date of the employee, if applicable.

Status String False

The current status of the employee (for example, Active, Inactive).

Employeetype String False

The type of employee (for example, full-time, part-time).

Employeetype1099type String False

The 1099 type of the employee, if applicable.

Emptypekey Int64 False

The key of the employee type associated with the employee.

Gender String False

The gender of the employee.

Terminationtype String False

The type of termination, if applicable.

Personalinfo_contactname String False

The contact name for the employee's personal information.

Personalinfo_prefix String False

The prefix (for example, Mr., Ms.) in the employee's personal information.

Personalinfo_firstname String False

The first name in the employee's personal information.

Personalinfo_initial String False

The middle initial in the employee's personal information.

Personalinfo_lastname String False

The last name in the employee's personal information.

Personalinfo_companyname String False

The company name in the employee's personal information.

Personalinfo_printas String False

The format for printing the employee's personal information.

Personalinfo_phone1 String False

The primary phone number in the employee's personal information.

Personalinfo_phone2 String False

The secondary phone number in the employee's personal information.

Personalinfo_cellphone String False

The cellphone number in the employee's personal information.

Personalinfo_pager String False

The pager number in the employee's personal information.

Personalinfo_fax String False

The fax number in the employee's personal information.

Personalinfo_email1 String False

The primary email address in the employee's personal information.

Personalinfo_email2 String False

The secondary email address in the employee's personal information.

Personalinfo_url1 String False

The primary URL in the employee's personal information.

Personalinfo_url2 String False

The secondary URL in the employee's personal information.

Personalinfo_mailaddress_address1 String False

The first address line in the employee's mailing address.

Personalinfo_mailaddress_address2 String False

The second address line in the employee's mailing address.

Personalinfo_mailaddress_city String False

The city in the employee's mailing address.

Personalinfo_mailaddress_state String False

The state in the employee's mailing address.

Personalinfo_mailaddress_zip String False

The ZIP code in the employee's mailing address.

Personalinfo_mailaddress_country String False

The country in the employee's mailing address.

Personalinfo_mailaddress_countrycode String False

The country code in the employee's mailing address.

Entity String False

The entity associated with the employee.

Supdocfoldername String False

The supporting document folder name for the employee.

Currency String False

The currency used for transactions involving the employee.

Name1099 String False

The name used for 1099 reporting for the employee.

Form1099type String False

The type of 1099 form associated with the employee.

Form1099box String False

The box on the 1099 form associated with the employee.

Earningtypekey Int64 False

The key for the earning type associated with the employee.

Earningtypename String False

The name of the earning type associated with the employee.

Earningtypemethod String False

The method of the earning type associated with the employee.

Postactualcost Boolean False

Indicates whether to post the actual cost for the employee.

Whencreated Datetime False

The date and time when the employee record was created.

Whenmodified Datetime False

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

Createdby Int64 False

The ID of the user who created the employee record.

Modifiedby Int64 False

The ID of the user who last modified the employee record.

Classid String False

The class ID associated with the employee.

Classname String False

The class name associated with the employee.

Classkey Int64 False

The class key associated with the employee.

Paymethodkey Int64 False

The key of the payment method associated with the employee.

Achenabled Boolean False

Indicates whether ACH payments are enabled for the employee.

Achbankroutingnumber String False

The ACH bank routing number for the employee.

Achaccounttype String False

The ACH account type for the employee.

Achremittancetype String False

The ACH remittance type for the employee.

Paymentnotify Boolean False

Indicates whether payment notifications are enabled for the employee.

Generic Boolean False

Indicates whether the employee record is generic.

Mergepaymentreq Boolean False

Indicates whether merge payment requests are enabled for the employee.

Contactkey Int64 False

The key of the contact associated with the employee.

Megaentitykey Int64 False

The key of the mega entity associated with the employee.

Megaentityid String False

The ID of the mega entity associated with the employee.

Megaentityname String False

The name of the mega entity associated with the employee.

Record_url String False

The URL link to the employee record.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434