ContractLineItemRangePricingTiers

Retrieves range pricing tiers for contract line items with minimum and maximum price ranges per period.

View-Specific Information

The connector uses the SAP Ariba API to process WHERE clause conditions that are built with the following column and operators:

For example, the following queries are processed server-side:

SELECT * FROM [ContractLineItemRangePricingTiers]
SELECT * FROM [ContractLineItemRangePricingTiers] WHERE [ContractUniqueName] = 'C10'

The connector processes other filters client-side within the connector.


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