SOW Template Download / SOW Template Upload

This integration downloads SOW template information to a file. If any fields need to be corrected in the file, it can be uploaded back into SAP Fieldglass using the upload connector.

This connector is mainly used by internal SAP Fieldglass users.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

Download - 1.0

Upload - API-A-V1.0

Format

CSV

Prerequisites

Company Details Setting must be turned on for Integration –SOW Template Download / SOW Template Upload.

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

Predecessors

Statement of Work Template(s)

Related Connectors

SOW Template Upload

Triggering Events

The connector pulls all active SOW Templates for a particular buyer.

File Formatting

Header

Component

Required?

Definition/Use

Notes

Value

Type

Yes

Upload File Type

If you have a custom connector name for a standard connector, you may use the exact same custom name for the Type header; otherwise, you must use the standard name shown in the Value field.

SOW Template Upload

Send Notification?

No

Determines whether normal Messaging Workflow should be followed.

This flag is used to control sending notifications to users.

Valid values are:

  • True: If value set to True, email will be sent.

  • False: If value is set to False, email will not be sent.

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

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

Determines the number format to be used 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

Determines the date format to be 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.

Comments

No

Upload Comments

Any comment that the client wants to add.

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

Type

Text

17

Yes

Valid values are:

  • Statement of Work

  • Print Services

  • Classic

Type of the template from SOW is created.

Name

Text

100

Yes

Name of the template from which SOW is Created.

Description

Text

20000

Yes

Description of SOW Template

UNSPSC Code

Text

20

No

United Nations Product and Services Code associated with SOW template

Enters Deliverables

Text

18

No

Valid values are;

  • Buyer

  • Buyer and Supplier

  • Supplier

Indicates who enters deliverables associated with SOW template.

Defined By locked on Statement of Work

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if Defined By field is locked on SOW.

Master SOW Template

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SOW template is Master SOW.

Child SOW creation

Text

100

No

Valid values are:

  • Allow when Child SOW budgets exceed Master SOW budget.

  • Prevent when Master SOW Maximum Budget is Exceeded

  • Prevent when Master SOW Maximum Budget, Maximum Characteristics Budget, or Maximum SOW Worker Budget is Exceeded.

Indicates if child SOWs can exceed Master SOW budget

If column is left blank or does not contain a valid value, value will default to 'Allow when Child SOW budgets exceed Master SOW budget'.

If Template is not an MSOW Template, the system ignores this column.

Use to create non-billable Statement of Work

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SOW Template is to be used to create a non-billable SOW.

Use to create SOW Bid

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SOW template can create SOW bid.

Associate all Business Units

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SOW template applies to all business units.

Adjustment Group

Text

100

No

Indicates tax or VAT group (i.e., Adjustment group) associated to SOW Template.

Creator can change Adjustment Group

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if creator of SOW Template can change Tax / VAT group.

Display Spend Allocation Details

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates tax or VAT group (i.e., Adjustment group)Indicates if spend allocation details to be displayed on SOW.

Currency

Text

1000

Yes

Valid SAP Fieldglass Currency code(s)

Example:

  • USD

  • GBP~EUR

Indicates currency associated with SOW Template.

Multiple currencies can be separated by tilde (~).

Clauses

Text

10

Yes

Valid values are:

  • Mandatory

  • Optional

Indicates if clauses is mandatory or optional when the SOW is created through this template.

Clause Section

Text

100

Yes

Indicates section associated with clauses.

Management Events

Text

10

Yes

Valid values are:

  • Mandatory

  • Optional

Indicates if management events is mandatory, optional or not to be used for the SOW created through this template.

Schedules

Text

10

Yes

Valid values are:

  • Mandatory

  • Optional

Indicates if schedules is mandatory or optional when the SOW is created through this template.

Events

Text

10

Yes

Valid values are:

  • Mandatory

  • Optional

Indicates if events is mandatory or optional when the SOW is created through this template.

Fee

Text

10

Yes

Valid values are:

  • Mandatory

  • Optional

Indicates if fee is mandatory or optional when the SOW is created through this template.

SOW Workers

Text

10

Yes

