SSIS Components for SAP Ariba Procurement

Build 26.0.9655

InvoiceLineItems

List line item details for invoices.

View-Specific Information

Select

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

  • ApprovableId supports the '=,IN' comparison operators.

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

SELECT * FROM [InvoiceLineItems]
SELECT * FROM [InvoiceLineItems] WHERE [ApprovableId] = 'Val1'

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

Columns

Name Type References Description
ApprovableId [KEY] String

Invoices.ApprovableId

Unique identifier of the parent invoice document.
NumberInCollection [KEY] Int The position index of this line item.
ERPLineItemNumber String The line item identifier recognized in the backend ERP system.
InvoiceLineNumber Int The physical line number as it appears on the supplier's actual invoice.
OrderLineNumber Int The line number this invoice item maps to on the original Purchase Order.
OrderUniqueName String The system identifier for the associated Purchase Order document.
OrderLineItemNumberInCollection Int The corresponding line index on the original Purchase Order.
MasterAgreementUniqueName String The system identifier for the associated Master Agreement document.
MALineItemNumberInCollection Int The corresponding line index on the Master Agreement.
SupplierOrderInfoOrderNumber String The Purchase Order number associated with this line.
SupplierOrderInfoMANumber String The Master Agreement number associated with this line.
SupplierOrderInfoReceiptNumber String The associated receipt number for the goods or services.
Category Int System category integer code classifying the nature of the line item.
LineTypeUniqueName String The specific classification code of the line.
CommodityCodeUniqueName String The system identifier or code for the associated commodity.
Carrier String The name of the shipping carrier used for delivery.
CarrierMethod String The specific shipping or transport method used by the carrier.
DeliverTo String The intended individual or location receiving the goods or services.
ReferenceDate Datetime A reference date associated with the line item's pricing or delivery schedule.
ServicePeriodPeriod String The frequency or type of the service period .
ServicePeriodFromDate Datetime The start date of the service period.
ServicePeriodToDate Datetime The end date of the service period.
SupplierUniqueName String The internal system identifier for the supplier.
SupplierName String The display name of the supplier.
SupplierLocationName String Name associated with the supplier's specific location.
SupplierLocationUniqueName String System identifier for the supplier's location.
SupplierLocationLines String Street address lines of the supplier's location.
SupplierLocationPhone String Phone number of the supplier's location.
SupplierLocationFax String Fax number of the supplier's location.
SupplierLocationCity String City of the supplier's location.
SupplierLocationState String State or province code of the supplier's location.
SupplierLocationPostalCode String Postal code of the supplier's location.
SupplierLocationCountryUniqueName String ISO country code of the supplier's location.
ShipFromName String Name of the facility or entity the goods shipped from.
ShipFromUniqueName String System identifier for the origin shipping location.
ShipFromLines String Street address lines for the origin shipping location.
ShipFromPhone String Phone number at the origin shipping location.
ShipFromFax String Fax number at the origin shipping location.
ShipFromCity String City the goods shipped from.
ShipFromState String State or province code the goods shipped from.
ShipFromPostalCode String Postal code of the origin shipping location.
ShipFromCountryUniqueName String ISO country code the goods shipped from.
ShipToName String Name of the facility or entity receiving the goods.
ShipToUniqueName String System identifier for the destination location.
ShipToLines String Street address lines for the destination.
ShipToPhone String Phone number at the destination.
ShipToFax String Fax number at the destination.
ShipToCity String City of the destination.
ShipToState String State or province code of the destination.
ShipToPostalCode String Postal code of the destination.
ShipToCountryUniqueName String ISO country code of the destination.
BillingAddressName String Name of the company or entity at the billing address.
BillingAddressUniqueName String The system unique name/ID of the billing address.
BillingAddressLines String Street address lines for the billing location.
BillingAddressFax String Fax number for the billing address.
BillingAddressPhone String Phone number for the billing address.
BillingAddressCity String City of the billing address.
BillingAddressState String State or province code for the billing address.
BillingAddressPostalCode String Postal or ZIP code for the billing address.
BillingAddressCountryUniqueName String ISO country code for the billing address.
DescriptionLineItemNumberInCollection Int The collection index of the item being described.
DescriptionLineItemInvoiceLineNumber Int The physical invoice line number corresponding to this description.
Description String The primary name or brief description of the item, tax, or charge.
DescriptionShortName String A truncated or short version of the item's name.
DescriptionExtendedDescription String Detailed, extended text description of the line item.
DescriptionSupplierPartNumber String The specific part number or SKU assigned by the supplier.
DescriptionSupplierPartAuxiliaryId String Auxiliary identifier or secondary part number provided by the supplier.
DescriptionSupplierUrl String The URL provided by the supplier for the item details or image.
DescriptionItemNumber String The internal company item number or SKU.
DescriptionLanguage String The language code used for the item description.
DescriptionQueryId String Identifier for an associated query or internal search.
DescriptionExtAttributesBitMask Int Bitmask value defining extended description attributes.
DescriptionLeadTime Int The expected delivery lead time, typically in days.
DescriptionPriceBasisQuantityDesc String Description of the price basis quantity.
DescriptionConversionFactor Decimal The conversion factor for pricing.
DescriptionPriceBasisQuantity Decimal The quantity basis for pricing.
DescriptionPriceBasisQuantityUOMUniqueName String The unit of measure for the price basis quantity.
DescriptionCommonCommodityCodeUniqueName String The UNSPSC or system identifier for the commodity code.
DescriptionCommonCommodityCodeName String The human-readable name of the commodity code.
DescriptionUnitOfMeasureUniqueName String The Unit of Measure code.
DescriptionPriceAmountInReportingCurrency Decimal The unit price expressed in the system's reporting currency.
DescriptionPriceApproxAmountInBaseCurrency Decimal The approximate unit price expressed in the system's base currency.
DescriptionPriceAmount Decimal The actual unit price amount in the transactional currency.
DescriptionPriceConversionDate Datetime The date used to determine the exchange rate for the unit price.
DescriptionPriceCurrencyUniqueName String The ISO currency code for the unit price.
DescriptionCustomPriceAmountInReportingCurrency Decimal The custom negotiated price in the reporting currency.
DescriptionCustomPriceApproxAmountInBaseCurrency Decimal The approximate custom negotiated price in the base currency.
DescriptionCustomPriceAmount Decimal The custom negotiated price in the transactional currency.
DescriptionCustomPriceConversionDate Datetime The date used for currency conversion on the custom price.
DescriptionCustomPriceCurrencyUniqueName String The ISO currency code for the custom price.
Quantity Decimal The invoiced quantity for this specific line item.
NumberShipped Decimal The quantity of the item that has been shipped by the supplier.
NumberConfirmedAccepted Decimal The quantity of the item confirmed as accepted without changes.
NumberConfirmedAcceptedWithChanges Decimal The quantity of the item confirmed as accepted but with modifications.
NumberConfirmedSubstituted Decimal The quantity of the item that was substituted with a different product.
NumberConfirmedRejected Decimal The quantity of the item confirmed as rejected.
NumberConfirmedBackOrdered Decimal The quantity of the item currently on backorder.
IsAdHoc Bool Indicates if the line item is an ad-hoc (non-catalog) purchase.
IsRecurring Bool Indicates if this is a recurring scheduled charge.
GRBasedInvoice Bool Indicates if this invoice line requires a matching Goods Receipt.
BoughtFromPreferredSupplier Bool Indicates if the item was purchased from a designated preferred supplier.
IsPriceModifiedByUser Bool Indicates if the unit price was manually modified by a user during reconciliation.
AmountInReportingCurrency Decimal The total line amount in the reporting currency.
AmountApproxAmountInBaseCurrency Decimal The approximate total line amount in the base currency.
Amount Decimal The total line amount in the transactional currency.
AmountConversionDate Datetime The date used for currency conversion on the line total.
AmountCurrencyUniqueName String The ISO currency code for the line total.
DiscountAmountInReportingCurrency Decimal The applied discount amount in the reporting currency.
DiscountAmountApproxAmountInBaseCurrency Decimal The approximate applied discount amount in the base currency.
DiscountAmount Decimal The applied discount amount in the transactional currency.
DiscountAmountConversionDate Datetime The date used for currency conversion on the discount amount.
DiscountAmountCurrencyUniqueName String The ISO currency code for the discount amount.
OriginalPriceAmountInReportingCurrency Decimal The original, unmodified price of the item in the reporting currency.
OriginalPriceApproxAmountInBaseCurrency Decimal The approximate original, unmodified price of the item in the base currency.
OriginalPriceAmount Decimal The original, unmodified price of the item in the transactional currency.
OriginalPriceConversionDate Datetime The date used for currency conversion on the original price.
OriginalPriceCurrencyUniqueName String The ISO currency code for the original item price.
BasePriceAmountInReportingCurrency Decimal The base catalog price of the item in the reporting currency.
BasePriceApproxAmountInBaseCurrency Decimal The approximate base catalog price in the base currency.
BasePriceAmount Decimal The base catalog price of the item in the transactional currency.
BasePriceConversionDate Datetime The date used for currency conversion on the base price.
BasePriceCurrencyUniqueName String The ISO currency code for the base catalog price.
TaxAmountInReportingCurrency Decimal The cumulative tax amount in the reporting currency.
TaxAmountApproxAmountInBaseCurrency Decimal The approximate cumulative tax amount in the base currency.
TaxAmount Decimal The cumulative tax amount in the transactional currency.
TaxAmountConversionDate Datetime The date used for currency conversion on the cumulative tax amount.
TaxAmountCurrencyUniqueName String The ISO currency code for the cumulative tax amount.
ExpectedTaxTaxTypeUniqueName String The specific unique name or code of the expected tax type.
ExpectedTaxIsAccrual Bool Indicates whether the expected tax is an accrued/use tax.
ExpectedTaxTaxRate Decimal The expected or standard tax rate percentage.
TaxDetailDescription String Description of the applied tax.
TaxDetailFormulaString String The mathematical formula string used to calculate the tax.
TaxDetailTaxLocation String The geographic location or jurisdiction applicable for the tax calculation.
TaxDetailExemptDetail String Details or codes explaining why the line item is exempt from this tax.
TaxDetailCategory String The classification of the tax.
TaxDetailPurpose String The intended purpose or classification code of the tax.
TaxDetailTriangularTransactionLawReference String The specific legal reference or statute justifying the triangular transaction.
TaxDetailIsDeductible Bool Indicates whether the applied tax is deductible.
TaxDetailIsTriangularTransaction Bool Indicates if this transaction is considered a triangular trade for tax purposes.
TaxDetailPercent Decimal The applied tax percentage rate.
TaxDetailPerUnit Decimal A fixed tax amount applied per individual unit of quantity.
TaxDetailAbatementPercent Decimal The percentage of tax abatement applied to the line.
TaxDetailPaymentDate Datetime The date when the tax liability was paid or is scheduled to be paid.
TaxDetailTaxPointDate Datetime The precise date when the tax liability arises (tax point).
TaxDetailTaxAmountInReportingCurrency Decimal The calculated tax amount in the reporting currency.
TaxDetailTaxAmountApproxAmountInBaseCurrency Decimal The approximate calculated tax amount in the base currency.
TaxDetailTaxAmount Decimal The calculated tax amount in the transactional currency.
TaxDetailTaxAmountConversionDate Datetime The date used for currency conversion on the tax amount.
TaxDetailTaxAmountCurrencyUniqueName String The ISO currency code for the tax amount.
TaxDetailTaxableAmountInReportingCurrency Decimal The base taxable amount in the reporting currency.
TaxDetailTaxableAmountApproxAmountInBaseCurrency Decimal The approximate base taxable amount in the base currency.
TaxDetailTaxableAmount Decimal The base taxable amount in the transactional currency.
TaxDetailTaxableAmountConversionDate Datetime The date used for currency conversion on the taxable base amount.
TaxDetailTaxableAmountCurrencyUniqueName String The ISO currency code for the taxable base amount.
ChargeAmountInReportingCurrency Decimal The standalone charge amount in the reporting currency.
ChargeAmountApproxAmountInBaseCurrency Decimal The approximate standalone charge amount in the base currency.
ChargeAmount Decimal The standalone charge amount in the transactional currency.
ChargeAmountConversionDate Datetime The date used for currency conversion on the charge amount.
ChargeAmountCurrencyUniqueName String The ISO currency code for the charge amount.
ChargeDetailANChargeDescription String The Ariba Network specific description for this charge.
ChargeDetailANChargeName String The Ariba Network specific name or code for this charge.
ChargeDetailTaxAmountInReportingCurrency Decimal The tax amount applied specifically to this charge in the reporting currency.
ChargeDetailTaxAmountApproxAmountInBaseCurrency Decimal The approximate tax amount applied to this charge in the base currency.
ChargeDetailTaxAmount Decimal The tax amount applied specifically to this charge in the transactional currency.
ChargeDetailTaxAmountConversionDate Datetime The date used for currency conversion on the charge tax amount.
ChargeDetailTaxAmountCurrencyUniqueName String The ISO currency code for the charge tax amount.
ChargeDetailChargeAmountInReportingCurrency Decimal The total charge amount in the reporting currency.
ChargeDetailChargeAmountApproxAmountInBaseCurrency Decimal The approximate total charge amount in the base currency.
ChargeDetailChargeAmount Decimal The total charge amount in the transactional currency.
ChargeDetailChargeAmountConversionDate Datetime The date used for currency conversion on the total charge amount.
ChargeDetailChargeAmountCurrencyUniqueName String The ISO currency code for the total charge amount.
ChargeDetailChargeTypeUniqueName String The system identifier for the type of charge applied.
SplitAccountings String Account details linked to the line item.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655