SalesOrders

List, Insert, Update, delete sales orders

Table Specific Information

Select

The provider will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.

Id supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM SalesOrders WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the CustomerId, SalesorderNumber and LineItems column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Salesorders (CustomerId, SalesorderNumber, LineItems) VALUES (3285934000000085043, 'SO-0001', '[{\"name\": \"OnePlus 8 pro\",\"description\":\"just a simple des\"}]')

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE SalesOrders SET SalesorderNumber = 11, CustomerId = 111 WHERE Id = '3285934000000136008'

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM SalesOrders WHERE Id = '3350895000000089001'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Unique ID generated by the server for the Sales Order.
BcyTotal	Integer	True		Base Total.
CreatedTime	Datetime	True		Created Time.
CurrencyCode	String	True		Currency code.
CustomerId	Long	False	Contacts.Id	Unique ID generated for the customer.
PriceBookId	Long	False	PriceBooks.Id	Unique ID generated by the server for the Pricebook. This is used as an identifier.
SalespersonId	Long	False		Unique ID generated by the server for the sales person. This is used as an identifier.
TemplateId	Long	False		Unique ID generated by the server for the Template. This is used as an identifier.
CustomerName	String	True		Name of the customer.
Date	Date	False		The date for the Sales Order.
IsBackorder	Boolean	True		is backorder.
IsDropShipment	Boolean	True		is drop shipment.
IsDiscountBeforeTax	Boolean	False		Used to check whether the discount is applied before tax or after tax.
IsEmailed	Boolean	True		is emailed.
IsInclusiveTax	Boolean	False		Used to specify whether the line item rates are inclusive or exclusive of tax.
LastModifiedTime	Datetime	True		Time at which the sales order details were last modified.
LineItems	String	False		Each line item contains item_id,name,desc,rate,quantity,unit,tax_id,tax_name,tax_type,tax_percentage,item_total.
CustomFields	String	False		Custom Fields.
Notes	String	False		Notes for the Sales Order.
ExchangeRate	Double	False		Exchange rate of the currency, with respect to the base currency.
Adjustment	Double	False		Adjustment on the Sales Orde total.
AdjustmentDescription	String	False		Description for the adjustment.
Terms	String	False		Terms for the Sales Order.
Discount	String	False		The percentage of Discount applied.
DiscountType	String	False		Type of discount. The allowed values are entity_level, item_level.
ShippingCharge	Double	False		Shipping charges that can be applied to the Sales Order.
DeliveryMethod	String	False		Delivery method of the shipment.
Quantity	Integer	True		Quantity of the line item.
QuantityInvoiced	Integer	True		Quantity Invoiced of the line item.
QuantityPacked	Integer	True		Quantity Packed of the line item.
QuAntityShipped	Integer	True		Quantity shipped of the line item.
ReferenceNumber	String	False		Reference number of the Sales Order.
SalesChannel	String	True		sales channel.
SalesorderNumber	String	False		The Sales Order number.
ShipmentDate	Date	False		Shipment date of the Sales Order.
ShipmentDays	String	True		Shipment days.
Status	String	True		The status for the Sales Order.
Total	Integer	True		Total amount of the Sales Order.
ShippingAddressId	Long	False		Customer shipping address.
BillingAddressId	Long	False		Customer billing address.
Taxes	String	True		Number of taxes applied on sales order.
Documents	String	True		Sales order can have files attached to them.
BillingAddressAddress	String	True		Name of the street of the customer shipping address.
BillingAddressCity	String	True		Name of the city of the customer shipping address.
BillingAddressCountry	String	True		Name of the country of the customer shipping address.
BillingAddressFax	String	True		Fax number of the customer shipping address.
BillingAddressState	String	True		Name of the state of the customer shipping address.
BillingAddressZip	Integer	True		Zip code of the customer shipping address.
ContactPersonsContactPersonId	Long	True	ContactPersons.Id	Unique ID generated by the server for the contact person.
ShippingAddressAddress	String	True		Name of the street of the customer shipping address.
ShippingAddressCity	String	True		Name of the city of the customer shipping address.
ShippingAddressCountry	String	True		Name of the country of the customer shipping address.
ShippingAddressFax	String	True		Fax number of the customer shipping address.
ShippingAddressState	String	True		Name of the state of the customer shipping address.
ShippingAddressZip	Integer	True		Zip code of the customer shipping address.
AllowQuickShipment	Boolean	True		Whether quick shipment is allowed.
ContactPersons	String	True		Contact persons.
CouponCode	String	True		Coupon code.
DiscountAmount	Double	True		Discount amount.
LockDetail	String	True		Lock details.
PaymentTermsId	Long	True		ID of the payment terms.
RoundingMode	String	True		Rounding mode.
ShippingChargeTaxes	String	True		Shipping charge taxes.
Tags	String	True		Tags.
BcyRoundingMode	String	True		BCY rounding mode.
BeatId	Long	True		ID of the beat.
BeatNumber	String	True		Beat number.
BillingAddressCounty	String	True		County of the customer billing address.
CanShowKitReturn	Boolean	True		Whether kit return can be shown.
ContactCategory	String	True		Category of the contact.
CouponId	Long	True		ID of the coupon.
Exceptions	String	True		Exceptions.
IsKitPartialReturn	Boolean	True		Whether kit partial return is enabled.
IsScheduledForQuickShipmentCreate	Boolean	True		Whether scheduled for quick shipment creation.
IsViewedInMail	Boolean	True		Whether viewed in mail.
JourneyPlanId	Long	True		ID of the journey plan.
LockDetails	String	True		Lock details.
LockedActions	String	True		Locked actions.
MailFirstViewedTime	Datetime	True		Time when mail was first viewed.
MailLastViewedTime	Datetime	True		Time when mail was last viewed.
ShippingAddressCounty	String	True		County of the customer shipping address.
TaxOverridePreference	String	True		Tax override preference.
TaxRounding	String	True		Tax rounding.