Valid values are:

  • Do Not Use

This field will determine if the Workers are allowed on the SOW.

Disallow approval of items when Maximum Budget is exceeded

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates approval of items will not be allowed if maximum budget exceeded on SOW.

Default value of this flag is No.

Lock 'Disallow approval of items when Maximum Budget is exceeded'

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if disallow approval of items when maximum budget is exceeded is to be locked and cannot be edited on SOW.

Default value of this flag is No.

Disallow Approval of Items When Maximum Budget is Exceeded or Maximum Budget is Exceeded for Cost Center

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates approval of items will not be allowed if maximum budget exceeded on SOW or cost center.

Default value of this flag is No.

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

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates approval of items will not be allowed if maximum budget exceeded on cost center and SOD.

Not applicable if' 'Allow all Cost Centers of the company to be assigned to Workers' flag is enabled.

Mutually exclusive when 'Disallow approval of items when Maximum Budget is exceeded' or 'Disallow approval of items when Maximum Budget is exceeded for Cost Center' is enabled.

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

Auto Respond

Text

3

Yes

Valid values are:

  • Yes

  • No

If the flag is true on template, then the SOW created from this template will go directly to Submitted status instead of Response Pending status, which requires supplier to submit it.

Default value of this flag is No.

Lock ‘Auto Respond'

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if auto respond is to be locked and cannot be edited on SOW.

Default value of this flag is No.

Skip Collaboration

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if collaboration can be skipped on SOW approval.

Default value of this flag is No.

Lock ‘Skip Collaboration’

Text

3

No

Valid values are:

  • Yes

  • No

Determines if skip collaboration is to be locked and cannot be edited on SOW.

Default value of this flag is No.

Auto Calculate Maximum Budget

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates maximum budget should be recalculated

Maximum Budget Entered By defaults to

Text

9

Yes

Valid values are:

  • Yes

  • No

Indicates who enters maximum budget by default.

Add Workers Without Time Sheets for any SOW Worker Role

Text

3

Valid values are:

  • Yes

  • No

Indicates whether SOW workers without time sheets can be added for any SOW worker role.

This field is only applicable if the rule 'Allow Suppliers to disable 'Track Time Sheet' flag on SOW Worker' = Yes.

When Rates 2.0 is enabled, this field doesn't appear.

Allow Suppliers to disable 'Track Time Sheet' flag on SOW Worker

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates supplier can disable "Track Time Sheet" flag.

Site Config Time Sheet - Services, should be enabled.

If field left blank or missing, default is No.

Lock 'Allow Suppliers to disable Track Time Sheet flag on SOW Worker'

Text

3

Conditional

Valid values are:

  • Yes

  • No

Determines if Allow Suppliers to disable "Track Time Sheet" flag on SOW Worker is to be locked and cannot be edited on SOW.

Site Config Time Sheet - Services should be enabled.

If field left blank or missing, default is No.

Suppress Budget Amount from Suppliers

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates supplier cannot enter maximum budget.

Default value of this flag is No.

Lock ‘Suppress Budget Amount from Suppliers’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if suppress budget amount from suppliers is to be locked and cannot be edited on SOW.

Default value of this flag is No.

Enable SOW Headcount Cap

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if headcount cap is enabled on SOW.

Allow Assistance For SOW Creation

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if assistance allowed for SOW creation.

Default value of this flag is No.

Populate statement of work fields using AI

Text

3

No

Valid values are:

  • Yes

  • No

Indicates that SOW Document Extraction can be used to populate statement of work fields using AI.

Default value of this flag is No.

Allow Additional Invoice Adjustment Currency

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if additional invoice tax currency can be added.

Default value of this flag is No.

Suppress SOW Bid Owner, SOW Bid Creator and Line Item Owner from Supplier

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SOW bid fields should be suppressed from supplier.

SOW Revision approval required only when Maximum Budget is increased

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if approval of SOW revision required only if maximum budget exceeded.

Default value of this flag is No.

Lock ‘SOW Revision approval required only when Maximum Budget is increased’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if SOW Revision approval required only when Maximum Budget is increased is to be locked and cannot be edited on SOW.

