List of invoices for the business.

Table Specific Information

The add-in uses the Wave Financial API to process some of the filters. The add-in processes other filters client-side within the add-in. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. For example, the following queries are processed server side.

SELECT

SELECT * FROM Invoices WHERE BusinessId = 'QnVzaW5lc3M6NjE2MTYtYzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdl'
SELECT * FROM Invoices WHERE CustomerID = 'QnVzaW5lc3M6NjE2MTY4NzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdlO0N1c3RvbWVyOjMyNzkyMTEz'
SELECT * FROM Invoices WHERE ModifiedAt < '2020-02-26 18:02:06.171'
SELECT * FROM Invoices WHERE InvoiceDate >= '2020-07-03'
SELECT * FROM Invoices WHERE Status = 'SENT'
SELECT * FROM Invoices WHERE CurrencyCode = 'USD'

Columns

Name	Type	References	SupportedOperators	Description
Id [KEY]	String			Unique identifier for the invoice.
BusinessId	String	Businesses.id		The unique identifier for the business.
CreatedAt	Datetime			When the invoice was created.
ModifiedAt	Datetime			When the invoice was last modified.
PdfUrl	String			URL to access PDF representation of the invoice.
ViewUrl	String			URL to view the invoice online as seen by a customer.
CustomerId	String	Customers.id		Unique identifier for the customer.
CustomerName	String			The customer's name.
Status	String			Status of the Invoice. The allowed values are DRAFT, OVERDUE, PAID, PARTIAL, SAVED, SENT, UNPAID, VIEWED.
Title	String			Invoice title at the top of the document.
Subhead	String			Invoice subheading text.
InvoiceNumber	String			Unique number assigned to the invoice.
PoNumber	String			Purchase order or sales order number for the invoice.
InvoiceDate	Date			Date when invoice is issued.
DueDate	Date			Date when payment is due.
AmountDueValue	Decimal			Amount represented as a combination of the major and minor currency unit (uses a decimal separator).
AmountDueCurrencyCode	String	Currencies.Code		Currency code.
AmountPaidValue	Decimal			Amount represented as a combination of the major and minor currency unit (uses a decimal separator).
AmountPaidCurrencyCode	String	Currencies.Code		Currency code.
TaxTotalValue	Decimal			Amount represented as a combination of the major and minor currency unit (uses a decimal separator).
TaxTotalCurrencyCode	String	Currencies.Code		Currency code.
TotalValue	Decimal			Amount represented as a combination of the major and minor currency unit (uses a decimal separator).
TotalCurrencyCode	String	Currencies.Code		Currency code.
CurrencyCode	String	Currencies.Code		Currency code.
ExchangeRate	Decimal			Exchange rate to business's currency from the invoice's currency. Used to value the invoice income within Wave's accounting transactions.
Memo	String			Invoice memo (notes) text.
Footer	String			Invoice footer text.
DisableCreditCardPayments	Bool			Within a business that is enabled to accept credit card payments, indicates if this individual invoice has been marked to not be payable by card.
DisableBankPayments	Bool			Within a business that is enabled to accept bank payments, indicates if this individual invoice has been marked to not be payable by bank payment.
ItemTitle	String			The label for the 'Item' column in the line items listing.
UnitTitle	String			The label for the 'Unit' column in the listing of line items on the invoice.
PriceTitle	String			The label for the 'Price' column in the listing of line items on the invoice.
AmountTitle	String			The label for the 'Amount' (= unit x price) column in the listing of line items on the invoice.
HideName	Bool			Indicates whether item's product name in item column is hidden in the line items listing.
HideDescription	Bool			Indicates whether item's description in item column is hidden in the line items listing.
HideUnit	Bool			Indicates whether item's unit is hidden in the line items listing.
HidePrice	Bool			Indicates whether item's price is hidden in the line items listing.
HideAmount	Bool			Indicates whether item's amount is hidden in the line items listing.
LastSentAt	Datetime			When the invoice was last sent.
LastSentVia	String			How the invoice was last sent.
LastViewedAt	Datetime			When the invoice was last viewed by the customer.
DisableAmexPayments	Bool			Within a business that is enabled to accept credit card payments, indicates if this individual invoice has been marked to not be payable by American Express.