SalesOrders

Tracks confirmed sales orders with shipment status, billing details, and linked invoices; not available in free or standard editions.

Table-Specific Information

Select

This table supports the COQL and BULK APIs for filtering, meaning that most filters comparing columns to values are submitted server-side.

Insert

INSERT INTO SalesOrders (Subject, AccountName_Id, OrderedItems) VALUES ('Sales Order', '1021046000000427104', '[
  {
    "Product_Name": {
      "id": "1021046000000414457"
    },
    "Quantity": 1024,
    "Discount": 99,
    "Tax": 13,
    "List_Price": 176.21,
    "Description": "test description 3"
  }
]');

Required fields for REST API: Subject, OrderedItems.

Required fields for BULK API: Subject, AccountName_Id, OrderedItems.

Any field which is not read-only (ReadOnly = false in the table below) can be inserted.

Please note that the REST API honors only the 'id' field of the 'Product_Name' aggregate in the OrderedItems column. The BULK API does not accept any other field in this aggregate.

Delete

You must specify the Id in the WHERE clause when executing a delete against this table.

DELETE FROM SalesOrders WHERE Id = '3152079000000153079'

Update

You must specify the Id in the WHERE clause when executing an update against this table.

UPDATE SalesOrders SET Description = 'Changed from the API.' WHERE Id = '3152079000000493027'

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	True	Unique identifier of the sales order.
Billing_Latitude	Double	False	Latitude coordinate of the sales order's billing address.
Billing_Longitude	Double	False	Longitude coordinate of the sales order's billing address.
Shipping_Latitude	Double	False	Latitude coordinate of the sales order's shipping address.
Shipping_Longitude	Double	False	Longitude coordinate of the sales order's shipping address.
Customer_No	String	False	Customer number associated with the sales order.
SO_Number	String	True	Sales order number.
Subject	String	False	Subject or title of the sales order.
Deal_Name_Id	String	False	Identifier of the related deal.
Purchase_Order	String	False	Purchase order number associated with the sales order.
Quote_Name_Id	String	False	dentifier of the related quote.
Due_Date	Date	False	Date by which the sales order is due.
Pending	String	False	Represents pending items or actions on the sales order.
Contact_Name_Id	String	False	Identifier of the associated contact.
Carrier	String	False	Name of the shipping carrier for the sales order.
Excise_Duty	Decimal	False	Amount of excise duty applied.
Sales_Commission	Decimal	False	Commission earned on the sales order.
Status	String	False	Current status of the sales order.
Account_Name_Id	String	False	Identifier of the associated account.
Owner_Id	String	False	Identifier of the user who owns the sales order.
Owner_FirstName	String	True	First name of the sales order owner.
Owner_LastName	String	True	Last name of the sales order owner.
Owner_Email	String	True	Email address of the sales order owner.
Created_By_Id	String	False	Identifier of the user who created the sales order.
Modified_By_Id	String	False	Identifier of the user who last modified the sales order.
Modified_By_FirstName	String	True	First name of the user who last modified the sales order.
Modified_By_LastName	String	True	Last name of the user who last modified the sales order.
Modified_By_Email	String	True	Email address of the user who last modified the sales order.
Created_Time	Datetime	False	Date and time when the sales order was created.
Modified_Time	Datetime	False	Date and time when the sales order was last modified.
Tag	String	False	Tags associated with the sales order.
Sub_Total	String	True	Subtotal amount before tax and discounts.
Discount	Decimal	False	Discount applied to the sales order.
Tax	Decimal	False	Total tax amount applied to the sales order.
Adjustment	Decimal	False	Any manual adjustment applied to the total.
Grand_Total	String	True	Final total amount after taxes, discounts, and adjustments.
Terms_and_Conditions	String	False	Terms and conditions associated with the sales order.
Description	String	False	Additional notes or description of the sales order.
Id_CustomModule	Long	True	Record identifier used internally.
Locked__s	Bool	True	Indicates whether the record is locked for editing.
Last_Activity_Time	Datetime	False	Date and time of the last activity on the record.
Billing_Country	String	False	Billing country.
Billing_Flat_House_No_Building_Apartment_Name	String	False	Flat/house number, building, or apartment name portion of the billing address.
Billing_Street	String	False	Billing street address.
Billing_City	String	False	Billing city.
Billing_State	String	False	Billing state.
Billing_Code	String	False	Billing postal code.
Shipping_Country	String	False	Shipping country.
Shipping_Flat_House_No_Building_Apartment_Name	String	False	Flat/house number, building, or apartment name portion of the shipping address.
Shipping_Street	String	False	Shipping street address.
Shipping_City	String	False	Shipping city.
Shipping_State	String	False	Shipping state.
Shipping_Code	String	False	Shipping postal code.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
Ordered_Items	String	List of items included in the sales order.
DuplicateCheckFields	String	The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field.
Trigger	String	To trigger the rule while inserting record into CRM account.

ADO.NET Provider for Zoho CRM