Rate Grid Upload
This integration uploads sets of rate grid codes.
Rates 2.0 does not support Rate Grids. Once rate grids have been established, rate grid details can be uploaded to associate suppliers and sites to rate groups. Rate grids are displayed on job posting templates.
Connector Overview
|
Component |
Detail |
|---|---|
|
Company Type |
Buyer MSP Administrator |
|
Version Type |
API-V1.0 API-A-V1.0 |
|
Format |
CSV |
|
Prerequisites |
Company plug-ins must be turned on for Integration – Rate Grid Upload. User role permission must be turned on for Upload Data and Download Data. |
|
Predecessors |
N/A |
|
Related Connectors |
Rate Code Upload Rate Group Upload Rate Group Detail Upload Rate Grid Detail 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. |
Rate Grid Upload |
|
Transaction |
No |
Only applicable for the API-V1.0 version. Transaction type |
Transaction type. The valid type names are:
If this field is not included in the header, the default value will be True. Only applicable to the API version. |
|
|
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)
|
|
|
MSP |
Conditional |
Only applicable if buyer has multiple MSP suppliers. |
Valid MSP Supplier code. Only one MSP code is allowed to be entered. |
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 |
|---|---|---|---|---|---|
|
Modification Type |
Char |
1 |
Yes |
Valid values:
|
Action to be performed: A = Add U = Update D = Delete If this field is blank, it will be processed as an Add. |
|
Rate Grid Code |
Text |
80 |
Yes |
Unique Code to be assigned to be the Rate Grid. |
|
|
Name |
Text |
80 |
Yes, for Adds only. |
Name of the Rate Grid. |
|
|
Description |
Text |
500 |
No |
Optional description of the Rate Grid. |
|
|
MSP Code |
Text |
6 |
Conditional |
Valid MSP supplier code. |
Indicates if rate grid applies to MSP. Only applicable if buyer has multiple MSP suppliers. If left blank or missing, the file header ‘MSP’ will be used. If both the file header and column are specified with MSP values, they must match. |
Unique Identifier
-
Rate Grid Code field
Configuration Considerations
|
# |
Item |
Notes |
|---|---|---|
|
1 |
Rate Grid Name |
It is important to create a meaningful naming convention for Rate Grids. Although they may rarely be used by the standard User population, they will need to be associated to different objects by SAP Fieldglass Administrators and consistent and descriptive naming will assist in these tasks. |