CreditNotesLineItems
Get line items related to 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. | |
| 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. |