Default value of this flag is No.

Suppress SOW Revision

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SOW Revision can be suppressed.

Default value of this flag is No.

Allow Supplier to initiate a Statement of Work Revision

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SOW Revision can be initiated by supplier.

Allow Supplier to specify Site on Line Item

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if supplier can specify site on a SOW line item.

Automatically Update SOW Owner Name on Existing SOW Line Items after SOW Revision or Edit

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if SOW characteristics are to be updated when an Owner is updated.

If no value is entered, the default is the value on associated SOW Type.

Company configuration 'SOW owner name updates on existing line items' must be enabled.

If the value selected on the associated SOW Type is locked and is different from the value in the upload file, then the value on the upload is ignored.

Auto Invoice all Characteristics, Time Sheets and Expense Sheets

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SOW characteristics, time sheets, and expense sheets can be auto invoiced.

Expand recurring Line Items prior to SOW Approval

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if recurring SOW line items should be expanded prior to SOW approval

Allow managing of Management Events, Schedules, Events and Fees after Statement of Work is created

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SOW characteristics can be managed after SOW created.

Bypass approvals on Line Items

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SOW line items can bypass approval.

Allow Buyer to edit Line Item Cost Allocation when Buyer adds Line Item to Statement of Work

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if buyer can edit line item cost allocation when line item added to SOW.

Add and Remove Cost Centers while editing Line Item Cost Allocation

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if cost centers can be added and/or removed when editing the line item cost allocation.

Company configuration Cost centers can be added or removed must be enabled, and the SOW Template flag Allow Buyer to edit cost allocation while adding on SOW must be enabled.

This field cannot be used unless 'Allow Buyer to edit Line Item Cost Allocation when Buyer adds Line Item to Statement of Work' is enabled.

Allow Supplier to select Approver for Events, Fee Responses and Schedules

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if supplier can select approver for SOW line items.

Lock ‘Allow Supplier to select Approver for Events, Fee Responses and Schedules’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if 'Allow Supplier to select Approver for Events, Fee Responses, and Schedules' is to be locked and cannot be edited on the SOW.

Allow management of line item cost allocation when marking line items as complete.

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if supplier and resource can manage line item cost allocation when marking line items as complete.

Allow editing of Post PO segments on an SOD during completion of Line Item

Text

3

Conditional

Valid values are:

  • Yes

  • No

Provides ability for supplier to edit post purchase order segment values during completion of line item.

Company configurations Segmented object detail and Segmented object detail based allocation is required must be enabled.

At least one of the three Characteristics (Event, Schedule or Fee) must be enabled.

Field 'Use to create non-billable Statement of Work' must be No.

Prevent Supplier from Responding to Schedules Prior to the Due Date

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if supplier can respond to schedules prior to due date.

Default value of this flag is No.

Can Supplier change the amount prior to invoicing the Schedule

Text

3

Yes

Valid values are:

No

Can Reduce

Can Reduce/Increase

Indicates if supplier can change schedule amount prior to invoicing.

If 'Auto Calculate Maximum Budget' is enabled at the SOW Type or SOW Template, the option 'Can Reduce/Increase' is not selectable.

Lock ‘Can Supplier change the amount prior to invoicing the Schedule’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if can supplier change the amount prior to invoicing the schedule is to be locked and cannot be edited on SOW.

Can Supplier change the amount when marking the Event as complete

Text

3

Yes

Valid values are:

No

Can Reduce

Can Reduce/Increase

Indicates if supplier can change event amount prior to invoicing.

If 'Auto Calculate Maximum Budget' is enabled at the SOW Type or SOW Template, the option 'Can Reduce/Increase' is' not selectable.

Lock ‘Can Supplier change the amount when marking the Event as complete’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if can supplier change the amount when marking the Event as complete is to be locked and cannot be edited on SOW.

Supplier can create multiple Events from a single Event

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if supplier can create multiple events from a single event.

Lock ‘Supplier can create multiple Events from a single Event’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if supplier can create multiple events from a single event is to be locked and cannot be edited on SOW.

Use Hierarchical Events

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if using hierarchical events.

