Power BI Connector for Wave Financial

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062