CreditNotesLineItems
Get line items related to 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. | |
| BcyRate | Double | Rate in base currency. | |
| ComboType | String | Type of combo product. | |
| Discount | Double | Discount. | |
| ImageDocumentId | Long | ID of the image document. | |
| IsComboProduct | Boolean | Whether this is a combo product. | |
| ItemCode | String | Code of the item. | |
| ItemCustomFields | String | Custom fields for the item. | |
| ItemOrder | Integer | Order of the item. | |
| ItemTotal | Double | Total of the item. | |
| ItemType | String | Type of the item. | |
| LineItemCategory | String | Category of the line item. | |
| LineItemTaxes | String | Line item taxes. | |
| LocationId | Long | ID of the location. | |
| MappedItems | String | Mapped items. | |
| PackageDetails | String | Package details. | |
| PricebookId | Long | ID of the price book. | |
| ProjectId | Long | ID of the project. | |
| Rate | Double | Rate. | |
| Sku | String | SKU. | |
| Tags | String | Tags. | |
| CanSkipStockTracking | Boolean | Whether stock tracking can be skipped. | |
| DiscountAccountId | Long | ID of the discount account. | |
| DiscountAccountName | String | Name of the discount account. | |
| DiscountAmount | Double | Discount amount. | |
| Discounts | String | Discounts. | |
| InternalName | String | Internal name. | |
| IsCreditOnlyItem | Boolean | Whether this is a credit only item. | |
| IsModifierItem | Boolean | Whether this is a modifier item. | |
| LineItemId | Long | ID of the line item. | |
| LocationName | String | Name of the location. | |
| PricingScheme | String | Pricing scheme. | |
| SalesMargin | Double | Sales margin. | |
| TaxName | String | Name of the tax. | |
| TaxPercentage | Double | Tax percentage. | |
| TaxType | String | Type of the tax. | |
| Unit | String | Unit of the line item. |