PurchaseOrders
Create, update, delete, and query information regarding purchase orders. Not available in free and standard ZohoCRM accounts.
Table-Specific Information
Select
This table supports COQL for filtering, meaning that most filters comparing columns to values are submitted server-side.
Insert
INSERT INTO PurchaseOrders (Subject, ProductDetails) VALUES ('Purchase Order', '[ { "product": { "Product_Code": "12342321", "name": "Egg", "id": "3276571000000184076" }, "quantity": 1024, "Discount": 0, "total_after_discount": 1239.04, "net_total": 1239.04, "book": null, "Tax": 0, "list_price": 1.21, "unit_price": 1.21, "quantity_in_stock": -1024, "total": 1239.04, "id": "3276571000000184104", "product_description": null, "line_tax": [] } ]')
Required fields: Subject, Purchase_Items
Any field which is not read-only (ReadOnly = false in the table below) can be inserted.
Delete
You must specify the Id in the WHERE clause when executing a delete against this table.
DELETE FROM PurchaseOrders WHERE Id = '3152079000000153079'
Update
You must specify the Id in the WHERE clause when executing an update against this table.
UPDATE PurchaseOrders SET Description = 'Changed from the API.' WHERE Id = '3152079000000492001'
Required fields: Id.
Any field which is not read-only (ReadOnly = false in the table below) can be updated.
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
The unique identifier for this record. |
PurchaseOrderOwner_Id | String | False |
The Id of the owner of the purchase order. |
PurchaseOrderOwner_FirstName | String | False |
The First Name of the owner of the purchase order. |
PurchaseOrderOwner_LastName | String | False |
The Last Name of the owner of the purchase order. |
PONumber | String | False |
The number of the purchase order. |
Subject | String | False |
The subject of the purchase order. |
VendorName_Id | String | False |
The Id of the vendor of the purchase order. |
RequisitionNumber | String | False |
The requisition number of the purchase order. |
TrackingNumber | String | False |
The tracking number of the purchase order. |
ContactName_Id | String | False |
The Id of the contanct regarding this purchase order. |
PODate | Date | False |
The date listed in this purchase order. |
DueDate | Date | False |
The due date of this purchase order. |
Carrier | String | False |
The carrier listed in this purchase order. |
ExciseDuty | Double | False |
The amount of excise duty on this purchase order. |
SalesCommission | Double | False |
The amount of commision for the sale listed on this purchase order. |
Status | String | False |
The status of the purchase order. |
CreatedBy_Id | String | False |
The Id of the User who created the record. |
ModifiedBy_Id | String | False |
The Id of the User who modified the record. |
ModifiedBy_FirstName | String | False |
The First Name of the User who modified the record. |
ModifiedBy_LastName | String | False |
The Last Name of the User who modified the record. |
CreatedTime | Datetime | False |
The time when the record was created. |
Tag | String | False |
A list of tags regarding this purchase order. |
ModifiedTime | Datetime | False |
The time when the record was modified. |
BillingStreet | String | False |
The billing street of the purchase order. |
ShippingStreet | String | False |
The shipping street of the purchase order. |
BillingCity | String | False |
The billing city of this purchase order. |
ShippingCity | String | False |
The shipping city of this purchase order. |
BillingState | String | False |
The billing state of this purchase order. |
ShippingState | String | False |
The shipping state of this purchase order. |
BillingCode | String | False |
The billing code of this purchase order. |
ShippingCode | String | False |
The shipping code of this purchase order. |
BillingCountry | String | False |
The billing country of this purchase order. |
ShippingCountry | String | False |
The shipping country of this purchase order. |
ProductDetails | String | False |
A json aggregate of the product details. |
SubTotal | Double | True |
The sub total price of the purchase order. |
Discount | Double | False |
The discount listed in this purchase order. |
Tax | Double | True |
The amount of tax listed in this purchase order. |
Adjustment | Double | False |
The amount of adjustment regarding this purchase order. |
GrandTotal | Double | True |
The grand total of this purchase order. |
TermsandConditions | String | False |
The terms and conditions regarding this purchase order. |
Description | String | False |
The description of this purchase order. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Word | String |
Used to search for a specific word in records. |
DuplicateCheckFields | String |
The field/s to be used for checking in an upsert. |
Converted | Boolean |
Set to true to return only converted records. |
Approved | Boolean |
Set to true to return only approved records. |
CustomViewId | String |
The custom view Id to be used for filtering this record. |
PurchaseItems | String |
Purchase Items SubForm. This column can only be used for Insert and Update. |