SalesOrderDetails

Get the details of a sales order.

Table Specific Information

Select

The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
Note: SalesorderId is required in order to query SalesOrderDetails.

SalesorderId supports the '=' comparison.

For example:

    SELECT * FROM SalesOrderDetails WHERE SalesorderId = '1894553000000077349'

Columns


Name	Type	References	SupportedOperators	Description
SalesorderId [KEY]	String	SalesOrders.SalesorderId		ID of sales order.
AccountIdentifier	String			Account identifier for sales order.
Adjustment	Decimal			Adjustments made to the sales order.
AdjustmentDescription	String			Description of adjustments made to the sales order.
ApproverId	String	Users.UserId		ID of an approver.
AttachmentName	String			Name of the attachment.
BcyAdjustment	Decimal			Adjustment made in Base Currency.
BcyDiscountTotal	Decimal			Total amount of discount in Base Currency.
BcyShippingCharge	Decimal			Shipping charge applied in Base Currency.
BcySubTotal	Decimal			Sub total of Base Currency.
BcyTaxTotal	Decimal			Total tax of Base Currency.
BcyTotal	Decimal			Total Base Currency.
BillingAddress	String			Billing address of a sales order.
BillingAddressAttention	String			Name of a person in billing address.
BillingAddressCity	String			City of a billing address.
BillingAddressCountry	String			Country of a billing address.
BillingAddressFax	String			Fax of a billing address.
BillingAddressPhone	String			Phone number of a billing address.
BillingAddressState	String			State of a billing address.
BillingAddressStreet2	String			Street two of a billing address.
BillingAddressZip	String			ZIP code of a billing address.
CanSendInMail	Boolean			Check if the sales order can be send in mail.
ColorCode	String			Color code for sales order.
ContactCategory	String			Category of a contact.
CreatedById	String	Users.UserId		Id of a user who has created sales order.
CreatedTime	Datetime			Time at which the sales order was created.
CurrencyCode	String			Currency code of the customer's currency.
CurrencyId	String	Currencies.CurrencyId		Currency ID of the customer's currency.
CurrencySymbol	String			Currency symbol of the customer's currency.
CurrentSubStatus	String			Current sub status of a sales order.
CurrentSubStatusId	String			Current sub status ID of a sales order.
CustomerId	String	Contacts.ContactId		ID of the customer or vendor.
CustomerName	String			Name of the customer or vendor.
Date	Date			Date of a sales order.
DeliveryMethod	String			Method of a delivery.
DeliveryMethodId	String			Method ID of a delivery.
Discount	String			Discount given to specific item in sales order.
DiscountAppliedOnAmount	Decimal			Amount in which discount was applied.
DiscountPercent	Double			Percentage applied for discount.
DiscountTotal	Decimal			Total amount get on discount.
DiscountType	String			Type of discount applied in sales order.
EstimateId	String	Estimates.EstimateId		ID of an estimate.
ExchangeRate	Decimal			Exchange rate of the currency.
HasQtyCancelled	Boolean			Check if the sales order quantity has been cancelled.
IntegrationId	String			ID of sales order integration.
InvoiceConversionType	String			Type of invoice conversion applied for sales order.
InvoicedStatus	String			Status of invoiced sales order.
IsDiscountBeforeTax	Boolean			Check if the sales order can be applied discount before tax.
IsEmailed	Boolean			Check if the sales order is emailed.
IsInclusiveTax	Boolean			Check if the sales order is inclusive tax.
IsPreGst	Boolean			Check if pre GST is applied.
LastModifiedById	String	Users.UserId		Id of the user last modified.
LastModifiedTime	Datetime			The time of last modification of the sales order.
MerchantId	String			ID of the merchant.
MerchantName	String			Name of the merchant.
Notes	String			Notes of sales order.
OrderStatus	String			Status of order.
Orientation	String			Orientation of page.
PageHeight	String			Height of page.
PageWidth	String			Width of page.
PricePrecision	Integer			The precision for the price.
ReferenceNumber	String			Reference number of a sales order.
RoundoffValue	Decimal			Round Off value of sales order.
SalesorderNumber	String			Number of sales order.
SalespersonId	String			ID of a sales person.
SalespersonName	String			Name of the sales person.
ShipmentDate	Date			Date when shipment was done for sale order.
ShippingAddress	String			Shipment Address.
ShippingAddressAttention	String			Name of a person of shipping address.
ShippingAddressCity	String			City of a shipping address.
ShippingAddressCountry	String			Country of a shipping address.
ShippingAddressFax	String			Fax of a shipping address.
ShippingAddressPhone	String			Phone number of a shipping address.
ShippingAddressState	String			State of a shipping address.
ShippingAddressStreet2	String			Street two details of a shipping address.
ShippingAddressZip	String			Zip code of a shipping address.
ShippingCharge	Decimal			Shipping charge.
Status	String			Status of the sales order.
SubTotal	Decimal			Sub total of sales orders.
SubTotalInclusiveOfTax	Decimal			Subtotal amount which are inclusive of tax.
SubmittedBy	String			Detail of the user who has submitted the sales order.
SubmittedDate	Date			Date when submission was made of sales order.
SubmitterId	String	Users.UserId		Id of a submitter.
TaxTotal	Decimal			Total amount of tax.
TemplateId	String			ID of a template.
TemplateName	String			Name of a template.
TemplateType	String			Type of template.
Terms	String			Terms and Conditions apply of a sales order.
Total	Decimal			Total of sales order.
TransactionRoundingType	String			Type of round off used for transaction.

CData Python Connector for Zoho Books

SalesOrderDetails

Table Specific Information

Select

Columns