SalesOrderProduct
The Sales Order Product DMO is a Data Cloud data model object (DMO) for the component of a sales order that identifies a product or service to be sold to the customer.
Columns
| Name | Type | References | Description |
| Adjusted Delivery Tax Amount | Double | The roll up number of sales order product tax rows associated with delivery fees. | |
| Allocated Quantity | Double | The quantity allocated for fulfillment. | |
| Available Quantity | Double | The quantity of product available. | |
| Comments | Varchar | A message that is displayed to the customer during order creation. | |
| Created Date | Datetime | The date the record was created. | |
| Data Source | Varchar | A reference ID for the logical name for a system that is the source of records identified by an external record ID. | |
| Data Source Object | Varchar | A reference ID for the logical name of the object where this record came from, whether that is a name of a cloud storage file or another connector’s external object. | |
| Delivery Tax Amount | Double | The amount of tax owed for delivery. | |
| Description | Varchar | The description of the sales order product. | |
| Discount Amount | Double | The discount amount applied to each order line item. | |
| Discount Amount Currency | Varchar | A reference ID to the denomination of currency for the discount amount. | |
| External Record ID | Varchar | A reference ID to an external data source system. | |
| External Source ID | Varchar | A reference ID to system that External Record ID was assigned. | |
| Gift Order Message | Varchar | The text message on a gift order. | |
| Gift Recipient Telephone number | Varchar | The phone number of a gift recipient. | |
| Handling Cost Amount Currency | Varchar | A reference ID to the denomination of currency for the handling cost amount. | |
| Internal Organization | Varchar | A reference ID to the business unit or other internal organization that owns the business account. | |
| Is Automatically Renewed | Varchar | An indicator if a subscription-type product can be automatically renewed or was selected for auto-renewal. | |
| Is Bonus Product | Varchar | An indicator if the sales order item is a bonus or free product added to an order. | |
| Is Bundle Root | Varchar | An indicator whether it’s an element of a bundled product. | |
| Is Gift | Varchar | An indicator that the sales order is a gift. | |
| Last Modified Date | Datetime | The date when a user last modified the record. | |
| Line Adjustment SubTotal Amount | Double | The subtotal amount of a line adjustment. | |
| List Price Amount | Double | The list price amount for one unit of a sales order product. | |
| List Price Amount Currency | Varchar | The denomination of currency for the list price amount. | |
| List Price Quantity Unit of Measure | Varchar | A reference ID to a unit of measure for the list price of a physical product, for example, a box, case, or palette. | |
| List Price Term Unit of Measure | Varchar | A reference ID to a unit of measure for list price for a product with a subscription term, for example, monthly, quarterly, or yearly. | |
| Order Adjustment SubTotal Amount | Double | ||
| Order Manual Adjustment SubTotal Amount | Double | ||
| Order Product number | Varchar | An automatically generated number that identifies a sales order product. | |
| Ordered Quantity | Double | The number of units of sales order product. | |
| Original Order Product | Varchar | A reference ID to the original sales order product being reduced. | |
| Pricebook Entry | Varchar | A reference ID related to an entry within a price book. | |
| Product | Varchar | A reference ID to what's being sold, for example, goods, services, bundles, and made-to-order products. | |
| Promised Date | Datetime | The start date for sales order product. | |
| Provisioning Date | Datetime | The date when the seller expects to provision a service or product. | |
| Quantity Fulfilled | Double | The quantity of a sales order product that is provided. | |
| Quantity Ordered Unit Of Measure | Varchar | A reference ID to a unit of measure for quantity of sales order product ordered, for example item, box, or palette. | |
| Quote Line Item | Varchar | A reference ID to the associated quote line item. | |
| Recurring Price Amount | Double | A charge incurred by the buyer on a recurring basis. | |
| Requested End Date | Datetime | The date when a product or service ends. | |
| Requested Start Date | Datetime | The date when a product or service begins, from a sales order perspective. | |
| Sales Order | Varchar | A reference ID to the related sales order. | |
| Sales Order Delivery Group | Varchar | A reference ID to the sales order delivery group. | |
| Sales Order Product Adjusted Tax Amount | Double | The amount of taxes including any adjustments. | |
| Sales Order Product Id | Varchar | A unique ID used as the primary key for the Sales Order Product DMO. | |
| Sales Order Product Reason | Varchar | A reference ID to the reason code for sales order product. | |
| Sales Order Product Status | Varchar | A reference ID to status of sales order product in order, for example Placed or Activated. | |
| SalesOrderProductIdentifications | Varchar | ||
| SalesOrderProductNotes relationship | Varchar | Any notes related to a sales order. | |
| SalesOrderProductPriceAdjustments | Varchar | ||
| SalesOrderProductRelatedProducts | Varchar | ||
| SalesOrderProductTaxes relationship | Varchar | ||
| Segment Index | Double | A reference ID to the number used with segment indexes for pricing subscriptions. | |
| Segment Index number | Double | A number used for pricing subscriptions, where subperiods of the overall subscription are priced differently, and the pricing can change. | |
| Seller Account | Varchar | A reference ID to the seller account assigned to a sales order product. | |
| Shipping Cost Amount Currency | Varchar | A denomination of currency for shipping cost amount. | |
| Shipping Tax Amount Currency | Varchar | The denomination of currency for shipping tax amount. | |
| Subscription Renewal Month Quantity | Double | The length of time of subscription, in months, of sales order item. | |
| Subscription Term Quantity | Double | The quantity of a subscription term. | |
| Subscription Term Unit of Measure | Varchar | A reference ID to a unit of measure for a subscription term. | |
| Total Adjustment Amount | Double | The total amount including adjustments. | |
| Total Adjustment Tax Amount | Double | The total amount of taxes after adjustment. | |
| Total Distributed Adjustment Amount | Double | ||
| Total Distributed Adjustment Tax Amount | Double | ||
| Total Distributed Tax Amount | Double | The total line level taxes on distributed adjustments. | |
| Total Line Adjustment Amount | Double | The amount of any adjustment on a line item of an order. | |
| Total Line Amount | Double | The amount of a line item of an order. | |
| Total List Price Amount | Double | The list price of a product. | |
| Total Manual Adjustment Amount | Double | The total amount of any adjustments. | |
| Total Price Amount | Double | The total price of an order. | |
| Total Product Tax Amount | Double | The total tax amount on a specific product. | |
| Total Recurring Price Amount | Double | The total price of recurring charges for subscription products that have recurring charges. | |
| Total Tax Amount | Double | The total tax owed on an order. | |
| Total Unit Price Amount | Double | The total amount of the unit price. | |
| Unit Price Amount | Double | The cost of one unit of product for each customer, which overrides the standard list price. | |
| Unit Price Amount Currency | Varchar | A reference ID to the denomination of currency for the unit price amount. | |
| Unit Tax Amount | Double | The unit tax amount for sales order product. | |
| Unit Tax Amount Currency | Varchar | A reference ID to the denomination of currency for the unit tax amount. |