SOW with Bid Download

This integration downloads SOW and SOW bid information.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

1.0

Format

CSV

Prerequisites

Company Details Setting must be turned on for Integration – SOW with Bid Download.

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

Predecessors

Statement of Work

SOW Bid

Related Connectors

N/A

Triggering Events

Activity

User

SOW Status

Buyer submits SOW/Bid for approval

Buyer

Pending Approval

Buyer rejects the SOW/Bid

Buyer

Rejected.

SOW/Bid approved by Buyer

Buyer

Pending Response

Suppliers accepts SOW/Bid

Supplier

Response Pending Approval

Suppliers declines SOW/Bid

Supplier

Declined

Buyer Approves the SOW/Bid

Buyer

Approved

SOW/Bid is edited

Buyer

Approved

SOW/Bid is edited

Supplier

Approved

SOW Revision created

Buyer

Pending Supplier Review

Supplier Reviews/Submits SOWR

Supplier

Pending Buyer Review

Buyer submits SOWR for approval

Buyer

Pending Approval

SOWR approved by Buyer

Buyer

Pending Response

Supplier accepts SOWR

Supplier

Response Pending Approval

Buyer Approves the SOWR

Buyer

Approved

SOW/Bid is closed

Buyer

Closed

File Formatting

Detail

Column Header Name

Data Type

Length

Enabled by Default?

Value(s)/Format

Description/Use/Field Rules

SOW ID

Text

16

Yes

Example:

  • XXXXTQ00000001

Unique identifier for SOW/Bid.

Revision Number

Number

Yes

Example:

  • 0

  • 1

SOW Revision number.

SOW Name

Text

100

Yes

SOW name.

Start Date

Date

Yes

Format:

  • MM/DD/YYYY

SOW start date.

End Date

Date

Yes

Format:

  • MM/DD/YYYY

SOW end date.

Status

Text

25

Yes

Valid SAP Fieldglass SOW statuses:

  • Approved

  • Closed

  • Pending Approval

  • Pending Buyer Review

  • Pending Response

  • Pending Supplier Review

  • Rejected

  • Response Pending Approval

  • Response Rejected

Current SOW Status.

Supplier Code

Text

6

Yes

 Valid SAP Fieldglass supplier code for buyer.

SOW Supplier company code.

If the SOW template rule Suppress Supplier Name is enabled, the supplier code displays as ‘XXXX’ if:
  • This is an SOW Bid.

    or

  • This is an SOW with the status of Draft, Pending Supplier Review, Pending Approval, or Response Approval.

    and / or

  • The user has the View Supplier Bid Responses user role permission enabled.

After the SOW reveals the name of the supplier, the associated SOW bid also shows the name of the supplier.

Supplier Name

Text

200

Yes

SOW Supplier company name.

If the SOW template rule Suppress Supplier Name is enabled, the supplier name displays as ‘Name Withheld’ if:
  • This is an SOW Bid.

    or

  • This is an SOW with the status of Draft, Pending Supplier Review, Pending Approval, or Response Approval.

After the SOW reveals the name of the supplier, the associated SOW bid also shows the name of the supplier.

Billable?

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if SOW is billable to the client.

Master SOW?

Text

3

No

Valid values are:

  • Yes

  • No

Flag to determine if this is a Master SOW.

Legal Entity

Text

100

Conditional

Valid SAP Fieldglass Legal Entity

Legal Entity code associated to SOW.

Company configuration Use legal entity must be turned on for Services.

Purchase Unit

Text

100

Conditional

Name of Purchase Unit.

Company configuration Purchase unit must be enabled. The User Role Permission Purchase Unit - View must be enabled to view this information.

Purchase Unit Code

Text

100

Conditional

Code of Purchase Unit.

Company configuration Purchase unit must be enabled. The User Role Permission Purchase Unit - View must be enabled to view this information.

Business Unit

Text

100

Yes

 Valid SAP Fieldglass business unit code for buyer.

Business unit code associated to SOW.

Clauses

Text

3

Yes

Valid values are:

  • Yes

  • No

This field determines if clauses are in use by the SOW.

Management Events

Text

3

Yes

Valid values are:

  • Yes

  • No

This field determines if the Management Event characteristic is in use by the SOW.

Schedules

Text

3

Yes

Valid values are:

  • Yes

  • No

This field determines if the Schedule characteristic is in use by the SOW.

Events

Text

3

Yes

Valid values are:

  • Yes

  • No

This field determines if the Event characteristic is in use by the SOW.

Units/Reimbursable

Text

3

Yes

Valid values are:

  • Yes

  • No

This field determines if any fee is defined in the SOW.

SOW Agency Workers

Text

3

Yes

