SOW Shell Update Upload

This integration uploads SOW shell edits while the SOW is in Draft, Declined, Pending Buyer Review, or Rejected status.

There are still two connectors that are needed to upload a complete SOW. The other two are Characteristic Upload and SOW Submit Upload.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

BULK-DELTA-V1.0

Format

CSV

Prerequisites

Company plug-ins must be turned on for Integration – SOW Shell Update Upload.

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

Predecessors

Statement of Work

Related Connectors

SOW Shell Upload

SOW Submit Upload

SOW Supplier Response Upload

SOW Worker Upload

Characteristic Upload

Fee Upload

Fee Response Upload

File Formatting

Header

Component

Required?

Definition/Use

Notes

Value

Type

Yes

Upload file type

SOW Shell Update Upload

Approval Required

No

Determines if the changes will be required to go through an approval process.

The valid values are:

  • True: Changes will route through the appropriate approval process if one is assigned per the current configuration of SAP Fieldglass.

  • False: Changes will bypass the approval process.

If this field is not included in the header, the default value will be False.

Submit

No

Determines the status in which the SOW will be saved.

The valid values are:

  • True: SOW will be considered completed.

    SOW would be in Pending Buyer Review status if there are sections pending to review.

    SOW would be in Pending Supplier Review status if there are no sections pending to review and supplier defined it. SOW goes to submitted status if it was defined by buyer.

  • False: The SOW will be saved in draft status.

If this field is not included in the header, the default value will be False.

Language

No

Determines the language to be used for values in the file, such as drop-down lists and radio buttons. Column headers will always default to the upload user's preferred language.

The valid language values are:

Arabic (Standard Arabic)
Chinese (Simplified)
Chinese (Traditional)
Dutch (Netherlands)
English (United Kingdom)
English (United States)
French (Canada)
French (France)
German (Germany)
Hebrew (Israel)
Hungarian (Hungary)
Italian (Italy)
Japanese (Japan)
Korean (Korea)
Mongolian (Mongolia)
Polish (Poland)
Portuguese (Brazil)
Portuguese (European)
Russian (Russia)
Spanish (Mexico)
Swedish (Sweden)

Number Format

No

This determines the number format for the numeric data in the file.

The valid values are:

  • “#,##9.99" (Example: "1,234,567.99”)

  • “#.##9,99" (Example: "1.234.567,99”)

  • “#'##9.99" (Example: "1'234'567.99”)

  • “# ##9,99" (Example: "1 234 567,99”)

The quotes are required even if the value does not have a comma in it. If this field is not included in the header the default value will be “#,##9.99” (Example: ”1,234,567.99”)

Date Format

No

Date format used in the file.

The valid values are:

  • MM/DD/YYYY

  • DD/MM/YYYY

  • YYYY-MM-DD

If this field is not included in the header, the default value will be MM/DD/YYYY.

Mark Clauses Reviewed?

Conditional. Required if any SOW has its status as 'Pending Buyer Review', next step as 'Review Clauses', and it has clauses in 'Pending Collaborator Review' status.

Indicates if clauses need to be reviewed.

The valid values are:

  • True: The connector marks all clauses which are in 'Pending Collaborator Review' as reviewed, and the SOW moves to the next step as per the existing functionality.

  • False: System displays an error since clauses must be reviewed by the Collaborator.

If this field is not included in the header, the default value is False.

Comments

No

Upload Comments

This is a comment field containing notes about the upload file.

Immediately following the Header section of the upload is one blank line.

Detail

Column Header Name

Data Type

Length

Required?

Value(s)/Format

Description/Use/Field Rules

Statement of Work ID

Text

100

Yes

Valid SAP Fieldglass SOW ID or External SOW ID

Example:

  • XXXXTQ00000001

Unique identifier of SOW.

Description

Text

10000

No

SOW Shell Description.

Cannot be updated for SOW Revisions.

