Salesorder table

Column Type

Salesorder_Id

String

Is_Pre_Gst

String

Gst_No

String

Gst_Treatment

String

Place_Of_Supply

String

Vat_Treatment

String

Tax_Treatment

String

Zcrm_Potential_Id

String

Zcrm_Potential_Name

String

Salesorder_Number

String

Date

String

Status

String

Shipment_Date

Date

Reference_Number

String

Customer_Id

String

Customer_Name

String

Currency_Id

String

Currency_Code

String

Currency_Symbol

String

Exchange_Rate

Number

Discount_Amount

String

Discount

Number

Discount_Applied_On_Amount

Number

Is_Discount_Before_Tax

Boolean

Discount_Type

String

Estimate_Id

String

Delivery_Method

String

Delivery_Method_Id

String

Is_Inclusive_Tax

Boolean

Shipping_Charge

Number

Adjustment

Number

Adjustment_Description

String

Sub_Total

Number

Tax_Total

Number

Total

Number

Price_Precision

Number

Is_Emailed

Boolean

Notes

String

Terms

String

Template_Id

String

Template_Name

String

Page_Width

String

Page_Height

String

Orientation

String

Template_Type

String

Created_Time

Timestamp

Last_Modified_Time

Timestamp

Created_By_Id

String

Attachment_Name

String

Can_Send_In_Mail

Boolean

Salesperson_Id

String

Salesperson_Name

String

Merchant_Id

String

Merchant_Name

String

Order_Status

String

Bcy_Shipping_Charge

Number

Discount_Percent

Number

Billing_Address_Phone

String

Billing_Address_Country_Code

String

Billing_Address_State_Code

String

Roundoff_Value

Number

Offline_Created_Date_With_Time

Date

Paid_Status

String

Tds_Calculation_Type

String

Tracking_Url

String

Has_Discount

Boolean

Approver_Id

String

Submitter_Id

String

Bcy_Shipping_Charge_Tax

String

Color_Code

String

Submitted_By_Email

String

Tax_Rounding

String

Current_Sub_Status_Id

String

Payment_Terms_Label

String

Is_Taxable

String

Current_Sub_Status

String

Pickup_Location_Id

String

Source

String

Created_Date

Date

Contact_Category

String

Submitted_By_Name

String

Submitted_By

String

Has_Shipping_Address

Boolean

Bcy_Adjustment

Number

Sub_Total_Exclusive_Of_Discount

Number

Shipping_Charge_Tax

String

Invoiced_Status

String

Shipping_Charge_Inclusive_Of_Tax_Formatted

String

Account_Identifier

String

Shipping_Charge_Inclusive_Of_Tax

String

Created_By_Email

String

Integration_Id

String

Last_Modified_By_Id

String

Shipping_Charge_Tax_Name

String

Submitted_Date

Date

Has_Qty_Cancelled

Boolean

Is_Reverse_Charge_Applied

String

Created_By_Name

String

Total_Quantity

Number

Shipping_Address_Id

String

Entity_Tags

String

Submitted_By_Photo_Url

String

Bcy_Sub_Total

Number

Billing_Address_Id

String

Is_Test_Order

Boolean

Shipping_Charge_Tax_Percentage

String

Payment_Terms

Number

Bcy_Total

Number

Is_Adv_Tracking_In_Package

Boolean

Shipping_Charge_Tax_Id

String

Shipping_Charge_Tax_Type

String

Shipping_Charge_Tax_Exemption_Id

String

Shipping_Charge_Tax_Exemption_Code

String

Shipping_Charge_Exclusive_Of_Tax

String

Shipping_Charge_Tax_Formatted

String

Shipping_Charge_Exclusive_Of_Tax_Formatted

String

Transaction_Rounding_Type

String

Sub_Total_Inclusive_Of_Tax

Number

Discount_Total

Number

Bcy_Discount_Total

Number

Bcy_Tax_Total

Number

Computation_Type

String

Reverse_Charge_Tax_Total

String

Contact_Unused_Customer_Credits

Number

Contact_Customer_Balance

Number

Contact_Credit_Limit

Number

Contact_Is_Credit_Limit_Migration_Completed

Boolean

Balance

Number

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

Shipping_Address_Address

String

Shipping_Address_Street2

String

Shipping_Address_City

String

Shipping_Address_State

String

Shipping_Address_Zip

String

Shipping_Address_Country

String

Shipping_Address_Phone

String

Shipping_Address_Country_Code

String

Shipping_Address_State_Code

String

Shipping_Address_Fax

String

Shipping_Address_Attention

String

Has_Attachment

Boolean

Delivery_Date

Date

Email

String

Company_Name

String

Custom_Fields_List

String

Due_By_Days

String

Shipment_Days

String

Due_In_Days

String

Total_Invoiced_Amount

Number

Quantity_Invoiced

Number

Order_Fulfillment_Type

String

Invoice_Conversion_Type

String

Tds_Override_Preference

String

Tax_Specification

String

Tax_Override_Preference

String

Shipping_Charge_Sac_Code

String

Merchant_Gst_No

String

Tax_Reg_No

String

Contact_Contact_Number

String

Documents

Array

Contact_Persons

Array

Line_Items

Array

Taxes

Array

Purchaseorders

Array

Sub_Statuses

Array

Contact_Person_Details

Array

Invoices

Array

Approvers_List

Array

Tds_Summary

String

Examples

UPDATE Salesorder
SET
    Line_Items = REPLACE (
        Line_Items,
        '{""quantity"": 3',
        '{""quantity"": 4'
    )
WHERE
    Salesorder_Id = '579676000000119019'
DELETE FROM Salesorder
WHERE
    Salesorder_Id = '579676000000119019'