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 connector 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 connector.
- 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. |