InvoiceLineItems
Get the details of line items from invoices.
Table Specific Information
Select
The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
Note: InvoiceId is required in order to query InvoiceLineItems.
- InvoiceId supports the '=' comparison.
SELECT * FROM InvoiceLineItems WHERE InvoiceId = '1864543000000078539'
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. |