Power BI Connector for Zoho Inventory

Build 24.0.9062

InvoicesLineItems

Line items of Invoices.

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

  • LineItemId supports the '=' comparison.
  • WarehouseId supports the '=' comparison.
  • TaxId supports the '=' comparison.
  • InvoiceId supports the '=' comparison.
  • Name supports the '=' comparison.
  • ItemId supports the '=' comparison.
  • Description supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM InvoicesLineItems WHERE WarehouseId = '3350895000000089001'

SELECT * FROM InvoicesLineItems WHERE InvoiceId = '1937623621'

Insert

Insert can be executed by specifying the CustomerId and LineItems column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO InvoicesLineItems (Description) VALUES ('test')

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE InvoicesLineItems SET Description = 'test2' WHERE LineItemId = '3285934000000136008'

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM InvoicesLineItems WHERE LineItemId = '3350895000000089001'

Columns

Name Type References Description
LineItemId [KEY] Long The line item ID.
WarehouseId Long

Warehouses.Id

Unique ID generated by the server for the ware houses.
TaxId Long

Taxes.Id

ID of the tax or tax group applied to the estimate.
InvoiceId Long

Invoices.Id

ID of invoice.
ItemId Long

Items.Id

Unique item id.
ProjectId String Unique ID of the projet associated to an invoice.
ExpenseId String Unique ID of the expenses associated.
BcyRate Integer Base currency rate.
Discount Integer Discount applied to the invoice..
DiscountAmount Integer The discount amount on the line item
ExpenseReceiptName String Name of the expense receipt associated.
HsnOrSac Integer Add HSN/SAC code for your goods/services.
ItemOrder Integer The order of the line item_order.
ItemTotal Integer The total amount of the line items.
Description String The description of the line items.
Name String The name of the line item.
Quantity Integer The quantity of line item.
Rate Integer Rate of the line item..
TaxName String The name of the tax.
TaxPercentage Double The percentage of tax levied.
TaxType String The type of the tax.
TimeEntryIds String Unique ID of all the time entries associated to the linked project.
Unit String Unit of the line item.

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