Excel Add-In for SAP Ariba Procurement

Build 26.0.9655

Invoices

List invoices.

View-Specific Information

Select

The add-in uses the SAP Ariba API to process WHERE clause conditions that are built with the following columns and operators:

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

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

SELECT * FROM [Invoices]
SELECT * FROM [Invoices] WHERE [ApprovableId] = 'Val1'
SELECT * FROM [Invoices] WHERE [UniqueName] = 'Val1'

The add-in processes other filters client-side within the add-in.

Columns

Name Type References Description
ApprovableId [KEY] String The unique identifier used by the Ariba approval engine to track and route this specific document.
UniqueName String The primary, system-generated identifier for this specific invoice record.
InitialUniqueName String The original, immutable identifier assigned to the document when it was first instantiated, which remains constant even if the document is copied or versioned.
InvoiceNumber String The unique invoice identifier provided by the supplier on the physical or electronic invoice.
UpperCaseInvoiceNumber String The supplier's invoice number converted to uppercase, used by the system for duplicate checking and search indexing.
Name String The human-readable title or name assigned to the invoice document.
Type String The specific Ariba class type of the document.
Category Int A system integer representing the classification or type of the invoice document.
StatusString String The current operational or processing status of the document.
InvoiceStatusString String The specific financial status of the invoice.
InvoiceState String The internal system state of the invoice document lifecycle.
ApprovedState String The current status of the document within the approval workflow.
InvoiceExternalStatusString String The status of the invoice as reported back from an external connected system such as an ERP.
Active Bool Indicates whether the document is active and valid or has been deactivated.
ApprovalRequestsVersion Int The current iteration or version number of the active approval workflow.
PreviousApprovalRequestsVersion Int The version number of the approval request before the most recent modification or workflow restart.
VersionNumber Int The revision number of the invoice document itself.
CreateDate Datetime The timestamp when the invoice record was initially created in the Ariba database.
TimeCreated Datetime The exact system timestamp of when the object was instantiated.
InvoiceDate Datetime The date the invoice was issued by the supplier.
SubmitDate Datetime The timestamp when the user or system officially submitted the invoice into the workflow.
ApprovedDate Datetime The timestamp when the invoice successfully cleared all approval nodes.
ReconciledDate Datetime The timestamp when the invoice successfully matched against receipts and completed the reconciliation process.
ScheduledPaymentDate Datetime The calculated date on which the invoice is scheduled to be paid based on the invoice date and payment terms.
TimeUpdated Datetime The timestamp of the most recent system or user modification to the invoice.
LastModified Datetime The timestamp of the most recent change made to the record.
InvoiceOrigin String The system or interface from which the invoice originated.
InvoiceOriginType Int An integer code classifying the origination method of the invoice.
InvoiceSubmissionMethod String The channel through which the invoice was submitted into Ariba.
InvoiceSourceDocument String The preceding procurement document type that triggered this invoice.
ProjectId String The unique identifier of a sourcing, contract, or procurement project linked to this invoice.
ProjectTitle String The human-readable title of the associated project workspace.
InvoicePurpose String The intended financial function of the document.
IsNonPO Bool Indicates whether the invoice was created without a referenced Purchase Order.
OrderUniqueName String The unique identifier of the Purchase Order against which this invoice is being billed.
MasterAgreementUniqueName String The unique identifier of the Master Agreement or Contract governing this invoice.
Signed Bool Indicates whether the invoice contains a valid digital signature for compliance purposes.
FullUrl String The direct web address to view the specific invoice document within the Ariba UI.
AccountReceivableId String The supplier's internal Accounts Receivable identifier or reference number.
RemitToId String The specific identifier for the bank account or location where the payment should be sent.
HeaderLevel Bool Indicates if the data context applies to the header level of the invoice rather than the line items.
IsTaxInLine Bool Indicates whether tax details are applied at the individual line-item level or rolled up to the header level.
TaxExchangeRate Decimal The exchange rate used to calculate tax amounts when the invoice currency differs from the tax authority's currency.
RequesterUniqueName String The system ID of the individual who requested or owns the document.
RequesterPasswordAdapter String The authentication adapter managing the requester's login credentials.
PreparerUniqueName String The system ID of the user who actively drafted or entered the invoice into the system.
PreparerPasswordAdapter String The authentication adapter managing the preparer's login credentials.
SupplierUniqueName String The unique system identifier for the supplier organization.
SupplierName String The formal, registered name of the supplier organization.
PurchaseOrgUniqueName String The identifier for the Purchasing Organization legally responsible for the procurement transaction.
CompanyCodeUniqueName String The identifier for the specific legal entity associated with the financial liability of this invoice.
PaymentTermsUniqueName String The identifier for the payment terms applied to the invoice.
SupplierLocationState String The state, province, or region of the supplier's primary location.
SupplierLocationPhone String The primary contact phone number for the supplier's location.
SupplierLocationPostalCode String The ZIP or postal code of the supplier's location.
SupplierLocationCity String The city of the supplier's location.
SupplierLocationFax String The fax number for the supplier's location.
SupplierLocationUniqueName String The system identifier for this specific location or branch of the supplier.
SupplierLocationLines String The street address line of the supplier's location.
SupplierLocationName String The customized name for this specific supplier location.
SupplierLocationCountryUniqueName String The ISO country code of the supplier's location.
RemitToAddressState String The state, province, or region of the remittance address.
RemitToAddressPhone String The contact phone number for the remittance address.
RemitToAddressPostalCode String The ZIP or postal code of the remittance address.
RemitToAddressCity String The city of the remittance address.
RemitToAddressFax String The fax number for the remittance address.
RemitToAddressUniqueName String The system identifier for the remittance address location.
RemitToAddressLines String The street address line of the remittance address.
RemitToAddressName String The name associated with the remittance address.
RemitToAddressCountryUniqueName String The ISO country code of the remittance address.
SoldToName String The name of the buying entity to whom the goods or services were legally sold.
SoldToAddressState String The state, province, or region of the buying entity's address.
SoldToAddressPhone String The contact phone number for the buying entity's address.
SoldToAddressPostalCode String The ZIP or postal code of the buying entity's address.
SoldToAddressCity String The city of the buying entity's address.
SoldToAddressFax String The fax number for the buying entity's address.
SoldToAddressUniqueName String The system identifier for the buying entity's address.
SoldToAddressLines String The street address line of the buying entity's address.
SoldToAddressName String The name associated with the buying entity's address.
SoldToAddressCountryUniqueName String The ISO country code of the buying entity's address.
TotalCostAmountInReportingCurrency Decimal The total cost converted into the system's global reporting currency.
TotalCostApproxAmountInBaseCurrency Decimal The total cost converted into the local realm's base currency.
TotalCostAmount Decimal The total cost in the transactional currency listed on the invoice.
TotalCostConversionDate Datetime The date used to look up the exchange rate for total cost currency conversions.
TotalCostCurrencyUniqueName String The ISO currency code for the total cost transactional amount.
TotalTaxAmountInReportingCurrency Decimal The total tax converted into the system's global reporting currency.
TotalTaxApproxAmountInBaseCurrency Decimal The total tax converted into the local realm's base currency.
TotalTaxAmount Decimal The total tax in the transactional currency listed on the invoice.
TotalTaxConversionDate Datetime The date used to look up the exchange rate for total tax currency conversions.
TotalTaxCurrencyUniqueName String The ISO currency code for the total tax transactional amount.
TotalInvoicedLessTaxAmountInReportingCurrency Decimal The total invoiced amount excluding tax converted into the system's global reporting currency.
TotalInvoicedLessTaxApproxAmountInBaseCurrency Decimal The total invoiced amount excluding tax converted into the local realm's base currency.
TotalInvoicedLessTaxAmount Decimal The total invoiced amount excluding tax in the transactional currency.
TotalInvoicedLessTaxConversionDate Datetime The date used to look up the exchange rate for total invoiced less tax currency conversions.
TotalInvoicedLessTaxCurrencyUniqueName String The ISO currency code for the total invoiced less tax transactional amount.
TotalInvoicedAmountInReportingCurrency Decimal The total invoiced amount converted into the system's global reporting currency.
TotalInvoicedApproxAmountInBaseCurrency Decimal The total invoiced amount converted into the local realm's base currency.
TotalInvoicedAmount Decimal The total invoiced amount in the transactional currency.
TotalInvoicedConversionDate Datetime The date used to look up the exchange rate for total invoiced currency conversions.
TotalInvoicedCurrencyUniqueName String The ISO currency code for the total invoiced transactional amount.
TotalWithholdingTaxAmountInReportingCurrency Decimal The total withholding tax converted into the system's global reporting currency.
TotalWithholdingTaxApproxAmountInBaseCurrency Decimal The total withholding tax converted into the local realm's base currency.
TotalWithholdingTaxAmount Decimal The total withholding tax in the transactional currency.
TotalWithholdingTaxConversionDate Datetime The date used to look up the exchange rate for total withholding tax currency conversions.
TotalWithholdingTaxCurrencyUniqueName String The ISO currency code for the total withholding tax transactional amount.
TaxAmountAmountInReportingCurrency Decimal The tax amount converted into the system's global reporting currency.
TaxAmountApproxAmountInBaseCurrency Decimal The tax amount converted into the local realm's base currency.
TaxAmountAmount Decimal The tax amount in the transactional currency.
TaxAmountConversionDate Datetime The date used to look up the exchange rate for tax amount currency conversions.
TaxAmountCurrencyUniqueName String The ISO currency code for the tax amount transactional currency.
MaxDiscountApplicableAmountInReportingCurrency Decimal The maximum applicable discount converted into the system's global reporting currency.
MaxDiscountApplicableApproxAmountInBaseCurrency Decimal The maximum applicable discount converted into the local realm's base currency.
MaxDiscountApplicableAmount Decimal The maximum applicable discount in the transactional currency.
MaxDiscountApplicableConversionDate Datetime The date used to look up the exchange rate for maximum discount currency conversions.
MaxDiscountApplicableCurrencyUniqueName String The ISO currency code for the maximum applicable discount transactional currency.
LineItems String The line items linked to the invoice.
ApprovalRequests String The approval requests linked to the invoice.
Attachments String The attachments linked to the invoice.

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