TimeJournals
Retrieve time journals that are in Submitted, Consolidated, and/or Errored status depending on a provided parameter using the Time Journal Download connector.
View Specific Information
The add-in will use the SAP Fieldglass API to process WHERE clause conditions built with the following columns and operators. The remaining filter criteria is executed client-side within the add-in.
- Status supports the '=' operator. This parameter specifies the status of the time journal. Available values are: All, Pending Approval, Approved, Rejected, Consolidated, and Errored. By default, all time journals are retrieved.
For example, the following queries are processed server-side:
SELECT * FROM TimeJournals WHERE Status = 'Approved' SELECT * FROM TimeJournals WHERE Status = 'Rejected'
Columns
| Name | Type | Description |
| Time Journal ID | String | Reference ID for the time journal. |
| Resource | String | Resource name. |
| Buyer | String | Name of buyer associated to the time journal. |
| Buyer Code | String | Buyer code associated to the time journal. |
| Supplier | String | Name of supplier associated to the time journal. |
| Supplier Code | String | Supplier code associated to the time journal. |
| Date | Date | Date the resource time data for was logged to the time journal. |
| Create Date | Date | Date the time journal was created. |
| Assignment ID | String | Reference ID for the associated assignment. |
| Assignment | String | Name of the associated assignment. |
| Site | String | Site name. |
| Assignment Owner | String | Name of assignment owner at the time the time journal was created. |
| Total Hours | Decimal | Total number of hours worked by the resource on a given assignment line item and rate category. |
| Rate Category/UOM | String | Rate category and unit of measure of the rate |
| Rate | Decimal | Rate applicable for the hours and rate category worked by the resource. |
| Amount | Decimal | Time journal amount. |
| Cost Center | String | Cost center associated with the time journal. |
| Status | String | Status of the time journal. Available values are All, Pending Approval, Approved, Rejected, Consolidated, and Errored. Defaults to All. |
| PO Number | String | Assignment purchase order number. |
| Line Item Number | String | Assignment line item number. |
| Time Journal Segment Name | String | Any user selectable segment associated with Time Journal. The Segment Name should contain an [s] before the name. The Data Set company configuration must be enabled to view this field. Valid values of the user selectable segments are picked up from the Time Journal. |
| Lookup Name | String | Assignment rate lookup name. The Data Set company configuration must be enabled to view this field. |
| Job Code | String | Job code on the time journal. |
| Currency | String | Currency associated with the time journal. |
| Buyer Ref | String | Buyer reference field that can be used to reference the time journal. |