| Label | ID | Type | UI Workbook | SuiteScript / SuiteTalk REST Web Services | Connect |
|---|---|---|---|---|---|
| Allocated Hours | allocatedhours | time | Yes | Yes | Yes |
| Approval Status | approvalstatus | select | Yes | Yes | Yes |
| Employee | employee | select | Yes | Yes | Yes |
| End Date | enddate | date | Yes | Yes | Yes |
| ExternalId | externalid | text | Yes | Yes | Yes |
| Internal ID | id | integer | Yes | Yes | Yes |
| Name | name | text | Yes | Yes | Yes |
| Planned Hours | plannedhours | time | Yes | Yes | Yes |
| Rejected Hours | rejectedhours | time | Yes | Yes | Yes |
| Start Date | startdate | date | Yes | Yes | Yes |
| Submitted hours | submittedhours | time | Yes | Yes | Yes |
| Subsidiary | subsidiary | select | Yes | Yes | Yes |
| Total Hours | totalhours | time | Yes | Yes | Yes |
| Week Of | trandate | date | Yes | Yes | Yes |
| Work Calendar Hours | workcalendarhours | time | Yes | Yes | Yes |
| Join | Target Record | UI Workbook | SuiteScript / SuiteTalk REST Web Services | Connect |
|---|---|---|---|---|
| Weekly Timesheet to Approval Status (timeLineApprovalStatus.key) | weekly timesheet (timesheet, timesheet.approvalstatus) | Yes | Yes | Yes |
| Weekly Timesheet to Entity (entity.id) | weekly timesheet (timesheet, timesheet.employee) | No | Yes | Yes |