Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData FireDAC Components for Zoho Books Views


Name	Description
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.
ChartOfAccountInlineTransactions	Retrieves the list of inline transactions.
ChartOfAccountTransactions	Retrieves list of all involved transactions for the given account.
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.
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.
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.
OpeningBalanceAccounts	Retrieves list of accounts of opening balance.
OpeningBalanceTransactionSummaries	Get transaction summaries of opening balance.
Organizations	Retrieves list of organizations.
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.
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.
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.
SalesOrderLineItems	Retrieves list of line items of a sales order.
SalesOrders	Retrieves list of all sales orders.
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
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.