ADO.NET Provider for Zoho Inventory

Build 24.0.9062

Pricebooks

Read, Insert, Update and Delete Pricebooks.

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

  • Id supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Pricebooks WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the Name, CurrencyId, PricebookType, IsIncrease and SalesOrPurchaseType 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 Pricebooks (Name, CurrencyId, PricebookType, IsIncrease, SalesOrPurchaseType, RoundingType) VALUES ('mylist', 3350895000000075159, 'fixed_percentage', true, 'sales', 'round_to_dollar_minus_01')

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 Pricebooks SET Name = 'newname', PricebookType = 'fixed_percentage', CurrencyId = 65, IsIncrease = true, SalesOrPurchaseType = 'sales' WHERE Id = '3350895000000089001'

Delete

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

DELETE FROM Pricebooks WHERE Id = '3350895000000089001'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Unique ID generated by server for the price book

CurrencyCode String True

Code based on currency

CurrencyId Long False

The currency id of the currency

DecimalPlace Integer True

Decimal place for pricebook.

Description String False

Description about the pricebook

IsDefault Boolean True

To check the default pricebook.

IsIncrease Boolean False

Mark up or Mark down to discounts.

Name String False

Name of the pricebook

Percentage Integer False

About percentage of discounts

PricebookItems String False

Items for the price book

PricebookType String False

Type of the pricebook.

RoundingType String False

Type of the rounding

SalesOrPurchaseType String False

Whether its sales or purchase type

Status String False

Status of the price book

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