Work Order Delta Download

This integration downloads the modified work orders since the last run date. The Work Order Delta Download pulls all active workers since the date entered as a parameter to the connector.

Connector Overview

Component

Detail

Company Type

Buyer

Supplier

MSP Partner

Version Type

1.0 – Pulls the latest revision of all modified work orders since last run date.

2.0 – Pulls all modified work order revisions since the last run date.

Format

CSV

Prerequisites

Company Details Setting must be turned on for Integration – Work Order Delta Download.

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

Predecessors

Work Order(s)

Related Connectors

Worker from Work Order Download

Active Work Order Download

Inclusion Criteria

Workers and work orders in the following statuses are included if there have been any updates made to either the worker or work order record since the last run of the download.

Work Order Status

Worker Registered

Worker Record Included in Download

Status in Download

Person ID

Pending Approval

No

Yes

Pending

Blank

Rejected

No

Yes

Closed

Blank

Created

No

Yes

Pending

Blank

Accepted

No

Yes

Pending

Blank

Activated

No

Yes

Pending

Blank

Confirmed

Yes

Yes

Active

Populated

Pending Approval

Yes

Yes

Active

Populated

Created

Yes

Yes

Active

Populated

Confirmed

Yes

Yes

Active

Populated

Rejected

Yes

Yes

Active

Populated

Declined

Yes

Yes

Active

Populated

Confirmed

Yes

Yes

Active

Populated

Closed

No

Yes

Closed

Blank

Declined

No

Yes

Closed

Blank

Confirmed (Worker Closed) (End date after the download date)

Yes

Yes

Active

Populated

Confirmed (Worker Closed) (End date on or before the download date)

Yes

Yes

Closed

Populated

File Formatting

Detail

Column Header Name

Data Type

Length

Enabled by Default?

Value(s)/Format

Description/Use/Field Rules

Work Order ID

Text

16

Yes

Valid SAP Fieldglass Work Order ID.

Example:

  • XXXXWO00000001

Unique identifier for work order.

Revision Number

Number

Yes

Example:

  • 1

Indicates number of work order revisions.

Work Order Start Date

Date

Yes

Start Date of Work Order.

Work Order End Date

Date

Yes

End Date of latest Work Order.

Work Order Status

Text

100

Yes

Valid values are:

  • Accepted

  • Activated

  • Confirmed

  • Created

  • Declined

  • Pending Approval

  • Rejected

  • Withdrawn

Status of the Work Order.

Work Order Last Modified Date

Date

Yes

Last modified date of Work Order.

Work Order Activation Date

Date

No

Date this work order was activated.

Worker First Name

Text

200

No

Worker’s First Name.

Worker Last name

Text

200

No

Worker’s Last Name.

Worker ID

Text

16

Yes

Valid SAP Fieldglass Worker ID.

Example:

  • XXXXWK00000001

SAP Fieldglass Worker ID.

Job Seeker ID

Text

16

Yes

Valid SAP Fieldglass Job Seeker ID .

Example:

  • XXXXJS00000001

SAP Fieldglass Job Seeker ID for worker.

Vendor Name

Text

100

Yes

Vendor Name.

Vendor Code

Text

6

Yes

Valid SAP Fieldglass supplier code for buyer.

Supplier code associated to buyer.

Job Posting Title

Text

100

Yes

Job posting title for worker.

Legal Entity

Text

100

Conditional

Valid SAP Fieldglass Legal Entity

Legal Entity code associated to work order or SOW.

Company configuration Use legal entity must be turned on for Contingent and /or Services: Work Orders and Workers.

Site Name

Text

100

Yes

Site name.

Site Code

Text

100

Yes

Valid SAP Fieldglass Site Code.

Site code.

Site Address 1

Text

600

No

Site address 1.

Site Address 2

Text

600

No

Site address 2.

Site City – use with Worker based report

Text

50

No

Site city.

Site State/Province – use with Worker based Report

Text

50

No

