InvoiceLineItems
Get the details of line items from invoices.
Table Specific Information
Select
The add-in 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 add-in.
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. |