Employee

Internal ID: employee

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
accountnumber	text	true	Account	false
aliennumber	text	true	Alien Number	false
approvallimit	currency	true	Expense Approval Limit	false
approver	select	true	Expense Approver	false	References an employee record. Sets the person who approves the employees expense reports and purchase requests. If you have set a supervisor, you can NOT set an approver. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
authworkdate	date	true	Authorized to work until	false
autoname	checkbox	false	Auto	false
billaddr1	text	false		false
billaddr2	text	false		false
billaddr3	text	false		false
billcity	text	false		false
billcountry	text	false		false
billingclass	select	true	Billing Class	false
billpay	checkbox	false	Enable Online Bill Pay	false
billstate	text	false		false
billzip	text	false		false
birthdate	date	true	Birth Date	false
btemplate	text	false	Employee is Template	false
class	select	true	Class	false	References a value from a user defined list at Setup > Company > Classifications > Classes. This field is required when the Make Classes Mandatory preference is enabled at Setup > Accounting > Accounting Preferences. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
comments	textarea	true	Notes	false	Enter other information you want to track for this employee.
commissionpaymentpreference	select	false	Pay Commissions Using	false
currency	select	false	Currency	false	The currency for an employee automatically defaults to the base currency of the associated subsidiary or company. This currency must be used for transactions with this employee.
customform	select	false	Custom Form	true
datecreated	datetime	false	Date Created	false
defaultaddress	address	false	Address	false
department	select	true	Department	false	References a value from a user defined list at Setup > Company > Departments. This field is required when Make Departments Mandatory is enabled at Setup > Accounting > Accounting Preferences. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
directdeposit	checkbox	false	Use Direct Deposit	false
eligibleforcommission	checkbox	false	Eligible for Commission	false
email	email	false	Email	false	Sets the employee's e-mail address.
empcenterqty	text	false	EmpCenter current	false
empcenterqtymax	text	false	EmpCenter max	false
employeestatus	select	true	Employee Status	false
employeetype	select	true	Type	false
entityid	text	true	Employee ID	true
ethnicity	select	true	Ethnicity	false	Select the employee's ethnicity. You can create a new ethnicity category at <_TABNAME=EDIT_EMPOTHERLIST_> > <_TASKCATEGORY=EDIT_EMPOTHERLIST_> > Employee Related Lists.
expenselimit	currency	true	Expense Limit	false
externalid	text	false	ExternalId	false
fax	phone	true	Fax	false	Enter a fax number for this record. You should enter the fax number exactly as it must be dialed. If a '1' is required to fax to this number, be sure to include it at the beginning of the number.The number you enter here automatically appears in the To Be Faxed field of transactions when you select this customer.To fax NetSuite forms, an administrator must first set up fax service at <_TABNAME=ADMI_PRINTING_> &gt; <_TASKCATEGORY=ADMI_PRINTING_> &gt; Printing, Fax &amp; Email Preferences.
firstname	text	true	Name	false
fulluserqty	text	false	FullUser current	false
fulluserqtymax	text	false	FullUser max	false
gender	select	true	Gender	false	Select the employee's gender.
giveaccess	checkbox	false	Give Access	false
globalsubscriptionstatus	select	false	Global Subscription Status	false
hasofflineaccess	checkbox	false	Offline Client Access	false
hiredate	date	true	Hire Date	true
homephone	phone	true	Home Phone	false
i9verified	checkbox	true	I-9 Verified	false
image	select	false	Image	false	References an image file that has already been uploaded to the account. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
initials	text	false	Initials	false	NetSuite automatically completes this field as you enter first, middle and last names.If you want to make changes to an employee's initials, enter up to three letters in this field.
isempcenterqtyenforced	text	false	EmpCenter enforce	false
isfulluserqtyenforced	text	false	FullUser enforce	false
isinactive	checkbox	true	Inactive	false
isjobresource	checkbox	true	Project Resource	false
isretailuserqtyenforced	text	false	RetailUser enforce	false
issalesrep	checkbox	true	Sales Rep	false
issupportrep	checkbox	true	Support Rep	false
jobdescription	textarea	false	Job Description	false
jurisdiction1display	text	false	Federal:	false
jurisdiction2display	text	false	State:	false
jurisdiction3display	text	false	County:	false
jurisdiction4display	text	false	Local:	false
jurisdiction5display	text	false	School District:	false
laborcost	currency	true	Labor Cost	false
lastmodifieddate	datetime	false	Last Modified Date	false
lastname	text	true		false
lastpaiddate	date	true	Last Paid Date	false
lastreviewdate	date	true	Last Review Date	false
location	select	true	Location	false	References a value in a user-defined list at Setup > Company > Classifications > Locations. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
maritalstatus	select	true	Marital Status	false
middlename	text	true		false
mobilephone	phone	true	Mobile Phone	false
nextreviewdate	date	true	Next Review Date	false
officephone	phone	false	Office Phone	false
payfrequency	select	true	Pay Frequency	true
phone	phone	true	Phone	false
phoneticname	text	false	Furigana	false
purchaseorderapprovallimit	currency	true	Purchase Approval Limit	false
purchaseorderapprover	select	true	Purchase Approver	false
purchaseorderlimit	currency	true	Purchase Limit	false
releasedate	date	true	Termination Date	false
requirepwdchange	checkbox	false	Require Password Change On Next Login	false
residentstatus	select	true	Resident Status	false
retailuserqty	text	false	RetailUser current	false
retailuserqtymax	text	false	RetailUser max	false
salesrole	select	true	Sales Role	false
salutation	text	true	Mr./Ms...	false	Enter the employee's salutation, such as Mr. or Ms., here.
sendemail	checkbox	false	Send Notification Email	false
socialsecuritynumber	ssnumber	true	Social Security	false
strength	text	false	Password Strength	false
subsidiary	select	false	Subsidiary	true	Select the subsidiary to associate with this employee. You cannot enter transactions for this employee unless a subsidiary is assigned. If you select this employee on time transactions, the transaction is associated with this subsidiary. The employee is able to access only information associated with this subsidiary. Note: Once a transaction has posted for the employee, you are not able to change the subsidiary selected on the employee record.
supervisor	select	true	Supervisor	false	References an employee record. This employee will approve expense reports and purchase requests. In order to retrieve a list of available values for this field, use the GetSelectValue operation. For more information, see getSelectValue of the Platform Guide.
terminationbydeath	checkbox	false	Termination Due To Death	false
timeapprover	select	true	Time Approver	false
title	text	true	Job Title	false	Enter this employee's official job title here.
unsubscribe	select	false	Unsubscribe from Campaigns	false
useperquest	checkbox	true	Include in Payroll	false
usetimedata	select	true	Compensation Type	false
visaexpdate	date	true	Visa Expiration Date	false
visatype	select	true	Visa Type	false
wasempcenterhasaccess	text	false	EmpCenter hasaccess	false
wasfulluserhasaccess	text	false	FullUser hasaccess	false
wasinactive	text	false	wasinactive	false
wasretailuserhasaccess	text	false	RetailUser hasaccess	false
workcalendar	select	true	Work Calendar	true
workplace	select	true	Workplace	false	Select the workplace where this employee works.The address of this workplace will be used to define the taxes you are required to withhold and pay for this employee.

