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 |
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 |
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 |
Join ID | Join Description | Actual Join Name |
---|---|---|
employee | Employee | Employee |
timebill | Time | Time |
timeentry | Time Entry | Time Entry |
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) |
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) |