CreditNoteLineItems

Retrieves details of line items from existing Credit Notes.

Table Specific Information

Select

The cmdlet uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

CreditnoteId supports the '=' and IN operators.

NOTE: CreditnoteId is required to query CreditNoteLineItems.

The rest of the filter is executed client-side in the cmdlet.

For example:

    SELECT * FROM CreditNoteLineItems WHERE CreditnoteId = '1895452000000083136'
	SELECT * FROM CreditNoteLineItems WHERE CreditnoteId IN (SELECT CreditNoteID FROM CreditNotes)
	SELECT * FROM CreditNoteLineItems WHERE CreditnoteId IN ('1895452000000083136','1895452000000083137')

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.
SKU	String			The SKU of the Line Item.

Cmdlets for Zoho Books

CreditNoteLineItems

Table Specific Information

Select

Columns