Sublists

accruedtime - Accrued Time

Internal ID	Type	Label	Required
accrualmethod	select	Accrue As	false
accrualrate	float	Accrual Rate	false
accruedhours	float	Accrued Hours	false
inactive	checkbox	Inactive	false
maximumaccruedhours	float	Maximum Hours	false
monetaryrate	currency	Monetary Rate	false
payrollitem	select	Sick/Vacation Time	true
resetaccruedhoursatyearend	checkbox	Reset at Year End	false

addressbook - Address

Internal ID	Type	Label	Required
addr1	text	Address 1	false
addr2	text	Address 2	false
addr3	text		false
addressee	text	Addressee	false
addressid	text		false
addrtext	address	Address	false
attention	text	Attention	false
city	text	City	false
country	select	Country	false
defaultbilling	checkbox	Home	false
defaultshipping	checkbox	Default Shipping	false
displaystate	text	State/Province	false
id	integer	ID	false
internalid	integer		false
label	text	Label	false
override	checkbox	Override	false
phone	phone	Phone	false
state	text	State/Province	false
zip	text	Zip	false

companycontribution - Company Contributions

Internal ID	Type	Label	Required
inactive	checkbox	Inactive	false
limit	currency	Limit	false
payrollitem	select	Company Contribution	true
rate	rate	Rate	false

deduction - Deductions

Internal ID	Type	Label	Required
inactive	checkbox	Inactive	false
limit	currency	Limit	false
payrollitem	select	Deduction	true
rate	rate	Rate	false

directdeposit - Accounts

Internal ID	Type	Label	Required
accountprenoted	checkbox	Prenoted	false
amount	currency	Amount	false
bankaccountnumber	text	Account Number	true
bankname	text	Bank Name	true
bankroutingnumber	text	Routing Number	true
id	text	ID	false
inactive	checkbox	Inactive	false
netaccount	checkbox	Net Account	false
savingsaccount	checkbox	Savings Account	false

earning - Earnings

Internal ID	Type	Label	Required
defaultearning	checkbox	Default	false
defaulthours	float	Default Hours	false
inactive	checkbox	Inactive	false
payrate	rate	Rate	false
payrollitem	select	Earning	true
primaryearning	checkbox	Primary	false

Tabs

