Retrieves invoice header information.

View-Specific Information

Select

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

• DocumentNumber supports the '=' comparison operator.
• SupplierANID supports the '=' comparison operator.
• BuyerANID supports the '=' comparison operator.
• CreatedDate supports the '>=', '>', '=', '<', '<=' comparison operators.
• RoutingStatus supports the '=' comparison operator.
• DocumentStatus supports the '=' comparison operator.
• DocumentStatusDate supports the '>', '<' comparison operators.
• Purpose supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM Invoices WHERE DocumentNumber = 'I0123'

SELECT * FROM Invoices WHERE RoutingStatus = 'Sent'

SELECT * FROM Invoices WHERE Purpose = 'creditMemo'

SELECT * FROM Invoices WHERE CreatedDate > '2000-01-01T00:00:00' AND CreatedDate < '2000-01-15T01:00:00'

Columns

Name	Type	References	Description
DocumentNumber [KEY]	String		Invoice document number.
SupplierName	String		First name and last name of the supplier.
SupplierANID	String		ANID of the supplier.
BuyerName	String		First name and last name of the buyer.
BuyerANID	String		ANID of the buyer.
CreatedDate	Datetime		Date on which the invoice is created on SAP Business Network.
DocumentDate	Datetime		Invoice date on the cXML document.
RoutingStatus	String		Routing status of the invoice.
DocumentStatus	String		Processing status of the invoice.
PayloadId	String		Payload ID of the invoice.
NetTerms	Int		Numbers of days till payment is due.
DocumentStatusComments	String		Comments about the last document status update.
DocumentStatusDate	Datetime		Date of the last status update of the document.
ExternalInvoiceNumber	String		External invoice number related to the invoice.
ExternalOrderNumber	String		External reference number related to the purchase order of the invoice.
NumberOfItems	Int		Number of items on the invoice.
Purpose	String		Purpose of the invoice.
SignFromCountry	String		Country/region of origin of the invoice.
SignToCountry	String		Country/region of destination of the invoice.
TaxAmount	Decimal		Tax amount in the invoice.
TaxCurrencyCode	String		Currency code for the tax amount in the invoice.
TotalAmount	Decimal		Total amount in the invoice.
TotalAmountCurrencyCode	String		Currency code for the total amount in the invoice.
Type	String		Type of invoice.
PaymentDueDate	Datetime		The date on which the buyer plans to make the payment to the supplier.
BuyerVatID	String		The VAT id of the buyer.
SupplierVatID	String		The VAT id of the supplier.
BuyerTaxID	String		The Tax id or VAT id of the organization that ordered the items or services.
SupplierTaxID	String		The Tax id or VAT id of the supplier.
FromAddressName	String		The address used by supplier companies to invoice the buyer companies on the invoice header. From address name.
FromAddressStreet1	String		The address used by supplier companies to invoice the buyer companies on the invoice header. From address street1.
FromAddressStreet2	String		The address used by supplier companies to invoice the buyer companies on the invoice header. From address street2.
FromAddressStreet3	String		The address used by supplier companies to invoice the buyer companies on the invoice header. From address street3.
FromAddressStreet4	String		The address used by supplier companies to invoice the buyer companies on the invoice header. From address street4.
FromAddressCity	String		The address used by supplier companies to invoice the buyer companies on the invoice header. From address city.
FromAddressState	String		The address used by supplier companies to invoice the buyer companies on the invoice header. From address state.
FromAddressPostalCode	String		The address used by supplier companies to invoice the buyer companies on the invoice header. From address postal code.
FromAddressCountry	String		The address used by supplier companies to invoice the buyer companies on the invoice header. From address country.
SoldToAddressName	String		The address of the organization that ordered the items or services. Sold-to address name.
SoldToAddressStreet1	String		The address of the organization that ordered the items or services. Sold-to address street1.
SoldToAddressStreet2	String		The address of the organization that ordered the items or services. Sold-to address street2.
SoldToAddressStreet3	String		The address of the organization that ordered the items or services. Sold-to address street3.
SoldToAddressStreet4	String		The address of the organization that ordered the items or services. Sold-to address street4.
SoldToAddressCity	String		The address of the organization that ordered the items or services. Sold-to address city.
SoldToAddressState	String		The address of the organization that ordered the items or services. Sold-to address state.
SoldToAddressPostalCode	String		The address of the organization that ordered the items or services. Sold-to address postal code.
SoldToAddressCountry	String		The address of the organization that ordered the items or services. Sold-to address country.
BillToAddressName	String		The address of the company being billed. Bill-to address name.
BillToAddressStreet1	String		The address of the company being billed. Bill-to address street1.
BillToAddressStreet2	String		The address of the company being billed. Bill-to address street2.
BillToAddressStreet3	String		The address of the company being billed. Bill-to address street3.
BillToAddressStreet4	String		The address of the company being billed. Bill-to address street4.
BillToAddressCity	String		The address of the company being billed. Bill-to address city.
BillToAddressState	String		The address of the company being billed. Bill-to address state.
BillToAddressPostalCode	String		The address of the company being billed. Bill-to address postal code.
BillToAddressCountry	String		The address of the company being billed. Bill-to address country.
RemitToAddressName	String		The address used by buyer companies to remit payments to supplier companies. Remit-to address name.
RemitToAddressStreet1	String		The address used by buyer companies to remit payments to supplier companies. Remit-to address street1.
RemitToAddressStreet2	String		The address used by buyer companies to remit payments to supplier companies. Remit-to address street2.
RemitToAddressStreet3	String		The address used by buyer companies to remit payments to supplier companies. Remit-to address street3.
RemitToAddressStreet4	String		The address used by buyer companies to remit payments to supplier companies. Remit-to address street4.
RemitToAddressCity	String		The address used by buyer companies to remit payments to supplier companies. Remit-to address city.
RemitToAddressState	String		The address used by buyer companies to remit payments to supplier companies. Remit-to address state.
RemitToAddressPostalCode	String		The address used by buyer companies to remit payments to supplier companies. Remit-to address postal code.
RemitToAddressCountry	String		The address used by buyer companies to remit payments to supplier companies. Remit-to address country.