Event Hierarchy Lookup

Text

100

No

Valid values are:

Valid event hierarchy custom lookup name.

The Event Hierarchy Lookup field value from the SOW template.

Allow statements of work to use AI-generated hierarchical events

Text

3

No

Valid values are:

  • Yes

  • No

Indicates that AI-generated hierarchical events can be used to populate statements of work.

Allow rates from the Event Hierarchy lookup to be edited when adding a Standard hierarchical Event to a Statement of Work or SOW bid

Text

18

No

Valid values are:

No

Can reduce

Can reduce/increase

The Use Hierarchical Events rule must be set to Yes for this rule to apply.

When a value is included in this field, it only applies if the Event Hierarchy custom lookup selected when defining hierarchical events does not include the Rate Change Allowed (Standard only) Value option. When the Value option is included on the lookup and the lookup is associated to the statement of work, the application determines if the rate can be edited based on the entry in the column for the row. The value from the custom lookup overrides the value on this rule on the SOW template upload.

Modify cost allocation of individual fees in a fee response

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if fees can have different cost centers.

Statement of Work must be enabled AND either 'Suppliers manage cost allocation when marking line items complete' must be enabled OR one option of 'Approver can change the cost centers and task codes on schedules, fees, and events' is enabled.

Fee Usage must be optional or Mandatory.

Fees must be copied from the Library

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if fees can be copied from library.

Allow use of Fees with SOW Workers

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if fees can be used with SOW Workers.

When this rule is enabled, Fees and SOW Workers can be added to the SOW and the buyer can specify a set of roles for the crew.

Lock ‘Allow use of Fees with SOW Workers’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if allow user of fees with SOW Workers is to be locked and cannot be edited on SOW.

Auto Activate SOW Worker

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if want to auto activate the SOW Worker.

Lock ‘Auto Activate SOW Worker’

Tex

3

Yes

Valid values are:

  • Yes

  • No

Determines if auto activate SOW Worker is to be locked and cannot be edited on SOW.

Auto Register SOW Worker

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if want to auto register SOW Worker.

Lock ‘Auto Register SOW Worker’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if auto register SOW Worker is to be locked and cannot be edited on SOW.

Require Approvals on SOW Workers added during SOW Response and SOW Revision Response

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if approvals on SOW Workers can be added on SOW response and SOW revision response.

Lock ‘Require Approvals on SOW Workers added during SOW Response and SOW Revision Response’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if require approvals on SOW Workers added during SOW Response and SOW Revision Response is to be locked and cannot be edited on SOW.

Use Rate Schedule

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if rate schedule is to be used on SOW.

Disallow Supplier edits to Pay Rate (for Rate Schedules with Coefficients)

Or

Disallow Supplier edits to Pay Rate on SOW Workers

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if supplier can edit pay rate for rate schedules with coefficients.

'Disallow Supplier edits to Pay Rate on SOW Workers' is only visible when Rates 2.0 is enabled.

Enable SAP CATS Time Sheet?

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if SAP CATS system time sheets are to be used with SOW.

Allow all Cost Centers of the company to be assigned to Workers

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if workers should have access to all cost centers belonging to the legal entity of the SOW.

If Rates 2.0 is enabled, and If 'Use Rates on SOW Workers' and 'Allow use of Fees with SOW Workers' are both set to No, the system ignores the contents of this field.

Lock ‘Allow all Cost Centers of the company to be assigned to Workers’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if Allow all Cost Centers of the company to be assigned to Workers is to be locked and cannot be edited on SOW.

Give Workers access to all Task Codes for the Cost Centers

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if workers should have access to all task codes for the Cost centers.

If Rates 2.0 is enabled, and If 'Use Rates on SOW Workers' and 'Allow use of Fees with SOW Workers' are both set to "No", the system ignores the contents of this field.

Lock ‘Give Workers access to all Task Codes for the Cost Centers’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if give workers access to all task codes for the Cost centers is to be locked and cannot be edited on SOW.

Allow Worker to submit Time Sheets

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if workers can submit time sheets.

