ODBC Driver for Zoho Inventory

Build 24.0.9060

RetainerInvoicesLineItems

List line items of retainer invoice.

Table Specific Information

Select

The driver will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.

  • RetainerInvoiceId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM RetainerInvoiceLineItems WHERE RetainerInvoiceId = '3350895000000089001'

Columns

Name Type References Description
RetainerInvoiceId Long

RetainerInvoices.Id

RetainerInvoice Id.
BcyRate Integer base currency rate
Description String The description of the line items.
ItemOrder Integer The order of the line item_order
ItemTotal Integer The total amount of the line items
LineItemId [KEY] Long The line item id
Rate Integer Rate of the line item.
TaxId Long ID of the tax or tax group applied to the estimate
TaxName String The name of the tax
TaxPercentage Double The percentage of tax levied
TaxType String The type of the tax

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