Valid values:

  • Valid US State Abbreviation.

  • Province

Site State or Province.

Site Country – use with Worker based report

Text

3

No

Valid ISO country code.

Example:

  • USA

  • CAN

Site Country.

Site ZIP/Postal Code

Text

20

No

Site Zip or Postal code.

Business Unit Name

Text

100

Yes

Business Unit Name.

Business Unit Code

Text

100

Yes

Valid SAP Fieldglass Business Unit code.

Hours per Day

Decimal

Yes

Example:

  • 7.5

Indicates Hours per Day.

Hours per Week

Decimal

Yes

Example:

  • 37.5

Indicates Hours per Week.

Estimated Additional Spend Percentage

Decimal

No

Indicates any additional estimated spend percentage.

Total Estimated Hours

Decimal

Yes

Indicates total estimated hours for work order.

Estimated Expenses Percentage

Decimal

No

Indicates any estimated expenses percentage.

Adjustments applied to spend Percentage

Decimal

No

Indicates any adjustments applied to spend percentage.

Remit-To Address Code

Text

100

No

Code as assigned to the Remit-To Address by Supplier.

Worker Pay Type Code

Text

100

Conditional

Indicates any worker pay types. Company configuration Worker pay type must be enabled.

Bill Rate Category

Text

100

Yes

Examples are:

  • ST

  • OT

Rate category for Bill Rate.

Bill Rate

Decimal

Yes

Worker’s Bill Rate that is associated to the Rate Unit listed in the next field.

Rate Unit

Text

100

Yes

Examples are:

  • Hr

  • Day

Rate Unit associated to the previous field.

Currency

Text

3

Yes

Valid ISO Currency Code.

Examples:

  • USD

  • CAD

  • GBP

  • EUR

Currency designation.

Average Rate used to calculate committed spend

Decimal

Yes

Calculated average rate for work order.

Billable per Diem

Decimal

No

Amount that is billable per day.

Maximum Expense

Decimal

No

Maximum amount for expenses.

Committed Spend

Decimal

Yes

Amount of committed spend.

Cost Center Name

Text

200

Yes

Cost Center Name in SAP Fieldglass.

Primary Cost Center only.

Cost Center Code

Text

200

Yes

Valid SAP Fieldglass Cost Center Code.

Cost Center Code in SAP Fieldglass.

Primary Cost Center Only.

Cost Allocation Percentage

Decimal

Conditional

 Example:

  • 15.000

Percentage to allocate to cost center.

If Cost Allocation Amount entered, this field is mandatory.

If company configuration Cost Allocation Percentage decimal precision is enabled, this field shows zeros beyond the precision value set digit.

Cost Allocation amount

Decimal

No

Amount to be allocated to cost center.

Task Name

Text

100

No

Name of task code.

Task Code

Text

100

No

Valid SAP Fieldglass Task Code.

Task code.

Cumulative Committed Spend

Decimal

Yes

Amount accumulated for committed spend for work order(s).

Spend to Date

Decimal

Yes

Amount spent to date.

Job Posting Owner

Text

100

Yes

Valid SAP Fieldglass username .

Name of JP owner.

Job Posting Owner Employee ID

Text

100

No

Employee ID of JP owner.

Job Posting Creator

Text

100

No

Valid SAP Fieldglass username .

Name of JP creator.

Work Order Create Date

Date

Yes

Creation date of work order.

Work Order Submit Date

Date

No

Submit date of work order.

External ID

Text

100

No

An external Work Order identifier used by the client for tracking purposes.

PO Number

Text

100

No

PO number.

Auto Register

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if worker will auto register.

Worker Country of Origin

Text

3

Conditional

Valid SAP Fieldglass country code.

Examples:

  • GER

  • USA

Indicates worker's country of origin.

Company configurations Security ID format by worker country of origin and Security Information must be enabled.

Line Item Number

Number

No

Fetches Line Item Numbers of Cost Centers from Work Orders when Account Category Pick List is used.

Not applicable for supplier downloads.