If Rates 2.0 is enabled, 'Use Rates on SOW Workers' and 'Give Workers access to all Task Codes for the Cost Centers' must both be set to "Yes" in order for this field to be set to "Yes".

Lock ‘Allow Worker to submit Time Sheets’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if allow worker to submit time sheets is to be locked and cannot be edited on SOW.

Issue warning if Hours per Day are exceeded on Time Sheet

Text

3

Yes

Valid values are:

  • Yes

  • No

Will give warning if hours per day are exceeded on time sheet.

If Rates 2.0 is enabled and this field is set to 'Yes' but 'Use Rates on SOW Workers is set to 'No', the system automatically sets this field to 'No'.

Lock ‘Issue warning if Hours per Day are exceeded on Time Sheet’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if issue warning if hours per day are exceeded on time sheets is to be locked and cannot be edited on SOW.

Allow Time Capture in Hundredths of Hours

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if time can be entered in hundredths of hours.

If Rates 2.0 is enabled and this field is set to 'Yes' but 'Use Rates on SOW Workers is set to 'No', the system automatically sets this field to 'No'.

Allow invoicing from approved Time Sheets

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if approved time sheets can be invoiced.

If Rates 2.0 is enabled and this field is set to "Yes" but 'Use Rates on SOW Workers is set to "No", the system automatically sets this field to "No". The 'Allow invoicing from approved Time Sheets' must be set to "Yes" when 'Use Rate Schedules' is enabled.

Lock ‘Allow invoicing from approved Time Sheets’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if Allow invoicing from approved Time Sheets is to be locked and cannot be edited on SOW.

Allow rates on SOW Worker Roles without invoicing

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if rates can be entered for a non-billable SOW worker without invoicing.

Company configuration Use Rate Grid for SOW Workers on Statement of Work must be enabled. The rule 'Use Rate Schedule' must not be enabled. The rule 'Allow Invoicing from Approved Time Sheets' must be set to No.

If this field is left blank or Rate Grid is not enabled, the value will default to No.

If Rates 2.0 is enabled, this field doesn't appear.

Lock allow rates on SOW Worker roles without invoicing

Text

3

No

Valid values are:

  • Yes

  • No

Determines if Allow rates for SOW Worker Roles without invoicing is to be locked and cannot be edited on SOW.

If Rates 2.0 is enabled, this field doesn't appear.

SOW Worker Spend estimation based on number of positions and period

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates that SOW Worker spend estimation is based on number of positions and period.

Company configuration Use Rate Grid for SOW Workers on Statement of Work must be enabled. One of the following rules must be enabled: 'Allow Invoicing from Approved Time Sheets' or 'Allow rates for SOW Worker Roles without invoicing' or 'Use Rate Schedule'.

If Rates 2.0 is enabled, this field doesn't appear.

Give Workers access to all Expense Codes for the Cost Centers

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if workers can enter all expense codes for the cost centers.

Lock ‘Give Workers access to all Expense Codes for the Cost Centers’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if Give Workers access to all Expense Codes for the Cost Centers is to be locked and cannot be edited on SOW.

Allow Deductions to be Submitted on Time Sheet

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if workers can enter deductions on time sheets.

If Rates 2.0 is enabled and this field is set to 'Yes' but 'Use Rates on SOW Workers, is set to 'No', the system automatically sets this field to 'No'.

Lock ‘Allow Deductions to be Submitted on Time Sheet’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if Allow Deductions to be Submitted on Time Sheet is to be locked and cannot be edited on SOW.

Can Supplier change Rate from Rate Grids

Or

Can supplier edit the rate value when defining SOW Worker roles?

Text

19

Conditional

Valid values are:

  • Can Reduce

  • Can Reduce/Increase

  • None

Indicates if supplier can change rate from rate grid.

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

Note - Classic SOW Templates and SOWs created from Classic SOW Templates will always have value 'Can Reduce'.

'Can supplier edit the rate value when defining SOW Worker roles' is only visible when Rates 2.0 is enabled.

If Rates 2.0 is enabled and this field is set to 'Can Reduce' or 'Can Reduce or Increase' but 'Use Rates on SOW Workers' is set to 'No', the system automatically sets this field to 'No'.

