The Sales Order Product DMO represents a product or service being sold to the customer as part of a sales order.
Object API Name
ssot__SalesOrderProduct__dlm
Category
Other
Primary Subject Area
Sales Order
Primary Key
Sales Order Product ID (ssot__Id__c)
Relationships
| Object | Field | Cardinality | Related Object | Related Field |
|---|---|---|---|---|
| Loyalty Transaction Journal | Sales Order Product | Many To One: N:1 | Sales Order Product | Sales Order Product ID |
| Sales Order Product | Seller Account | Many To One: N:1 | Account | Account ID |
| Sales Order Product | Original Order product | Many To One: N:1 | Sales Order Product | Sales Order Product ID |
| Sales Order Product | Sales Order | Many To One: N:1 | Sales Order | Sales Order ID |
| Sales Order Product | Product | Many To One: N:1 | Goods Product | Goods Product ID |
| Sales Order Product | Product | Many To One: N:1 | Master Product | Master Product ID |
| Sales Order Product | Product | Many To One: N:1 | Bundle Product | Bundle Product ID |
All Fields
| Field Name | Field API Name | Description | Data Type |
|---|---|---|---|
| Adjusted Delivery Tax Amount | ssot__AdjustedDeliveryTaxAmount__c |
The roll up number of sales order product tax rows associated with delivery fees. | number |
| Allocated Quantity | ssot__AllocatedQuantity__c |
The quantity allocated for fulfillment. | number |
| Available Quantity | ssot__AvailableQuantity__c |
The quantity of product available. | number |
| Comments | ssot__Commenttext__c |
A message that is displayed to the customer during order creation. | text |
| Created Date | ssot__CreatedDate__c |
The date the record was created. | dateTime |
| Data Source | ssot__DataSourceId__cc |
A reference ID for the logical name for a system that is the source of records identified by an external record ID. | text |
| Data Source Object | ssot__DataSourceObjectId__c |
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. | text |
| Delivery Tax Amount | ssot__DeliveryTaxAmount__c |
The amount of tax owed for delivery. | number |
| Description | ssot__Description__c |
The description of the sales order product. | text |
| Discount Amount | ssot__DiscountAmount__c |
The discount amount applied to each order line item. | number |
| Discount Amount Currency | ssot__DiscountAmountCurrency__c |
A reference ID to the denomination of currency for the discount amount. | text |
| External Record ID | ssot__ExternalRecordId__c |
A reference ID to an external data source system. | text |
| External Source ID | ssot__ExternalSourceId__c |
A reference ID to system that External Record ID was assigned. | text |
| Gift Order Message | ssot__GiftOrderMessagetext__c |
The text message on a gift order. | text |
| Gift Recipient Telephone number | ssot__GiftRecipientTelephonenumber__c |
The phone number of a gift recipient. | text |
| Handling Cost Amount Currency | ssot__HandlingCostAmountCurrency__c |
A reference ID to the denomination of currency for the handling cost amount. | text |
| Internal Organization | ssot__InternalOrganizationId__c |
A reference ID to the business unit or other internal organization that owns the business account. | text |
| Is Automatically Renewed | ssot__IsAutomaticallyRenewed__c |
An indicator if a subscription-type product can be automatically renewed or was selected for auto-renewal. | text |
| Is Bonus Product | ssot__IsBonusProduct__c |
An indicator if the sales order item is a bonus or free product added to an order. | text |
| Is Bundle Root | ssot__IsBundleRoot__c |
An indicator whether it’s an element of a bundled product. | text |
| Is Gift | ssot__IsGift__c |
An indicator that the sales order is a gift. | text |
| Last Modified Date | ssot__LastModifiedDate__c |
The date when a user last modified the record. | dateTime |
| Line Adjustment SubTotal Amount | ssot__LineAdjustmentSubTotalAmount__c |
The subtotal amount of a line adjustment. | number |
| List Price Amount | ssot__ListPriceAmount__c |
The list price amount for one unit of a sales order product. | number |
| List Price Amount Currency | ssot__ListPriceAmountCurrency__c |
The denomination of currency for the list price amount. | text |
| List Price Quantity Unit of Measure | ssot__ListPriceQuantityUOMId__c |
A reference ID to a unit of measure for the list price of a physical product, for example, a box, case, or palette. | text |
| List Price Term Unit of Measure | ssot__ListPriceTermUOMId__c |
A reference ID to a unit of measure for list price for a product with a subscription term, for example, monthly, quarterly, or yearly. | text |
| Order Adjustment SubTotal Amount | ssot__OrderAdjustmentSubTotalAmount__c |
number | |
| Order Manual Adjustment SubTotal Amount | ssot__OrderManualAdjustmentSubTotalAmount__c |
number | |
| Order Product number | ssot__OrderProductnumber__c |
An automatically generated number that identifies a sales order product. | text |
| Ordered Quantity | ssot__OrderedQuantity__c |
The number of units of sales order product. | number |
| Original Order Product | ssot__OriginalOrderProductId__c |
A reference ID to the original sales order product being reduced. | text |
| Pricebook Entry | ssot__PricebookEntryId__c |
A reference ID related to an entry within a price book. | text |
| Product | ssot__ProductId__c |
A reference ID to what's being sold, for example, goods, services, bundles, and made-to-order products. | text |
| Promised Date | ssot__PromisedDate__c |
The start date for sales order product. | dateTime |
| Provisioning Date | ssot__ProvisioningDate__c |
The date when the seller expects to provision a service or product. | dateTime |
| Quantity Fulfilled | ssot__QuantityFulfilled__c |
The quantity of a sales order product that is provided. | number |
| Quantity Ordered Unit Of Measure | ssot__QuantityOrderedUOMId__c |
A reference ID to a unit of measure for quantity of sales order product ordered, for example item, box, or palette. | text |
| Quote Line Item | ssot__QuoteLineItemId__c |
A reference ID to the associated quote line item. | text |
| Recurring Price Amount | ssot__RecurringPriceAmount__c |
A charge incurred by the buyer on a recurring basis. | number |
| Requested End Date | ssot__RequestedEndDate__c |
The date when a product or service ends. | dateTime |
| Requested Start Date | ssot__RequestedStartDate__c |
The date when a product or service begins, from a sales order perspective. | dateTime |
| Sales Order | ssot__SalesOrderId__c |
A reference ID to the related sales order. | text |
| Sales Order Delivery Group | ssot__SalesOrderDeliveryGroupId__c |
A reference ID to the sales order delivery group. | text |
| Sales Order Product Adjusted Tax Amount | ssot__SalesOrderProductAdjustedTaxAmount__c |
The amount of taxes including any adjustments. | number |
| Sales Order Product Id | ssot__Id__c |
A unique ID used as the primary key for the Sales Order Product DMO. | text |
| Sales Order Product Reason | ssot__SalesOrderProductReasonId__c |
A reference ID to the reason code for sales order product. | text |
| Sales Order Product Status | ssot__SalesOrderProductStatusId__c |
A reference ID to status of sales order product in order, for example Placed or Activated. | text |
| SalesOrderProductIdentifications | ssot__SalesOrderProductIdentifications__c |
text | |
| SalesOrderProductNotes relationship | ssot__SalesOrderProductNotes__c |
Any notes related to a sales order. | text |
| SalesOrderProductPriceAdjustments | ssot__SalesOrderProductPriceAdjustments__c |
text | |
| SalesOrderProductRelatedProducts | ssot__SalesOrderProductRelatedProducts__c |
text | |
| SalesOrderProductTaxes relationship | ssot__SalesOrderProductTaxes__c |
text | |
| Segment Index | ssot__SegmentIndexId__c |
A reference ID to the number used with segment indexes for pricing subscriptions. | number |
| Segment Index number | ssot__SegmentIndexnumber__c |
A number used for pricing subscriptions, where subperiods of the overall subscription are priced differently, and the pricing can change. | number |
| Seller Account | ssot__SellerAccountId__c |
A reference ID to the seller account assigned to a sales order product. | text |
| Shipping Cost Amount Currency | ssot__ShippingCostAmountCurrency__c |
A denomination of currency for shipping cost amount. | text |
| Shipping Tax Amount Currency | ssot__ShippingTaxAmountCurrency__c |
The denomination of currency for shipping tax amount. | text |
| Subscription Renewal Month Quantity | ssot__SubscriptionRenewalMonthQuantity__c |
The length of time of subscription, in months, of sales order item. | number |
| Subscription Term Quantity | ssot__SubscriptionTermQuantity__c |
The quantity of a subscription term. | number |
| Subscription Term Unit of Measure | ssot__SubscriptionTermUnitId__c |
A reference ID to a unit of measure for a subscription term. | text |
| Total Adjustment Amount | ssot__TotalAdjustmentAmount__c |
The total amount including adjustments. | number |
| Total Adjustment Tax Amount | ssot__TotalAdjustmentTaxAmount__c |
The total amount of taxes after adjustment. | number |
| Total Distributed Adjustment Amount | ssot__TotalDistributedAdjustmentAmount__c |
number | |
| Total Distributed Adjustment Tax Amount | ssot__TotalDistributedAdjustmentTaxAmount__c |
number | |
| Total Distributed Tax Amount | ssot__TotalDistributedTaxAmount__c |
The total line level taxes on distributed adjustments. | number |
| Total Line Adjustment Amount | ssot__TotalLineAdjustmentAmount__c |
The amount of any adjustment on a line item of an order. | number |
| Total Line Amount | ssot__TotalLineAmount__c |
The amount of a line item of an order. | number |
| Total List Price Amount | ssot__TotalListPriceAmount__c |
The list price of a product. | number |
| Total Manual Adjustment Amount | ssot__TotalManualAdjustmentAmount__c |
The total amount of any adjustments. | number |
| Total Price Amount | ssot__TotalPriceAmount__c |
The total price of an order. | number |
| Total Product Tax Amount | ssot__TotalProductTaxAmount__c |
The total tax amount on a specific product. | number |
| Total Recurring Price Amount | ssot__TotalRecurringPriceAmount__c |
The total price of recurring charges for subscription products that have recurring charges. | number |
| Total Tax Amount | ssot__TotalTaxAmount__c |
The total tax owed on an order. | number |
| Total Unit Price Amount | ssot__TotalUnitPriceAmount__c |
The total amount of the unit price. | number |
| Unit Price Amount | ssot__UnitPriceAmount__c |
The cost of one unit of product for each customer, which overrides the standard list price. | number |
| Unit Price Amount Currency | ssot__UnitPriceAmountCurrency__c |
A reference ID to the denomination of currency for the unit price amount. | text |
| Unit Tax Amount | ssot__UnitTaxAmount__c |
The unit tax amount for sales order product. | number |
| Unit Tax Amount Currency | ssot__UnitTaxAmountCurrency__c |
A reference ID to the denomination of currency for the unit tax amount. | text |