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