Allow invoicing from approved Expense Sheets

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if approved expense sheets can be invoiced.

Lock ‘Allow invoicing from approved Expense Sheets’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if Allow invoicing from approved Expense Sheets is to be locked and cannot be edited on SOW.

Allow addition of Workers during approval

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if workers can be added to SOW during approval.

Allow Supplier to Close SOW Worker

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if supplier can close SOW worker.

Supplier must submit Resume/CV Text 3 Yes

Valid values are:

  • Yes

  • No

Indicates if supplier must submit resume/CV for a SOW worker.

Allow Supplier to define SOW Worker Roles

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if supplier can define SOW worker roles.

If Rates 2.0 is enabled and this field is set to 'Yes' but 'Use Rates on SOW Workers is set to 'No', the system automatically sets this field to 'No'.

Allow changes to Site and Location on the SOW Work Order/Worker

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if changes can be made to site/location on SOW work order/SOW worker.

Allow Supplier to add Multiple Locations

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if supplier can add multiple locations.

Enable at least one sub-configuration for the company configuration Use multiple locations.

Supplier selects SOW worker location from statement of work locations.

Text

3

No

Valid values are:

  • Yes

  • No

Used with Multiple Locations functionality. Indicates if the source of an SOW worker location should come from the statement of work or site associations.

Restrict Site selection to Sites on the SOW.

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates only sites already on SOW can be selected.

Can Supplier Submit Absences

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if supplier can submit absences for SOW workers.

Can Worker Submit Absences

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if workers can submit own absences.

Allow Supplier Review on Time Sheet

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if supplier can review worker timesheets.

If Rates 2.0 is enabled and this field is set to 'Yes' but 'Use Rates on SOW Workers is set to 'No', the system automatically sets this field to 'No'.

Lock ‘Allow Supplier Review on Time Sheet’

Text

3

Yes

Valid values are:

  • Yes

  • No

Determines if Allow Supplier Review on Time Sheet is to be locked and cannot be edited on SOW.

Can edit Worker start date

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if the buyer, supplier, or buyer and supplier can edit the worker start date.

If no value is entered in this field, the value on its associated SOW type is defaulted.

If the value selected on its associated SOW type is locked and is different from the value in the upload file, then the value on the upload is ignored. The value on its associated SOW type is applied.

The company configuration Buyer and supplier can change SOW worker dates without a revision must be enabled for this column to appear on the upload file.

Can shorten Worker end date

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if the buyer, supplier, or buyer and supplier can shorten the SOW worker end date.

Can extend Worker end date

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if buyer, supplier, or buyer and supplier can extend the SOW worker end date.

Automatically Extend SOW Worker End Dates to Match SOW End Date

Text

3

Conditional. The SOW rule Allow Changes to Worker End Dates Without Revision must be enabled.

Valid values are:

  • Yes

  • No

Indicates whether the SOW worker end dates are to be automatically extended to match the SOW end date.

Worker Primary Contact can be changed on the SOW Work Order/Worker

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if worker's SAP primary contact can be changed on SOW work order or SOW worker.

Allow supplier to define payment currency on a SOW bid response

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if the supplier can define payment currency on a SOW bid response. This field is required for SOW bids.

'Add Multiple Supplier Tenants

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if multiple suppliers are allowed on Master SOW.

Company configuration 'Master SOW' must be enabled.

Add Multiple Currencies and Use lookup for Worker Roles, Site and Rates

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if multiple currencies are allowed on Master SOW and use lookup for worker roles, sites, and rates.

Company configuration 'Master SOW' must be enabled.

Add Multiple Currencies and Use lookup for Rates

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if multiple currencies are allowed on Master SOW and use lookup for rates.

Company configuration 'Master SOW' must be enabled.

Disallow Supplier to add SOW Worker until SOW is completely Approved.

Text

3

No

Valid values are:

  • Yes

  • No

When 'SOW Worker' characteristic is not enabled on the SOW and the user enters 'Yes' for this new rule, an error is generated.

Suppress Supplier Name on Bid Response

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if supplier name should be suppressed until SOW approved.

