InvoiceItems
The line items (product, unit and price) that make up the invoiced sale.
Table Specific Information
The 本製品 uses the Wave Financial API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. 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 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. | |
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. |