SSIS Components for SAP Fieldglass

Build 24.0.9060

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

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060