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
DuplicateCheckFields	String	The field/s to be used for checking in an upsert.
CustomViewId	Long	The custom view Id to be used for filtering this record. Will work when useCOQL=false.
PurchaseItems	String	Purchase Items SubForm. This column can only be used for Insert and Update.

Power BI Connector for Zoho CRM