SOW template rule 'Use to create SOW Bid' must = Yes.

Flag Remaining Bid Responses for Rejection

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if SOW Bid owners want to reject unawarded SOW Bid responses.

Enforce Bid Respond By Date

Text

3

Conditional. SOW template rule Use to create SOW Bid must = Yes.

Valid values are:

  • Yes

  • No

Indicates if the supplier can respond to the bid until the bid response date or after.

Allow Multiple SOWs from SOW Bid Response

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if buyers can now create multiple statements of works from a single bid response.

Restrict Response Visibility before Respond By Date for

Text

9

Conditional. SOW template rule 'Enforce Bid Respond By Date' must = Yes.

Valid values are:

  • All Users

  • None

Indicates if bid responses (from suppliers/viewed by buyers) can be made prior to respond by date.

If value =All Users, buyers cannot view responses until the bid response date.

If value = None, buyers can view and reject responses prior to the bid response date. Suppliers can edit and resubmit rejected responses until the bid response date.

The SOW cannot be created from the response until the bid response date.

Suppliers cannot submit responses after the bid response date.

If the value selected on its associated SOW Type is locked and is different from the value in the upload file, then the value on the upload is ignored. The value on its associated SOW Type is applied.

If no value is entered in this field, this field defaults to All Users.

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.

Lock Supplier can change the Rate from Rate Grids

Or

Lock 'Can supplier edit the rate value when defining SOW Worker roles'

Text

3

Yes if 'Can Supplier change the Rate from Rate Grids' entered.

Valid values are:

  • Yes

  • No

Determines if 'Can Supplier change the Rate from Rate Grids' is to be locked and cannot be edited on the SOW.

"Lock 'Can supplier edit the rate value when defining SOW Worker roles" is only visible when Rates 2.0 is enabled.

Allow MSOW Association to SOW Bid Supplier

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if MSOWs can be associated to SOW Bid suppliers.

The SOW Template rule 'Use to create SOW Bid' should be set to Yes. Rules 'Allow supplier to define payment currency on a SOW bid response' and 'Suppress Supplier name on SOW Bid Response' cannot be enabled along with this rule.

Event due date is mandatory

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if event due date is mandatory.

If this field left blank on an Add, it will pick up the value from the SOW Type.

Discounts can be defined on the SOW

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if SOW discounts apply.

If this field is left blank, it defaults to No.

Set Fee response / revision attachments as mandatory

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if attachments are mandatory.

[c] SOW Custom Fields

Dependent on custom field configuration

Dependent on custom field configuration

Format:

[c] Custom Field Name

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

Use Rates on SOW Workers

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if Rates are used on SOW workers.

SOW Workers must be Optional or Mandatory in order to enable this field.

If an invalid value is entered or the SOW Type has enabled the "Hidden?" and/or "Locked" flag on the template the step, the system will default this field according to the SOW Type.

This field is only visible when Rates 2.0 is enabled.

SOW Worker Roles Lookup

Text

100

No

The name of a valid SOW Worker Roles lookup

The name of the SOW Worker Role lookup.

If a Buyer uses multiple MSPs, the lookup must be valid for the SOW Template’s MSP Company.

When 'Use Rate Schedule' is enabled, the selected 'SOW Worker Roles Lookup' can't use 'Rate Category /UOM' as a value.

If the SOW template rule 'Use to create SOW Bid' is enabled, then the lookup entered can only use SOW Worker Role Code and Site Code as values, not Rate Category /UOM.

When "Use Rates on SOW Workers" is set to "No", the system ignores the contents of this field, and no lookup is saved.

This field is only visible when Rates 2.0 is enabled.

Rates Lookup

Text

100

Yes

The name of a valid Rates Lookup with the following Service Type:

  • Services

  • Contingent and Services

The name of the Rates Lookup.

If a Buyer uses multiple MSPs, the lookup must be valid for the SOW Template’s MSP Company.

If 'Use Rates on SOW Workers' is set to "No" the system ignores the contents of this field and no lookup is saved.

