ContractLineItemAdvancedPricingTiers
Retrieves advanced pricing tiers for contract line items with complex time-based and location-based 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 [ContractLineItemAdvancedPricingTiers]
SELECT * FROM [ContractLineItemAdvancedPricingTiers] 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. |
| NumberInCollection [KEY] | Int | Position of the pricing tier object in the response collection. | |
| StartDate | Datetime | Start date for this advanced pricing tier period. | |
| EndDate | Datetime | End date for this advanced pricing tier period. | |
| TierType | String | Tier basis for pricing calculation (Amount, Quantity). | |
| TierValueType | String | Type of tier value calculation (Price, Percent). | |
| IsTierPricingCumulative | String | Whether tier pricing applies cumulatively across tiers (Yes/No). | |
| ShipToUniqueName | String | Unique identifier of the ship-to location for this tier. | |
| ShipToName | String | Name of the ship-to location for this tier. | |
| ShipToLine1 | String | Address line 1 of the ship-to location. | |
| ShipToLine2 | String | Address line 2 of the ship-to location. | |
| ShipToLine3 | String | Address line 3 of the ship-to location. | |
| ShipToCity | String | City of the ship-to location. | |
| ShipToState | String | State of the ship-to location. | |
| ShipToPostalCode | String | Postal code of the ship-to location. | |
| ShipToCountryName | String | Country name of the ship-to location. | |
| ShipToCountryUniqueName | String | Country unique identifier of the ship-to location. | |
| ShipToPhone | String | Phone number of the ship-to location. | |
| ShipToFax | String | Fax number of the ship-to location. | |
| TieredPricingSteps | String | Array of tiered pricing steps within this advanced pricing tier. |