Sales Order Product Engagement DMO

Object API Name: std__SalesOrderProductEngagementDmo__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.
• PersonalizationContentId has a FOREIGNKEY relationship with the Personalization Log DMO Id field.
• ProductOrderEngagementId has a FOREIGNKEY relationship with the Product Order Engagement DMO Id field.
• UtmId has a FOREIGNKEY relationship with the Campaign DMO Id field.

• AdjustmentTaxAmount
• cdp_sys_record_currency
• CreatedDate
• DataSourceId
• DataSourceObjectId
• Description
• EngagementChannelAction
• EngagementDateTm
• EngagementType
• Id
• IndividualId
• InternalOrganizationId
• LocationId
• NameInterfaceField
• OrderedQuantity
• OrderProductNumber
• PerslServiceProviderName
• PersonalizationContentId
• PersonalizationId
• PersonalizationRequestId
• PrimaryCouponName
• ProductAffiliationName
• ProductBrandName
• ProductCategory1Name
• ProductCategory2Name
• ProductCategory3Name
• ProductCategory4Name
• ProductCategory5Name
• ProductId
• ProductIndexNumber
• ProductListId
• ProductListName
• ProductOrderEngagementId
• ProductPriceAmount
• ProductTaxAmount
• ProductTotalDiscountAmount
• ProductVariantDescription
• ShippingCostAmount
• TotalAdjustmentAmount
• TotalLineAmount
• TotalTaxAmount
• UnitPriceAmount
• UnitPriceQuantityUomid
• UserAgentText
• UtmCampaignName
• UtmContentDescription
• UtmId
• UtmMediumName
• UtmSourceName
• UtmSourcePlatformName
• UtmTermDescription
• WebSession

• Field API Name: std__AdjustmentTaxAmount__c
• Data Type: DOUBLE
• Description: Total Adjustment Amount * Tax Rate.

• 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__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time when this record was created.

• 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__Description__c
• Data Type: TEXT
• Description: Description of the Order Item.

• Field API Name: std__EngagementChannelAction__c
• Data Type: TEXT
• Description: Action taken within the engagement channel, such as open, click, or unsubscribe.

• Field API Name: std__EngagementDateTm__c
• Data Type: DATETIME
• Description: The date and time of the engagement date tm.

• Field API Name: std__EngagementType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the engagement type.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this SalesOrderProductEngagement record. Maximum size is 36 characters.

• Field API Name: std__IndividualId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__LocationId__c
• Data Type: TEXT
• Description: The physical location associated with the item ( the physical store location).

• Field API Name: std__NameInterfaceField__c
• Data Type: TEXT
• Description: Name of this record.

• Field API Name: std__OrderedQuantity__c
• Data Type: DOUBLE
• Description: Number of units of the product being ordered.

• Field API Name: std__OrderProductNumber__c
• Data Type: TEXT
• Description: Automatically-generated number that identifies the order product.

• Field API Name: std__PerslServiceProviderName__c
• Data Type: TEXT
• Description: Name of the personalization service provider associated with the engagement.

• Field API Name: std__PersonalizationContentId__c
• Data Type: TEXT
• Description: Identification token for a unique piece of digital content.

• Field API Name: std__PersonalizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__PersonalizationRequestId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__PrimaryCouponName__c
• Data Type: TEXT
• Description: Multiple coupons could apply to an Item. If multiple exist, this identifies the primary one, recorded as a text value rather than a reference.

• Field API Name: std__ProductAffiliationName__c
• Data Type: TEXT
• Description: Names a supplying company or store location where the item is available.

• Field API Name: std__ProductBrandName__c
• Data Type: TEXT
• Description: Name of the product brand of the item.

• Field API Name: std__ProductCategory1Name__c
• Data Type: TEXT
• Description: The first Product Category assigned to the Sales Order Product Engagement.

• Field API Name: std__ProductCategory2Name__c
• Data Type: TEXT
• Description: The second Product Category assigned to the Sales Order Product Engagement.

• Field API Name: std__ProductCategory3Name__c
• Data Type: TEXT
• Description: The third Product Category assigned to the Sales Order Product Engagement.

• Field API Name: std__ProductCategory4Name__c
• Data Type: TEXT
• Description: The fourth Product Category assigned to theSales Order Product Engagement.