If it is left blank, the value does not change.

Start Date

Date

Conditional

Required only when the Source specified in the file is Template.

Start date of the SOW. Cannot be before the original start date.

Cannot be updated for SOW Revisions.

If child SOW and Enforce Date Duration of Master Statement of Work when creating Child Statement of Work = Start date only or On Start and End Dates, this field must be within the start and end dates of the MSOW. If the rule = End date only, this field can be any date before the end of the CSOW.

If left blank, keep the existing value.

If this field is defaulted and locked by the contract, then the value in the file will be ignored.

End Date

Date

Conditional

Required only when the Source specified in the file is Template.

End date of the SOW. Cannot be before original start date.

If master SOW and Enforce Date Duration of Master Statement of Work when creating Child Statement of Work = Start date only, the end date on MSOW cannot be earlier than the start date of any of the existing CSOWs. If rule = End date only or On Start and End Dates, the end date on the MSOW cannot be earlier than an end date of any of the existing CSOWs.

If child SOW and Enforce Date Duration of Master Statement of Work when creating Child Statement of Work = Start date only, this field must be after the start date of CSOW. If rule = End date only or On Start and End Dates, this field must be within the start and end dates of the MSOW.

If left blank, keep the existing value.

If this field is defaulted and locked by the contract, then the value in the file will be ignored.

Project ID

Text

14

No

Example: ABCDPJ00001212

The Project ID that is associated to the given statement of work. The given project must not be closed.

If the business unit associated to the statement of work is not found in the list of business units associated to the project, an error occurs.

If the currency of the given statement of work does not match the currency of the project, an error occurs.

Comments To Supplier

Text

2000

No

The comments to the supplier.

Additional Classifications

Text

100

No

Example:

  • Class2|Class3|Class4

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

Applicable only for MSOWs.

If this field is left blank, no Additional Classifications are added. Default value is blank.

Maximum Budget

Decimal

No

Maximum budget for SOW.

If this field is entered and SOW Template rule Auto Calculate Max Budget is enabled, it must match the sum calculated, else an error is generated.

If it is left blank, the value will not change.

If the contract defaults and locks the Maximum Budget, then the value in the upload will be ignored.

Cap on Worker Spend

Decimal

No

If an amount specified, the worker spend amount cannot exceed this amount.

This amount cannot exceed the Maximum Budget amount.

If the SOW already has Cap on Worker Spend as zero and no value given in file, value is set to the Maximum Budget amount.

When there is no value given in the file for this field, this value is set to the amount in the Maximum Budget field. To avoid the maximum amount from being inserted, it is recommended that you provide a value.If left blank, keep the existing value.

If this field is defaulted and locked by the contract, then the value in the file will be ignored.

For all other cases, value of this field won’t change.

When the Allow invoicing from approved Time Sheets flag and the Allow invoicing from approved Expense Sheets flag are both unchecked or set to No, any value in this field is ignored and validation is suppressed.

If the contract defaults and locks the Maximum Budget, then the value in the upload will be ignored.

Headcount Cap

Decimal

Conditional

Mandatory if head count cap rule is enabled for the template.

Range: 1-9999

Maximum number of workers for SOW. Specified cap value will be validated during the SOW Worker addition to the SOW.

Do Not Exceed Amount

Decimal

No

Positive Decimal value.

Maximum Budget set on SOW.

If it is left blank, the value will not change.

Disallow approval of items when Maximum Budget is exceeded

Text

3

No

Valid values are:

  • Yes

  • No

Indicates items cannot be approved if maximum budget exceeded.

Disallow approval of items when Maximum Budget is exceeded for a Cost Center

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates items cannot be approved if maximum budget for cost center exceeded.

Cannot be selected when the Allow all Cost Centers of the company to be assigned to Workers flag is enabled.

Disallow approval of items when Maximum Budget is exceeded for Segmented Object Detail

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates items cannot be approved if maximum budget exceeded for SOD.

