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:

  • True:  If any record errors, the entire upload fails.

  • False:  Only records that are in error fail. Remaining records are committed successfully.

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)
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)

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:

  • A

  • U

  • D

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.