Products
List of products (and services) 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 Products WHERE BusinessId = 'QnVzaW5lc3M6NjE2MTYtYzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdl' SELECT * FROM Products WHERE Id = 'QzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdlO0N1c3RvbWVyOjMyNzkyMTEz' SELECT * FROM Products WHERE IsSold = true SELECT * FROM Products WHERE IsBought = true SELECT * FROM Products WHERE IsArchived = true SELECT * FROM Products WHERE ModifiedAt < '2020-07-03 08:28:56.0'
Columns
Name | Type | References | SupportedOperators | Description |
Id [KEY] | String | Unique identifier for the product. | ||
BusinessId | String |
Businesses.id | The unique identifier for the business. | |
Name | String | Name of the product. | ||
Description | String | Description of the product. | ||
UnitPrice | Decimal | Price per unit in the major currency unit. | ||
IsSold | Bool | Is product sold by the business. Allow this product or service to be added to Invoices. | ||
IsBought | Bool | Is product bought by the business. Allow this product or service to be added to Bills. | ||
IncomeAccountId | String |
Accounts.Id | Unique identifier for the account. | |
ExpenseAccountId | String |
Accounts.Id | Unique identifier for the account. | |
IsArchived | Bool | Is the product hidden from view by default. | ||
CreatedAt | Datetime | When the product was created. | ||
ModifiedAt | Datetime | When the product was last modified. |