ContractLineItems
Retrieves contract line item information.
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 [ContractLineItems]
SELECT * FROM [ContractLineItems] 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. |
| NumberInCollection [KEY] | Int | Line number within the contract. | |
| ParentLineNumber | Int | Line number of the parent line item for this line item. | |
| ERPLineItemNumber | String | The line item number from the ERP system. | |
| StartDate | Datetime | Start date for this line item. | |
| EndDate | Datetime | End date for this line item. | |
| AccountType | String | This account type of the line item. | |
| AccountCategory | String | Account category name for SAP ERPs. | |
| ItemCategory | String | Item category name for SAP ERPs. | |
| BillingAddress | String | The corporate billing address. | |
| ShipTo | String | Address where ordered items should be shipped. | |
| HideAmount | Boolean | This field value determines whether the Amount value in BPOs is hidden from suppliers in the Ariba Network. | |
| HideUnitPrice | Boolean | This field value determines whether the Unit Price value in BPOs is hidden from suppliers in the Ariba Network. | |
| IsHardReleaseMaximum | Boolean | Specifies whether MaxReleaseAmount/MaxReleaseQuantity is a hard constraint or not. | |
| IsHardReleaseMinimum | Boolean | The minimum quantity for each releases for this line item. | |
| IsObsolete | Boolean | Specifies whether the item is obsolete or not. If item is obsolete, it doesn't get shown on the UI, but is retained. It is also impossible to create new releases on an obsolete item. | |
| IsRecurring | Boolean | Indicates whether the review period recurs at a specified frequency within the date range specified by contract StartDate and EndDate. | |
| CompoundPricingTerms | Boolean | Boolean to indicate if the subagreement wants its pricing to be compounded with the parent, this will be visible in the UI based on the parent's pricing term. | |
| RollUpAccumulatorsToParent | Boolean | Indicates if subagreement spend should be rolled up to the parent. | |
| LimitType | String | How the limit is determined (Amount or Quantity).
The allowed values are Amount, Quantity. | |
| Amount | Decimal | Forecasted amount for this line item. For catalog items, this value is automatically populated from the catalog. | |
| AmountCurrencyName | String | Currency name for the line item amount. | |
| AmountCurrencyUniqueName | String | Unique identifier of the currency for the line item amount. | |
| MaxAmount | Decimal | Maximum amount for releases against this line item. | |
| MaxAmountCurrencyName | String | Currency name for the maximum amount. | |
| MaxAmountCurrencyUniqueName | String | Unique identifier of the currency for the maximum amount. | |
| MaxAmountTolerancePercent | Decimal | Tolerance percentage above maximum amount before moving to closed state. | |
| MinAmount | Decimal | Minimum amount committed for this line item. | |
| MinAmountCurrencyName | String | Currency name for the minimum amount. | |
| MinAmountCurrencyUniqueName | String | Unique identifier of the currency for the minimum amount. | |
| MaxReleaseAmount | Decimal | Maximum amount per release for this line item. | |
| MaxReleaseAmountCurrencyName | String | Currency name for the maximum release amount. | |
| MaxReleaseAmountCurrencyUniqueName | String | Unique identifier of the currency for the maximum release amount. | |
| MinReleaseAmount | Decimal | Minimum amount per release for this line item. | |
| MinReleaseAmountCurrencyName | String | Currency name for the minimum release amount. | |
| MinReleaseAmountCurrencyUniqueName | String | Unique identifier of the currency for the minimum release amount. | |
| ExpectedValueAmount | Decimal | Expected cost for SAP service line items. | |
| ExpectedValueCurrencyName | String | Currency name for the expected value. | |
| ExpectedValueCurrencyUniqueName | String | Unique identifier of the currency for the expected value. | |
| OverallLimitAmount | Decimal | Maximum amount for SAP service line items. | |
| OverallLimitCurrencyName | String | Currency name for the overall limit. | |
| OverallLimitCurrencyUniqueName | String | Unique identifier of the currency for the overall limit. | |
| MaxQuantity | Decimal | Maximum cumulative quantity for all releases of this line item. | |
| MaxQuantityTolerancePercent | Decimal | Tolerance percentage above maximum quantity. | |
| MinQuantity | Decimal | Minimum cumulative quantity for all releases of this line item. | |
| MaxReleaseQuantity | Decimal | Maximum quantity per release for this line item. | |
| MinReleaseQuantity | Decimal | Minimum quantity per release for this line item. | |
| MaxReleaseTolerancePercent | Decimal | Maximum tolerance percentage per release. | |
| CatalogSubscription | String | Catalog subscription name for retrieving catalog subscription. | |
| CommodityCodeName | String | Name of the commodity code for this line item. | |
| CommodityCodeUniqueName | String | Unique identifier of the commodity code for this line item. | |
| CommodityCodeDomain | String | Domain value for the commodity code. | |
| LineTypeName | String | Name of the line type. | |
| LineTypeUniqueName | String | Unique identifier of the line type. | |
| LineTypeCategory | Int | Category of the line type. | |
| Description | String | Description text of the product. | |
| DescriptionClassificationCodeAux | String | Classification code auxiliary for the product description. | |
| DescriptionCommonCommodityCodeName | String | Name of the common commodity code. | |
| DescriptionCommonCommodityCodeUniqueName | String | Unique identifier of the common commodity code. | |
| DescriptionCommonCommodityCodeDomain | String | Domain of the common commodity code. | |
| DescriptionContractPriceAmount | Decimal | Contract price amount for the product. | |
| DescriptionContractPriceCurrencyName | String | Currency name for the contract price. | |
| DescriptionContractPriceCurrencyUniqueName | String | Unique identifier of the currency for the contract price. | |
| DescriptionCustomPriceAmount | Decimal | Custom catalog price amount for the product. | |
| DescriptionCustomPriceCurrencyName | String | Currency name for the custom price. | |
| DescriptionCustomPriceCurrencyUniqueName | String | Unique identifier of the currency for the custom price. | |
| DescriptionIndexContractPriceAmount | Decimal | Index contract price amount for the product. | |
| DescriptionIndexContractPriceCurrencyName | String | Currency name for the index contract price. | |
| DescriptionIndexContractPriceCurrencyUniqueName | String | Unique identifier of the currency for the index contract price. | |
| DescriptionLanguage | String | Language for the product description. | |
| DescriptionLeadTime | Int | Lead time for the product. | |
| DescriptionManName | String | Manufacturer name for the product. | |
| DescriptionManPartNumber | String | Manufacturer part number for the product. | |
| DescriptionManURL | String | Manufacturer URL for the product. | |
| DescriptionNonContractPriceAmount | Decimal | Non-contract price amount for the product. | |
| DescriptionNonContractPriceCurrencyName | String | Currency name for the non-contract price. | |
| DescriptionNonContractPriceCurrencyUniqueName | String | Unique identifier of the currency for the non-contract price. | |
| DescriptionPriceAmount | Decimal | Catalog price amount for the product. | |
| DescriptionPriceCurrencyName | String | Currency name for the catalog price. | |
| DescriptionPriceCurrencyUniqueName | String | Unique identifier of the currency for the catalog price. | |
| DescriptionShortName | String | Short description of the product. | |
| DescriptionSupplierPartAuxiliaryId | String | Supplier part auxiliary ID for the product. | |
| DescriptionSupplierPartNumber | String | Supplier part number for the product. | |
| DescriptionSupplierURL | String | Supplier URL for the product. | |
| DescriptionUnitOfMeasureName | String | Name of the unit of measure. | |
| DescriptionUnitOfMeasureUniqueName | String | Unique identifier of the unit of measure. | |
| DescriptionCommonSupplierName | String | Name of the common supplier. | |
| DescriptionCommonSupplierSystemId | String | System ID of the common supplier. | |
| MilestoneNotificationDays | Int | Days to notify before completion. | |
| MilestoneSupplierContact | String | Supplier contact that the user should contact to verify the milestone completion. | |
| MilestoneTitle | String | The title of this milestone. | |
| MilestoneVerifierGroup | String | Group type verifier field. | |
| MilestoneVerifierUserName | String | Name of the verifier user. | |
| MilestoneVerifierUserUniqueName | String | Unique identifier of the verifier user. | |
| MilestoneVerifierUserPasswordAdapter | String | Password adapter of the verifier user. | |
| AccountingsSplitAccountings | String | Split accounting information for this line item. | |
| PricingInfoPricingTermsType | String | Pricing structure type (DiscountedPrice, DiscountedPercent, etc.). | |
| PricingInfoDiscountedPriceAmount | Decimal | Amount for this term. | |
| PricingInfoDiscountedPriceCurrencyName | String | Currency name for the term amount. | |
| PricingInfoDiscountedPriceCurrencyUniqueName | String | Unique identifier of the currency for the term amount. | |
| PricingInfoDiscountPercent | Decimal | Discount percentage applied to the base price. | |
| TierPricingInfoPricingTermsType | String | Tier-based pricing structure type (TierBasedPricingTerms). | |
| TierPricingInfoTierType | String | Tier basis for pricing calculation (Amount, Quantity). | |
| TierPricingInfoTierValueType | String | Type of tier value calculation (Price, Percent). | |
| TierPricingInfoIsTierPricingCumulative | String | Whether tier pricing applies cumulatively across tiers (Yes/No). | |
| TierPricingInfoAmountCurrencyName | String | Currency name for the term amounts. | |
| TierPricingInfoAmountCurrencyUniqueName | String | Unique identifier of the currency for the term amount. | |
| TierPricingInfoTieredPricingSteps | String | Pricing steps with TierValue and MinTierValue thresholds. | |
| TermPricingInfoPricingTermsType | String | Term-based pricing structure type (TermBasedPricingTerms). | |
| TermPricingInfoPricingTiers | String | Time-period pricing with StartDate and discount/price values. | |
| FormulaPricingInfoPricingTermsType | String | Formula-based pricing structure type. | |
| FormulaPricingInfoFormula | String | Mathematical formula string for calculating prices. | |
| FormulaPricingInfoGridInfos | String | Grid factor objects containing variables and values for formula calculation. | |
| AdvancedPricingInfoPricingTermsType | String | Pricing terms type for advanced pricing structures. | |
| AdvancedPricingInfoPricingTiers | String | Time-based pricing tiers with tier steps, dates, and ship-to information. | |
| RangePricingInfoPricingTermsType | String | Pricing terms type for range-based pricing structures. | |
| RangePricingInfoRangePricingTiers | String | Pricing tiers with minimum and maximum price ranges per period. |