VendorCreditLineItems
Retrieves list of line items from vendor credits.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- VendorCreditId supports the '=' and IN operators.
NOTE: VendorCreditId is required to query VendorCreditLineItems.
The rest of the filter is executed client-side in the add-in
For example:
SELECT * FROM VendorCreditLineItems WHERE VendorCreditId = '1894545000000083308'
SELECT * FROM VendorCreditLineItems WHERE VendorCreditId IN (SELECT VendorCreditId FROM VendorCredits)
SELECT * FROM VendorCreditLineItems WHERE VendorCreditId IN ('1894545000000083308','1894545000000083309')
Columns
| Name | Type | References | SupportedOperators | Description |
| LineItemId [KEY] | String | Id of a line item. | ||
| VendorCreditId | String |
VendorCredits.VendorCreditId | Id of a vendor credit. | |
| AccountId | String |
BankAccounts.AccountId | Id of the Bank Account. | |
| AccountName | String | Name of the account. | ||
| BcyRate | Decimal | Rate of a Base Currency. | ||
| CustomFields | String | Custom Fields added for the line item. | ||
| Description | String | Description of the vendor credit line item. | ||
| GstTreatmentCode | String | Treatement code of GST. | ||
| HasProductTypeMismatch | Boolean | Check if the product type has mismatch. | ||
| HsnOrSac | String | HSN Code. | ||
| ItcEligibility | String | Eligibility of Input Tax Credit. | ||
| ItemId | String |
Items.ItemId | Id of an item. | |
| ItemOrder | Integer | Order of an item. | ||
| ItemTotal | Decimal | Total of an item. | ||
| ItemType | String | Type of an item. | ||
| Name | String | Name of a line item. | ||
| PricebookId | String | Id of a price book. | ||
| ProductType | String | Product type of vendor credit. | ||
| ProjectId | String |
Projects.ProjectId | Id of a project. | |
| Quantity | Decimal | Quantity of vendor credit. | ||
| Rate | Decimal | Rate of vendor credit. | ||
| ReverseChargeTaxId | String | Id of the reverse charge tax. | ||
| Tags | String | Details of tags related to vendor credit line items. | ||
| TaxExemptionCode | String | Code of tax exemption. | ||
| TaxExemptionId | String |
BankRules.TaxExemptionId | Id of tax exemption. | |
| TaxId | String |
Taxes.TaxId | Id of tax. | |
| TaxName | String | Name of tax. | ||
| TaxPercentage | Integer | Percentage of tax. | ||
| TaxType | String | Type of tax. | ||
| Unit | String | Unit of line items in vendor credit. | ||
| SKU | String | The SKU of the Line Item. |