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:
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)
|
|
|
Number Format |
No |
Determines the number format to be used in the file. |
The valid values are:
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:
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:
|
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;
|
Indicates who enters deliverables associated with SOW template. |
|
Defined By locked on Statement of Work |
Text |
3 |
Yes |
Valid values are:
|
Indicates if Defined By field is locked on SOW. |
|
Master SOW Template |
Text |
3 |
Yes |
Valid values are:
|
Indicates if SOW template is Master SOW. |
|
Child SOW creation |
Text |
100 |
No |
Valid values are:
|
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:
|
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:
|
Indicates if SOW template can create SOW bid. |
|
Associate all Business Units |
Text |
3 |
Yes |
Valid values are:
|
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:
|
Indicates if creator of SOW Template can change Tax / VAT group. |
|
Display Spend Allocation Details |
Text |
3 |
Yes |
Valid values are:
|
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:
|
Indicates currency associated with SOW Template. Multiple currencies can be separated by tilde (~). |
|
Clauses |
Text |
10 |
Yes |
Valid values are:
|
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:
|
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:
|
Indicates if schedules is mandatory or optional when the SOW is created through this template. |
|
Events |
Text |
10 |
Yes |
Valid values are:
|
Indicates if events is mandatory or optional when the SOW is created through this template. |
|
Fee |
Text |
10 |
Yes |
Valid values are:
|
Indicates if fee is mandatory or optional when the SOW is created through this template. |
|
SOW Workers |
Text |
10 |
Yes |
Valid values are:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
Indicates maximum budget should be recalculated |
|
Maximum Budget Entered By defaults to |
Text |
9 |
Yes |
Valid values are:
|
Indicates who enters maximum budget by default. |
|
Add Workers Without Time Sheets for any SOW Worker Role |
Text |
3 |
Valid values are:
|
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:
|
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:
|
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:
|
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:
|
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:
|
Indicates if headcount cap is enabled on SOW. |
|
Allow Assistance For SOW Creation |
Text |
3 |
Yes |
Valid values are:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
Indicates if SOW Revision can be initiated by supplier. |
|
Allow Supplier to specify Site on Line Item |
Text |
3 |
Yes |
Valid values are:
|
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:
|
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:
|
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:
|
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:
|
Indicates if SOW characteristics can be managed after SOW created. |
|
Bypass approvals on Line Items |
Text |
3 |
Yes |
Valid values are:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
Indicates if fees can be copied from library. |
|
Allow use of Fees with SOW Workers |
Text |
3 |
Yes |
Valid values are:
|
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:
|
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:
|
Indicates if want to auto activate the SOW Worker. |
|
Lock ‘Auto Activate SOW Worker’ |
Tex |
3 |
Yes |
Valid values are:
|
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:
|
Indicates if want to auto register SOW Worker. |
|
Lock ‘Auto Register SOW Worker’ |
Text |
3 |
Yes |
Valid values are:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
Indicates if approved expense sheets can be invoiced. |
|
Lock ‘Allow invoicing from approved Expense Sheets’ |
Text |
3 |
Yes |
Valid values are:
|
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:
|
Indicates if workers can be added to SOW during approval. |
|
Allow Supplier to Close SOW Worker |
Text |
3 |
Yes |
Valid values are:
|
Indicates if supplier can close SOW worker. |
| Supplier must submit Resume/CV | Text | 3 | Yes |
Valid values are:
|
Indicates if supplier must submit resume/CV for a SOW worker. |
|
Allow Supplier to define SOW Worker Roles |
Text |
3 |
Yes |
Valid values are:
|
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:
|
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:
|
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:
|
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:
|
Indicates only sites already on SOW can be selected. |
|
Can Supplier Submit Absences |
Text |
3 |
Yes |
Valid values are:
|
Indicates if supplier can submit absences for SOW workers. |
|
Can Worker Submit Absences |
Text |
3 |
Yes |
Valid values are:
|
Indicates if workers can submit own absences. |
|
Allow Supplier Review on Time Sheet |
Text |
3 |
Yes |
Valid values are:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
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:
|
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:
|
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:
|
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:
|
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:
If the SOW Template uses Rates 2.0:
The value will default to No, if:
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:
|
|
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.