ContractRequestLineItemRangePricingTiers
Retrieves range pricing tiers for contract request line items with minimum and maximum price ranges per period.
View-Specific Information
Select
The connector uses the SAP Ariba API to process WHERE clause conditions that are built with the following column and operators:
- ContractRequestUniqueName supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [ContractRequestLineItemRangePricingTiers]
SELECT * FROM [ContractRequestLineItemRangePricingTiers] WHERE [ContractRequestUniqueName] = 'CR10'
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | Description |
| ContractRequestUniqueName [KEY] | String |
ContractRequests.UniqueName | The unique identifier of the contract request that contains these line items. |
| LineItemNumberInCollection [KEY] | Int |
ContractRequestLineItems.NumberInCollection | Line number within the contract request. |
| NumberInCollection [KEY] | Int | Position of the pricing tier object in the response collection. | |
| StartDate | Datetime | Start date for this range pricing tier period. | |
| EndDate | Datetime | End date for this range pricing tier period. | |
| RangeTierType | String | Type of range tier (Price, Percent).
The allowed values are Price, Percent. | |
| RangeFactor | Decimal | Range factor for price calculation. | |
| MinimumPriceAmount | Decimal | Minimum price amount for this range tier. | |
| MinimumPriceCurrencyName | String | Currency name for the minimum price. | |
| MinimumPriceCurrencyUniqueName | String | Unique identifier of the currency for the minimum price. | |
| MaximumPriceAmount | Decimal | Maximum price amount for this range tier. | |
| MaximumPriceCurrencyName | String | Currency name for the maximum price. | |
| MaximumPriceCurrencyUniqueName | String | Unique identifier of the currency for the maximum price. |