Timesheet

Internal ID: timesheet

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
allocatedhours time false Allocated Hours false
approvalstatus select false false Select an approval status for this time entry.
customform select false Custom Form true Select the type of form to use.
employee select false Employee false Select the employee whose time you are recording. Click New to set up a new employee record. For Timesheets, click the Quick Find icon at the top of the page to select a different timesheet.
enddate date false End Date true
externalid text false ExternalId false
id integer Internal ID false
iscomplete checkbox false false
plannedhours time false Planned Hours false
rejectedhours time false Rejected Hours false
startdate date false Start Date true NetSuite displays the start date for the current timesheet.
submittedhours time false Submitted Hours false
subsidiary select false Subsidiary false The subsidiary associated with the employee is displayed here.
templatestored text false false
totalhours time false Total Hours false NetSuite displays the total hours entered on this timesheet. This field is updated in real time.
trandate date false Week Of true NetSuite inserts today's date as the date of this transaction. You can type or pick another date.
workcalendarhours time false Work Calendar Hours false

Sublists

timegrid - Time

Internal ID Type Label Required Help
friday summary false
monday summary false
saturday summary false
sunday summary false
thursday summary false
tuesday summary false
wednesday summary false

timeitem - Enter Time

Internal ID Type Label Required Help
billingclass select Billing Class false
billingsubsidiary select Billing Subsidiary false
casetaskevent select Case/Task/Event false
class select Class false
customer select Customer : Job false
department select Department false
hours0 time Sun false
hours1 time Mon false
hours2 time Tue false
hours3 time Wed false
hours4 time Thu false
hours5 time Fri false
hours6 time Sat false
isbillable checkbox Billable false
isexempt checkbox Exempt false
isproductive checkbox Productive false
isutilized checkbox Utilized false
item select Service Item false
location select Location false
memo textarea Memo false
overriderate checkbox Lock this Rate false
payrollitem select Payroll Item false
payrollworkplace select Payroll Item Workplace false
price select Price Level false
rate currency2 Rate false
rejectionnote textarea Rejection Note false
statushours0 integer false
statushours1 integer false
statushours2 integer false
statushours3 integer false
statushours4 integer false
statushours5 integer false
statushours6 integer false
timebill0 integer false
timebill1 integer false
timebill2 integer false
timebill3 integer false
timebill4 integer false
timebill5 integer false
timebill6 integer false
timemodified checkbox Time Modified false
timeofftype select Time-Off Type false
timetype select Type false

Search Joins

Join ID Join Description Actual Join Name
employee Employee Employee
timebill Time Time
timeentry Time Entry Time Entry

Search Filters

Internal ID Type Label
allocatedhours time Allocated Hours
allocatedhoursdecimal float Allocated Hours (DECIMAL)
approvalstatus select Approval Status (Text)
employee select Employee
externalid select External ID
externalidstring text External ID (Text)
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
id integer ID
internalid select Internal ID
internalidnumber integer Internal ID (Number)
plannedhours time Planned Hours
plannedhoursdecimal float Planned Hours (DECIMAL)
rejectedhours time Rejected Hours
rejectedhoursdecimal float Rejected Hours (DECIMAL)
submittedhours time Submitted Hours
submittedhoursdecimal float Submitted Hours (DECIMAL)
timesheetdate date Timesheet Date
totalhours float Total Hours
workcalendarhours time Work Calendar Hours
workcalendarhoursdecimal float Work Calendar Hours (DECIMAL)

Search Columns

Internal ID Type Label
allocatedhours time Allocated Hours
allocatedhoursdecimal float Allocated Hours (DECIMAL)
approvalstatus select Approval Status (Text)
employee select Employee
enddate date End Date
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)
id integer ID
internalid select Internal ID
plannedhours time Planned Hours
plannedhoursdecimal float Planned Hours (DECIMAL)
rejectedhours time Rejected Hours
rejectedhoursdecimal float Rejected Hours (DECIMAL)
startdate date Start Date
submittedhours time Submitted Hours
submittedhoursdecimal float Submitted Hours (DECIMAL)
totalhours text Total Hours
totalhoursdecimal float Total Hours (DECIMAL)
workcalendarhours time Work Calendar Hours
workcalendarhoursdecimal float Work Calendar Hours (DECIMAL)