VendorCreditLineItems
Retrieves list of line items from vendor credits.
Table Specific Information
Select
The connector 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 connector
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. |