Sales Order Product DMO
A component of a Sales Order that identifies a product or service that will be sold to the customer
Object API Name: std__SalesOrderProductDmo__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id
- ProductId has a FOREIGNKEY relationship with the Goods Product DMO
Idfield. - SellerAccountId has a FOREIGNKEY relationship with the Account DMO
Idfield. - ProductId has a FOREIGNKEY relationship with the Product DMO
Idfield. - ProductId has a FOREIGNKEY relationship with the Bundle Product DMO
Idfield. - SalesOrderId has a FOREIGNKEY relationship with the Sales Order DMO
Idfield. - ProductId has a FOREIGNKEY relationship with the Master Product DMO
Idfield. - SalesOrderDeliveryGroupId has a FOREIGNKEY relationship with the Sales Order Delivery Group DMO
Idfield. - OriginalOrderProductId has a FOREIGNKEY relationship with the Sales Order Product DMO
Idfield. - SalesModelId has a FOREIGNKEY relationship with the Sales Model DMO
Idfield.
- AdjustedDeliveryTaxAmount
- AdjustedSalesOrderProductAmount
- AllocatedQuantity
- AllocatedQuantityUomid
- AvailableQuantity
- BonusProductReasonType
- cdp_sys_record_currency
- CommentText
- CreatedDate
- CurrencyCode
- DataSourceId
- DataSourceObjectId
- DeliveryTaxAmount
- Description
- DiscountAmount
- DiscountAmountCurrency
- ExternalRecordId
- ExternalSourceId
- GiftOrderMessageText
- GiftRecipientTelephoneNumber
- GrossUnitPriceAmount
- HandlingCostAmountCurrency
- Id
- InternalOrganizationId
- IsAutomaticallyRenewed
- IsBonusProduct
- IsBundleRoot
- IsGift
- IsListedProduct
- IsOutOfStock
- IsPromotionalProduct
- LastModifiedDate
- LineAdjustmentSubTotalAmount
- ListPriceAmount
- ListPriceAmountCurrency
- ListPriceQuantityUom
- ListPriceQuantityUomid
- ListPriceTermUom
- ListPriceTermUomid
- NameInterfaceField
- OrderAdjustmentSubTotalAmount
- OrderedQuantity
- OrderManualAdjustmentSubTotalAmount
- OrderProductNumber
- OriginalOrderProductId
- PricebookEntryId
- ProductId
- ProductReturnQuantity
- PromisedDate
- PromotionId
- ProvisioningDate
- QuantityFulfilled
- QuantityOrderedUom
- QuantityOrderedUomid
- QuoteLineItemId
- RecommendedQuantity
- RecurringPriceAmount
- RequestedEndDate
- RequestedStartDate
- SalesModelId
- SalesOrderDeliveryGroupId
- SalesOrderId
- SalesOrderProductAdjustedTaxAmount
- SalesOrderProductIdentifications
- SalesOrderProductNotes
- SalesOrderProductPriceAdjustments
- SalesOrderProductReasonId
- SalesOrderProductRelatedProducts
- SalesOrderProductStatus
- SalesOrderProductStatusId
- SalesOrderProductSubType
- SalesOrderProductTaxes
- SalesOrderProductType
- SegmentIndexId
- SegmentIndexNumber
- SellerAccountId
- ShippingCostAmountCurrency
- ShippingTaxAmountCurrency
- SpecialUnitPriceAmount
- SubscriptionRenewalMonthQuantity
- SubscriptionTermQuantity
- SubscriptionTermUnit
- SubscriptionTermUnitId
- TotalAdjustmentAmount
- TotalAdjustmentTaxAmount
- TotalDistributedAdjustmentAmount
- TotalDistributedAdjustmentTaxAmount
- TotalDistributedTaxAmount
- TotalLineAdjustmentAmount
- TotalLineAmount
- TotalListPriceAmount
- TotalManualAdjustmentAmount
- TotalPriceAmount
- TotalProductTaxAmount
- TotalRecurringPriceAmount
- TotalTaxAmount
- TotalUnitPriceAmount
- TotalWithTaxAdjustmentAmount
- TotalWithTaxAmount
- TotalWithTaxDistAdjustmentAmount
- TotalWithTaxLineAdjustmentAmount
- TotalWithTaxLineAmount
- UnitPriceAmount
- UnitPriceAmountCurrency
- UnitTaxAmount
- UnitTaxAmountCurrency
- WithTaxAdjustedLineAmount
- Field API Name:
std__AdjustedDeliveryTaxAmount__c - Data Type: DOUBLE
- Description: Rollup of Sales Order Product Tax rows, where the product is delivery fee, after any adjustments on delivery fees.
- Field API Name:
std__AdjustedSalesOrderProductAmount__c - Data Type: DOUBLE
- Description: Total, including line adjustments but not order-lever adjustments or tax, of the OrderItemSummary. This is a calculated field.
- Field API Name:
std__AllocatedQuantity__c - Data Type: DOUBLE
- Description: Allocated quantity on this order item summary. This quantity is associated with one or more FulfillmentOrderLineItems. If the OrderLifeCycleType field on the associated OrderSummary is set to UNMANAGED, then users with the Edit Unmanaged Order Summaries or B2B Commerce Integrator user permission can modify this field.
- Field API Name:
std__AllocatedQuantityUomid__c - Data Type: TEXT
- Description: Alphanumeric string representing the allocated quantity uomid.
- Field API Name:
std__AvailableQuantity__c - Data Type: DOUBLE
- Description: Quantity available to be allocated on this OrderItemSummary. This amount is equal to QuantityOrdered minus QuantityCanceled.
- Field API Name:
std__BonusProductReasonType__c - Data Type: TEXT
- Description: The reason type which lead/related to bonus part being added in the order. Possible values are: - Sales Order - Sales Order Product Reward.
- Field API Name:
std__cdp_sys_record_currency__c - Data Type: TEXT
- Description: System-generated metadata field that stores a 3-letter ISO currency code.
- Field API Name:
std__CommentText__c - Data Type: TEXT
- Description: A message displayed to the customer during order creation.
- Field API Name:
std__CreatedDate__c - Data Type: DATETIME
- Description: The date and time the record was originally created.
- Field API Name:
std__CurrencyCode__c - Data Type: TEXT
- Description: ISO 4217 code identifying the currency used in the transaction or record.
- Field API Name:
std__DataSourceId__c - Data Type: TEXT
- Description: A unique, system-generated identifier for this record.
- Field API Name:
std__DataSourceObjectId__c - Data Type: TEXT
- Description: A unique, system-generated identifier for this record.
- Field API Name:
std__DeliveryTaxAmount__c - Data Type: DOUBLE
- Description: Rollup of Sales Order Product Tax rows, where the product is delivery fee, before any adjustments on delivery fees.
- Field API Name:
std__Description__c - Data Type: TEXT
- Description: Required. Description of the OrderItemSummary. Maximum size is 255 characters.
- Field API Name:
std__DiscountAmount__c - Data Type: DOUBLE
- Description: Numeric value representing the discount amount. Do not include currency symbols or commas.
- Field API Name:
std__DiscountAmountCurrency__c - Data Type: TEXT
- Description: Alphanumeric string representing the discount amount currency.
- Field API Name:
std__ExternalRecordId__c - Data Type: TEXT
- Description: A unique, system-generated identifier for this record.
- Field API Name:
std__ExternalSourceId__c - Data Type: TEXT
- Description: A unique, system-generated identifier for this record.
- Field API Name:
std__GiftOrderMessageText__c - Data Type: TEXT
- Description: The message on the gift.
- Field API Name:
std__GiftRecipientTelephoneNumber__c - Data Type: TEXT
- Description: Telephone number of the gift recipient.
- Field API Name:
std__GrossUnitPriceAmount__c - Data Type: DOUBLE
- Description: Unit price, including tax, of the OrderItemSummary. This value is equal to UnitPrice + the amount of tax on the UnitPrice. If th eOrderLifeCycleType field on the associated OrderSummary is set to UNMANAGED, then users with the Edit Unmanaged Order Summaries or B2B Commerce Integrator user permission can modify this field.
- Field API Name:
std__HandlingCostAmountCurrency__c - Data Type: TEXT
- Description: Alphanumeric string representing the handling cost amount currency.
- Field API Name:
std__Id__c - Data Type: TEXT
- Description: Required. A unique, system-generated identifier for this SalesOrderProduct record. Maximum size is 36 characters.
- Field API Name:
std__InternalOrganizationId__c - Data Type: TEXT
- Description: A unique, system-generated identifier for this record.
- Field API Name:
std__IsAutomaticallyRenewed__c - Data Type: TEXT
- Description: For a subscription-type product that can be automatically renewed, this setting indicates the order selection was for auto-renewal.
- Field API Name:
std__IsBonusProduct__c - Data Type: TEXT
- Description: Defines if the sales order item a bonus product. Bonus products are usually free products add to an order. Being bonus has implecations on returns and adjustments.
- Field API Name:
std__IsBundleRoot__c - Data Type: TEXT
- Description: Is the product the root-level of a bundled product?
- Field API Name:
std__IsGift__c - Data Type: TEXT
- Description: Is this is a gift.
- Field API Name:
std__IsListedProduct__c - Data Type: TEXT
- Description: If true then represents that product exists in an authorization list and sold to specific Account i.e. Account on Sales Order.
- Field API Name:
std__IsOutOfStock__c - Data Type: BOOLEAN
- Description: Specifies whether the ordered product is out of stock.
- Field API Name:
std__IsPromotionalProduct__c - Data Type: TEXT
- Description: If true then represents the product is promotional product.
- Field API Name:
std__LastModifiedDate__c - Data Type: DATETIME
- Description: The date and time of the last modification to this record.
- Field API Name:
std__LineAdjustmentSubTotalAmount__c - Data Type: DOUBLE
- Description: Calculated as: UnitPriceTotalAmount: TotalLineAdjustmentAmount.
- Field API Name:
std__ListPriceAmount__c - Data Type: DOUBLE
- Description: List price for the order product. Value is inherited from the associatedPriceBookEntryupon order product creation.
- Field API Name:
std__ListPriceAmountCurrency__c - Data Type: TEXT
- Description: Alphanumeric string representing the list price amount currency.
- Field API Name:
std__ListPriceQuantityUom__c - Data Type: TEXT
- Description: Alphanumeric string representing the list price quantity uom.
- Field API Name:
std__ListPriceQuantityUomid__c - Data Type: TEXT
- Description: Alphanumeric string representing the list price quantity uomid.
- Field API Name:
std__ListPriceTermUom__c - Data Type: TEXT
- Description: Alphanumeric string representing the list price term uom.
- Field API Name:
std__ListPriceTermUomid__c - Data Type: TEXT
- Description: Alphanumeric string representing the list price term uomid.
- Field API Name:
std__NameInterfaceField__c - Data Type: TEXT
- Description: Name of this record.
- Field API Name:
std__OrderAdjustmentSubTotalAmount__c - Data Type: DOUBLE
- Description: Calculated as: TotalUnitPriceAmount: TotalDistributedAdjustmentAmount.
- Field API Name:
std__OrderedQuantity__c - Data Type: DOUBLE
- Description: Required. Number of units of this order product.
- Field API Name:
std__OrderManualAdjustmentSubTotalAmount__c - Data Type: DOUBLE
- Description: Calculated as: TotalUnitPriceAmount: TotalDistributedAdjustmentAmount.
- Field API Name:
std__OrderProductNumber__c - Data Type: TEXT
- Description: Automatically generated number that identifies the order product.
- Field API Name:
std__OriginalOrderProductId__c - Data Type: TEXT
- Description: Required if is Reduction Order on the parent order is true. ID of the original order product being reduced.
- Field API Name:
std__PricebookEntryId__c - Data Type: TEXT
- Description: Required. ID of the pricebook entry associated with this OrderItemSummary. This field is a relationship field. Maximum size is 36 characters.
- Field API Name:
std__ProductId__c - Data Type: TEXT
- Description: Required. ID of the Product2 associated with this OrderItem. This field is a relationship field. Maximum size is 36 characters.
- Field API Name:
std__ProductReturnQuantity__c - Data Type: DOUBLE
- Description: Returned quantity on this OrderItemSummary. If the OrderLifeCycleType field on the associated OrderSummary is set to UNMANAGED, then users with the Edit Unmanaged Order Summaries or B2B Commerce Integrator user permission can modify this field.
- Field API Name:
std__PromisedDate__c - Data Type: DATETIME
- Description: The date and time of the promised date.
- Field API Name:
std__PromotionId__c - Data Type: TEXT
- Description: The reference Promotion record if the product is promotional product.
- Field API Name:
std__ProvisioningDate__c - Data Type: DATETIME
- Description: The date and time of the provisioning date.
- Field API Name:
std__QuantityFulfilled__c - Data Type: DOUBLE
- Description: Fulfilled quantity on this OrderItemSummary. This quantity can no longer be canceled. If the OrderLifeCycleType field on the associated OrderSummary is set to UNMANAGED, then users with the Edit Unmanaged Order Summaries or B2B Commerce Integrator user permission can modify this field.
- Field API Name:
std__QuantityOrderedUom__c - Data Type: TEXT
- Description: Alphanumeric string representing the quantity ordered uom.
- Field API Name:
std__QuantityOrderedUomid__c - Data Type: TEXT
- Description: Alphanumeric string representing the quantity ordered uomid.
- Field API Name:
std__QuoteLineItemId__c - Data Type: TEXT
- Description: ID of the associated quote line item. If this field is specified, the quote line item's QuoteId must match the QuoteId for the order product's parent order.
- Field API Name:
std__RecommendedQuantity__c - Data Type: DOUBLE
- Description: The quantity recommended based of historical data by algorithm or given by relevant promotion.
- Field API Name:
std__RecurringPriceAmount__c - Data Type: DOUBLE
- Description: A charge that's incurred by the buyer on a repeating basis.
- Field API Name:
std__RequestedEndDate__c - Data Type: DATETIME
- Description: The date and time of the requested end date.
- Field API Name:
std__RequestedStartDate__c - Data Type: DATETIME
- Description: The date and time of the requested start date.
- Field API Name:
std__SalesModelId__c - Data Type: TEXT
- Description: The ID of the related product selling model. The product selling model defines one method by which a product can be sold, for example, as a one-time sale, an evergreen subscription, or a termed subscription. This field is available with Subscription Management. This is a One to One (1:1) relationship field. SalesOrderProducts is the relationship name and Sales Model is the referenced object. Maximum size is 36 characters.
- Field API Name:
std__SalesOrderDeliveryGroupId__c - Data Type: TEXT
- Description: Sales Order Delivery Group.
- Field API Name:
std__SalesOrderId__c - Data Type: TEXT
- Description: Required. ID of the order that this order product is a child of. This field is a relationship field. Maximum size is 36 characters.
- Field API Name:
std__SalesOrderProductAdjustedTaxAmount__c - Data Type: DOUBLE
- Description: TotalPriceAmount + TotalTaxAmount.
- Field API Name:
std__SalesOrderProductIdentifications__c - Data Type: TEXT
- Description: Alphanumeric string representing the sales order product identifications.
- Field API Name:
std__SalesOrderProductNotes__c - Data Type: TEXT
- Description: Alphanumeric string representing the sales order product notes.
- Field API Name:
std__SalesOrderProductPriceAdjustments__c - Data Type: TEXT
- Description: Alphanumeric string representing the sales order product price adjustments.
- Field API Name:
std__SalesOrderProductReasonId__c - Data Type: TEXT
- Description: A unique, system-generated identifier for this record.
- Field API Name:
std__SalesOrderProductRelatedProducts__c - Data Type: TEXT
- Description: Alphanumeric string representing the sales order product related products.
- Field API Name:
std__SalesOrderProductStatus__c - Data Type: TEXT
- Description: Alphanumeric string representing the sales order product status.
- Field API Name:
std__SalesOrderProductStatusId__c - Data Type: TEXT
- Description: A unique, system-generated identifier for this record.
- Field API Name:
std__SalesOrderProductSubType__c - Data Type: TEXT
- Description: Type code of the OrderItemSummary. Charge indicates that the OrderItemSummary represents a charge or fee. Product indicates that it represents any other type of product, service, or charge. A type code can be associated with one or more types. Possible values are: - Charge - Product If the OrderLifeCycleType field on the associated OrderSummary is set to UNMANAGED, then users with the Edit Unmanaged Order Summaries or B2B Commerce Integrator user permission can modify this field. Maximum size is 15 characters.
- Field API Name:
std__SalesOrderProductTaxes__c - Data Type: TEXT
- Description: Alphanumeric string representing the sales order product taxes.
- Field API Name:
std__SalesOrderProductType__c - Data Type: TEXT
- Description: Type of the OrderItemSummary. Delivery Charge indicates that the OrderItemSummary represents a delivery charge. Fee indicates that it represents another type of fee, such as a return fee. Order Product indicates that it represents any other type of product, service, or charge. Each type corresponds to one type code, shown here in parentheses. Possible values are: - Delivery Charge (Charge) - Fee (Charge) This value is available in API v56.0 and later. - Order Product (Product) If the OrderLifeCycleType field on the associated OrderSummary is set to UNMANAGED, then users with the Edit Unmanaged Order Summaries or B2B Commerce Integrator user permission can modify this field. Maximum size is 15 characters.
- Field API Name:
std__SegmentIndexId__c - Data Type: DOUBLE
- Description: Used with Segment Indexes for pricing subscriptions. A Segment Index is unique to a customer's purchase of a product that uses segment pricing, and is used to group the segmements together.
- Field API Name:
std__SegmentIndexNumber__c - Data Type: DOUBLE
- Description: Used for pricing subscriptions, where sub-periods of the overall subscription are priced differently, and the pricing changes in a structured way over a series of segments, which are identified by numerically increasing Segment Numbers.
- Field API Name:
std__SellerAccountId__c - Data Type: TEXT
- Description: Lookup to the Seller Account assigne to this order product. This is normally be used only in marketplace configurations, where the ecommerce site provides a customer with access to products that are sold by multiple other entities.
- Field API Name:
std__ShippingCostAmountCurrency__c - Data Type: TEXT
- Description: Alphanumeric string representing the shipping cost amount currency.
- Field API Name:
std__ShippingTaxAmountCurrency__c - Data Type: TEXT
- Description: Alphanumeric string representing the shipping tax amount currency.
- Field API Name:
std__SpecialUnitPriceAmount__c - Data Type: DOUBLE
- Description: The reduced price for an item that's used for the item value calculation if specified.
- Field API Name:
std__SubscriptionRenewalMonthQuantity__c - Data Type: DOUBLE
- Description: Determines how often a new order is placed, in months, if this Order Item is a subscription.
- Field API Name:
std__SubscriptionTermQuantity__c - Data Type: DOUBLE
- Description: Quantity of the Subscription Unit Term Unit of Measure.
- Field API Name:
std__SubscriptionTermUnit__c - Data Type: TEXT
- Description: Alphanumeric string representing the subscription term unit.
- Field API Name:
std__SubscriptionTermUnitId__c - Data Type: TEXT
- Description: A unique, system-generated identifier for this record.
- Field API Name:
std__TotalAdjustmentAmount__c - Data Type: DOUBLE
- Description: Total of all price adjustments applied to this OrderItemSummary. This is a calculated field.
- Field API Name:
std__TotalAdjustmentTaxAmount__c - Data Type: DOUBLE
- Description: Tax on the TotalAdjustmentAmount. This is a calculated field.
- Field API Name:
std__TotalDistributedAdjustmentAmount__c - Data Type: DOUBLE
- Description: Total of all order-level price adjustments applied to this OrderItemSummary. This value includes OrderItemAdjustmentLineSummaries that belong to OrderAdjustmentGroupSummaries of type Header. This is a calculated field.
- Field API Name:
std__TotalDistributedAdjustmentTaxAmount__c - Data Type: DOUBLE
- Description: The sum of all taxes computed on order-level adjustments that are prorated to SalesOrderProduct (excludes taxes on SalesOrderProduct-level adjustments).
- Field API Name:
std__TotalDistributedTaxAmount__c - Data Type: DOUBLE
- Description: Total line level taxes on distributed adjustments.
- Field API Name:
std__TotalLineAdjustmentAmount__c - Data Type: DOUBLE
- Description: Total of all non-order-level price adjustments applied to this OrderItemSummary. This value includes OrderItemAdjustmentLineSummaries that don’t belong to an OrderAdjustmentGroupSummary, or that belong to an OrderAdjustmentGroupSummary of type SplitLine. This is a calculated field.
- Field API Name:
std__TotalLineAmount__c - Data Type: DOUBLE
- Description: Total, not including adjustments or tax, of the OrderItemSummary. If the OrderLifeCycleType field on the associated OrderSummary is set to UNMANAGED, then users with the Edit Unmanaged Order Summaries or B2B Commerce Integrator user permission can modify this field.
- Field API Name:
std__TotalListPriceAmount__c - Data Type: DOUBLE
- Description: The total list price amount for the sales order product.
- Field API Name:
std__TotalManualAdjustmentAmount__c - Data Type: DOUBLE
- Description: SalesOrderProductPriceAdjustment(SalesOrderProductPriceAdjustmentType == Manual): AdjustmentAmount.
- Field API Name:
std__TotalPriceAmount__c - Data Type: DOUBLE
- Description: Required. Total, including line and order-level adjustments, but not tax, of the OrderItemSummary. This is a calculated field.
- Field API Name:
std__TotalProductTaxAmount__c - Data Type: DOUBLE
- Description: Tax on the TotalLineAmount. This is a calculated field.
- Field API Name:
std__TotalRecurringPriceAmount__c - Data Type: DOUBLE
- Description: For subscription products that have recurring charges, this total stores the total of recurring charges, when these are distinct from Product charges.
- Field API Name:
std__TotalTaxAmount__c - Data Type: DOUBLE
- Description: Tax on the TotalPrice. This is a calculated field.
- Field API Name:
std__TotalUnitPriceAmount__c - Data Type: DOUBLE
- Description: The total unit price amount for the sales order product.
- Field API Name:
std__TotalWithTaxAdjustmentAmount__c - Data Type: DOUBLE
- Description: Total amount of all price adjustments applied to this OrderItemSummary, inclusive of tax. This amount is equal to TotalAdjustmentAmount plus TotalAdjustmentTaxAmount.
- Field API Name:
std__TotalWithTaxAmount__c - Data Type: DOUBLE
- Description: Total price of the OrderItemSummary, inclusive of tax. This amount is equal to TotalPrice + TotalTaxAmount. This is a calculated field.
- Field API Name:
std__TotalWithTaxDistAdjustmentAmount__c - Data Type: DOUBLE
- Description: Total of all order-level price adjustments applied to this Sales Order Product This value includes OrderItemAdjustmentLineSummaries that belong to OrderAdjustmentGroupSummaries of type Header.
- Field API Name:
std__TotalWithTaxLineAdjustmentAmount__c - Data Type: DOUBLE
- Description: Total of all non-order-level price adjustments applied to this Sales Order Product, inclusive of tax. This amount is equal to TotalLineAdjustmentAmount + TotalLineAdjustmentTaxAmount.
- Field API Name:
std__TotalWithTaxLineAmount__c - Data Type: DOUBLE
- Description: Total unadjusted amount of the OrderItemSummary, inclusive of tax. This amount is equal to TotalLineAmount + TotalLineTaxAmount.
- Field API Name:
std__UnitPriceAmount__c - Data Type: DOUBLE
- Description: The unit price after all price adjustments are applied. This field is available with Subscription Management.
- Field API Name:
std__UnitPriceAmountCurrency__c - Data Type: TEXT
- Description: Alphanumeric string representing the unit price amount currency.
- Field API Name:
std__UnitTaxAmount__c - Data Type: DOUBLE
- Description: Numeric value representing the unit tax amount. Do not include currency symbols or commas.
- Field API Name:
std__UnitTaxAmountCurrency__c - Data Type: TEXT
- Description: Alphanumeric string representing the unit tax amount currency.
- Field API Name:
std__WithTaxAdjustedLineAmount__c - Data Type: DOUBLE
- Description: Total price of the Sales Order Product, inclusive of adjustments and tax. This amount is equal to AdjustedLineAmount + TotalAdjustedLineTaxAmount.