CreditNotesLineItems
List line items of Credit Notes.
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.
- 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. |