Invoices

List of invoices for the business.

Table Specific Information

The component uses the Wave Financial API to process some of the filters. The component processes other filters client-side within the component. 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'

INSERT

The following columns can be used to create a new record:

BusinessId, CustomerId, Status, Title, Subhead, InvoiceNumber, PoNumber, InvoiceDate, DueDate, CurrencyCode, ExchangeRate, Memo, Footer, DisableCreditCardPayments, DisableBankPayments, ItemTitle, UnitTitle, PriceTitle, AmountTitle, HideName, HideDescription, HideUnit, HidePrice, HideAmount, DisableAmexPayments, RequireTermsOfServiceAgreement

The following pseudo-columns can be used to create a new record:

InvoiceItems (references InvoiceItems), FixedInvoiceDiscounts (references FixedInvoiceDiscounts), PercentageInvoiceDiscounts (references PercentageInvoiceDiscounts)

InvoiceItems Temporary Table Columns


Column Name	Type	Description
ProductId	String	Unique identifier for the associated product.
Description	String	Detailed description.
Quantity	Decimal	Number of units.
UnitPrice	Decimal	Price per unit.
InvoiceItemTaxes (references InvoiceItemTaxes)	String	The item's taxes.

FixedInvoiceDiscounts Temporary Table Columns


Column Name	Type	Description
Name	String	A description of the discount.
Amount	Decimal	The amount of the discount.

PercentageInvoiceDiscounts Temporary Table Columns


Column Name	Type	Description
Name	String	A description of the discount.
Percentage	Decimal	The percentage of the discount.

InvoiceItemTaxes Temporary Table Columns


Column Name	Type	Description
SalesTaxId	String	The unique identifier for the sales tax.
AmountValue	Decimal	Amount represented as a combination of the major and minor currency unit (uses a decimal separator).

INSERT INTO InvoiceItemTaxes#TEMP (ParentId, RowId, SalesTaxId, AmountValue) VALUES (1, 1, 'QnVzaW5lc3M6ZGVlMjVhM2YtNjRjOS00ZmI0LWE5MmYtYTRiMTYyMTFhMjg1O1NhbGVzVGF4OjE5NTgzNDUzMjQ=',10);
INSERT INTO InvoiceItemTaxes#TEMP (ParentId, RowId, SalesTaxId, AmountValue) VALUES (1, 2, 'QnVzaW5lc3M6ZGVlMjVhM2YtNjRjOS00ZmI0LWE5MmYtYTRiMTYyMTFhMjg1O1NhbGVzVGF4OjE5NTgzNDUzNzU=',15);
INSERT INTO InvoiceItemTaxes#TEMP (ParentId, RowId, SalesTaxId, AmountValue) VALUES (2, 1, 'QnVzaW5lc3M6ZGVlMjVhM2YtNjRjOS00ZmI0LWE5MmYtYTRiMTYyMTFhMjg1O1NhbGVzVGF4OjE5NTgzNDUzMjQ=',12);
INSERT INTO InvoiceItemTaxes#TEMP (ParentId, RowId, SalesTaxId, AmountValue) VALUES (2, 2, 'QnVzaW5lc3M6ZGVlMjVhM2YtNjRjOS00ZmI0LWE5MmYtYTRiMTYyMTFhMjg1O1NhbGVzVGF4OjE5NTgzNDUzNzU=',14);
INSERT INTO InvoiceItems#TEMP (RowId, ProductId, Description, Quantity, UnitPrice, InvoiceItemTaxes) VALUES (1, 'QnVzaW5lc3M6ZGVlMjVhM2YtNjRjOS00ZmI0LWE5MmYtYTRiMTYyMTFhMjg1O1Byb2R1Y3Q6NjgxNjk2OTY=', 'Description', 50, 100, 'InvoiceItemTaxes#TEMP');
INSERT INTO InvoiceItems#TEMP (RowId, ProductId, Description, Quantity, UnitPrice, InvoiceItemTaxes) VALUES (2, 'QnVzaW5lc3M6ZGVlMjVhM2YtNjRjOS00ZmI0LWE5MmYtYTRiMTYyMTFhMjg1O1Byb2R1Y3Q6NjgxNjk2OTY=', 'Description', 75, 200, 'InvoiceItemTaxes#TEMP');
INSERT INTO PercentageInvoiceDiscounts#TEMP (RowId, Name, Percentage) VALUES (1, 'Discount', 10);
INSERT INTO Invoices (BusinessId, CustomerId, Status, CurrencyCode, Title, Subhead, InvoiceNumber, PoNumber, InvoiceDate, ExchangeRate, DueDate, InvoiceItems, PercentageInvoiceDiscounts, Memo, Footer, DisableAmexPayments, DisableBankPayments, ItemTitle, UnitTitle, PriceTitle, AmountTitle, HideName, HideDescription, HideUnit, HidePrice, HideAmount) VALUES ('QnVzaW5lc3M6ZGVlMjVhM2YtNjRjOS00ZmI0LWE5MmYtYTRiMTYyMTFhMjg1', 'QnVzaW5lc3M6ZGVlMjVhM2YtNjRjOS00ZmI0LWE5MmYtYTRiMTYyMTFhMjg1O0N1c3RvbWVyOjk0MjM2OTg1', 'SAVED', 'EUR', 'Invoice', 'Subhead', '24', '128', '2025-05-20', 10.42, '2025-05-26', 'InvoiceItems#TEMP', 'PercentageInvoiceDiscounts#TEMP', 'Memo', 'Footer', false, false, 'Items', 'Quantity', 'Price', 'Amount', false, false, false, false, false);

Columns


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

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
InvoiceItems	String	The line items (product, unit and price) that make up the invoiced sale.
FixedInvoiceDiscounts	String	The fixed discounts applied to the invoice (currently limited to max 1).
PercentageInvoiceDiscounts	String	The percentage discounts applied to the invoice (currently limited to max 1).

SSIS Components for Wave Financial