Name	Label
access	Access
address	Address
commission	Commission
curjurisdictions	Current
custom	Custom
dd	ACH/Direct Deposit
education	Education
general	General
hr	Human Resources
hrpersonal	Personal
hrworkstatus	Work Status
info	Info
jurisdictions	Jurisdictions
marketing	Marketing
payfed	Federal Withholdings
payroll	Payroll
support	Support
workflow	Workflow

Search Joins

Join ID	Join Description	Actual Join Name
campaignresponse	Campaign Response	Campaign
department	Department	Department
location	Location	Location
messages	Messages	Message
messagesfrom	Messages From	Message
messagesto	Messages To	Message
subsidiary	Subsidiary	Subsidiary

Search Filters

Internal ID	Type	Label
address	textarea	Address
addressee	text	Addressee
addresslabel	text	Address Label
addressphone	phone	Address Phone
aliennumber	text	Alien Number
anniversary	date	Anniversary
approvallimit	currency	Expense Approval Limit
approver	select	Expense Approver
attention	text	Attention
authworkdate	date	Authorized to work until date
billaddress	textarea	Billing Address
billingclass	select	Billing Class
birthdate	date	Birth Date
birthday	date	Birthday
ccontribution	select	Company Contribution
city	text	City
class	select	Class
comments	textarea	Comments
commissionplan	select	Commission Plan
concurrentwebservicesuser	checkbox	Concurrent Web Services User
country	select	Country
county	text	County/State
datecreated	datetime	Date Created
deduction	select	Deduction
department	select	Department
earning	select	Earning
education	select	Education
eligibleforcommission	checkbox	Eligible For Commission
email	text	Email
employeestatus	select	Employee Status
employeetype	select	Type
employeetypekpi	checkbox	Include in KPI
entityid	text	Name/ID
ethnicity	select	Ethnicity
expenselimit	currency	Expense Limit
externalid	select	External ID
externalidstring	text	External ID (Text)
fax	phone	Fax
firstname	text	First Name
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
gender	checkbox	Gender
giveaccess	checkbox	Login Access
globalsubscriptionstatus	select	Global Subscription Status
group	multiselect	Group
hiredate	date	Hire Date
i9verified	checkbox	I9 Verified
image	image	Image
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
isdefaultbilling	checkbox	Default Billing Address
isdefaultshipping	checkbox	Default Shipping Address
isinactive	checkbox	Inactive
isjobresource	checkbox	Is Job Resource
istemplate	checkbox	Is Template
jobdescription	text	Job Description
laborcost	currency	Labor Cost
language	select	Language
lastmodifieddate	datetime	Last Modified
lastname	text	Last Name
lastpaiddate	date	Last Paid Date
lastreviewdate	date	Last Review Date
level	select	Level
location	select	Location
maritalstatus	select	Marital Status
middlename	text	Middle Name
nextreviewdate	date	Next Review Date
offlineaccess	checkbox	Offline Access
payfrequency	select	Pay Frequency
permchangedate	datetime	Permission Change Date
permission	select	Permission
permissionchange	select	Permission Change
phone	phone	Phone
phoneticname	text	Phonetic Name
primaryearningamount	currency	Primary Earning Amount
primaryearningitem	text	Primary Earning Item
primaryearningtype	text	Primary Earning Type
purchaseorderapprovallimit	currency	Purchase Approval Limit
purchaseorderapprover	select	Purchase Approver
purchaseorderlimit	currency	Purchase Limit
releasedate	date	Release Date
representingsubsidiary	select	Represents Subsidiary
residentstatus	select	Resident Status
role	select	Role
rolechange	select	Role Change
rolechangedate	datetime	Role Change Date
salesrep	checkbox	Is Sales Rep
salesrole	select	Sales Role
salutation	text	Mr./Mrs...
socialsecuritynumber	ssnumber	Social Security Number
state	select	State/Province
subsidiary	select	Subsidiary
supervisor	select	Supervisor
supportrep	checkbox	Is Support Rep
timeapprover	select	Time Approver
title	text	Job Title
type	select	Entity Type
useperquest	checkbox	Include In US Payroll
usetimedata	checkbox	Use Time Data
visaexpdate	date	Visa Expiration Date
visatype	select	Visa Type
withholding	select	Withholding
workcalendar	select	Work Calendar
workplace	select	Workplace
zipcode	text	Zip

Search Columns

