ADO.NET Provider for Zoho Books

Build 20.0.7654

ビュー

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

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。テーブルおよびストアドプロシージャの詳細については、このヘルプドキュメントの該当エントリを参照してください。

CData ADO.NET Provider for Zoho Books ビュー

Name Description
BankAccounts Retrieves list of all bank and credit card accounts for your organization.
BankMatchingTransactions Retrieves the list of transactions which includes invoices/bills/credit-notes.
BankRuleCriterions Get criterions of a specific bank rule.
BankRules Fetch all the rules or a specific rule created for a specified bank or credit card account ID.
BankTransactionLineItems Get details of bank transaction line items.
BankTransactions Get all the transaction details involved in an account.
BaseCurrencyAdjustmentAccounts Retrieves lists of base currency adjustment accounts.
BaseCurrencyAdjustments Retrieves list of base currency adjustment.
BillDetails Get the details of a bill.
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.
ChartOfAccounts Retrieves list of all chart of accounts.
ChartOfAccountTransactions Retrieves list of all involved transactions for the given account.
ContactAddresses Get addresses of a contact including its Shipping Address, Billing Address.
ContactDetails Get details of a contact.
Contacts Retrieves list of all contacts.
CreditNoteDetails Retrieves details of an existing Credit Note.
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.
Currencies Get list of currencies configured. Also, get the details of a currency.
CurrencyExchangeRates Retrieves list of exchange rates configured for the currency.
CustomerContacts Retrieves list of all contact persons. Also, get the contact person details.
CustomerPaymentDetails Retrieves details of an existing payment.
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.
EstimateDetails Get the details of an estimate.
EstimateLineItems Get the details of line items for estimates.
Estimates Retrieves list of all estimates.
ExpenseDetails Get the details of an Expense.
Expenses Retrieves list of all the Expenses.
InvoiceAppliedCredits Retrieves list of credits applied for an invoice.
InvoiceDetails Get the details of 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.
ItemDetails Retrieves details of an existing item.
Items Retrieves list of all active items.
JournalLineItems Retrieves list of line items of a journal.
Journals Retrieves list of journals.
OpeningBalanceAccounts Retrieves list of accounts of opening balance.
OpeningBalances Get details of opening balance.
OpeningBalanceTransactionSummaries Get transaction summaries of opening balance.
Organizations Retrieves list of organizations.
ProjectInvoices Retrieves list of invoices created for a project.
Projects Retrieves list of projects.
ProjectUsers Retrieves list of users associated with a project. Also, get details of a user in project.
PurchaseOrderDetails Get the details of a purchase order.
PurchaseOrderLineItems Get the details of line items of purchase orders.
PurchaseOrders Retrieves list of all purchase orders.
RecurringExpenseDetails Get the details of a recurring expense.
RecurringExpenses Retrieves list of all the Expenses.
RecurringInvoiceDetails Get the details of a recurring invoice.
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.
RetainerInvoiceDetails Get the details of a retainer invoice.
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.
SalesOrderDetails Get the details of a sales order.
SalesOrderLineItems Retrieves list of line items of a sales order.
SalesOrders Retrieves list of all sales orders.
Tasks Retrieves list of tasks added to a project. Also, get the details of a task.
Taxes Retrieves list of simple and compound taxes. Also, get the details of a simple or compound tax.
TimeEntries Retrieves list of all time entries.
Users Retrieves list of all users in the organization. Also, get the details of a user.
VendorCreditBills Retrieves list of bills to which the vendor credit is applied.
VendorCreditDetails Get details of a vendor credit.
VendorCreditLineItems Retrieves list of line items from vendor credits.
VendorCredits Retrieves list of vendor credits.
VendorPaymentDetails Get details of a Vendor Payment.
VendorPayments Retrieves list of all the payments made to your vendor.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654