PurchaseOrders

Read, Insert, Update and Delete Purchase Orders.

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 PurchaseOrders WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the PurchaseorderNumber, VendorId 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 Purchaseorders (PurchaseorderNumber, VendorId, LineItems) VALUES ('PO-00006', 3249056000000085109, '[{\"item_id\":3249056000000113080,\"account_id\":3249056000000034003, \"name\": \"Laptop-white/15inch/dell\", \"description\": \"Just a sample description.\",  \"item_order\": 1, \"bcy_rate\": 122,  \"purchase_rate\": 122,  \"quantity\": 2,  \"quantity_received\": 2,  \"unit\": \"qty\", \"item_total\": 244, \"warehouse_id\": 3249056000000138013, \"salesorder_item_id\": 3249056000000113014}]')

Update

Update can be executed by specifying the PurchaseorderNumber, VendorId and LineItems in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Purchaseorders SET PurchaseorderNumber = '90', VendorId = '876', LineItems = [{\"item_id\":3249056000000113080,\"account_id\":3249056000000034003, \"name\": \"Laptop-white/15inch/dell\", \"description\": \"Just a sample description.\",  \"item_order\": 1, \"bcy_rate\": 122,  \"purchase_rate\": 122,  \"quantity\": 2,  \"quantity_received\": 2,  \"unit\": \"qty\", \"item_total\": 244, \"warehouse_id\": 3249056000000138013, \"salesorder_item_id\": 3249056000000113014}]' WHERE Id = '99800006'

Delete

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

DELETE FROM PurchaseOrders WHERE Id = '3350895000000089001'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Unique ID generated by the server for the Purchase Order.
CreatedTime	Datetime	True		Time at which the Purchase Order was created.
CurrencyCode	String	True		Currency code.
CurrencyId	Long	True		Unique ID generated by the server for the currency.
Date	Date	False		Date of Purchase Order
DeliveryDate	Date	False		Date of delivery of the product.
IsBackorder	Boolean	False		This indicates whether it is a Back order or not.
IsDropShipment	Boolean	False		Default is FALSE, in case of drop shipment value must be TRUE.
LastModifiedTime	Datetime	True		Time at which the Purchase Order details were last modified.
PricePrecision	Integer	True		The precision level for the price decimal point in a Purchase Order.
PurchaseorderNumber	String	False		Purchase Order number.
Receives	String	True		Receives
ReferenceNumber	String	False		Reference number of purchase order.
Status	String	True		Status of Purchase Order.
Total	Integer	True		Total amount of the Purchase Order.
VendorId	Long	False		Unique ID generated by the server for the vendor.
VendorName	String	False		Name of the vendor.
LineItems	String	False		Line Items of the Purchase Order.
Bills	String	False		Bills of purchase order.
Purchasereceives	String	False		Purchase Receives of the purchase order
BillingAddressAddress	String	False		Address of billing address.
BillingAddressCity	String	False		City of billing address.
BillingAddressCountry	String	False		Country of billing address.
BillingAddressFax	String	False		Fax of billing address.
BillingAddressState	String	False		State of billing address.
BillingAddressZip	Integer	False		Zip of billing address.
DeliveryAddressAddress	String	False		Address of address.
DeliveryAddressCity	String	False		City of address.
DeliveryAddressCountry	String	False		Country of address.
DeliveryAddressFax	String	False		Fax
DeliveryAddressState	String	False		State of address.
DeliveryAddressZip	Integer	False		Zip code of address.