JDBC Driver for Sage Intacct

Build 22.0.8462

Employee

Retrieves Employee report 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 Recordno field of the Employee object.

Employeeid [KEY] String False

The Employeeid field of the Employee object.

Title String False

The Title field of the Employee object.

Locationid String False

The Locationid field of the Employee object.

Locationkey Int64 False

The Locationkey field of the Employee object.

Departmentid String False

The Departmentid field of the Employee object.

Departmentkey Int64 False

The Departmentkey field of the Employee object.

Parentkey Int64 False

The Parentkey field of the Employee object.

Supervisorid String False

The Supervisorid field of the Employee object.

Supervisorname String False

The Supervisorname field of the Employee object.

Birthdate Datetime False

The Birthdate field of the Employee object.

Startdate Datetime False

The Startdate field of the Employee object.

Enddate Datetime False

The Enddate field of the Employee object.

Status String False

The Status field of the Employee object.

Employeetype String False

The Employeetype field of the Employee object.

Employeetype1099type String False

The Employeetype1099type field of the Employee object.

Emptypekey Int64 False

The Emptypekey field of the Employee object.

Gender String False

The Gender field of the Employee object.

Terminationtype String False

The Terminationtype field of the Employee object.

Personalinfo_contactname String False

The Personalinfo_contactname field of the Employee object.

Personalinfo_prefix String False

The Personalinfo_prefix field of the Employee object.

Personalinfo_firstname String False

The Personalinfo_firstname field of the Employee object.

Personalinfo_initial String False

The Personalinfo_initial field of the Employee object.

Personalinfo_lastname String False

The Personalinfo_lastname field of the Employee object.

Personalinfo_companyname String False

The Personalinfo_companyname field of the Employee object.

Personalinfo_printas String False

The Personalinfo_printas field of the Employee object.

Personalinfo_phone1 String False

The Personalinfo_phone1 field of the Employee object.

Personalinfo_phone2 String False

The Personalinfo_phone2 field of the Employee object.

Personalinfo_cellphone String False

The Personalinfo_cellphone field of the Employee object.

Personalinfo_pager String False

The Personalinfo_pager field of the Employee object.

Personalinfo_fax String False

The Personalinfo_fax field of the Employee object.

Personalinfo_email1 String False

The Personalinfo_email1 field of the Employee object.

Personalinfo_email2 String False

The Personalinfo_email2 field of the Employee object.

Personalinfo_url1 String False

The Personalinfo_url1 field of the Employee object.

Personalinfo_url2 String False

The Personalinfo_url2 field of the Employee object.

Personalinfo_mailaddress_address1 String False

The Personalinfo_mailaddress_address1 field of the Employee object.

Personalinfo_mailaddress_address2 String False

The Personalinfo_mailaddress_address2 field of the Employee object.

Personalinfo_mailaddress_city String False

The Personalinfo_mailaddress_city field of the Employee object.

Personalinfo_mailaddress_state String False

The Personalinfo_mailaddress_state field of the Employee object.

Personalinfo_mailaddress_zip String False

The Personalinfo_mailaddress_zip field of the Employee object.

Personalinfo_mailaddress_country String False

The Personalinfo_mailaddress_country field of the Employee object.

Personalinfo_mailaddress_countrycode String False

The Personalinfo_mailaddress_countrycode field of the Employee object.

Entity String False

The Entity field of the Employee object.

Supdocfoldername String False

The Supdocfoldername field of the Employee object.

Currency String False

The Currency field of the Employee object.

Name1099 String False

The Name1099 field of the Employee object.

Form1099type String False

The Form1099type field of the Employee object.

Form1099box String False

The Form1099box field of the Employee object.

Earningtypekey Int64 False

The Earningtypekey field of the Employee object.

Earningtypename String False

The Earningtypename field of the Employee object.

Earningtypemethod String False

The Earningtypemethod field of the Employee object.

Postactualcost Boolean False

The Postactualcost field of the Employee object.

Whencreated Datetime False

The Whencreated field of the Employee object.

Whenmodified Datetime False

The Whenmodified field of the Employee object.

Createdby Int64 False

The Createdby field of the Employee object.

Modifiedby Int64 False

The Modifiedby field of the Employee object.

Classid String False

The Classid field of the Employee object.

Classname String False

The Classname field of the Employee object.

Classkey Int64 False

The Classkey field of the Employee object.

Paymethodkey Int64 False

The Paymethodkey field of the Employee object.

Achenabled Boolean False

The Achenabled field of the Employee object.

Achbankroutingnumber String False

The Achbankroutingnumber field of the Employee object.

Achaccounttype String False

The Achaccounttype field of the Employee object.

Achremittancetype String False

The Achremittancetype field of the Employee object.

Paymentnotify Boolean False

The Paymentnotify field of the Employee object.

Generic Boolean False

The Generic field of the Employee object.

Mergepaymentreq Boolean False

The Mergepaymentreq field of the Employee object.

Contactkey Int64 False

The Contactkey field of the Employee object.

Megaentitykey Int64 False

The Megaentitykey field of the Employee object.

Megaentityid String False

The Megaentityid field of the Employee object.

Megaentityname String False

The Megaentityname field of the Employee object.

Record_url String False

The Record_url field of the Employee object.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462