Supplier Update Upload

This integration uploads supplier updates.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

API-A-V1.0

Format

CSV

Prerequisites

Company Details setting must be turned on for Integration – Supplier Update Upload.

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

Predecessors

Supplier(s)

Related Connectors

Supplier Onboarding Upload

Non Transactional Supplier Upload

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. Supplier Update Upload
Send Notification? No Determines whether normal notifications workflow should be followed.

This flag is used to control sending notifications to users. The valid values are:

  • True: a notification will be sent.

  • False: a notification won't 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 in the file.

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.

 
Suppress Owner Validation No Determines if error issued if owner is invalid

Determines whether an error or just a warning should be issued for invalid owner usernames.

The valid values are:

  • True: the owner will be set to Company Contact Person. If the entry for the Owner is invalid, a warning message appears.

  • False: the record will create an error and be rejected.

If this field is not included in the header, the default value will be 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

Field Header Name

Data Type

Length

Required?

Value(s)/Format

Description/Use/Field Rules

Supplier Code Text 6 Yes Valid SAP Fieldglass Supplier Code for buyer SAP Fieldglass Supplier code to determine which supplier information needs to be edited for the buyer company that is uploading the file.

Supplier Types-Internal

 

Text 3 No

Valid values are:

  • Yes

  • No

Supplier Types selection field. If the user needs to select this supplier type, then the uploaded value should be Yes.

To leave the current value, pass a blank value.

To change the supplier type “Internal” from Yes to No, pass a ‘No’ value.

Supplier Types-Payroll Text 3 No

Valid values are:

  • Yes

  • No

Supplier Types selection field. If the user needs to select this supplier type, then the uploaded value should be Yes.

To leave the current value, pass a blank value.

To change the supplier type “Payroll” from Yes to No, pass a ‘No’ value.

Supplier Types-IC Evaluator Text 3 No

Valid values are:

  • Yes

  • No

Supplier Types selection field. If the user needs to select this supplier type, then the uploaded value should be Yes.

To leave the current value, pass a blank value.

To change the supplier type “IC Evaluator” from Yes to No, pass a ‘No’ value.

Supplier Types-Offshore Text 3 No

Valid values are:

  • Yes

  • No

Supplier Types selection field. If the user needs to select this supplier type, then the uploaded value should be Yes.

To leave the current value, pass a blank value.

To change the supplier type “Offshore” from Yes to No, pass a ‘No’ value.

Supplier Types-Independent Consultant Text 3 No

Valid values are:

  • Yes

  • No

Supplier Types selection field. If the user needs to select this supplier type, then the uploaded value should be Yes.

To leave the current value, pass a blank value.

To change the supplier type “Independent Consultant” from Yes to No, pass a ‘No’ value.

Supplier Types-Recruiter Text 3 No

Valid values are:

  • Yes

  • No

Supplier Types selection field. If the user needs to select this supplier type, then the uploaded value should be Yes.

To leave the current value, pass a blank value.

To change the supplier type ‘Recruiter’ from Yes to No, pass a ‘No’ value.

Allow Supplier to view Statement of Work and Statement of Work Revisions in Pending Approval

 

Text 3 No

Valid values are:

  • Yes

  • No

Flag to allow the supplier to view SOW and SOWR when in Pending Approval status.

Can only be selected with value of ‘Yes’ when ‘Service Provided–Services’ is also selected. If it is not selected, then the flag can’t be activated.

This option is available when the ‘Allow supplier to view SOWs and SOW Revisions in Pending Approval’ company configuration option is enabled.

Allow Worker Data to be shared with a Freelance Management System

Text 3 No

Valid values are:

  • Yes

  • No

When enabled, Freelance Management System (FMS) and SAP Fieldglass can send and receive worker and interview data.

Parent ID Text 50 No   Native field for the buyer company’s parent ID.
Vendor ID Text 50 No   Native field for the buyer company’s external ID.

Consolidated Invoice for Assignment Management

Text

19

Conditional. Both the 'Assignment Management' company configuration and the 'Consolidated Transaction Invoice' company configuration must be enabled.

Valid values are:

  • Created by Supplier

  • Do Not Use

Flag to determine if the buyer will use consolidated invoices for Assignment Management.
Consolidated Invoice for Contingent Text 20 No

Possible Values:

  • Created By Buyer

  • Do Not Use

  • Created by Supplier (appears only when the company config ‘Adjustment groups’ and ‘Does Buyer Have Msp’ are disabled and ‘Source of Buyer Bill To and Supplier Remit-to Address and Tax Information’ is set as ‘Legal Entity’)

Flag to determine if the buyer will use consolidated invoices for contingent workers.

 

Consolidated Invoice for Services Text 20 No

Possible Values:

  • Created By Buyer

  • Do Not Use

  • Created by Supplier (appears only when the company configuration ‘Does Buyer Have Msp’ is disabled and ‘Source of Buyer Bill To and Supplier Remit-to Address and Tax Information’ is set as ‘Legal Entity’).

