BillLineItems
Get the details of a line items of bills.
Table Specific Information
Select
The component uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- BillId supports the '=' comparison.
NOTE: BillId is required to query BillLineItems.
The rest of the filter is executed client-side in the component.
For example:
SELECT * FROM BillLineItems WHERE BillId = '1894253000000085259'
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. |