Approved Time Sheet Fixed Format Download

This integration downloads approved time sheets.

Connector Overview

Component

Detail

Company Type

Buyer

Supplier

Version Type

1.0

Format

CSV

Prerequisites

Company Details Setting must be turned on for Integration – Approved Time Sheet Fixed Format Download.

User role permission must be turned on for Upload Data and Download Data.

Predecessors

Time Sheets

Related Connectors

Standard Time Sheet Upload

Approved Expense Sheet Download

Triggering Events

  • Time sheet must be in Submitted, Invoiced or Paid status.

  • Time sheets for the logged in user are pulled. For example, the supplier user will pull time sheets for that supplier; buyer user will pull time sheets for that buyer.

  • Time sheet must be approved since the last download.

File Formatting

Detail

Column Header Name

Data Type

Length

Enabled by Default?

Value(s)/Format

Description/Use/Field Rules

FG Reference Number Text 16 Yes Valid SAP Fieldglass Time Sheet ID Fieldglass Time Sheet ID
First Name Text 200 Yes   Worker’s First Name
Last Name Text 200 Yes   Worker’s Last Name
Vendor Code Text 6 Yes Valid SAP Fieldglass supplier code Fieldglass Supplier Code of the supplier to which the worker is employed.
Vendor Name Text 100 Yes   Fieldglass Supplier Name of the supplier to which the Worker is employed.
Buyer Code Text 6 Yes Valid SAP Fieldglass buyer code Buyer Code for the supplier to which the Worker is contracted.
Remit to Address Code Text 100 No   Supplier Remit to Address Code, if required by the buyer or entered for the worker.
Billable Per Diem Decimal No

Example:

75.00

Numeric amount of daily per diem for the worker.
Billable Days Number Yes   Number of days for which the worker entered billable time.
Rate Currency Text 3 Yes

Examples:

USD

CAD

GBP

Currency in which the time sheet will be paid.
Start Date Date Yes   Start Date of the time sheet.
End Date Date Yes   End Date of the time sheet.
Job Seeker ID Text 16 Yes   Fieldglass Job Seeker ID of the worker entering time.
Date Approved DateTime Yes   Date on which the time sheet received its final approval.
Supplier Amount Decimal Yes

Example:

123.45

Amount for which the supplier will be paid for the time sheet.
Pay to Vendor Number Yes   Will always be “0”.
Total Amount Decimal Yes

Example:

246.80

Total amount paid by the customer. Equal to Buyer Amount.

Total Amount after Discount

Decimal

Yes

Example:

233.88

Total Amount of the time sheet after applying the discount.

[r] Rate Category / UOM Decimal Yes

Example:

22.13

For each Rate Category associated with the worker, this is the rate the worker will be paid for hours entered.
[diff] Rate Category / UOM Number Yes   Will always be “0”.
[pr] Rate Category / UOM Decimal No

Example:

29.44

Pay rate paid to the worker for hours worked.
[hr] Rate Category / UOM Number No   Hours worked for the Rate Category listed.
[c] Time Sheet Custom Field X Dependent on Custom Field Type Conditional on Custom Field.   Any time sheet custom fields that are visible to the supplier.
[c] Worker Custom Field X Dependent on Custom Field Type Conditional on Custom Field.   Any worker custom fields which are visible to the supplier.

Unique Identifier

  • FG Reference Number (Fieldglass Time Sheet ID)

General Conventions

Time sheets will appear in the download if they have been approved since the last time the download was run. The Last Run Date is stored in SAP Fieldglass each time the connector is successfully run. The current data is compared with the Last Run Date and data is pulled into the download accordingly. In the event that previous data is required again, you may contact your SAP Fieldglass representative and they can update this to the date you request.

Custom Fields

  • The download file will include custom fields from various modules in SAP Fieldglass. The specific modules are explained in the file format above.

  • Custom fields that are included will always appear at the end of the column layout after all of the native, either default or optional, SAP Fieldglass fields have been output.

  • Custom field headers will be displayed in the format “[c] Field Name”.

Assumptions/Tips

  • Time sheets are pulled from the latest confirmed work order.

  • SOW Rate Schedule Time Sheets are included in this download.