Rate Grid Download

This integration downloads 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

Version Type

1.0

Format

CSV

Prerequisites

Company plug-ins must be turned on for Integration – Rate Grid Download.

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

Predecessors

Rate

Rate Group

Rate Grid

Related Connectors

Rate Code Upload

Rate Group Upload

Rate Group Detail Upload

Rate Grid Detail Upload

Rate Grid Upload

Triggering Events

All rate grids are eligible to be downloaded.

File Formatting

Detail

Field Header Name

Data Type

Length

Enabled by Default?

Value(s)/Format

Description/Use/Field Rules

Modification Type

Char

1

Yes

Valid values:

  • A

  • U

  • D

  • Blank (no value)

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

Name of the Rate Grid.

Description

Text

500

No

 

Optional description of the Rate Grid.

MSP Code

Text

6

No

Valid MSP Supplier Code for buyer.

Indicates if specific MSP Supplier associated to rate grid.

Unique Identifier

  • Rate Grid Code field