SalesOrderDetails
Returns details of a sales order.
Columns
| Name | Type | References | |
| OrganizationId | Long |
Organizations.OrganizationId | |
| SalesOrderId [KEY] | Long |
SalesOrders.SalesOrderId | |
| SalesorderNumber | String | ||
| Status | String | ||
| AccountIdentifier | String | ||
| Adjustment | Double | ||
| AdjustmentDescription | String | ||
| ApproverId | String | ||
| ApproversList | String | ||
| AttachmentName | String | ||
| Balance | Double | ||
| BcyAdjustment | Double | ||
| BcyDiscountTotal | Double | ||
| BcyShippingCharge | Double | ||
| BcySubTotal | Double | ||
| BcyTaxTotal | Double | ||
| BcyTotal | Double | ||
| CanSendInMail | Boolean | ||
| ColorCode | String | ||
| ContactCategory | String | ||
| ContactPersonDetails | String | ||
| ContactPersons | String | ||
| CreatedByEmail | String | ||
| CreatedById | String | ||
| CreatedDate | Date | ||
| CreatedTime | Datetime | ||
| Creditnotes | String | ||
| CurrencyCode | String | ||
| CurrencyId | String | ||
| CurrencySymbol | String | ||
| CurrentSubStatus | String | ||
| CurrentSubStatusId | String | ||
| CustomFields | String | ||
| CustomerId | String | ||
| CustomerName | String | ||
| Date | Date | ||
| DeliveryMethod | String | ||
| DeliveryMethodId | String | ||
| Discount | Double | ||
| DiscountAmount | Double | ||
| DiscountAppliedOnAmount | Double | ||
| DiscountPercent | Double | ||
| DiscountTotal | Double | ||
| DiscountType | String | ||
| Documents | String | ||
| EstimateId | String | ||
| ExchangeRate | Double | ||
| HasDiscount | Boolean | ||
| HasQtyCancelled | Boolean | ||
| HasUnconfirmedLineItem | Boolean | ||
| IntegrationId | String | ||
| InvoicedStatus | String | ||
| Invoices | String | ||
| IsAdvTrackingInPackage | Boolean | ||
| IsBackordered | Boolean | ||
| IsDiscountBeforeTax | Boolean | ||
| IsDropshipped | Boolean | ||
| IsEmailed | Boolean | ||
| IsInclusiveTax | Boolean | ||
| IsManuallyFulfilled | Boolean | ||
| IsTestOrder | Boolean | ||
| LastModifiedById | String | ||
| LastModifiedTime | Datetime | ||
| LineItems | String | ||
| MerchantId | String | ||
| MerchantName | String | ||
| Notes | String | ||
| OfflineCreatedDateWithTime | String | ||
| OrderStatus | String | ||
| Orientation | String | ||
| Packages | String | ||
| PageHeight | String | ||
| PageWidth | String | ||
| PaymentTerms | Integer | ||
| PaymentTermsLabel | String | ||
| Payments | String | ||
| Picklists | String | ||
| PickupLocationId | String | ||
| PricePrecision | Integer | ||
| Purchaseorders | String | ||
| ReferenceNumber | String | ||
| Refunds | String | ||
| RoundoffValue | Double | ||
| SalesChannel | String | ||
| SalesChannelFormatted | String | ||
| SalespersonId | String | ||
| SalespersonName | String | ||
| Salesreturns | String | ||
| ShipmentDate | Date | ||
| ShippedStatus | String | ||
| ShippingAddressId | String | ||
| ShippingAddressAddress | String | ||
| ShippingAddressAttention | String | ||
| ShippingAddressCity | String | ||
| ShippingAddressCountry | String | ||
| ShippingAddressCountryCode | String | ||
| ShippingAddressFax | String | ||
| ShippingAddressPhone | String | ||
| ShippingAddressState | String | ||
| ShippingAddressStateCode | String | ||
| ShippingAddressStreet2 | String | ||
| ShippingAddressZip | String | ||
| BillingAddressId | String | ||
| BillingAddressAddress | String | ||
| BillingAddressAttention | String | ||
| BillingAddressCity | String | ||
| BillingAddressCountry | String | ||
| BillingAddressCountryCode | String | ||
| BillingAddressFax | String | ||
| BillingAddressPhone | String | ||
| BillingAddressState | String | ||
| BillingAddressStateCode | String | ||
| BillingAddressStreet2 | String | ||
| BillingAddressZip | String | ||
| ShippingCharge | Double | ||
| Source | String | ||
| SubStatuses | String | ||
| SubTotal | Double | ||
| SubTotalExclusiveOfDiscount | Double | ||
| SubTotalInclusiveOfTax | Double | ||
| SubmittedBy | String | ||
| SubmittedDate | String | ||
| SubmitterId | String | ||
| TaxRounding | String | ||
| TaxTotal | Double | ||
| Taxes | String | ||
| TemplateId | String | ||
| TemplateName | String | ||
| TemplateType | String | ||
| Terms | String | ||
| Total | Double | ||
| TotalQuantity | Double | ||
| TrackingUrl | String | ||
| TransactionRoundingType | String | ||
| ZcrmPotentialId | String | ||
| ZcrmPotentialName | String |