VendorCreditsLineItems
List line items of Vendor Credits.
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. |