BillLineItems
Get the details of a line items of bills.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- BillId supports the the '=' and IN operators.
NOTE: BillId is required to query BillLineItems.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM BillLineItems WHERE BillId = '1894253000000085259'
SELECT * FROM BillLineItems WHERE BillId IN (SELECT BillId FROM Bills)
SELECT * FROM BillLineItems WHERE BillId IN ('1894553000000085259','1894553000000085260')
Columns
| Name | Type | References | SupportedOperators | Description |
| LineItemId [KEY] | String | Id of line item. | ||
| BillId | String |
Bills.BillId | Id of a Bill. | |
| AccountId | String |
BankAccounts.AccountId | Id of the Bank Account. | |
| AccountName | String | Name of the account. | ||
| BcyRate | Decimal | Rate of Base Currency. | ||
| CustomFields | String | Custom fields. | ||
| CustomerId | String |
Contacts.ContactId | Id of the customer or vendor. | |
| CustomerName | String | Name of the customer or vendor. | ||
| Description | String | Description of the bill line item. | ||
| Discount | Double | Discount to be applied on the bill line item. | ||
| GstTreatmentCode | String | Treatment code of GST. | ||
| HasProductTypeMismatch | Boolean | Check if the product type is mismatch. | ||
| HsnOrSac | String | HSN Code. | ||
| ImageDocumentId | String | Id of the image document. | ||
| InvoiceId | String |
Invoices.InvoiceId | Id of an invoice. | |
| InvoiceNumber | String | Number of an invoice. | ||
| IsBillable | Boolean | Check if the bill line items is billable. | ||
| ItcEligibility | String | Eligibility if bill for Input Tax Credit. | ||
| ItemId | String |
Items.ItemId | Id of an item. | |
| ItemOrder | Integer | Order of an item. | ||
| ItemTotal | Decimal | Total items. | ||
| ItemType | String | Type of item. | ||
| Name | String | Name of the bill line item. | ||
| PricebookId | String | Id of pricebook. | ||
| ProductType | String | Type of product. | ||
| ProjectId | String |
Projects.ProjectId | Id of project. | |
| ProjectName | String | Name of the project. | ||
| PurchaseorderItemId | String | Item Id for purchase order. | ||
| Quantity | Decimal | Quantity of line item. | ||
| Rate | Decimal | Rate of the line item. | ||
| ReverseChargeTaxId | String | Id of the reverse charge tax. | ||
| TaxExemptionCode | String | Code for tax exemption. | ||
| TaxExemptionId | String |
BankRules.TaxExemptionId | Id of tax exemption. | |
| TaxId | String |
Taxes.TaxId | Id of tax. | |
| TaxName | String | Name of tax. | ||
| TaxPercentage | Integer | Percentage applied for tax. | ||
| TaxType | String | Type of tax. | ||
| Unit | String | Number of quantity. | ||
| SKU | String | The SKU of the Line Item. |