If Use Rates Based on Effective Date is set to Yes, the upload fails with an error message if the rates lookup:
  • Does not use Valid On as a key

  • Uses Base Rate Category/UOM as a key

  • Uses Rate Component Group Code as a value

This field is only visible when Rates 2.0 is enabled.

Can buyer edit the rate value when defining SOW Worker roles?

Text

19

No

Valid values are:

  • No

  • Can Reduce

  • Reduce/Increase

Indicates the options the Buyer has for editing the rate value when defining an SOW worker.

If an invalid value is entered or the "Hidden?" and/or "Locked?" flags on the SOW type are enabled, the default is the value on associated SOW Type.

This field is only visible when Rates 2.0 is enabled.

Task Code Lookup

Text

100

No, dependent on the time sheet company configuration.

Valid task code lookup name.

Optional field that can be added by buyers if they want to associate a lookup.

Expense Code Lookup

Text

100

No, dependent on the expense sheet company configuration.

Valid expense code lookup name.

Optional field that can be added by buyers if they want to associate a lookup.

Evaluate SOW Bid Response Wizard

Text

100

No

Valid SOW Bid Response Wizard name.

Optional field that can be added by buyers if they want to associate an Evaluate SOW Bid Response Wizard.

Automatically refresh rates for SOW Worker Roles from lookup

Text

3

No

Valid values are:

  • Yes

  • No

When this rule is enabled, if any key is changed on the Statement of Work, SOW Revision, or SOW Bid Response, the rates for SOW Worker roles will automatically refresh from the lookup. Rates already on SOW Workers won't be impacted.

On Page Validation Custom Lookup

Text

100

No

Valid lookup name for 'On Page Validation with Notifications' custom lookup type.

This field displays if the On Page Validation with Notification lookup was added by the buyer on the job positing template.

Suppress Event Hierarchy tolerance amount from supplier

Text

3

No

Valid values are:

  • Yes

  • No

When this rule is enabled, the tolerance fields are hidden from the supplier.

Use Rates Based on Effective Date

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if multiple rate rows based on different effective start dates should display for a worker on the SOW.

If the SOW Template uses Rates 1.0:
  • This field will be ignored

If the SOW Template uses Rates 2.0:
  • If this field is left blank, the template picks the value from the SOW Type.

  • If the value of the SOW Type is locked or hidden on the template, only that value is used and this field is ignored.

The value will default to No, if:
  • You enter an invalid value

  • SOW Workers is set to Do Not Use

  • Use Rates on SOW Workers is set to No.

The upload fails with an error message if you enter Yes as a value for this field, and any of the following are set to Yes:
  • Discounts can be defined on the SOW

  • Use Rate Schedule

Use Product Group on Hierarchical Events

Text

No

Valid Values are No, Optional, Required.

Default value is No.

Indicates whether Product Group is required on hierarchical events for the SOW. Company configuration "Product Group" must be enabled.

If no value is entered, the default value is No. Automatically set to No if Master SOW Template = Yes or if Use Hierarchical Events = No.

If this rule is hidden or locked on the SOW Type, the value from the SOW Type is applied. If the rule is set to Required and the selected Event Hierarchy Lookup does not use Product Group as a key, the upload fails with the error: "[column name] is set to Required, but the selected Event Hierarchy Lookup does not use Product Group as a Key. Select a new lookup or remove the lookup."

Unique Identifier

  • Name field

Custom Fields

The download file will include custom fields from Statement of Work and Characteristics modules in Fieldglass.

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 Fieldglass against the setup of the connector. If no custom fields are supplied, the download will not include any custom field values.

General Conventions

The download will pull all the records created up to run date. No check is provided over the last run date of the connector.

Assumptions/Tips

It is common practice to run SOW Template Download and immediately upload the downloaded file into another environment with Upload.

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

The field 'Suppress Supplier Name on Bid Response' cannot be Yes if the rule 'Allow Supplier to control Worker rules and create Worker roles' is Yes, or an error is generated.

When the Event Hierarchy Lookup field isn't locked or hidden on the SOW type, no value is added to Event Hierarchy Lookup field on the SOW template. If the field is locked on the SOW type, an error message is displayed indicating that an event hierarchy lookup is required.