Read, Insert, Update and Delete Pricebooks.

Table Specific Information

Select

The add-in 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 add-in.

• 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