Power BI Connector for Wave Financial

Build 24.0.9062

Invoices

List of invoices for the business.

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 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.

使用できる値は次のとおりです。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.

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