Commodity Code

Text

100

No

Commodity Code from the Contingent Work Order, Statement of Work, Event, Fee, Schedule, or SOW Worker.

Example:

  • 432231

Code for the commodity.

This field must be manually configured to be in the download file template.

Commodity Code Description

Text

100

No

Commodity Code Description from the Contingent Work Order, Statement of Work, Event, Fee, Schedule, or SOW Worker.

Example:

  • Digital Mobile Network Infrastructure Equipment Components

Description of the commodity code.

This field must be manually configured to be in the download file template.

Discount %

Decimal

No

Valid values are 0-100, up to 3 decimal places

Discount % from SOW Worker.

Primary Location Code

Text

100

No

Valid SAP Fieldglass location code

Indicates primary location code when at least one sub-configuration for the company configuration Use multiple locations is enabled.

Client must configure the download to include this field via the Enabled Fields +Add Native Fields hyperlink.

Location Code

Text

100

Conditional

Valid SAP Fieldglass location code

The location code.

Enable at least one sub-configuration for the company configuration Use multiple locations. If the download’s parameters pull a document with multiple locations, the row is repeated with the exact same information in all columns except the location columns. There will be as many duplicated rows as there are number of locations on the time sheet.

Work Location Name

Text

100

Conditional

The location name.

Enable at least one sub-configuration for the company configuration Use multiple locations. If the download’s parameters pull a document with multiple locations, the row is repeated with the exact same information in all columns except the location columns. There will be as many duplicated rows as there are number of locations on the time sheet.

Primary Location

Text

100

No

Indicates primary location name when at least one sub-configuration for the company configuration Use multiple locations is enabled.

Client must configure the download to include this field via the Enabled Fields +Add Native Fields hyperlink.

Original Revision Start Date

Date

No

This field returns the Start Date from the original work order regardless of what revision the work order is currently on.

[c]{module}_{custom field(s)}

Dependent on custom field.

Dependent on custom field.

Dependent on custom field.

Custom fields may be included in download per the request of the company.

Custom fields from the following modules may be included in the download:

  • Business Unit

  • Cost Center

  • Job Posting

  • Job Seeker

  • Security Information

  • SOW Worker

  • Supplier

  • Work Order

  • Work Order Revision

  • Worker

  • Worker User Person

If there are many custom fields, there will be many columns and the column header format will be:

"[c]modulename_custom field name" (i.e. [c] followed by module custom text lowercase with no spaces, followed by underscore, followed by the custom field name text as defined by users in the SAP Fieldglass application).

Unique Identifier

  • Work Order ID field

Custom Fields

  • The download file may include custom fields from various modules in SAP Fieldglass. For the specific modules, consult your SAP Fieldglass Representative.

  • The client can specify the custom fields they wish to include in the file and the order in which they want to see them.

  • At the time the connector is activated for the client, the client will be required to supply a list of the custom fields and their order. This list will be stored in SAP Fieldglass against the setup of the connector. If no custom fields are supplied, then the download will not include any custom field values.

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

Assumptions/Tips

  • Both buyer- and supplier-entered Custom Fields will display and can be updated by both parties regardless of who created the Custom Field first.

  • If the buyer company has multiple MSPs, when the MSP supplier user downloads records, they will see only records for their MSP.

  • Company configuration Security ID format by worker country of origin cannot be enabled for companies using 'Manage Pay Parity'.

  • Work Orders/Work Order Revisions in Withdrawn status do not appear in supplier downloads.

  • This download does not assist or produce the 'Pending Approval' status.

  • For Rates 2.0,

    • For calculated rates with Calculation Type = Rate Rule, if rate's value has already been calculated, that value outputs. If rate's value has not been already calculated, output value is zero.

    • The following fields contain Rates 2.0 values: Bill Rate Category, Bill Rate, Rate Unit, Currency, Committed Spend, Cumulative Committed Spend, and Spend to Date.

  • The system includes any inactive cost centers associated with the document.