ContractLineItemTermPricingTiers

Retrieves term-based pricing tiers for contract line items with time-period pricing.

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 [ContractLineItemTermPricingTiers]
SELECT * FROM [ContractLineItemTermPricingTiers] 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 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.