The line items (product, unit and price) that make up the invoiced sale.

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. For example, the following queries are processed server side.

SELECT

SELECT * FROM InvoiceItems WHERE InvoiceId = 'QnVzaW5lc3M6MTY4NTYtYzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdl'

Columns

Name	Type	References	SupportedOperators	Description
ProductId [KEY]	String	Products.Id		Unique identifier for the associated product.
InvoiceId [KEY]	String	Invoices.Id		Unique identifier for the invoice.
Description	String			Detailed description.
Quantity	Decimal			Number of units.
UnitPrice	Decimal			Price per unit.
SubtotalValue	Decimal			Amount represented as a combination of the major and minor currency unit (uses a decimal separator).
SubtotalCurrencyCode	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.
AccountId	String			Unique identifier for the account.

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
InvoiceItemTaxes	String		The item's taxes.