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:
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) |
|
| 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. |
|
| 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:
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
Flag to determine if the buyer will use consolidated invoices for Assignment Management. |
| Consolidated Invoice for Contingent | Text | 20 | No |
Possible Values:
|
Flag to determine if the buyer will use consolidated invoices for contingent workers.
|
| Consolidated Invoice for Services | Text | 20 | No |
Possible Values:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
| Supplier can create Profile Worker | Text | 3 | No |
Valid values are:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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.