VendorCreditsLineItems
Get line items related to vendor credit
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.
- LineItemId supports the '=' comparison.
- VendorCreditId supports the '=' comparison.
- ItemId supports the '=' comparison.
- AccountId supports the '=' comparison.
- TaxId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM VendorCreditsLineItems WHERE LineItemId = '3350895000000089001' SELECT * FROM VendorCreditsLineItems WHERE VendorCreditId = '983872973'
Columns
| Name | Type | References | Description |
| VendorCreditId | Long | ID of the Vendor Credit | |
| ItemId | String | Item Id. | |
| LineItemId [KEY] | String | Line Item Id. | |
| AccountId | String | ID of the account, the line item is associated with | |
| Name | String | Name of the line item. | |
| HSNOrSAC | String | HSN Code | |
| ReverseChargeTaxId | Long | ID of the Reverse Charge | |
| WarehouseId | Boolean | Warehouse Id. | |
| Description | Boolean | Description of the line item. | |
| ItemOrder | String | Order of the line item | |
| Quantity | String | Quantity of the line item. | |
| Unit | String | Unit of the line item e.g. kgs, Nos. | |
| Rate | Integer | Rate of the line item. | |
| TaxId | Long | ID of the Tax associated with the Vendor Credit | |
| TaxTreatmentCode | String | Tax Treatment Code. | |
| Tags | String | Tags. | |
| ItemCustomFields | Integer | Item Custom Fields. | |
| ProjectId | Long | Project Id. | |
| ProjectName | String | Project Name. | |
| AccountName | String | Name of the account. | |
| BcyRate | Double | Rate in base currency. | |
| BillItemId | Long | ID of the bill item. | |
| Discount | Double | Discount. | |
| DiscountAccountId | Long | ID of the discount account. | |
| ImageDocumentId | Long | ID of the image document. | |
| IsComboProduct | Boolean | Whether this is a combo product. | |
| ItemCode | String | Code of the item. | |
| ItemTotal | Double | Total of the item. | |
| ItemType | String | Type of the item. | |
| LineItemCategory | String | Category of the line item. | |
| LineItemTaxes | String | Line item taxes. | |
| LocationId | Long | ID of the location. | |
| PackageDetails | String | Package details. | |
| PricebookId | Long | ID of the price book. | |
| Sku | String | SKU. | |
| TaxName | String | Name of the tax. | |
| TaxPercentage | Double | Tax percentage. | |
| DiscountAccountName | String | Name of the discount account. | |
| DiscountAmount | Double | Discount amount. | |
| Discounts | String | Discounts. | |
| LocationName | String | Name of the location. | |
| TaxType | String | Type of the tax. |