• Field API Name: std__ProductCategory5Name__c
• Data Type: TEXT
• Description: The fifth Product Category assigned to theSales Order Product Engagement.

• Field API Name: std__ProductId__c
• Data Type: TEXT
• Description: The service, product or charge associated with this SalesOrderProduct.

• Field API Name: std__ProductIndexNumber__c
• Data Type: DOUBLE
• Description: The position of the item within a displayed list.

• Field API Name: std__ProductListId__c
• Data Type: TEXT
• Description: Identifies a list to which the Sales Order Product belongs. Items within a Sales Order Product Engagement can belong to different lists.

• Field API Name: std__ProductListName__c
• Data Type: TEXT
• Description: Names a list to which the Sales Order Product belongs. Items within a Sales Order Product Engagement can belong to different lists.

• Field API Name: std__ProductOrderEngagementId__c
• Data Type: TEXT
• Description: Reference to the order header that this order product is a child of.

• Field API Name: std__ProductPriceAmount__c
• Data Type: DOUBLE
• Description: Product Quantity * Unit Price Amount.

• Field API Name: std__ProductTaxAmount__c
• Data Type: DOUBLE
• Description: Product Price Amount * Tax Rate.

• Field API Name: std__ProductTotalDiscountAmount__c
• Data Type: DOUBLE
• Description: The total of all item-level discounts applied.

• Field API Name: std__ProductVariantDescription__c
• Data Type: TEXT
• Description: The item variant or unique code or description for additional item details/options.

• Field API Name: std__ShippingCostAmount__c
• Data Type: DOUBLE
• Description: Shipping cost charged to customer.

• Field API Name: std__TotalAdjustmentAmount__c
• Data Type: DOUBLE
• Description: Total amount of all adjustments (discounts, promotions, manual adjustments) made to the line item.

• Field API Name: std__TotalLineAmount__c
• Data Type: DOUBLE
• Description: (Product Price Amount: Total Adjustment Amount ) + Total Tax Amount.

• Field API Name: std__TotalTaxAmount__c
• Data Type: DOUBLE
• Description: Total line level taxes (ProductTaxAmount: TotalAdjustmentTaxAmount). If TotalProductTaxAmount = $1.00 and TotalAdjustmentTaxAmount = $.10, then TotalTaxAmount = $.90.

• Field API Name: std__UnitPriceAmount__c
• Data Type: DOUBLE
• Description: Numeric value representing the unit price amount. Do not include currency symbols or commas.

• Field API Name: std__UnitPriceQuantityUomid__c
• Data Type: TEXT
• Description: Alphanumeric string representing the unit price quantity uomid.

• Field API Name: std__UserAgentText__c
• Data Type: TEXT
• Description: Full user agent string identifying the browser, operating system, and device used during the engagement.

• Field API Name: std__UtmCampaignName__c
• Data Type: TEXT
• Description: The name of a Marketing Campaign.

• Field API Name: std__UtmContentDescription__c
• Data Type: TEXT
• Description: Used to differentiate creatives. For example, if you have two call-to-action links within the same email message, you can use utm_content and set different values for each so you can tell which version is more effective.

• Field API Name: std__UtmId__c
• Data Type: TEXT
• Description: Id of the Urchin Tracking Module (UTM), which is a set of one or more code snippets that are added to a URL to support tracking. The UTM Id usually stores the ID of a Campaign.

• Field API Name: std__UtmMediumName__c
• Data Type: TEXT
• Description: Identifies the vehicles that you are using to market your company.

• Field API Name: std__UtmSourceName__c
• Data Type: TEXT
• Description: Identifies the subchannel that's the source of the engagement, for example Facebook or Instagram.

• Field API Name: std__UtmSourcePlatformName__c
• Data Type: TEXT
• Description: The platform responsible for directing traffic to a given Analytics property (such as a buying platform that manages organic traffic data). For example: Search Ads 360 or Display & Video 360.

• Field API Name: std__UtmTermDescription__c
• Data Type: TEXT
• Description: A paid keyword. Maximum size is 255 characters.

• Field API Name: std__WebSession__c
• Data Type: TEXT
• Description: Identifier for the web session associated with the engagement.