ContractLineItemAdvancedPricingTierSteps
Retrieves tiered pricing steps for contract line items with advanced 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:
- ContractUniqueName supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [ContractLineItemAdvancedPricingTierSteps]
SELECT * FROM [ContractLineItemAdvancedPricingTierSteps] WHERE [ContractUniqueName] = 'C10'
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | Description |
| ContractUniqueName [KEY] | String |
Contracts.UniqueName | The unique identifier of the contract that contains these line items. |
| LineItemNumberInCollection [KEY] | Int |
ContractLineItems.NumberInCollection | Line number within the contract. |
| PricingTierNumberInCollection [KEY] | Int |
ContractLineItemAdvancedPricingTiers.NumberInCollection | Position of the tier object in the response collection. |
| NumberInCollection [KEY] | Int | Position of the pricing step object in the response collection. | |
| MinTierValue | Decimal | Minimum tier value threshold for this pricing step. | |
| TierValue | Decimal | Tier value (price or percentage) for this pricing step. |