JDBC Driver for NetSuite

Build 22.0.8462

employee

The employee table.

Columns

Name Type References Description
id [KEY] Integer Internal ID
accountnumber String Account
aliennumber String Alien Number
approvallimit Decimal Expense Approval Limit
approver String Expense Approver
authworkdate Date Authorized to Work Until
billpay Boolean Enable Online Bill Pay
birthdate Date Birth Date
class String Class
comments String Notes
currency String Currency
datecreated Date Date Created
defaultacctcorpcardexp String Default Account for Corporate Card Expenses
defaultexpensereportcurrency String Default Currency For Expense Reports
defaultjobresourcerole String Default Job Resource Role
department String Department
eligibleforcommission Boolean Eligible for Commission
email String Email
employeestatus String Employee Status
employeetype String Type
entityid String Entity ID
ethnicity String Ethnicity
expenselimit Decimal Expense Limit
externalid String External ID
firstname String First Name
gender String Gender
giveaccess Boolean Login Access
globalsubscriptionstatus String Global Subscription Status
hiredate Date Hire Date
i9verified Boolean I-9 Verified
initials String Initials
isinactive Boolean Is Inactive
isjobmanager Boolean Job Manager
isjobresource Boolean Job Resource
issalesrep Boolean Sales Rep
issupportrep Boolean Support Rep
jobdescription String Job Description
laborcost Decimal Labor Cost
lastname String Last Name
lastreviewdate Date Last Review Date
location String Location
maritalstatus String Marital Status
middlename String Middle Name
nextreviewdate Date Next Review Date
purchaseorderapprovallimit Decimal Purchase Approval Limit
purchaseorderapprover String Purchase Approver
purchaseorderlimit Decimal Purchase Limit
releasedate Date Termination/Release Date
residentstatus String Resident Status
salesrole String Sales Role
salutation String Mr./Ms...
subsidiary String Subsidiary
supervisor String Supervisor
targetutilization Double Target Utilization
timeapprover String Time Approver
title String Job Title
visaexpdate Date Visa Expiration Date
visatype String Visa Type
workcalendar String Work Calendar

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