MuleSoft Connector for Zoho Books

Build 20.0.7654

SalesOrderDetails

Get the details of a sales order.

Table Specific Information

Select

The connector 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 connector.
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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654