Internal ID	Type	Label
accountnumber	text	Account
address	text	Address
address1	text	Address 1
address2	text	Address 2
address3	text	Address 3
addressee	text	Addressee
addressinternalid	integer	Address Internal ID
addresslabel	text	Address Label
addressphone	text	Address Phone
aliennumber	text	Alien #
altemail	email	Alt. Email
altname	text	Name
altphone	phone	Office Phone
approvallimit	currency	Expense Approval Limit
approver	select	Expense Approver
attention	text	Attention
authworkdate	date	Authorized to work until date
billaddress	text	Address
billaddress1	text	Billing Address 1
billaddress2	text	Billing Address 2
billaddress3	text	Billing Address 3
billaddressee	text	Billing Addressee
billattention	text	Billing Attention
billcity	text	Billing City
billcountry	select	Billing Country
billcountrycode	text	Billing Country Code
billingclass	select	Billing Class
billphone	text	Billing Phone
billstate	select	Billing State/Province
billzipcode	text	Billing Zip
birthdate	date	Birth Date
birthday	date	Birth Day
city	text	City
class	select	Class
classnohierarchy	select	Class (no hierarchy)
comments	text	Comments
concurrentwebservicesuser	checkbox	Concurrent Web Services User
country	select	Country
countrycode	text	Country Code
datecreated	datetime	Date Created
department	select	Department
departmentnohierarchy	select	Department (no hierarchy)
eligibleforcommission	checkbox	Eligible for Commission
email	email	Email
employeestatus	select	Employee Status
employeetype	select	Type
entityid	text	Name
entitynumber	integer	Number
ethnicity	select	Ethnicity
expenselimit	currency	Expense Limit
externalid	select	External ID
fax	text	Fax
firstname	text	First Name
formulacurrency	currency	Formula (Currency)
formuladate	date	Formula (Date)
formuladatetime	datetime	Formula (Date/Time)
formulanumeric	float	Formula (Numeric)
formulapercent	percent	Formula (Percent)
formulatext	text	Formula (Text)
gender	select	Gender
giveaccess	checkbox	Login Access
globalsubscriptionstatus	select	Global Subscription Status
hiredate	date	Hire Date
homephone	phone	Home Phone
i9verified	checkbox	I9 Verified
image	select	Image
internalid	select	Internal ID
isdefaultbilling	checkbox	Default Billing Address
isdefaultshipping	checkbox	Default Shipping Address
isinactive	checkbox	Inactive
isjobresource	checkbox	Job Resource
issalesrep	checkbox	Sales Rep
issupportrep	checkbox	Support Rep
istemplate	checkbox	Is Template
laborcost	currency	Labor Cost
language	select	Language
lastmodifieddate	datetime	Last Modified
lastname	text	Last Name
lastpaiddate	date	Last Paid Date
lastreviewdate	date	Last Review
lastviewed	datetime	Last Viewed
level	select	Level
location	select	Location
locationnohierarchy	select	Location (no hierarchy)
maritalstatus	select	Marital Status
middlename	text	Middle Name
mobilephone	phone	Mobile Phone
nextreviewdate	date	Next Review
offlineaccess	checkbox	Offline Access
payfrequency	select	Pay Frequency
permchangedate	datetime	Permission Change Date
permchangelevel	text	Permission Change Level
permission	select	Permission
permissionchange	text	Permission Change
phone	phone	Phone
phoneticname	text	Phonetic Name
primaryearningamount	currency	Primary Earning Amount
primaryearningitem	text	Primary Earning Item
primaryearningtype	text	Primary Earning Type
purchaseorderapprovallimit	currency	Purchase Approval Limit
purchaseorderapprover	select	Purchase Approver
purchaseorderlimit	currency	Purchase Limit
releasedate	date	Release Date
representingsubsidiary	select	Represents Subsidiary
residentstatus	select	Resident Status
role	select	Role
rolechange	text	Role Change
rolechangeaction	text	Role Change Action
rolechangedate	datetime	Role Change Date
salesrole	select	Sales Role
salutation	text	Mr./Mrs...
shipaddress1	text	Shipping Address 1
shipaddress2	text	Shipping Address 2
shipaddress3	text	Shipping Address 3
shipaddressee	text	Shipping Addressee
shipattention	text	Shipping Attention
shipcity	text	Shipping City
shipcountry	select	Shipping Country
shipcountrycode	text	Shipping Country Code
shipphone	text	Shipping Phone
shipstate	text	Shipping State/Province
shipzip	text	Shipping Zip
socialsecuritynumber	ssnumber	Social Security #
state	select	State/Province
statedisplayname	select	State/Province Display Name
subscription	select	Subscription
subscriptiondate	datetime	Subscription Date
subscriptionstatus	checkbox	Subscription Status
subsidiary	select	Subsidiary
subsidiarynohierarchy	select	Subsidiary (no hierarchy)
supervisor	select	Supervisor
timeapprover	select	Time Approver
title	text	Job Title
type	select	Type
useperquest	checkbox	Include In US Payroll
usetimedata	checkbox	Use Time Data
visaexpdate	date	Visa Expiration Date
visatype	select	Visa Type
workcalendar	select	Work Calendar
workplace	select	Workplace
zipcode	text	Zip Code

Transform Types

Target Record Type	Field Defaults
expensereport	customform
timebill	customform