Excel Add-In for Zoho Books

Build 22.0.8479

ビュー

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます(その機能がデータソースに適用できる場合)。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

CData Excel Add-In 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479