Time Journal Download
This integration downloads multiple time journals that are in Submitted, Consolidated, and/or Errored status depending on a provided parameter. Refer to the Parameters section below for parameter values.
Connector Overview
|
Component |
Detail |
|---|---|
|
Company Type |
Buyer Supplier MSP Partner |
|
Version Type |
1.0 |
|
Format |
CSV |
|
Prerequisites |
Company Details Setting must be turned on for Integration – Time Journal Download. User role permission must be turned on for Upload Data and Download Data. |
|
Predecessors |
Time Sheets |
|
Related Connectors |
N/A |
Triggering Events
Time journals appear in the download if their status agrees with the parameter value provided at run time. Refer to the Parameters section below.
Parameters
The parameter indicates what record types to download. Run-time parameters are as follows:
0 => All
1 => Pending Approval / Approval Paused
2 => Approved
3 => Rejected
4 => Consolidated
5 => Errored
File Formatting
Detail
|
Column Header Name |
Data Type |
Length |
Enabled by Default? |
Value(s)/Format |
Description/Use/Field Rules |
|---|---|---|---|---|---|
|
Time Journal ID |
Text |
14 |
Yes |
Valid SAP Fieldglass Time Journal ID Example: xxxxTJ00000014 |
Reference ID for the time journal. |
|
Resource |
Text |
100 |
Yes |
Example: Smith, John |
Resource name. |
|
Buyer |
Text |
200 |
No |
Name of buyer associated to the time journal. |
|
|
Buyer Code |
Text |
6 |
Yes |
Valid SAP Fieldglass Buyer Code |
Buyer code associated to the time journal. |
|
Supplier |
Text |
200 |
Yes |
Name of supplier associated to the time journal. |
|
|
Supplier Code |
Text |
6 |
Yes |
Valid SAP Fieldglass Supplier Code for buyer |
Supplier code associated to the time journal. |
|
Date |
Date |
Yes |
Example: 2/2/2021 |
Date the resource time data for was logged to the time journal. |
|
|
Create Date |
Date |
Yes |
Example: 3/3/2021 |
Date the time journal was created. |
|
|
Assignment ID |
Text |
14 |
Yes |
Valid SAP Fieldglass Assignment ID Example: xxxxAS00000015 |
Reference ID for the associated assignment. |
|
Assignment |
Text |
200 |
Yes |
Name of the associated assignment. |
|
|
Site |
Text |
100 |
Yes |
Site name. |
|
|
Assignment Owner |
Text |
100 |
Yes |
Example: John Smith |
Name of assignment owner at the time the time journal was created. |
|
Total Quantity |
Decimal |
Yes |
Examples: 1.5 -3.5 |
Total number of hours worked by the resource on a given assignment line item and rate category or the total quantity of non-hour values such as per diem. |
|
|
Rate Category/UOM |
Text |
100 |
Yes |
Examples: ST/Hr OT/Hr |
Rate category and unit of measure of the rate |
|
Rate |
Decimal |
Yes |
Example: 19.38 |
Rate applicable for the hours and rate category worked by the resource. |
|
|
Amount |
Decimal |
Yes |
Examples: 51.37 -81.38 |
Time journal amount. |
|
|
Cost Center |
Text |
200 |
Yes |
Cost center associated with the time journal. |
|
|
Status |
Text |
100 |
Yes |
Examples: Consolidated Error Approved |
Status of the time journal. |
|
PO Number |
Text |
100 |
No |
Assignment purchase order number. |
|
|
Line Item Number |
Text |
100 |
Yes |
Examples: 2 First |
Assignment line item number. |
|
Time Journal Segment Name |
Dependent on custom lookup segment configuration |
Dependent on custom lookup segment configuration |
Conditional |
Example: Contract Line |
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 |
Text |
100 |
Yes |
Assignment rate lookup name. The Data Set company configuration must be enabled to view this field. |
|
|
Job Code |
Text |
100 |
Yes |
Job code on the time journal |
|
|
Currency |
Text |
3 |
Yes |
Valid SAP Fieldglass currency code Example: USD EUR |
Currency associated with the time journal |
|
Buyer Ref |
Text |
100 |
No |
Buyer reference field that can be used to reference the time journal. |
Unique Identifier
-
Time Journal ID field
Assumptions/Tips
-
All revised and reversed time journals are pulled in this download.
-
Suppliers view data specific to their supplier company across buyers.
-
The system includes any inactive cost centers associated with the document.