VendorCreditsLineItems
List line items of Vendor Credits.
Table Specific Information
Select
The connector 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 connector.
- 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. |