ビュー
ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます(その機能がデータソースに適用できる場合)。
ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。
ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。
CData Tableau Connector for Zoho Books ビュー
Name | Description |
AccountTransactionsReport | Generated schema file. |
BalanceSheetsReport | This report summarizes your company's assets, liabilities and equity at a specific point in time |
BankMatchingTransactions | Retrieves the list of transactions which includes invoices/bills/credit-notes. |
BankRuleCriterions | Get criterions of a specific bank rule. |
BankTransactionLineItems | Get details of bank transaction line items. |
BaseCurrencyAdjustmentAccounts | Retrieves lists of base currency adjustment accounts. |
BillLineItems | Get the details of a line items of bills. |
BillPayments | Get the list of payments made for a bill. |
Bills | Retrieves list of bills. |
Budgets | To get the list of budgets |
BusinessPerformanceRatiosReport | Generated schema file. |
CashFlowReport | Generated schema file. |
ChartOfAccountInlineTransactions | Retrieves the list of inline transactions. |
ChartOfAccountTransactions | Retrieves list of all involved transactions for the given account. |
CommittedStockDetailsReport | Generated schema file. |
ContactAddresses | Get addresses of a contact including its Shipping Address, Billing Address. |
Contacts | Retrieves list of all contacts. |
CreditNoteInvoices | Retrieves details of invoices from an existing Credit Note. |
CreditNoteLineItems | Retrieves details of line items from existing Credit Notes. |
CreditNotes | Retrieves list of all the Credit Notes. |
CurrencyExchangeRates | Retrieves list of exchange rates configured for the currency. |
CustomerBalancesReport | Generated schema file. |
CustomerPayments | Retrieves list of all the payments made by your customer. |
Employees | Retrieves list of employees. Also, get the details of an employee. |
EstimateApprovers | Get the details of approvers for estimates. |
EstimateLineItems | Get the details of line items for estimates. |
Estimates | Retrieves list of all estimates. |
Expenses | Retrieves list of all the Expenses. |
GeneralLedgerReport | Generated schema file. |
InventorySummaryReport | Generated schema file. |
InventoryValuationReport | Generated schema file. |
InvoiceAppliedCredits | Retrieves list of credits applied for an invoice. |
InvoiceLineItems | Get the details of line items from invoices. |
InvoicePayments | Get the list of payments made for an invoice. |
Invoices | Retrieves list of all invoices. |
Items | Retrieves list of all active items. |
JournalLineItems | Retrieves list of line items of a journal. |
JournalReport | Generated schema file. |
MovementOfEquityReport | Generated schema file. |
OpeningBalanceAccounts | Retrieves list of accounts of opening balance. |
OpeningBalanceTransactionSummaries | Get transaction summaries of opening balance. |
Organizations | Retrieves list of organizations. |
PaymentsReceivedReport | Generated schema file. |
ProductSalesReport | Generated schema file. |
ProfitsAndLossesReport | This report summarizes your company's assets, liabilities and equity at a specific point in time |
ProjectInvoices | Retrieves list of invoices created for a project. |
ProjectPerformanceSummaryReport | Generated schema file. |
ProjectUsers | Retrieves list of users associated with a project. Also, get details of a user in project. |
PurchaseOrderLineItems | Get the details of line items of purchase orders. |
PurchaseOrders | Retrieves list of all purchase orders. |
PurchaseOrdersByVendorReport | Generated schema file. |
RecurringBillLineItems | Get the details of a line items of bills. |
RecurringBills | To list, add, update and delete details of a bill. |
RecurringExpenses | Retrieves list of all the Expenses. |
RecurringInvoiceLineItems | Get the details of line items of a recurring invoice. |
RecurringInvoices | Retrieves list of all recurring invoices. |
RecurringSubExpense | Retrieves list of child expenses created from recurring expense. |
ReportsAccountTransactionsDetails | Retrieves the list of inline transactions. |
RetainerInvoiceLineItems | Retrieves detail of line items of retainer invoices. |
RetainerInvoicePayments | Get the list of payments made for a retainer invoices. |
RetainerInvoices | Retrieves list of all retainer invoices. |
SalesByCustomerReport | Generated schema file. |
SalesByItemReport | Generated schema file. |
SalesBySalespersonReport | Generated schema file. |
SalesOrderLineItems | Retrieves list of line items of a sales order. |
SalesOrders | Retrieves list of all sales orders. |
StockSummaryReport | Generated schema file. |
TaxSummaryReport | This report summarizes your company's assets, liabilities and equity at a specific point in time |
TrialBalanceReport | This report summarizes your company's assets, liabilities and equity at a specific point in time |
VendorBalancesReport | Generated schema file. |
VendorCreditBills | Retrieves list of bills to which the vendor credit is applied. |
VendorCreditLineItems | Retrieves list of line items from vendor credits. |
VendorCredits | Retrieves list of vendor credits. |
VendorPayments | Retrieves list of all the payments made to your vendor. |