Time Entry

Internal ID: timeentry

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
approvalstatus	select	false		false
billingclass	text	false	Billing Class	false
casetaskevent	select	false	Case/Task/Event	false
class	select	false	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.
createddate	datetime	false		false
customer	select	false	Customer	false	References an existing customer. If you select a customer or job, you must also select a service item.
day	date	false	Date	false
department	select	false	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.
employee	select	false	Employee	true
externalid	text	false	ExternalId	false
hours	timetrack	false	Duration	true	Required on Add.
isbillable	checkbox	false	Billable	false
isexempt	checkbox	false	Exempt	false
isproductive	checkbox	false	Productive	false
isutilized	checkbox	false	Utilized	false
item	select	false	Service Item	false	References an existing service item record. This field is required when the customer field is set.
location	select	false	Location	true	References a value in a user-defined list at Setup > Company > Classifications > Locations. This field is required when Make Locations Mandatory is enabled at Setup > Accounting > Accounting Preferences.
memo	textarea	false	Memo	false	If you want, enter a memo for this time transaction.If you are billing this time back to a customer or job, this memo appears as a description for this line item on the customer invoice.
overriderate	text	false	Lock this Rate	false
paidexternally	checkbox	false	Paid Externally	false
payrollitem	select	false	Payroll Item	false
price	select	false	Price Level	false	If you've set up a custom price level for your customer, it appears here. Otherwise, Sales Price 1 on the service item's record appears.If you want to change the price level, select one from the list. Select Custom to enter a new price in the Rate field. If you're entering time for a payroll item like vacation time, leave this field blank.
projecttaskassignment	select	false		false
rate	text	false	Rate	false	If you selected a price in the Price Level field, it automatically appears here.If you don't use multiple prices or if you selected Custom in the Price Level field, enter a rate for this time transaction. If you're entering time for a payroll item like vacation time, leave this field blank.
subsidiary	select	false	Subsidiary	false	The subsidiary associated with the employee is displayed here.
timetype	select	false	Type	false

Search Joins

Join ID	Join Description	Actual Join Name
billingclass	BillingClass	Billing Class
customer	Customer	Customer
department	Department	Department
employee	Employee	Employee
job	Job	Job
location	Location	Location
projecttask	Project Task	Project Task
task	Task	Task
timesheet	Timesheet	Timesheet
user	User	Employee
vendor	Vendor	Vendor

Search Filters

Internal ID	Type	Label
approvalstatus	select	Approval Status
billable	checkbox	Billable
billingclass	select	Billing Class
billingstatus	checkbox	Billing Status
class	select	Class
customer	select	Customer:Job
date	date	Date
datecreated	datetime	Date Created
department	select	Department
duration	float	Duration
employee	select	Employee
exempt	checkbox	Exempt
externalid	select	External ID
externalidstring	text	External ID (Text)
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
ischarged	checkbox	Charged
item	select	Item
lastmodified	datetime	Last Modified
location	select	Location
memo	text	Memo
nextapprover	select	Next Approver
paidbypayroll	checkbox	Paid by Payroll
paidexternally	checkbox	Paid Externally
payitem	select	Payroll Item
productive	checkbox	Productive
subsidiary	select	Subsidiary
type	select	Type
utilized	checkbox	Utilized

Search Columns

Internal ID	Type	Label
approvalstatus	select	Approval Status
billingclass	select	Billing Class
billingstatus	text	Billing Status
break	text	Break
casetaskevent	select	Case/Task/Event
chargebillingrunid	integer	Charge Billing Run ID
class	select	Class
classnohierarchy	select	Class (no hierarchy)
customer	select	Customer:Job
date	date	Date
datecreated	date	Date Created
department	select	Department
departmentnohierarchy	select	Department (no hierarchy)
durationdecimal	float	Duration (Decimal)
employee	select	Employee
endtime	timeofday	End Time
externalid	select	External ID
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)
hours	text	Duration
internalid	integer	Internal ID
isbillable	checkbox	Billable
isexempt	checkbox	Exempt
isproductive	checkbox	Productive
isutilized	checkbox	Utilized
item	text	Item
lastmodified	date	Last Modified
location	select	Location
locationnohierarchy	select	Location (no hierarchy)
memo	text	Note
nextapprover	select	Next Approver
paidexternally	checkbox	Paid Externally
payitem	select	Payroll Item
payrolldate	date	Payroll Date
rate	currency	Rate
starttime	timeofday	Start Time
subsidiary	text	Subsidiary
subsidiarynohierarchy	text	Subsidiary (no hierarchy)
timesheet	url	Timesheet
type	select	Type