Purchase_Order table

Column Type

Purchaseorder_Id

String

Vat_Treatment

String

Gst_No

String

Gst_Treatment

String

Tax_Treatment

String

Is_Pre_Gst

String

Source_Of_Supply

String

Destination_Of_Supply

String

Place_Of_Supply

String

Pricebook_Id

String

Pricebook_Name

String

Is_Reverse_Charge_Applied

String

Purchaseorder_Number

String

Date

String

Expected_Delivery_Date

Date

Discount

Number

Discount_Account_Id

String

Is_Discount_Before_Tax

Boolean

Reference_Number

String

Status

String

Vendor_Id

String

Vendor_Name

String

Crm_Owner_Id

String

Currency_Id

String

Currency_Code

String

Currency_Symbol

String

Exchange_Rate

Number

Delivery_Date

Date

Is_Emailed

Boolean

Is_Inclusive_Tax

Boolean

Sub_Total

Number

Tax_Total

Number

Total

Number

Acquisition_Vat_Total

String

Reverse_Charge_Vat_Total

String

Billing_Address_Address

String

Billing_Address_Street2

String

Billing_Address_City

String

Billing_Address_State

String

Billing_Address_Zip

String

Billing_Address_Country

String

Billing_Address_Fax

String

Billing_Address_Attention

String

Notes

String

Terms

String

Ship_Via

String

Ship_Via_Id

String

Attention

String

Delivery_Org_Address_Id

String

Delivery_Customer_Id

String

Delivery_Address_Zip

String

Delivery_Address_Is_Verifiable

String

Delivery_Address_State

String

Delivery_Address_Address1

String

Delivery_Address_Address2

String

Delivery_Address_Is_Valid

String

Delivery_Address_City

String

Delivery_Address_Country

String

Delivery_Address_Address

String

Delivery_Address_Email

String

Delivery_Address_Is_Primary

String

Delivery_Address_Organization_Address_Id

String

Delivery_Address_Phone

String

Delivery_Address_Is_Verified

String

Price_Precision

Number

Attachment_Name

String

Can_Send_In_Mail

Boolean

Template_Id

String

Template_Name

String

Page_Width

String

Page_Height

String

Orientation

String

Template_Type

String

Created_By_Id

String

Created_Time

Timestamp

Last_Modified_Time

Timestamp

Can_Mark_As_Bill

Boolean

Can_Mark_As_Unbill

Boolean

Order_Status

String

Tds_Calculation_Type

String

Submitted_By_Name

String

Contact_Category

String

Payment_Terms

Number

Tax_Rounding

String

Current_Sub_Status_Id

String

Client_Viewed_Time

Timestamp

Is_Viewed_By_Client

Boolean

Is_Adv_Tracking_In_Receive

Boolean

Billed_Status

String

Billing_Address_Id

String

Color_Code

String

Sub_Total_Inclusive_Of_Tax

Number

Submitted_Date

Date

Current_Sub_Status

String

Billing_Address_Phone

String

Submitted_By_Email

String

Has_Qty_Cancelled

Boolean

Total_Quantity

Number

Submitted_By_Photo_Url

String

Tax_Override_Preference

String

Discount_Applied_On_Amount

Number

Adjustment

Number

Adjustment_Description

String

Discount_Amount

Number

Submitter_Id

String

Discount_Type

String

Payment_Terms_Label

String

Submitted_By

String

Approver_Id

String

Delivery_Customer_Address_Id

String

Has_Attachment

Boolean

Company_Name

String

Due_In_Days

String

Quantity_Marked_As_Received

Number

Delivery_Days

String

Due_By_Days

String

Quantity_Yet_To_Receive

Number

Tax_Override

String

Tds_Override_Preference

String

Tds_Summary

String

Is_Discount_Tax_Inclusive

String

Tax_Reg_No

String

Documents

Array

Contact_Persons

Array

Line_Items

Array

Taxes

Array

Acquisition_Vat_Summary

String

Reverse_Charge_Vat_Summary

String

Bills

Array

Sub_Statuses

Array

Approvers_List

Array

Salesorders

Array

Receives

Array

Examples

UPDATE Purchase_order
SET
    Line_Items = REPLACE (Line_Items, '{"quantity": 3', '{"quantity": 4')
WHERE
    purchaseorder_id = '579676000000092047'
DELETE FROM Purchase_Order
WHERE
    PurchaseOrder_Id = '579676000000092047'