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 SSIS Components for Zoho Books Views


Name	Description
AccountDetailsBaseCurrencyAdjustment	Details of Base Currency Adjustment.
AccountDetailsBaseCurrencyAdjustmentAccounts	Account Details of Base Currency Adjustment
AccountTransactionsReport	Generated schema file.
BalanceSheetsReport	This report summarizes your company's assets, liabilities and equity at a specific point in time
BankAccountLastImportedStatement	Get the details of previously imported statement for the account.
BankAccountLastImportedStatementTransactions	Get the details of transaction related to previously imported statement for the account.
BankMatchingTransactions	Retrieves the list of transactions which includes invoices/bills/credit-notes.
BankRuleCriterions	Get criterions of a specific bank rule.
BankTransactionImportedTransaction	Get Imported Transactions.
BankTransactionLineItems	Get details of bank transaction line items.
BaseCurrencyAdjustmentAccounts	Retrieves lists of base currency adjustment accounts.
BillDocuments	Get the attachments associated with bills.
BillLineItems	Get the details of a line items of bills.
BillPayments	Get the list of payments made for a bill.
BillPurchaseOrders	Get bills related to purchase order.
Bills	Retrieves list of bills.
BillVendorCredits	Get bills related to vendor credits.
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.
ContactDocuments	Get the attachments associated with contacts.
ContactRefunds	Get refund details related to a contact.
Contacts	Retrieves list of all contacts.
CreditNoteDocuments	Get the attachments associated with credit notes.
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.
CustomerPaymentInvoices	Get invoices related to customer payments.
CustomerPayments	Retrieves list of all the payments made by your customer.
Documents	Get the list of all the documents associated with any entity.
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.
GetContactStatementEmailContent	Get the content of the mail sent to a contact.
InventorySummaryReport	Generated schema file.
InventoryValuationReport	Generated schema file.
InvoiceAppliedCredits	Retrieves list of credits applied for an invoice.
InvoiceDocuments	Get the attachments associated with invoices.
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.
ItemWarehouses	Get warehouse details related to 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.
PurchaseOrderDocuments	Get the attachments associated with Purchase Orders.
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.
RetainerInvoiceDocuments	Get the attachments associated with retainer invoices.
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.
SalesOrderDocuments	Get the attachments associated with salesorders.
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.
VendorPaymentBills	Get bills related to vendor payments.
VendorPayments	Retrieves list of all the payments made to your vendor.