Power BI Connector for Zoho Inventory

Build 24.0.9062

CreditNotesLineItems

List line items of Credit Notes.

Table Specific Information

Select

The 本製品 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 本製品.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062