BillLineItems
Get line items related to bills
Table Specific Information
Select
The provider will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
- BillId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM BillLineItems WHERE BillId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| BillId | Long |
Bills.Id | Unique ID generated by the server. |
| AccountId | Long | Account Id. | |
| AccountName | String | Account Name. | |
| BCYRate | Double | BCY Rate. | |
| CustomerId | Long | Customer Id. | |
| CustomerName | String | Customer Name. | |
| Description | String | Desciption of line item. | |
| Discount | Double | Discount. | |
| ImageName | String | Image Name. | |
| ImageType | String | Image Type. | |
| InvoiceId | Long | Invoice Id. | |
| InvoiceNumber | String | Invoice Number. | |
| IsBillable | Boolean | Checks whether the line item is billable or not. | |
| IsComboProduct | Boolean | Check whether the line item is a combo product. | |
| IsDropShippedItem | Boolean | Checks whether the item shipment has been dropped. | |
| ItemCustomFields | String | Custom Fields. | |
| ItemId | Long |
Items.Id | Item Id of line item. |
| ItemOrder | Integer | Order of the line item, starting from 0 | |
| ItemTotal | Double | Item total. | |
| ItemType | String | Item type. | |
| LineItemId [KEY] | Long | Unique ID generated by the server for each line item.. | |
| Name | String | Name of line item. | |
| Quantity | Integer | Quantity of line item. | |
| Unit | String | Unit of line item. | |
| PriceBookId | Long | PriceBook Id. | |
| ProjectId | Long | Project Id. | |
| ProjectName | String | Project Name. | |
| PurchaseOrderItemId | Long | Purchase Order Item Id. | |
| Rate | Integer | Rate. | |
| ReceiveItemId | Long | Receive Item Id. | |
| SKU | String | SKU. | |
| TaxId | Long | Tax Id. | |
| WarehouseId | Long | Warehouse Id. | |
| WarehouseName | String | Warehouse Name. | |
| AccountCode | String | Account code. | |
| DiscountAmount | Double | Discount amount. | |
| Discounts | String | Discounts. | |
| HeaderId | Long | ID of the header. | |
| ImageDocumentId | Long | ID of the image document. | |
| ItemCode | String | Code of the item. | |
| LineItemCategory | String | Category of the line item. | |
| LineItemTaxes | String | Line item taxes. | |
| LocationId | Long | ID of the location. | |
| MarkupPercent | Double | Markup percentage. | |
| PackageDetails | String | Package details. | |
| PurchaseRequestItems | String | Purchase request items. | |
| QuantityReceived | Double | Quantity received. | |
| SalesMargin | Double | Sales margin. | |
| Tags | String | Tags. | |
| DiscountAccountId | Long | ID of the discount account. | |
| DiscountAccountName | String | Name of the discount account. | |
| HeaderName | String | Name of the header. | |
| ItemMatchingType | String | Item matching type. | |
| LocationName | String | Name of the location. | |
| PurchaseorderId | Long | ID of the purchase order. | |
| ReceiptLineItemId | Long | ID of the receipt line item. | |
| ReceiveId | Long | ID of the receive. | |
| ReceiveLineItems | String | Receive line items. | |
| SalesRate | Double | Sales rate. | |
| TaxName | String | Name of the tax. | |
| TaxPercentage | Double | Tax percentage. | |
| TaxType | String | Type of the tax. |