Valid values are:

  • Yes

  • No

This field determines if the Workers are in use by the SOW.

Maximum Budget

Decimal

Yes

Example:

  • 1000950.50

Maximum allowed amount to spend on the SOW.

Holdback %

Decimal

Conditional

Examples:

  • 10.374

  • 7.520

The holdback % that is set on the SOW.

SOW template rule Enable Holdback must be set.

Fee Response Holdback %

Decimal

Conditional

Examples:

  • 10.374

  • 7.520

The holdback % that is set on the SOW fee response.

SOW template rule Enable Holdback must be set.

Currency

Text

100

Yes

Examples:

  • USD

  • AUD

  • GBP

Code of the currency used by the SOW.

Spend to Date

Decimal

Yes

Sum of the amount spend on the SOW.

Other Pending Spend

Decimal

Yes

The total amount of all schedules, events, units, and team-based amounts which are in pending status.

Remaining Budget

Decimal

Yes

Difference between Maximum Budget and Spend to Date values.

Cost Center Code

Text

200

Yes

Cost Center code associated to the SOW.

Cost Center Name

Text

200

Yes

Cost Center name associated to the SOW.

Create Date

Date

Yes

Format:

  • MM/DD/YYYY

Create date of the SOW.

Submit Date

Date

Yes

Format:

  • MM/DD/YYYY

Submit date of the SOW.

SOW Template Name

Text

100

No

Name of the template from which SOW is Created, if applicable.

SOW Template Type

Text

17

Yes

Valid values are:

  • Classic

  • Print Services

Type of the template from SOW is created.

The default value is 'Classic'.

AP Code

Text

200

Conditional

Valid SAP Fieldglass AP Codes defined on the Buyer Side on Remit To Addresses.

The AP Code field appears only when the AP Code Required has been enabled in the company configuration for Contingent and/or Services: Work Orders and Workers.

Custom Lookup: AP Code Selection must be created.

The AP Code is associated to Work Order or SOW.

Created for SOW Bid

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if SOW created for Bid.

SOW Bid Maximum Budget

Decimal

No

Indicates maximum budget for SOW Bid.

Associated MSOW Name

Text

100

Conditional

MSOW name associated with supplier.

SOW Template rule Allow MSOW association to ~SOW Bid~ supplier must be enabled. 

Associated MSOW ID

Text

14

Conditional

Valid SAP Fieldglass MSOW ID

MSOW ID associated with Supplier

SOW Template rule Allow MSOW association to ~SOW Bid~ supplier must be enabled. 

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.

For SOW Bid records in this download, this field will always be blank.

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.

For SOW Bid records in this download, this field will always be blank.

Additional Classifications

Text

100

No

Example:

  • Class2|Class3|Class4

For MSOWs that have multiple classifications, this field displays the additional classifications added during creation or revision, separated by a (|) pipe delimiter.

This field must be manually configured to appear in the download.

Work Location Code

Text

100

Conditional

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

Conditional

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.

Primary Location Code

Text

100

Conditional

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.

[c] Custom Fields

Dependent on Custom Field Configuration.

Dependent on Custom Field Configuration.

Format:

[c] Custom Field Name

Valid values of the custom field are configured during the setup of the SAP Fieldglass application.

If the Custom Field has the Applies To flag set to SOW Bid Only, then that Custom Field will not be displayed for non-bid SOW IDs and vice versa.

Associated Contract ID

Text

16

Conditional

Contract ID associated with supplier. Otherwise, the field will be blank.

Associated External Contract ID

Text

24

Conditional

If SOW uses a Contract, and that Contract has External Contract ID, the External Contract ID will be output. Otherwise, the field will be blank.

SOW Account Category

Text

500

No

A valid SAP Fieldglass account category.

The Account category of the SOW.

Unique Identifier

  • SOW ID field

  • Cost Center Code field

  • GL Account (if exists) field

Assumptions/Tips

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

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

General Conventions

SOW and SOW Bid information will appear in the download if a triggering event has occurred since the last time the download was run. The Last Run Date is stored in SAP Fieldglass each time the connector is successfully run. Therefore, the download will pull any records that have changed since Last Run Date. In the event that previous data is required again, you can contact your SAP Fieldglass representative and they can update this date to the date you request.

This is a multi-line download, if a SOW/Bid is associated with more than one cost center, SOW/Bid information is downloaded in more than one record.

Custom Fields

The download file will include custom fields from various modules in SAP Fieldglass. The specific modules are:
  • Cost Center

  • Business Unit

  • Site

  • Statement of Work

  • SOW Response

  • SOW Revision

  • SOW Bid

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

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, 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, either default or optional, SAP Fieldglass fields have been output.