CreditNoteLineItems
Retrieves details of line items from existing Credit Notes.
Table Specific Information
Select
The adapter will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the adapter.
Note: CreditnoteId is required in order to query CreditNoteLineItems.
- CreditnoteId supports the '=' comparison.
SELECT * FROM CreditNoteLineItems WHERE CreditnoteId = '1895452000000083136'
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. |