ContractRequestLineItemTermPricingTiers
Retrieves term-based pricing tiers for contract request line items with time-period pricing.
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 [ContractRequestLineItemTermPricingTiers]
SELECT * FROM [ContractRequestLineItemTermPricingTiers] 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 pricing tier period. | |
| DiscountPercent | Decimal | Discount percentage applied during this time period. | |
| DiscountedPriceAmount | Decimal | Discounted price amount for this time period. | |
| DiscountedPriceCurrencyName | String | Currency name for the discounted price. | |
| DiscountedPriceCurrencyUniqueName | String | Unique identifier of the currency for the discounted price. |