CreditNoteLineItems
Retrieves details of line items from existing Credit Notes.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- CreditnoteId supports the '=' and IN operators.
NOTE: CreditnoteId is required to query CreditNoteLineItems.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM CreditNoteLineItems WHERE CreditnoteId = '1895452000000083136'
SELECT * FROM CreditNoteLineItems WHERE CreditnoteId IN (SELECT CreditNoteID FROM CreditNotes)
SELECT * FROM CreditNoteLineItems WHERE CreditnoteId IN ('1895452000000083136','1895452000000083137')
Columns
| Name | Type | References | SupportedOperators | Description |
| CreditnoteId | String |
CreditNotes.CreditnoteId | Id of credit note. | |
| LineItemId [KEY] | String | Id of line item. | ||
| AccountId | String |
BankAccounts.AccountId | Id of the Bank Account. | |
| AccountName | String | Name of the account. | ||
| BcyRate | Decimal | Rate of Base Currency. | ||
| CustomFields | String | Custom Fields. | ||
| Description | String | Description of the credit note line item. | ||
| Discount | String | Discount given to specific item in credit note. | ||
| DiscountAmount | Decimal | Amount of discount. | ||
| GstTreatmentCode | String | Treatement codes for GST. | ||
| HasProductTypeMismatch | Boolean | Check if the credit note item contains product type mismatch. | ||
| HsnOrSac | String | HSN Code. | ||
| ImageDocumentId | String | Id of image document. | ||
| InvoiceId | String |
Invoices.InvoiceId | Id of an invoice. | |
| InvoiceItemId | String | Id of an invoice item. | ||
| ItemId | String |
Items.ItemId | Id of an item. | |
| ItemOrder | Integer | Order of an item. | ||
| ItemTotal | Decimal | Total number of an item. | ||
| ItemType | String | Type of an item. | ||
| Name | String | Name of the credit note. | ||
| PricebookId | String | Id of price book. | ||
| ProductType | String | Type of product. | ||
| ProjectId | String |
Projects.ProjectId | Id of project. | |
| Quantity | Double | Quantity of items in credit note. | ||
| Rate | Decimal | Rate of the line item. | ||
| ReverseChargeTaxId | String | Id of the reverse charge tax. | ||
| Tags | String | Details of tags related to credit note line items. | ||
| TaxId | String |
Taxes.TaxId | Id of tax. | |
| TaxName | String | Name of the tax. | ||
| TaxPercentage | Integer | Percentage applied for tax. | ||
| TaxType | String | Type of tax. | ||
| Unit | String | Number of quantity. | ||
| SKU | String | The SKU of the Line Item. |