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.