Time Entry

Internal ID: timeentry

Subrecord

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
approvalstatus	select	false		false	Select an approval status for this time entry.
billingclass	text	false	Billing Class	false	Select a billing class for this time entry. If a billing class is selected for this employee it is automatically selected.
casetaskevent	select	false	Case/Task/Event	false	Select a case, task, event or call for the customer or project you selected, to associate this time with an activity. This time entry is added to the record you select.
class	select	false	Class	false	If you want, select the class that applies to this transaction. Click New to set up a new class.
createddate	datetime	false		false
customer	select	false	Customer	false	If applicable, select the customer or project that applies to this time transaction. If you select a customer or project, you must also select a service item. Click -New- to set up a new customer.
day	date	false	Date	false
department	select	false	Department	false	If you want, select the department that applies to this transaction. Click New to set up a new department.
employee	select	false	Employee	true
externalid	text	false	ExternalId	false
hours	timetrack	false	Duration	true	If you filled in the Start Time, End Time and Break fields, NetSuite automatically fills in the Duration field for you. If you didn't fill in these fields, enter the total time worked in hours and minutes. If you want to time yourself as you work, click the Timer link next to the Duration field.
isbillable	checkbox	false	Billable	false	Check this box if the time you are entering can be billed.
isexempt	checkbox	false	Exempt	false
isproductive	checkbox	false	Productive	false
isutilized	checkbox	false	Utilized	false
item	select	false	Service Item	false	If applicable, select the service that was provided. If you select a service item, you must also select a customer or project. Click New to set up a new service item.
location	select	false	Location	true	Select a location to associate with this transaction. Select New to create a new location record.
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	If you're billing this time back to a customer, check this box to lock the rate you enter so it's not affected by rate changes that happen before the customer is billed. If you're entering time for a charge-based project and there are time-based charge rules, the rate is determined by the applied charge rule. Any rates entered on time records are discarded. If you are entering time for a payroll item like vacation time, leave this field blank.
paidexternally	checkbox	false	Paid Externally	false	Check this box to designate that this time will be or has been paid to the employee outside of NetSuite. This removes the time entry from NetSuite payroll lists and transactions but still keeps the time available for billing back to the customer.
payrollitem	select	false	Payroll Item	false	Select the payroll item that applies to this time entry. Selecting the correct payroll item ensures that the correct rate is applied.
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. If you're entering time for a charge-based project and there are time-based charge rules, any price level selected in this field will be overridden by the applied charge rule.
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. If you're entering time for a charge-based project and there are time-based charge rules, any rate entered in this field will be overridden by the applied charge rule.
subsidiary	select	false	Subsidiary	false	The subsidiary associated with the employee is displayed here.
timetype	select	false	Type	false	The type of time transaction is displayed here. Actual time is time that has been worked by an employee. Planned time is time that has been accounted for when planning a project. Allocated time is time that has been assigned due to a resource allocation.

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