SalesOrder
The Sales Order DMO is a Data Cloud data model object (DMO) that provides information around current and pending sales orders.
Columns
| Name | Type | References | Description |
| Activated By User | Varchar | A reference ID to user who activated order. | |
| Adjusted Product Tax Amount | Double | The total product tax plus the total adjustment tax amount. | |
| Adjusted Total Product Amount | Double | The total product amount plus the total adjustment amount. | |
| Bill To Account | Varchar | A reference ID to account billed for order. Can only be updated when order's StatusCode value is Draft. | |
| Bill To Address | Varchar | A reference ID to billing address. | |
| Bill To Contact | Varchar | A reference ID to customer billed for order. | |
| Bill to Email | Varchar | A reference ID to email address of customer billed for order. | |
| Bill to Phone Number | Varchar | A reference ID to phone number of customer billed for order. | |
| Billing Day of the Month | Double | The day of the month that customer is invoiced. | |
| Can Bill Now | Varchar | An indicator if a customer is eligible to bill. | |
| CompanyAuthorizedBy | Varchar | A reference ID to user who authorized the account associated with order. | |
| Confirmation Recipient Email | Varchar | A list of email addresses to send messages for order confirmation. Not for large volume implementations | |
| Contract | Varchar | A reference ID to contract associated with order. Can only be updated when the order's Status Code value is Draft. | |
| Created Date | Datetime | The date the record was created. | |
| Currency Code | Varchar | A reference ID to currency code for order. Currency code is used for all child objects, such as sales order product and sales order price adjustments. | |
| CustomerAuthorizedBy | Varchar | A reference ID to contact who authorized order. | |
| Data Source | Varchar | A reference ID to logical name for system that is source of records identified by External Record Id. | |
| Data Source Object | Varchar | A reference ID to logical name of object where record originated, for example a cloud storage file or another connector’s external object. | |
| Description | Varchar | The order’s description. | |
| Device | Varchar | A reference ID to electronic unit where signals are tracked, for example fridge, watch or car. | |
| External Record ID | Varchar | A reference ID for external data source record. | |
| External Source ID | Varchar | A reference ID for the system in which the external record ID was assigned. | |
| Filed Date | Datetime | The date the order was filed. | |
| Grand Total Amount | Double | The total amount of the order. | |
| Internal Business Unit | Varchar | A reference ID to business unit within seller organization responsible for order. | |
| Internal Organization | Varchar | A reference ID to business unit or other internal organization that owns business account. | |
| Is Alerted | Varchar | An indicator if a user is notified when something went wrong during order workflow. | |
| Is Anonymous | Varchar | An indicator if the order was placed by unregistered guest user. | |
| Is Closed | Varchar | An indicator if the order is closed. Used to drive and halt workflows. | |
| Is Contracted | Varchar | An indicator if the order placed is under the terms of a contract. | |
| Is Historical Only | Varchar | An indicator for when an order is historical and can’t be changed. | |
| Is Suspended | Varchar | An indicator for when an order is suspended. | |
| Is Tax Exempt | Varchar | An indicator for whether taxes apply to order. | |
| Last Modified Date | Datetime | The date when a user last modified the record. | |
| Name | Varchar | The order name. | |
| Opportunity | Varchar | A reference ID to the opportunity associated with order. | |
| Order End Date | Datetime | The date when the order ends, such as for a subscription. | |
| Order insurance Amount Currency | Varchar | A reference ID to the currency of the order insurance amount. | |
| Order Number | Varchar | A unique number assigned to order and displayed to end users. | |
| Order Start Date | Datetime | The date when order becomes effective, such as when a subscription begins. | |
| Original Order | Varchar | A reference ID to the parent order. | |
| Owner User Id | Varchar | A reference ID to the user or entity who owns this order. | |
| Price Calculation Status Message | Varchar | The status message describing the state of the order’s price calculation. | |
| Promise Date | Datetime | The date the order was promised. | |
| Purchase Order Date | Datetime | The date of purchase order. | |
| Purchase Order Number | Varchar | The number identifying a purchase order. | |
| Quote | Varchar | A reference ID to quote associated with order. | |
| Renewal Term | Varchar | A reference ID to length of renewal term for renewal orders. | |
| Renewal Uplift Rate | Double | For renewal orders, percentage of increase or decrease in order quantity. | |
| Requested Start Date | Datetime | The customer's preferred date for order fulfillment. | |
| Sales Channel | Varchar | A reference ID to the sales channel used to place order. | |
| Sales Order Confirmation Status | Varchar | A reference ID to what stage of customer approval and finalization has been achieved. | |
| Sales Order Id | Varchar | A unique ID used as primary key for Sales Order DMO. | |
| Sales Order Status | Varchar | Current order status, for example, draft, ready for review, or placed. | |
| Sales Order System Status | Varchar | A reference ID to order status with fixed values such as draft or activated. | |
| Sales Order Type | Varchar | A reference ID to type of order, for example, change, renewal, or amendment. | |
| Sales Store | Varchar | A reference ID to the store used to place order. | |
| Sales Order Change Logs Relationship | Varchar | ||
| Sales Order Delivery Groups Relationship | Varchar | ||
| Sales Order Payment Summaries Relationship | Varchar | ||
| Sales Order Price Adjustments Relationship | Varchar | ||
| Seller | Varchar | A reference ID to order seller. | |
| Ship To Address | Varchar | A reference ID to location where order is shipped. | |
| Ship To Contact | Varchar | A reference ID to contact entity to whom order is shipped. | |
| Ship To Email | Varchar | A reference ID to email of contact entity to whom order is shipped. | |
| Shopping Cart Id | Varchar | A reference ID to shopping cart that customer used to select products in order, before placing order. | |
| Sold To Customer | Varchar | A reference ID to the customer. | |
| Total Adjusted Delivery Tax Amount | Double | The total delivery tax amount, if adjusted. | |
| Total Adjustment Amount | Double | The sum of all order price adjustments, excluding taxes on any adjustments. | |
| Total Adjustment Tax Amount | Double | The total tax amount, if adjusted. | |
| Total Amount Currency | Varchar | A reference ID to the currency of the total amount. | |
| Total Booking Amount | Double | The total amount of a sales order product booking. | |
| Total Canceled Billing Amount | Double | The total of all canceled orders. | |
| Total Delivery Amount | Double | A total of product, adjustment, and delivery fee amounts, but excluding taxes. | |
| Total Delivery Amount Currency | Varchar | A reference ID to the currency of the total delivery amount. | |
| Total Delivery Fee Amount | Double | The total fee for delivery. | |
| Total Delivery Fee Currency | Varchar | A reference ID to currency of the total delivery amount. | |
| Total Delivery Tax Amount | Double | The total amount of delivery tax. | |
| Total Pending Billing Amount | Double | The total pending for all orders. | |
| Total Product Amount | Double | The total cost of the product. | |
| Total Product Amount Currency | Varchar | A reference ID to currency of the total product amount. | |
| Total Product Tax Amount | Double | The total amount of taxes for all product. | |
| Total Product Tax Amount Currency | Varchar | A reference ID to currency of the total product tax amount. | |
| Total Tax Amount | Double | The total amount of taxes. | |
| User Device Session | Varchar |