Company configuration 'Segmented object detail' is enabled.

This rule cannot be changed on upload if a value is locked on template.

Owner Username

Text

100

No

Valid SAP Fieldglass username

SOW Owner username.

This change will apply only on SOWs in Draft/ Pending Buyer Review / Rejected/ Response Rejected/ Declined status.

Cannot be updated for SOW Revisions.

If it is left blank, the value will not change.

If the Enhanced Legal Entity Validation configuration is enabled for the company, the system validates if the owner has visibility to the SOW legal entity, business unit, cost center, and site codes. If even one of these is not associated to the owner, the system displays an error message.

When company configuration SOW owner name updates on existing line items is enabled for the SOW and the Owner Username is updated, the new Owner is reflected on existing SOW line items.

Additional Suppliers

Text

100

Conditional

Example:

  • Supplier1|Supplier2|Supplier3

For MSOWs, this field contains the additional suppliers, and must be separated by a (|) pipe delimiter.

The company configurations Master SOW and Allow Multiple Suppliers must be enabled.

Maximum Schedule Budget Entered By User Type

Text

8

No

Valid values:

  • Buyer

  • Supplier

Indicates who can enter the maximum schedule budget.

Maximum Schedule Budget

Decimal

No

Maximum budget set for schedule.

If it is left blank, the value will not change.

Maximum Event Budget Entered By User Type

Text

8

No

Valid values:

  • Buyer

  • Supplier

Indicates who can enter the maximum event budget.

Maximum Event Budget

Decimal

No

Maximum budget set for event.

If it is left blank, the value will not change.

Maximum Fee Budget Entered By User Type

Text

8

No

Valid values:

  • Buyer

  • Supplier

Indicates who can enter maximum fee budget.

Maximum Fee Budget

Decimal

No

Maximum budget set for fee.

If it is left blank, the value will not change.

Maximum SOW Worker Budget

Decimal

No

Maximum budget set for worker.

If it is left blank, the value will not change.

Holdback %

Decimal

No

Example:

  • 10

  • 7.5

The holdback % that is set on the SOW.

SOW template rule Enable Holdback must be set.

Fee Response Holdback %

Decimal

No

Example:

  • 10

  • 7.5

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

SOW template rule Enable Holdback must be set.

SOW Coordinators

Text

504

No

A valid username in 'Open' status in the buyer company.

Examples:

  • username1

  • username1~username2

This field is used to identify the SOW Coordinators.

Multiple SOW Coordinators can be separated by tilde (~).

If any of the users do not have access to the SOW document's foundational data, the system displays an error message.

Allow Daily Verification

Text

3

no

Valid values are:

  • Yes

  • No

Indicates if daily verification applies to SOW worker.

Track Time Sheets flag must be set to Yes on the SOW.

Company configuration Enable SAP CATS Time Sheet cannot be set to Yes on the Statement of Work.

If a value is not entered, the field will default to No.

Can Supplier change the Rate from Rate Grids

Text

19

Conditional

Valid values are:

  • Can Reduce/Increase

  • Can Reduce

  • None

Indicates whether the supplier can reduce and/or increase the rate from the rate grids.

The company configurations Statement of Work and Use Rate Grid for SOW Workers on Statement of Work must be enabled.

If this field is left blank, the default value is Can Reduce.

Classic SOW Templates and SOWs created from Classic SOW Templates will always have a value of Can Reduce.

Supplier Chat Respond By Date

Date

Conditional

Chat cut-off date for an SOW bid.

This field is applicable if SOW Type flag Use to create SOW Bid? is set to Yes and not hidden on custom SOW Types.

Supplier Chat Respond By Date Time

Time

Conditional

Chat cut-off time for an SOW bid.

This field is applicable if SOW Type flag Use to create SOW Bid? is set to Yes and not hidden on custom SOW Types.

