TDV Adapter for Zoho Books

Build 24.0.9060

RetainerInvoiceLineItems

Retrieves detail of line items of retainer invoices.

Table Specific Information

Select

The adapter uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

  • RetainerInvoiceId supports the '=' and IN operators.

NOTE: RetainerInvoiceId is required to query RetainerInvoiceLineItems.

The rest of the filter is executed client-side in the adapter.

For example:

    SELECT * FROM RetainerInvoiceLineItems WHERE RetainerInvoiceId = '1894663000000085023'
	SELECT * FROM RetainerInvoiceLineItems WHERE RetainerInvoiceId IN (SELECT RetainerInvoiceId FROM RetainerInvoices)
	SELECT * FROM RetainerInvoiceLineItems WHERE RetainerInvoiceId IN ('1894663000000085023','1894663000000085024')

Columns

Name Type References SupportedOperators Description
RetainerInvoiceId String

RetainerInvoices.RetainerInvoiceId

Id of a retainer invoice.
LineItemId [KEY] String Id of line item.
AccountId String

BankAccounts.AccountId

Id of the Bank Account.
BcyRate Decimal Rate of Base Currency.
Description String Description of the retainer invoice line item.
ItemOrder Integer Order of items.
ItemTotal Decimal Total number of items in retainer invoice.
Rate Decimal Rate of the line item.
TaxId String

Taxes.TaxId

Id of tax.
TaxName String Name of the tax.
TaxPercentage Integer Percentage applied for tax.
TaxType String Type of tax.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060