ContractLineItemFormulaPricingGridInfos
Retrieves grid factor information for contract line items with formula-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 [ContractLineItemFormulaPricingGridInfos]
SELECT * FROM [ContractLineItemFormulaPricingGridInfos] 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 grid info object in the response collection. | |
| FactorName | String | Factor that this particular grid is representing. | |
| FactorValueType | String | The type of the factor value (String, Boolean, Date).
The allowed values are String, Boolean, Date. | |
| GridName | String | Grid name as loaded from the import. | |
| FactorCellValues | String | List of grid factor and cell values. |