Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Overview
Provides access to Workbench Timesheet data.
Endpoints
The resources available in this module.
TimesheetListApi
Provides API access to the Daily Desktop Timesheets (#/Timesheets/List.aspx) Web Workbench screen.
/api/TimesheetListApi | ||||
---|---|---|---|---|
Method | Performed As | Request Query | Request Body | Response |
POST | GridRequestParametersApi.IntValue, if specified; otherwise Logged in User. | - |
TimesheetDetailApi
Note: In order to create a Timesheet Line, please use POST with {Workbench.Mvc4.Areas.Api.Controllers.TimesheetDefaultsApiController} TimesheetDefaultsApiProvides API access to the Daily Timesheet Detail (#/Timesheets/Daily.aspx) Web Workbench screen.
/api/TimesheetDetailApi | |||||||
---|---|---|---|---|---|---|---|
Operation | Logged in User | Parameters | Method | Performed As | Request Query | Request Body | Response |
GET | Admin User | - | |||||
POST |
TimesheetDefaultsApi
[Description]Timesheet. | TimesheetApiModel.Form.Key.PersonId | - |
TimesheetDefaultsApi
Provides API access to the default line logic on the Daily Timesheet Detail (#/Timesheets/Daily.aspx) Web Workbench screen.
[Description]/api/TimesheetDefaultsApi | |||||||
---|---|---|---|---|---|---|---|
Operation | Logged in User | Parameters | Method | Performed As | Request Query | Request Body | Response |
GET | jobTranId |
TimesheetAttendanceApi
a given line key. | Admin User | - |
TimesheetAttendanceApi
Provides readonly API access to the Attendance Dialog on the Daily Desktop Timesheets (#/Timesheets/List.aspx) Web Workbench screen.
/api/TimesheetAttendanceApi | |||||||
---|---|---|---|---|---|---|---|
Operation | Logged in User | Parameters | Method | Performed As | Request Query | Request Body | Response |
POST |
Models
TimesheetApiModel
Property
Data Type
Description
Day1Complete
Boolean
Day2Complete
Boolean
Day3Complete
Boolean
Day4Complete
Boolean
Day5Complete
Boolean
Day6Complete
Boolean
Day7Complete
Boolean
AttendanceFields
Form
Rows
Array [TimesheetsDailyDetailLine]
ReadonlyMessages
Array [Tuple_String]
ValidationErrors
Array [MvcValidationError]
WarningMessage
String
SuccessMessage
String
ErrorMessage
String
⬆️ Back to top
TimesheetsAttendanceKeyRetrieve the attendance data a specific Timesheet. | Admin User | - | GridRequestParametersApi (IntValue and DateValue are required: they are the Person ID and Timesheet Date of the Timesheet respectively) |
Models
The definitions of models specific to endpoints in this module.
TimesheetKey
Property | Data Type | Description |
---|---|---|
PersonId | Integer | The ID of the Person this Timesheet is for. |
TimesheetDate | DateTime | The Timesheet Date. |
⬆️ Back to top
TimesheetLine
Property | Data Type | Description |
---|
PersonId
Integer
Key |
String
= ['FirstIn', 'FirstOut', 'SecondIn', 'SecondOut']
The unique key for the line. | ||
PersonName | The Person this Timesheet if for. | |
TimesheetDate | String | The Timesheet |
Rows
GridResult_TimesheetsAttendanceLine
⬆️ Back to top
TimesheetsAttendanceKey
Property
Data Type
Description
Action
String
=['FirstIn', 'FirstOut', 'SecondIn', 'SecondOut']
PersonId
Integer
TimesheetDate
Date, formatted. |
⬆️ Back to top
TimesheetApiAttendanceFields
Property
Data Type
Description
Entered | The total hours entered on the Timesheet. | |
Standard | The number of hours expected on the Timesheet. | |
Variance | The difference between Entered and Standard. | |
Completed | Boolean | The Completed flag on the Timesheet. |
Approved | Boolean | The Approved flag on the Timesheet. |
UpdatedDate | DateTime | The date the Timesheet was last modified. |
⬆️ Back to top
TimesheetsAttendanceLineTimesheetApiModel
Property | Data Type | Description |
---|
Form |
String
The general data associated withe the Timesheet. |
Rows |
String
Shift number.
Shift
String
Shift work.
Day1
Day 1 in the week.
Day2
Day 2 in the week.
Day3
Day 3 in the week.
Day4
Day 4 in the week.
Day5
Day 5 in the week.
Day6
Day 6 in the week.
Day7
Day 7 in the week.
ReadonlyFlag
Integer
Read Only status.
ReadonlyMessage
String
Read Only message.
OriginalKey
CurrentKey
Key
Index
Integer
⬆️ Back to top
TimesheetsDetailDefaultsArray<TimesheetDetailLine> | The Timesheet Lines. | |
AttendanceFields.Rows | Array<TimesheetAttendanceLine> | The Timesheet Attendance Lines. |
Day1Complete | Boolean | A flag to indicate if the first day of the Timesheet is complete. |
Day2Complete | Boolean | A flag to indicate if the second day of the Timesheet is complete. |
Day3Complete | Boolean | A flag to indicate if the third day of the Timesheet is complete. |
Day4Complete | Boolean | A flag to indicate if the fourth day of the Timesheet is complete. |
Day5Complete | Boolean | A flag to indicate if the fifth day of the Timesheet is complete. |
Day6Complete | Boolean | A flag to indicate if the sixth day of the Timesheet is complete. |
Day7Complete | Boolean | A flag to indicate if the seventh day of the Timesheet is complete. |
SuccessMessage | String | A message indicating the update was successful. |
WarningMessage | String | A warning message about the Timesheet. |
ValidationErrors | Array<MvcValidationError> | A list of specific validation errors if the save was unsuccessful. |
⬆️ Back to top
TimesheetForm
⬆️ Back to top
TimesheetsDetailDefaultsKey
Property
Data Type
Description
FinCoCode
String
Financial company code.
ActivityCode
Activity code.
ActivityType
String
Activity type.
ActivitySubType
String
Activity sub type.
CostRate
Number
Cost rate.
CostType
String
Cost type.
GstRate
Number
Tax rate.
WorkCentreCode
Work Centre code.
TimeCode
TimesheetDate
String
Timesheet date.
EmployeeClass
String
Employee class.
⬆️ Back to top
TimesheetsDetailKeyThe unique key for the line. | ||
ApprovalOnHoldField | BoolViewData | The Approval On Hold flag on the Timesheet. |
ApprovedField | BoolViewData | The Approved flag on the Timesheet. |
CompletedField | BoolViewData | The Completed flag on the Timesheet. |
VarianceNotes | StringViewData | The Variance notes on the Timesheet. |
ToilJobBalance | DecimalViewData | The User’s Time Off In Lieu balance. |
⬆️ Back to top
TimesheetDetailKey
Property | Data Type | Description |
---|---|---|
JobTranId | Integer | The unique ID of the Timesheet Line. |
PersonId | Integer | The Person idID. |
FinCoCode | String | The Financial company codeCompany Code. |
JobCode | String | The Job codeCode. |
ActivityCode | String | The Activity code Code. |
WorkCentreCode | String | The Work Centre code Code. |
ActivityType | String | The Activity type Type. |
ActivitySubType | String | The Activity sub type Sub Type. |
TimeCode | String | The Time codeCode. |
CostType | String | Cost type. |
CostRate | Number | Cost rate |
GstRate | Number | Tax rate. |
ProfileId | Integer | User profile id. |
StatusFlag | Integer | Status. | TranDate | String |
EmployeeClass | String | Employee class. |
The Cost Type of the Activity and Time Code. |
⬆️ Back to top
TimesheetsDailyDetailLineTimesheetDetailLine
Property | Data Type | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Key | The unique key for the line. | |||||||||||||||||
TranDate | String | The transaction date. | ||||||||||||||||
FinCoCode | String | Code of financial company. | ||||||||||||||||
FileAttachment | File attachment. | |||||||||||||||||
The Financial Company Code on the transaction. | ||||||||||||||||||
JobCode | The Job codeon the transaction. | |||||||||||||||||
Action | The Action on the transaction. | |||||||||||||||||
LogHeader | The Log headeron the transaction. | |||||||||||||||||
WorkCentreCodeActivityCode | CellDataWork Centre code | The Activity on the transaction. | ||||||||||||||||
ProfileActivityType | ActivityCode | Activity codeString | The Type of Activity. | |||||||||||||||
AllowanceTimeCode | AllowanceThe Time Code on the transaction. | |||||||||||||||||
ActivityTypeWorkCentreCode | String | The Work Centre on the transaction. | ||||||||||||||||
TimeCodeProfile | The Employee Profile on the transaction | |||||||||||||||||
StartTime | The Start timeTime on the transaction. | |||||||||||||||||
EndTime | The End timeTime on the transaction. | |||||||||||||||||
Breaks | The Breaks value on the transaction. | |||||||||||||||||
Quantity | Quantity of hoursThe hours Quantity, and Notes, on the transaction. | |||||||||||||||||
QuantityOnly | The hours Quantity on the transaction. | |||||||||||||||||
NoteOnly | Details | String | Duplicate | Delete | ||||||||||||||
PlantIssues | Plant issue if applied. | |||||||||||||||||
Payroll | JobManagerApproved | Boolean | PlantIssuesCount | Integer | StockIssuesCount | Integer | SourceID | Integer | SourceIDSpecified | Boolean | TimesheetRef1 | TimesheetRef2 | EmployeeClass | String | Employee classThe Notes on the transaction. | |||
JobManagerApproved | Boolean | The flag to indicate if the transaction has been approved. | ||||||||||||||||
PlantIssuesCount | Integer | The number of Plant Issues on the transaction. | ||||||||||||||||
PlantIssuesData.data | Array<PlantIssueLine> | The Plant Issues on the transaction. | ||||||||||||||||
StockIssuesCount | Integer | The number of Stock transactions on the transaction. | ||||||||||||||||
SourceID | Integer | The Source ID on the transaction. | ||||||||||||||||
SourceIDSpecified | Boolean | The flag to indicate if the transaction has a source. | ||||||||||||||||
TimesheetRef1 | The TimesheetRef1 details on the transaction. | |||||||||||||||||
TimesheetRef2 | The TimesheetRef2 details on the transaction. | |||||||||||||||||
EmployeeClass | String | The Employee Class on the transaction. | ||||||||||||||||
EmployeeClassValue | The Employee classClass on the transaction. | |||||||||||||||||
PlantIssuesData | WebGridDataModel_TimesheetsPlantIssueKey | |||||||||||||||||
Status | String | Status. | ||||||||||||||||
ReadonlyFlag | Integer | Read Only status. | ||||||||||||||||
ReadonlyMessage | String | Read Only message. | OriginalKey | CurrentKey | Key | Index | Integer |
⬆️ Back to top
TimesheetsKey
Property
Data Type
Description
PersonId
Integer
Person id.
TimesheetDate
String
⬆️ Back to top
PlantIssueKey
Property | Data Type | Description |
---|---|---|
JobTranID | Integer | The unique ID of the Plant Issue. |
ItemId | Integer | The ID of the Plant Item. |
JobCode | String | The Job Code. |
WorkCentreCode | String | The Work Centre Code. |
ActivityCode | String | The Activity Code. |
RateCode | String | The Plant Rate Code. |
TranDate | String | The Date of the Plant Issue. |
⬆️ Back to top
TimesheetsListItemPlantIssueLine
Property | Data Type | Description |
---|
Key |
The unique key for the line. |
Selected |
String
Timesheet date.
Entered
Standard
Variance
Completed
Boolean
Completed status.
Approved
Boolean
Approved status.
ExpenseClaim
Expense claim.
UpdatedDate
String
Updated date.
Status
String
Status.
ReadonlyFlag
Integer
Read Only status.
ReadonlyMessage
String
Read Only message.
OriginalKey
CurrentKey
Key
Index
A flag to indicate the Plant Issue is being edited. | ||
PlantCode | The Plant Item on the Plant Issue. | |
RateCode | The Plant Rate on the Plant Issue. | |
UnitCode | The Unit on the Plant Issue. | |
ActivityCode | The Activity on the Plant Issue. | |
WorkCentreCode | The Work Centre on the Plant Issue. | |
DefaultQuantity | The Default Quantity on the Plant Issue. | |
ActualQuantity | The Actual Quantity on the Plant Issue. | |
Note | The Note on the Plant Issue. | |
Delete | A flag to indicate the Plant Issue is being deleted. | |
Status | String | Either "from-database" if pre-existing, or "generated-line" if pre-populated by default. |
⬆️ Back to top
TimesheetDefaultLineApiModel
Property | Data Type | Description |
---|---|---|
keys | The default values for the Timesheet Line. |
⬆️ Back to top
TimesheetsPlantIssueKeyTimesheetDefaultLine
Property | Data Type | Description |
---|
JobTranID
Integer
ItemId
Integer
Item id.
FinCoCode | String |
The default Financial Company Code. |
ActivityCode |
String
The default Activity. |
ActivityType | String |
The Type of the Activity. |
Property
Data Type
Description
Selected
PlantCode
Plant code.
RateCode
Rate code.
UnitCode
Unit code.
ActivityCode
ActivitySubType | String |
NewRow
String
PlantCode
String
Plant code
TimeWorkCentreCode
String
⬆️ Back to top
TimesheetsPlantIssuesLine
The Sub Type of the Activity. | ||
CostRate | Number | The Cost Rate of the Activity. |
CostType | String | The Cost Type of the Activity. |
GstRate | Number | The GST Rate of the Activity. |
WorkCentreCode | The default Work Centre |
. |
TimeCode |
ActualQuantity
Note
Note.
Delete
Status
String
Status.
ReadonlyFlag
Integer
Read Only status.
ReadonlyMessage
String
Read Only message.
OriginalKey
CurrentKey
Key
Index
Integer
The default Time Code. | ||
TimesheetDate | String | the default Timesheet Date. |
⬆️ Back to top
AttendanceKey
Property | Data Type | Description |
---|---|---|
Action | String | Must be one of the following: 'FirstIn' (start of first shift), 'FirstOut' (end of first shift), 'SecondIn' (start of second shift), 'SecondOut' (end of second shift). |
PersonId | Integer | The Person ID on the Timesheet. |
TimesheetDate | String | The Timesheet Date. |
⬆️ Back to top
TimesheetsTimesheetFormResultAttendanceLine
Property | Data Type | Description |
---|---|---|
Key |
TimesheetsKey
ApprovalOnHoldField
BoolViewData
ApprovedField
BoolViewData
Value of Approval field.
CompletedField
BoolViewData
Value of Completed field.
NoEditMessage
String
TimesheetDate
String
Timesheet date,
TimesheetNew
Boolean
VarianceNotes
StringViewData
The difference between total and standard hours.
ToilJobBalance
DecimalViewData
Time Off In Lieu balance
⬆️ Back to top
WebGridDataModel_TimesheetsPlantIssueKey
Property
Data Type
Description
data
Array [TimesheetsPlantIssuesLine]
⬆️ Back to top
Example
V
title | Click to view |
---|
Request
language | json |
---|
Response
language | json |
---|
Response sample
language | json |
---|
The unique key for the line. | ||
LineNo | String | The integer representation of the Action ('0' for ‘FirstIn’, ‘1' for ‘’, ‘2' for ‘SecondIn’, ‘3’ for 'SecondOut’). |
ShiftNo | String | The shift number: either ‘1' for first shift, or '2’ for second shift. |
Shift | String | Either ‘Start’ or ‘End’. |
Day1 | Day 1 Attendance time. | |
Day2 | Day 2 Attendance time. | |
Day3 | Day 3 Attendance time. | |
Day4 | Day 4 Attendance time. | |
Day5 | Day 5 Attendance time. | |
Day6 | Day 6 Attendance time. | |
Day7 | Day 7 Attendance time. |
⬆️ Back to top
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|