BillLineItems
Get the details of a line items of bills.
Table Specific Information
Select
The adapter 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 adapter.
Note: BillId is required in order to query BillLineItems.
- BillId supports the '=' comparison.
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. |