Flag to determine if the buyer will use consolidated invoices for non-contingent services such as SOW.

Service Provided–Temp Text 3 No

Valid values are:

  • Yes

  • No

Supplier’s ‘Service Provided’ field value.

If value Yes is passed, then the service will be enabled for that supplier.

If value No is passed, then the service will not be selected for that supplier.

If a blank value is passed, then no changes will happen to the service flag.

Only buyer companies that use the contingent functionality will have this flag available.

Service Provided–Hire Text 3 No

Valid values are:

  • Yes

  • No

  • Blank (no value)

Supplier’s ‘Service Provided’ field value

If value Yes is passed, then the service will be enabled for that supplier.

If value No is passed, then the service will not be selected for that supplier.

If a blank value is passed, then no changes will happen to the Hire flag.

Only available if company configuration Enable Direct Hire is enabled.

Service Provided–Services Text 3 No

Valid values are:

  • Yes

  • No

Supplier’s ‘Service Provided’ field value.

If value Yes is passed, then the service will be enabled for that supplier.

If value No is passed, then the service will not be selected for that supplier.

If a blank value is passed, then no changes will happen to the service flag.

Only buyer companies that use the Services functionality will have this flag available.

Service Provided–Profile Worker Text 3 No

Valid values are:

  • Yes

  • No

Supplier’s ‘Service Provided’ field value.

If value Yes is passed, then the service will be enabled for that supplier.

If value No is passed, then the service will not be selected for that supplier.

If a blank value is passed, then no changes will happen to the service flag.

Only available if company configuration ‘Enable Profile Worker’ is enabled.

Service Provided–Assignment Management

Text

3

No

Valid values are:

  • Yes

  • No

Supplier’s ‘Service Provided’ field value.

If value Yes is passed, then the service will be enabled for that supplier.

If value No is passed, then the service will not be selected for that supplier.

If a blank value is passed, then no changes will happen to the service flag.

Only available if company configuration ‘Assignment Management’ is enabled.

MSP Service Fee Text 15 No

Valid values are:

  • Supplier-funded

  • Buyer-funded

This field determines if the MSP service fee will be paid by the supplier or the buyer company.

This field is available to be selected if:

  • The ‘Does Buyer Have MSP’ configuration option is enabled.

  • The supplier is not the MSP company.

Supplier can create Profile Worker Text 3 No

Valid values are:

  • Yes

  • No

Flag to determine if the supplier can create a profile worker for the buyer company.

This flag is only be available when the buyer company has profile worker functionality available and when the ‘Service Provided–Profile Worker’ is set to Yes.

Remittance Type (Contingent) Text 13 No

Valid values are:

  • Direct Pay

  • Indirect Pay

  • None

Flag to determine if the remittance type should be Direct or Indirect Pay or None.

For a non-MSP buyer, the only available value is Direct Pay.

Editable only if the supplier is a MSP.

Remittance Type (Services) Text 13 No

Valid values are:

  • Direct Pay

  • Indirect Pay

  • None

Flag to determine if the remittance type should be Direct or Indirect Pay or None.

For a non-MSP buyer, the only available value is Direct Pay.

Editable only if the supplier is a MSP

Automatically post jobs to the default SAP Fieldglass Candidate Portal Text 3 No

Valid values are:

  • Yes

  • No

Flag to determine if this rule will be enabled

Company configuration ‘Recruiter Toolbox for contingent labor’ must be turned on and supplier ‘Recruiter’ flag must be on.

Automatically mark applicants as finalists Text 3 No

Valid values are:

  • Yes

  • No

Flag to determine if this rule will be enabled

Company configuration ‘Recruiter Toolbox for contingent labor’ must be turned on and supplier ‘Recruiter’ flag must be on.

Send the work order acceptance to the candidate Text 3 No

Valid values are:

  • Yes

  • No

Flag to determine if this rule will be enabled

Company configuration ‘Recruiter Toolbox for contingent labor’ must be turned on and supplier ‘Recruiter’ flag must be on.

Ariba Supplier Network ID Text 50 No   Ariba Network ID
[c] Custom Fields Conditional Conditional*

Format:

[C] Custom Field Name

All the enabled custom fields will be downloaded in this format, unless the column name is customized.

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.

*All mandatory custom fields must be in upload

Unique Identifier

  • Supplier Code field

Configuration Consideration

#

Item

Notes

1

Allow supplier to view SOWs and SOW Revisions in Pending Approval

Needs to be enabled in the company’s configuration for the flag to be updated through the upload.

2

Use Managed service provider

If enabled in the company’s configurations, then the ‘MSP Service Fee’ field can be edited using the upload.

Assumptions/Tips

  • The upload file should contain values for only those fields that must be edited. All other fields that are left blank or are not included in the upload file retain their original values. The only exception is that mandatory custom fields MUST be in the upload file.