InvoiceLineItems
Get the details of line items from invoices.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- InvoiceId supports the '=' and IN operators.
NOTE: InvoiceId is required to query InvoiceLineItems.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM InvoiceLineItems WHERE InvoiceId = '1864543000000078539'
SELECT * FROM InvoiceLineItems WHERE InvoiceId IN (SELECT InvoiceId FROM Invoices)
SELECT * FROM InvoiceLineItems WHERE InvoiceId IN ('1864543000000078539','1864543000000078540')
Columns
| Name | Type | References | SupportedOperators | Description |
| LineItemId [KEY] | String | Line Item Id of an item. | ||
| InvoiceId | String |
Invoices.InvoiceId | Id of an invoice. | |
| AccountId | String |
BankAccounts.AccountId | Id of the Bank Account. | |
| AccountName | String | Name of the account. | ||
| BcyRate | Decimal | Rate of Base Currency. | ||
| BillId | String |
Bills.BillId | Id of an invoice. | |
| BillItemId | String | Item Id of an invoice. | ||
| CustomFields | String | Custom Fields added for the line item. | ||
| Description | String | Description of the invoice line item. | ||
| Discount | String | Discount applied in invoice. | ||
| DiscountAmount | Decimal | Discount Amount applied in invoice. | ||
| ExpenseId | String |
Expenses.ExpenseId | Id of an expense. | |
| ExpenseReceiptName | String | Receipt name of an expense. | ||
| GstTreatmentCode | String | Code GST treatement. | ||
| HasProductTypeMismatch | Boolean | Check if product type mismatch or not. | ||
| HeaderId | String | Id of a header. | ||
| HeaderName | String | Name of a header. | ||
| HsnOrSac | String | HSN Code. | ||
| ItemId | String |
Items.ItemId | Id of an item. | |
| ItemOrder | Integer | Order of an item. | ||
| ItemTotal | Decimal | Total number of an item. | ||
| ItemType | String | Type of an item. | ||
| Name | String | Name of an invoice. | ||
| ProductType | String | Type of the product. | ||
| ProjectId | String |
Projects.ProjectId | Id of the project. | |
| PurchaseRate | Double | Purchase rate of an invoice. | ||
| Quantity | Decimal | Quantity of line items. | ||
| Rate | Decimal | Rate of the line item. | ||
| ReverseChargeTaxId | String | Id of the reverse charge tax. | ||
| SalesorderItemId | String | Item Id of sales order. | ||
| TaxId | String |
Taxes.TaxId | Id of tax. | |
| TaxName | String | Name of tax. | ||
| TaxPercentage | Integer | Percentage of tax. | ||
| TaxType | String | Type of tax applied to invoice line item. | ||
| Unit | String | Number of unit in line items. | ||
| SKU | String | The SKU of the Line Item. |