ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData JDBC Driver for Wave Financial ビュー
Name | Description |
Accounts | Chart of Accounts for the business. |
AccountSubtypes | List subtypes of accounts. |
AccountTypes | List types of accounts. |
Businesses | List businesses. |
Countries | List countries. |
Currencies | List currencies. |
Customers | List of customers for the business. |
InvoiceItems | The line items (product, unit and price) that make up the invoiced sale. |
InvoiceItemTaxes | List of taxes applied to an invoice item. |
Invoices | List of invoices for the business. |
ProductDefaultSalesTaxes | Default sales taxes to apply on product. |
ProductDefaultSalesTaxRates | Tax rates with their effective dates of application. |
Products | List of products (and services) for the business. |
Provinces | List of principal subdivisions. |
SalesTaxes | List of sales taxes for the business. |
SalesTaxRates | Tax rates with their effective dates of application |
Vendors | List of vendors for the business. |