Time

Internal ID: timebill

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
casetaskevent	select	false	Case/Task/Event	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.
customer	select	false	Customer:Project	false	References an existing customer. If you select a customer or job, you must also select a service item.
customform	select	false	Custom Form	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.
employee	select	false	Employee	true	References an existing employee record. Required on Add.
externalid	text	false	ExternalId	false
hours	timetrack	false	Duration	true	Required on Add.
isbillable	checkbox	false	Billable	false
isexempt	checkbox	true	Exempt	false
isproductive	checkbox	true	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	true	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	true	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	text	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.
serviceitem	select	false	Service Item	false
subsidiary	select	false	Subsidiary	false	The subsidiary associated with the employee is displayed here.
supervisorapproval	checkbox	false	Supervisor Approval	false
timetype	select	false	Type	false
trandate	date	false	Date	true

Search Joins

Join ID	Join Description	Actual Join Name
customer	Customer	Customer
employee	Employee	Employee
job	Job	Job
projecttask	Project Task	ProjectTask
task	Task	Task

Search Filters

Internal ID	Type	Label
approved	checkbox	Approved
billable	checkbox	Billable
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)
item	select	Item
lastmodified	datetime	Last Modified
location	select	Location
memo	text	Memo
paidbypayroll	checkbox	Paid by Payroll
paidexternally	checkbox	Paid Externally
payitem	select	Payroll Item
productive	checkbox	Productive
status	checkbox	Status
subsidiary	select	Subsidiary
temporarylocaljurisdiction	select	Temporary Local Jurisdiction
temporarystatejurisdiction	select	Temporary State Jurisdiction
type	select	Type
utilized	checkbox	Utilized

Search Columns

Internal ID	Type	Label
break	text	Break
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	select	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
paidexternally	checkbox	Paid Externally
payitem	select	Payroll Item
payrolldate	date	Payroll Date
rate	currency	Rate
starttime	timeofday	Start Time
status	text	Status
subsidiary	text	Subsidiary
subsidiarynohierarchy	text	Subsidiary (no hierarchy)
supervisorapproval	checkbox	Approved
temporarylocaljurisdiction	select	Temporary Local Jurisdiction
temporarystatejurisdiction	select	Temporary State Jurisdiction
type	select	Type