PurchaseOrders
Read, Insert, Update and Delete Purchase Orders.
Table Specific Information
Select
The connector 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 connector.
- 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. |