A 'system vsap' view template that queries 'InvoiceReconciliation' transaction data.

View-Specific Information

Select

The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.

• IncludeInactive supports the '=' comparison operator.
• createdDateFrom supports the '=' comparison operator.
• createdDateTo supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM InvoiceReconcilationSAPcreatedRange WHERE createdDateFrom='2024-01-01 00:00:00.0' AND createdDateTo='2024-02-01 00:00:00.0'
SELECT * FROM InvoiceReconcilationSAPcreatedRange WHERE IncludeInactive='True' 

Columns

Name	Type	References	Description
RejectedDate	Datetime		The date when an invoice reconciliation was rejected.
ApprovedState	String		An integer value representing the current approval state of an invoice reconciliation. This field is used for internal purposes only. Possible numbers for the approvated state are: 1 - Composing, 2 - Submitted, 4 - Approved, 8 - Invalid, 16- Denied.
Invoice_UniqueName	String
InitialUniqueName	String		The ID of the invoice reconciliation when it was first created. This field is used for internal purposes only.
SubmitDate	Datetime		The date when an invoice reconciliation is successfully submitted for approval.
HoldTillDate	Datetime		The date until which processing of a fully approved invoice reconciliation is withheld.
SupplierLocation_State	String
SupplierLocation_Phone	String
SupplierLocation_Country_UniqueName	String
SupplierLocation_PostalCode	String
SupplierLocation_City	String
SupplierLocation_Fax	String
SupplierLocation_UniqueName	String
SupplierLocation_Lines	String
SupplierLocation_Name	String
Payments	String
ChargeAmount_AmountInReportingCurrency	Decimal
ChargeAmount_ApproxAmountInBaseCurrency	Decimal
ChargeAmount_Amount	Decimal
ChargeAmount_ConversionDate	Datetime
ChargeAmount_Currency_UniqueName	String
CreateDate	Datetime		The date when an invoice reconciliation is created.
Name	String		The title of an invoice reconciliation.
ExternalStatus	String		The status of this invoice reconciliation in the external system.
LastModified	Datetime		The date when an invoice reconciliation was last modified. Actions that lead to updates to the history record of an invoice reconciliation trigger changes to the last modified date.
TimeCreated	Datetime		The time when an invoice reconciliation is created.
PayloadID	String		The ID generated for documents transmitted to Ariba Network.
TaxAmount_AmountInReportingCurrency	Decimal
TaxAmount_ApproxAmountInBaseCurrency	Decimal
TaxAmount_Amount	Decimal
TaxAmount_ConversionDate	Datetime
TaxAmount_Currency_UniqueName	String
Requester_UniqueName	String		The user on behalf of whom a requisition is created. Typically, the preparer and requester of a requisition are the same user. If a preparer creates a requisition for someone else, the requester is the user for whom the requisition is created.
TaxDetails	String
PaidAmounts_AdjustmentAmount_Reason	String
PaidAmounts_AdjustmentAmount_Amount_AmountInReportingCurrency	Decimal
PaidAmounts_AdjustmentAmount_Amount_ApproxAmountInBaseCurrency	Decimal
PaidAmounts_AdjustmentAmount_Amount_Amount	Decimal
PaidAmounts_AdjustmentAmount_Amount_ConversionDate	Datetime
PaidAmounts_AdjustmentAmount_Amount_Currency_UniqueName	String
PaidAmounts_GrossAmount_AmountInReportingCurrency	Decimal
PaidAmounts_GrossAmount_ApproxAmountInBaseCurrency	Decimal
PaidAmounts_GrossAmount_Amount	Decimal
PaidAmounts_GrossAmount_ConversionDate	Datetime
PaidAmounts_GrossAmount_Currency_UniqueName	String
PaidAmounts_DiscountAmount_AmountInReportingCurrency	Decimal
PaidAmounts_DiscountAmount_ApproxAmountInBaseCurrency	Decimal
PaidAmounts_DiscountAmount_Amount	Decimal
PaidAmounts_DiscountAmount_ConversionDate	Datetime
PaidAmounts_DiscountAmount_Currency_UniqueName	String
PaidAmounts_NetAmount_AmountInReportingCurrency	Decimal
PaidAmounts_NetAmount_ApproxAmountInBaseCurrency	Decimal
PaidAmounts_NetAmount_Amount	Decimal
PaidAmounts_NetAmount_ConversionDate	Datetime
PaidAmounts_NetAmount_Currency_UniqueName	String
VATAmount_AmountInReportingCurrency	Decimal
VATAmount_ApproxAmountInBaseCurrency	Decimal
VATAmount_Amount	Decimal
VATAmount_ConversionDate	Datetime
VATAmount_Currency_UniqueName	String
LineItems	String
ChangedBy_UniqueName	String
ApprovedDate	Datetime		The date when an invoice reconciliation is fully approved.
TotalWithholdingTax_AmountInReportingCurrency	Decimal
TotalWithholdingTax_ApproxAmountInBaseCurrency	Decimal
TotalWithholdingTax_Amount	Decimal
TotalWithholdingTax_ConversionDate	Datetime
TotalWithholdingTax_Currency_UniqueName	String
ScheduledPaymentDate	Datetime		The scheduled payment date for a reconciled invoice.
PreviousApprovalRequestsVersion	Int		The version number for the previous version of the approval request. This field is used for internal purposes only.
ResubmitDate	Datetime		The date when an invoice is resubmitted for approval. An invoice is considered as resubmitted if a user edits a denied invoice and resubmits it for approval. Note: Invoices that are withdrawn by the preparer and submitted again are not considered as resubmitted invoices.
EligibleForDynamicDiscount	Bool		A flag used by Buyers to indicate if the supplier can ask for immediate remittance of this invoice reconciliation to get dynamic discounts.
NumberCleared	Decimal		The number of invoiced items that have been cleared after an invoice reconciliation is reconciled.
MaxDiscountApplicable_AmountInReportingCurrency	Decimal
MaxDiscountApplicable_ApproxAmountInBaseCurrency	Decimal
MaxDiscountApplicable_Amount	Decimal
MaxDiscountApplicable_ConversionDate	Datetime
MaxDiscountApplicable_Currency_UniqueName	String
DiscountAmount_AmountInReportingCurrency	Decimal
DiscountAmount_ApproxAmountInBaseCurrency	Decimal
DiscountAmount_Amount	Decimal
DiscountAmount_ConversionDate	Datetime
DiscountAmount_Currency_UniqueName	String
ServicePeriod	String
ApprovalRequests	String
Active	Bool		Indicates whether the invoice reconciliation is currently in use in the buying solution. This field can contain the values as True or False. False indicates inactive invoice reconciliations. Inactive invoice reconciliations are considered as those that are deleted and do not appear in search results and invoice reconciliation choosers.
ProcurementUnit_UniqueName	String
AmountBilled_AmountInReportingCurrency	Decimal
AmountBilled_ApproxAmountInBaseCurrency	Decimal
AmountBilled_Amount	Decimal
AmountBilled_ConversionDate	Datetime
AmountBilled_Currency_UniqueName	String
NextVersion	String
NumberBilled	Decimal		The total number of invoiced items.
UniqueName	String		The unique identifier for an invoice reconciliation in the system.
TotalInvoiced_AmountInReportingCurrency	Decimal
TotalInvoiced_ApproxAmountInBaseCurrency	Decimal
TotalInvoiced_Amount	Decimal
TotalInvoiced_ConversionDate	Datetime
TotalInvoiced_Currency_UniqueName	String
ProcessedState	String		The current payment processing state for an invoice reconciliation after it has been reconciled. The following are the possible values for the processing state for an invoice reconciliation: - Unprocessed: The invoice reconciliation has not been processed for payment. - Rejected: The invoice reconciliation has been rejected by an approver. - Paying: The invoice reconciliation has been approved and payment is being processed. - Paid: The invoice reconciliation has been approved and invoiced amounts have been paid. - FailedPaying: The invoice reconciliation has been approved but payment for the invoiced amount has failed.
AmountCleared_AmountInReportingCurrency	Decimal
AmountCleared_ApproxAmountInBaseCurrency	Decimal
AmountCleared_Amount	Decimal
AmountCleared_ConversionDate	Datetime
AmountCleared_Currency_UniqueName	String
ProjectID	String		The ID of a project.
Attachments	String
SourcingStatusString	String		The status of a sourcing transaction in the sourcing solution. This field contains cXML updates received from the sourcing solution.
PaymentModel	Int		The payment model used for a payment request associated with an invoice reconciliation document. This field can contain one of the following values: -1 – Default, 0 - ExternalPay, 1 – LocalPay, or 2 - AribaNetworkPay.
RemittanceLocation_UniqueName	String
PaidDate	Datetime		The date when payment for a reconciled invoice was made.
ServiceLocation_State	String
ServiceLocation_Phone	String
ServiceLocation_Country_UniqueName	String
ServiceLocation_PostalCode	String
ServiceLocation_City	String
ServiceLocation_Fax	String
ServiceLocation_UniqueName	String
ServiceLocation_Lines	String
ServiceLocation_Name	String
Exceptions	String
Supplier_UniqueName	String
Supplier_Name	String
InvoiceDate	Datetime		The date when the invoice associated with an invoice reconciliation is created.
StatusString	String		The current status of an invoice reconciliation. Example: Approved or Reconciled.
PreviousVersion	String
ApprovalRequestsVersion	Int		The version of an approval request when it was generated. This field is used for internal purposes only.
TimeUpdated	Datetime		The time when an invoice reconciliation was last updated.
VersionNumber	Int		The internal version number assigned to an approvable document. This field is used for optimistic locking and ensures that changes to the document are followed in an appropriate sequence. This field is used for internal purposes only.
TaxAccrualAmount_AmountInReportingCurrency	Decimal
TaxAccrualAmount_ApproxAmountInBaseCurrency	Decimal
TaxAccrualAmount_Amount	Decimal
TaxAccrualAmount_ConversionDate	Datetime
TaxAccrualAmount_Currency_UniqueName	String
Type	String		The internal name for the approvable document. For example, the internal name for an invoice reconciliation is ariba.invoicing.core.InvoiceReconciliation.
ProjectTitle	String		The title of a project.
IsAccruedOnIR	Bool		A flag that indicates if the amounts are accrued in an invoice reconciliation. Only NonPO Invoice's will have accrued amounts.
Preparer_UniqueName	String		The user who creates a requisition and submits it for approval.
IncludeInactive	Bool		By default, API responses do not include inactive transactions. You can set this query parameter to true to include inactive transactions in the responses.
createdDateFrom	Datetime		This filter corresponds to the 'TimeCreated' field. The operation is '>' and the default value is '2018-03-01T23:59:59Z'.
createdDateTo	Datetime		This filter corresponds to the 'TimeCreated' field. The operation is '<=' and the default value is '2018-03-29T23:59:59Z'.