BillLineItems
Get line items related to bills
Table Specific Information
Select
The add-in 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 add-in.
- 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. |