ADO.NET Provider for Zoho CRM

Build 25.0.9434

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 COQL 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.

CustomerNo. String False

Customer number associated with the sales order.

SONumber String True

Sales order number.

Subject String False

Subject or title of the sales order.

DealName_Id String False

Identifier of the related deal.

DealName_Name String True

Name of the related deal.

PurchaseOrder String False

Purchase order number associated with the sales order.

QuoteName_Id String False

Identifier of the related quote.

QuoteName_Name String True

Name of the related quote.

DueDate Date False

Date by which the sales order is due.

Pending String False

Represents pending items or actions on the sales order.

ContactName_Id String False

Identifier of the associated contact.

ContactName_Name String True

Name of the associated contact.

Carrier String False

Name of the shipping carrier for the sales order.

ExciseDuty Decimal False

Amount of excise duty applied.

SalesCommission Decimal False

Commission earned on the sales order.

Status String False

Current status of the sales order.

AccountName_Id String False

Identifier of the associated account.

AccountName_Name String True

Name of the associated account.

SalesOrderOwner_Id String False

Identifier of the user who owns the sales order.

SalesOrderOwner_FirstName String True

First name of the sales order owner.

SalesOrderOwner_LastName String True

Last name of the sales order owner.

SalesOrderOwner_Email String True

Email address of the sales order owner.

SalesOrderOwner_Name String True

Full name of the sales order owner.

CreatedBy_Id String False

Identifier of the user who created the sales order.

CreatedBy_FirstName String True

First name of the user who created the sales order.

CreatedBy_LastName String True

Last name of the user who created the sales order.

CreatedBy_Email String True

Email address of the user who created the sales order.

CreatedBy_Name String True

Full name of the user who created the sales order.

ModifiedBy_Id String False

Identifier of the user who last modified the sales order.

ModifiedBy_FirstName String True

First name of the user who last modified the sales order.

ModifiedBy_LastName String True

Last name of the user who last modified the sales order.

ModifiedBy_Email String True

Email address of the user who last modified the sales order.

ModifiedBy_Name String True

Full name of the user who last modified the sales order.

CreatedTime Datetime False

Date and time when the sales order was created.

ModifiedTime Datetime False

Date and time when the sales order was last modified.

Tag String False

Tags associated with the sales order.

BillingStreet String False

Billing street address.

ShippingStreet String False

Shipping street address.

BillingCity String False

Billing city.

ShippingCity String False

Shipping city.

BillingState String False

Billing state.

ShippingState String False

Shipping state.

BillingCode String False

Billing postal code.

ShippingCode String False

Shipping postal code.

BillingCountry String False

Billing country.

ShippingCountry String False

Shipping country.

SubTotal 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.

GrandTotal String True

Final total amount after taxes, discounts, and adjustments.

TermsandConditions String False

Terms and conditions associated with the sales order.

Description String False

Additional notes or description of the sales order.

OrderedItems String False

List of items included in the sales order.

RecordId Long True

Record identifier used internally.

Locked Bool True

Indicates whether the record is locked for editing.

LastActivityTime Datetime False

Date and time of the last activity on the record.

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 fields to use when checking for duplicate records during upsert. The REST API supports multiple fields, but the BULK API supports only one.

Trigger String

Used to trigger workflow rules during record insertion into the CRM.

CustomViewId Long

Custom view identifier for filtering this record. Works only when the useCOQL parameter is false.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434