Employee

Internal ID: employee

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
accountnumber	text	true	Account	false	If you, your payroll service, or other benefits provider assigns account numbers to your employees, enter that account number here. This field is required for the Online Bill Pay feature.
aliennumber	text	true	Alien Number	false
approvallimit	currency	true	Expense Approval Limit	false	In the Expense Approval Limit field, enter the maximum amount this employee is allowed to approve on an expense report when specified as an approver for another employee. Expenses that exceed this amount must be approved by another supervisor or approver with a sufficient approval limit.
approver	select	true	Expense Approver	false	In the Expense Approver field, select the person that approves the employee’s expense reports. If no approver is selected, the employee's supervisor approves expense reports. If an expense approver is selected, the supervisor is no longer part of the approval hierarchy.
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	Select a billing class to associate with this employee. The billing class you choose determines default pricing when you enter billable time and select a service item associated with this billing class. For information on existing billing classes or to create a new one, go to <_TABNAME=EDIT_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY=EDIT_ACCOUNTINGOTHERLIST_> > Accounting Lists.
billpay	checkbox	false	Enable Online Bill Pay	false	Check this box in order to send this employee payments online. You cannot use this feature for paychecks. You must follow the set up procedures at <_TABNAME=ADMI_XML_PAYTRUST_SETUP_> > <_TASKCATEGORY=ADMI_XML_PAYTRUST_SETUP_> > Online Bill Pay before you can use this feature.
billstate	text	false		false
billzip	text	false		false
birthdate	date	true	Birth Date	false	Enter the employee's date of birth.
btemplate	text	false	Employee is Template	false
class	select	true	Class	false	If you wish, select the class that applies to this employee. Click &#x2014;New&#x2014; to set up a new class.
comments	textarea	true	Notes	false	Enter other information you want to track for this employee.
commissionpaymentpreference	select	false	Pay Commissions Using	false	Select in the dropdown whether the payor for this employee's commissions always should be Payroll, always should be Accounts Payable, or should vary according to preferences set in the NetSuite system.
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	If you use a custom form for employee records, select the name of the form here. To create a custom form for employee records, click Customize Form. You can add or take away fields and change field names when you customize forms.
datecreated	datetime	false	Date Created	false
defaultaddress	address	false	Address	false	This field displays in text format the employee's address, as entered in fields on the Address subtab.
department	select	true	Department	false	If you like, select a department. Click New to enter a new department.
directdeposit	checkbox	false	Use Direct Deposit	false	Check this box to use Direct Deposit for transferring funds to an employee's bank account. Direct Deposit transactions take place over the Internet and in real time. These transactions have immediate accounting impact on your books. Payments you transmit are withdrawn from your company's bank account.
eligibleforcommission	checkbox	false	Eligible for Commission	false	Check the box to indicate this employee can be paid commission.
email	email	false	Email	false	Enter your employee's email address. If you allow your employees to track time or enter expense reports online, this will become part of their access codes.
empcenterqty	text	false	EmpCenter current	false
empcenterqtymax	text	false	EmpCenter max	false
employeestatus	select	true	Employee Status	false	Select an employee status. You can create a new employee status at <_TABNAME=EDIT_EMPOTHERLIST_> > <_TASKCATEGORY=EDIT_EMPOTHERLIST_> > Employee Related Lists.
employeetype	select	true	Type	false	Select a type to be used for descriptive and reporting purposes. Employees' types determine whether their data is included in employee-related key performance indicators. To review or add employee type definitions, go to <_TABNAME=EDIT_EMPOTHERLIST_> > <_TASKCATEGORY=EDIT_EMPOTHERLIST_> > Employee Related Lists.
entityid	text	true	Employee ID	true	If the Auto box is not checked, manually enter an ID for this record. If the Auto box is checked, NetSuite assigns an ID for this record based on your settings at <_TABNAME=ADMI_NUMBERING_> > <_TASKCATEGORY=ADMI_NUMBERING_> > Auto-Generated Numbers.
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	In the Expense Limit field, enter the amount this employee can expense without approval from a supervisor or approver.
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_> > <_TASKCATEGORY=ADMI_PRINTING_> > Printing, Fax & Email Preferences.
firstname	text	true	Name	false	Enter the employee's first name here. What you enter here automatically appears first in the Employee field. The first letter of what you enter here appears in the Initials field. This field is required for the Online Bill Pay feature.
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	Check this box to give your employee access to NetSuite. Then, assign a role to customize the level of access. You can assign multiple roles. To let your employee track time and enter expense reports, select the Employee Center role. You must also assign a password and email address for the employee to log in.
globalsubscriptionstatus	select	false	Global Subscription Status	false	Email recipients can have one of four subscription statuses: * Confirmed Opt-In - When an email recipient has indicated that they want to receive your campaign messages, they are assigned this subscription status. Only a recipient can set his or her subscription status to Confirmed Opt-In. * Soft Opt-In - Recipients with this status can receive opt-in messages that enable them to confirm whether or not they want to receive your email campaigns as well as email marketing campaigns. You can set a recipient&#x2019;s status to Soft Opt-In manually or through a mass update. * Soft Opt-Out - Recipients with this status cannot receive campaign email messages but can receive opt-in messages. You can change this subscription status to Soft Opt-In manually or through a mass update. * Confirmed Opt-Out - Only the recipient can set their subscription status to Confirmed Opt-Out. Recipients with this status cannot receive email campaigns or opt-in messages. Recipients with this status can only opt in again through the Employee Center or by clicking the link in a campaign message they have received prior to opting out.
hasofflineaccess	checkbox	false	Offline Client Access	false	Check this box to give this employee the ability to download the Offline Client for NetSuite. Employees must have a sales role in order to have access to the Offline Client. Default sales roles include Sales Person, Sales Manager and Sales Administrator. Custom roles must have the Sales Role box checked on the role record. An employee with access to the Offline Client can go to <_TABNAME=TRAN_USERPREFS_> > <_TASKCATEGORY=TRAN_USERPREFS_> > Set Preferences to download the client to a laptop or other wireless device.
hiredate	date	true	Hire Date	true	Enter the date this employee was hired.
homephone	phone	true	Home Phone	false	Enter this employee's home phone number here.
i9verified	checkbox	true	I-9 Verified	false
image	select	false	Image	false	Select an image from your file cabinet to attach to this employee record. Select -New- to upload a new image from your hard drive to your file cabinet in a new window.
inheritiprules	checkbox	false	Inherit IP Rules from Company	true	Check this box to allow this employee NetSuite login access at the IP addresses listed at Setup > Company Information. If you check this box, this employee has access to NetSuite at every company conputer with access unless you specify an IP address(es) in the IP Address Restriction field. If you do not check this box, you must enter an IP Address where this employee can log in in the field below, or this employee will not be able to log in to NetSuite.
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.
ipaddressrule	textarea	false	IP Address Restriction	true	Enter the IP address(es) where you want this employee to have access in the following formats: 1. A dotted decimal IP address such as 123.456.78.90 2. A range of IP addresses entered in dotted decimal with a dash and no spaces between such as 123.45.567.8-123.45.568.9 3. A list of IP address separated by spaces or commas such as 123.456.78.90, 123.546.768.97, . . . 4. An IP address and mask, such as 209.209.48.32/255.255.0.0. 5. The text "ALL" -- allows all IP addresses You can enter up to 1024 characters. If you do not enter an IP Address here, you must check the Inherit IP Rules from Company box, or this employee will no longer be able to log in to NetSuite.
isempcenterqtyenforced	text	false	EmpCenter enforce	false
isfulluserqtyenforced	text	false	FullUser enforce	false
isinactive	checkbox	true	Inactive	false	Check this box to inactivate this employee record. Inactivated records no longer appear in lists or as choices anywhere in your account. To view inactivated employee records or reactivate them, go to <_TABNAME=LIST_EMPLOYEE_> > <_TASKCATEGORY=LIST_EMPLOYEE_> > Employees, and check the Show Inactives box.
isjobresource	checkbox	true	Project Resource	false	Check this box to enable this employee to be added as a resource on projects and tasks.
isretailuserqtyenforced	text	false	RetailUser enforce	false
issalesrep	checkbox	true	Sales Rep	false	Check this box to mark this employee as a sales representative. Sales representatives are listed in the sales rep dropdown list for sales order forms and for sales territory assignments.
issupportrep	checkbox	true	Support Rep	false	Check this box to mark this employee as a support representative. Support representatives are listed in the assigned to dropdown list for case forms and in the support rep dropdown list for support territory assignments.
jobdescription	textarea	false	Job Description	false	Enter a description of the duties related to the job this person currently performs.
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	Enter the employee's hourly overhead labor rate. This rate is used to calculate the estimated cost of jobs this employee works on.
lastmodifieddate	datetime	false	Last Modified Date	false
lastname	text	true		false	Enter the employee's last name here. What you enter here automatically appears last in the Employee field. The first letter of what you enter here appears in the Initials field. This field is required for the Online Bill Pay feature.
lastpaiddate	date	true	Last Paid Date	false	Enter the last paid date for this employee. The last paid date is the date of the actual pay run which usually take place before the checks are issued. For example, the date on your most recent paycheck is October 13. This check includes payment for hours worked September 24 - October 7. The pay run is processed on October 7 but the check is issued on October 13. However, since the last paid date is the date of the pay run, you shoud enter October 7 as the last paid date. Note: You only have to enter this date once for each employee. This field is auto-updated with the most recent last paid date each time you run payroll.
lastreviewdate	date	true	Last Review Date	false	Enter the date of this person's last salary evaluation.
location	select	true	Location	false	Select the location where this employee works. Note: If you use the Payroll feature, you must select a location for each employee you wish to pay using NetSuite Payroll. If the employee&#x2019;s location is not listed, you must create a new staffed location. Create new locations to select here by selecting &#x96;New&#x96;.
maritalstatus	select	true	Marital Status	false	Select the employee's marital status. You can create a new marital status at <_TABNAME=EDIT_EMPOTHERLIST_> > <_TASKCATEGORY=EDIT_EMPOTHERLIST_> > Employee Related Lists.
middlename	text	true		false	Enter a middle name or initial here. What you enter here automatically appears second in the Employee field. The first letter of what you enter here appears in the Initials field. Enter up to 25 characters in this field.
mobilephone	phone	true	Mobile Phone	false	Enter this employee's mobile or cell phone number here.
nextreviewdate	date	true	Next Review Date	false	Enter the date of this person's next salary evaluation.
officephone	phone	false	Office Phone	false	Enter this employee's office phone number here.
payfrequency	select	true	Pay Frequency	true	Select the pattern of frequency for paying this employee.
phone	phone	true	Phone	false
phoneticname	text	false	Furigana	false	Enter the furigana character you want to use to sort this record.
purchaseorderapprovallimit	currency	true	Purchase Approval Limit	false	In the Purchase Approval Limit field, enter the maximum amount an employee is allowed to approve on a purchase request when specified as an approver for an employee.
purchaseorderapprover	select	true	Purchase Approver	false	In the Purchase Approver field, select the person that approves the employee&#x2019;s purchase requests. If no approver is selected, the supervisor approves purchase requests. If a purchase approver is selected, the supervisor is no longer part of the approval hierarchy.
purchaseorderlimit	currency	true	Purchase Limit	false	In the Purchase Limit field, enter the amount this employee can purchase without approval from a supervisor or approver.
releasedate	date	true	Termination Date	false	Enter this person's last date of employment.
requirepwdchange	checkbox	false	Require Password Change On Next Login	false	Check this box to require this user to change their password on their next login to NetSuite. When the user next logs in, they see the Change Password page and cannot access other NetSuite pages until a new password is created and saved. Requiring this action protects your account from unauthorized access using generic passwords and prepares your account for an audit. Note that the Require Password Change on Next Login box never displays as checked. When you check this box and save the record, an internal flag is set. When the password change occurs, the flag is cleared. If you later check the box again and resave the record, the internal flag is reset to require another password change.
residentstatus	select	true	Resident Status	false
retailuserqty	text	false	RetailUser current	false
retailuserqtymax	text	false	RetailUser max	false
salesrole	select	true	Sales Role	false	Select the this employee's role in the selling process. You can create new sales roles at <_TABNAME=LIST_CRMOTHERLIST_> > <_TASKCATEGORY=LIST_CRMOTHERLIST_> > CRM Lists > New > Sales Role.
salutation	text	true	Mr./Ms...	false	Enter the employee's salutation, such as Mr. or Ms., here.
sendemail	checkbox	false	Send Notification Email	false	Check this box to send an automatic e-mail notifying this employee of access privileges to NetSuite. If you leave this check box blank, you have to tell this person when and how to log in. For security, the email message will not disclose the password. You have to contact your employee with this information.
socialsecuritynumber	ssnumber	true	Social Security	false	Enter this employee's social security number here in the following format: 123-45-6789.
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	Select the name of your employee's supervisor. This person approves expense reports and purchase requests. If the employee doesn't have a supervisor, use the Approver field to select the person who approves this employee's expense reports and purchase requests.
terminationbydeath	checkbox	false	Termination Due To Death	false
timeapprover	select	true	Time Approver	false	In the Time Approver field, select the person who approves the employee&#x2019;s time transactions. If no time approver is selected, the employee&#x2019;s supervisor approves time entries. If both a supervisor and a time approver are selected, then only the time approver can approve time entries using their Employee Center role.
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	Check this box if you want to include this employee in your pay runs. This employee will also be included in the Employee list on payroll forms and reports.
usetimedata	select	true	Compensation Type	false	Select Wage if this employee's pay is based on hours entered via the weekly time sheet or by manual entry while processing the payroll. Select Salary if this employee's pay is based on a set amount and does not vary according to hours worked.
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	Select the work calendar for this employee.
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
addressbookaddress	summary	Edit	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

rates - Rates

Internal ID	Type	Label	Required
entitycurrency	select	Currency	true
rate	currency	Hourly Rate	true

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
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
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