VendorCreditsLineItems
Get line items related to vendor credit
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. | |
| 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. |