SOW Bid Respond By Date

Date

Conditional

SOW bid respond by date.

This field is only required when the Enforce Bid Respond By Date = Yes on the SOW Template.

SOW Bid Respond By Time

Time

No

SOW bid respond by time.

Please note that

[c] Custom Field1

Dependent on custom field configuration.

Yes, if the custom field is mandatory without a default value and is not a linked custom field.

Dependent on custom field configuration.

Any custom field associated with the SOW Shell. The custom field name should be prefixed with ‘[c]’.

When Custom Field Type = Segmented Pick List and the Autopopulate Segment rule on the Pick List = Yes, if a segment value is left blank on the upload, the value is auto populated on the document if there is only one possible value based on the previous segment values. If there is more than one possible value, an error message displays.

If left blank, keep the existing value.

If this field is defaulted and locked by the contract, then the value in the file will be ignored.

If statement of work uses a contract, the values will default from the contract.

If field was already on a statement of work, the statement of work value will default.

If field was picked up by the edit, then contract's value will default.

Unique Identifier

  • Statement of Work ID field

Assumptions/Tips

  • This connector will only update SOW shells in Draft, Declined, Pending Buyer Review or Rejected status.

  • If the collaborator specified on the SOW clauses was same as the previous SOW owner (owner before the upload), then changing of owner through the upload will be updated on the Clauses collaborator as well. If the collaborator was some other user, and not same as the previous owner (owner before the upload), that user will be retained as the collaborator on the clauses.

  • 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 editing MSOW:

    • For the Prevent: all MSOW Budgets setting of the SOW Template rule, the following fields will be optional, and, if left blank, there will be no change to the existing value on the MSOW:

      • Maximum Schedule Budget

      • Maximum Event Budget

      • Maximum Fee Budget

      • Maximum Worker Budget

    • For the Prevent: Maximum Budget only and the No Restriction settings of the SOW Template rule, the system will ignore the above budget fields if a value is entered because the fields do not apply in these scenarios.

  • If editing CSOW, the system will ignore the following fields because these budgets are not collected on CSOWs:

    • Maximum Schedule Budget

    • Maximum Event Budget

    • Maximum Fee Budget

    • Maximum Worker Budget

  • For user entered amounts, a validation has to happen on the upload to ensure that the value entered is a whole number for those currencies requiring the precision to be zero decimals.

  • If the custom field is configured for SOW Bid Only, an error will occur since this upload supports normal SOW custom fields only.

  • Regarding the SOW Coordinator field:

    If the buyer has an SOW Coordinators custom lookup defined: The custom lookup will trigger upon SOW document creation. If the user enters in a username in the 'SOW Coordinators' column, the application will add the SOW Coordinators as per the configured custom lookup and add the user(s) entered in the 'SOW Coordinators' column as SOW Coordinators for the SOW.

    If the buyer does not have an SOW Coordinators custom lookup defined: The username entered for the SOW Coordinator field will apply to the SOW only. If the 'SOW Coordinators' column is left blank, there will be no impact to the SOW. If multiple SOW Coordinators are to be entered via the upload, their usernames will need to be delimited by tilde (~) symbol. If multiple SOW Coordinators are entered on the upload and if any of the usernames are invalid or the user does not have access to the SOW document, the entire record will fail.

  • This can be used to update a CSOW's Maximum Budget, and the Maximum Budget will be converted into the MSOW's currency and validated.

  • This upload cannot be used with a statement of work that uses the Fieldglass Talent Network (FTN) SOW Type.

  • If Creation Type = Integration, this upload cannot be used.

  • Regarding leading and dependent custom fields:

    When leading and dependent custom fields have been set up and a buyer downloads a blank upload template for this connector from the user interface, leading and dependent custom fields are automatically added as individual columns.

    The system reads the value of the leading custom field and validates the first dependent custom field. This process continues for all dependent custom fields in the defined sequence until it is completed.