CreditNotesLineItems
List line items of Credit Notes.
Table Specific Information
Select
The add-in 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 add-in.
- CreditNoteId supports the '=' comparison.
- ItemId supports the '=' comparison.
- TaxId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM CreditNotesLineItems WHERE CreditNoteId = '1123344555' SELECT * FROM CreditNotesLineItems WHERE ItemId = '1123344555' SELECT * FROM CreditNotesLineItems WHERE TaxId = '1123344555'
Columns
| Name | Type | References | Description |
| CreditNoteId | String |
CreditNotes.Id | Unique ID of the credit note generated by the server |
| AccountId | String | Unique ID to denote the account.. | |
| AccountName | String | Name of the account.. | |
| Code | String | Unique code for the underlying line item of a credit note.. | |
| Description | String | A brief description about the item.. | |
| InvoiceId | String | Invoice ID of the required invoice.. | |
| InvoiceItemId [KEY] | Long | line_item_id of the underlying items in the invoice. | |
| IsItemShipped | Boolean | Defines the shipping status of the line item in the corresponding sales order.. | |
| IsReturnedToStock | Boolean | Defines the receivability of the items in the sales return.. | |
| ItemId | String | Defines the receivability of the items in the sales return.. | |
| Name | String | Name of the credit. | |
| ProductType | String | Enter goods/services. | |
| Quantity | Integer | Quantity of the item included.. | |
| SalesreturnItemId | Long | line_item_id of the underlying items in the sales return.. | |
| SerialNumbers | String | Enter serial number. | |
| TaxId | String | Unique ID to denote the tax associated with the credit note.. | |
| Type | Integer | Type. | |
| WarehouseId | Long | Warehouse Id. | |
| WarehouseName | String | Warehouse Name. |