Cc Fact Promotion Order Line Item DMO

This DMO stores detailed information about promotion applications to order line items. Each record links a specific promotion to a line item, capturing discount amounts and associated dimension references.

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

• PromotionId has a FOREIGNKEY relationship with the Cc Dim Promotion DMO Id field.
• SkuId has a FOREIGNKEY relationship with the Cc Dim Product DMO Id field.
• LineItemId has a FOREIGNKEY relationship with the Cc Fact Order Line Item DMO Id field.
• UtcSubmitDayId has a FOREIGNKEY relationship with the Cc Dim Date DMO Id field.
• UtcSubmitTimeId has a FOREIGNKEY relationship with the Cc Dim Time DMO Id field.
• StandardSubmitDayId has a FOREIGNKEY relationship with the Cc Dim Date DMO Id field.
• StandardSubmitTimeId has a FOREIGNKEY relationship with the Cc Dim Time DMO Id field.
• StandardTimeZoneId has a FOREIGNKEY relationship with the Cc Dim Time Zone DMO Id field.
• LocaleId has a FOREIGNKEY relationship with the Cc Dim Locale DMO Id field.
• SiteId has a FOREIGNKEY relationship with the Cc Dim Site DMO Id field.
• BusinessChannelId has a FOREIGNKEY relationship with the Cc Dim Business Channel DMO Id field.
• UserAgentId has a FOREIGNKEY relationship with the Cc Dim User Agent DMO Id field.
• CampaignId has a FOREIGNKEY relationship with the Cc Dim Campaign DMO Id field.
• SourceCodeGroupId has a FOREIGNKEY relationship with the Cc Dim Source Code Group DMO Id field.
• CustomerId has a FOREIGNKEY relationship with the Cc Dim Customer DMO Id field.
• LocalCurrencyId has a FOREIGNKEY relationship with the Cc Dim Currency DMO Id field.
• StandardCurrencyId has a FOREIGNKEY relationship with the Cc Dim Currency DMO Id field.
• ShippingGeographyId has a FOREIGNKEY relationship with the Cc Dim Geography DMO Id field.
• InvoiceGeographyId has a FOREIGNKEY relationship with the Cc Dim Geography DMO Id field.
• CustomerGeographyId has a FOREIGNKEY relationship with the Cc Dim Geography DMO Id field.
• CouponId has a FOREIGNKEY relationship with the Cc Dim Coupon DMO Id field.

• AiAgentSessionIdentifier
• BusinessChannelId
• BuyerEmail
• CampaignId
• cdp_sys_record_currency
• CouponId
• CustomerGeographyId
• CustomerId
• DataSourceId
• DataSourceObjectId
• HasTrackingOptedOut
• Id
• InternalOrganizationId
• InvoiceGeographyId
• IsAnonymous
• LineItemId
• LocalCurrencyId
• LocaleId
• LocalGrossMerchandiseValue
• LocalManualDiscount
• LocalManualDiscountOrderAlloc
• LocalManualDiscountShippingAlloc
• LocalPromotionDiscount
• LocalPromotionDiscountOrderAlloc
• LocalPromotionDiscountShippingAlloc
• LocalShipping
• LocalShippingOrderAlloc
• LocalTax
• LocalTaxOrderAlloc
• NaturalLineItemIdentifier
• NaturalOrderIdentifier
• OrderIdentifier
• PromotionId
• PromotionInstanceIdentifier
• Quantity
• ShippingGeographyId
• SiteId
• SkuId
• SourceCodeGroupId
• StandardCurrencyId
• StandardGrossMerchandiseValue
• StandardManualDiscount
• StandardManualDiscountOrderAlloc
• StandardManualDiscountShippingAlloc
• StandardPromotionDiscount
• StandardPromotionDiscountOrderAlloc
• StandardPromotionDiscountShipAlloc
• StandardShipping
• StandardShippingOrderAlloc
• StandardSubmitDayId
• StandardSubmitTimeId
• StandardSubmitTimestamp
• StandardTax
• StandardTaxOrderAlloc
• StandardTimeZoneId
• UserAgentId
• UtcSubmitDayId
• UtcSubmitTimeId
• UtcSubmitTimestamp
• UtcUpdateTimestamp
• VisitorIdentifier

• Field API Name: std__AiAgentSessionIdentifier__c
• Data Type: TEXT
• Description: Identifier of the Agentforce session.

• Field API Name: std__BusinessChannelId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_business_channel.

• Field API Name: std__BuyerEmail__c
• Data Type: TEXT
• Description: Email address of the buyer.

• Field API Name: std__CampaignId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_campaign.

• 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__CouponId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_coupon for the coupon.

• Field API Name: std__CustomerGeographyId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_geography for customer's address.

• Field API Name: std__CustomerId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_customer.

• 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__HasTrackingOptedOut__c
• Data Type: BOOLEAN
• Description: Boolean indicating if the customer has opted out of tracking.

• Field API Name: std__Id__c
• Data Type: DOUBLE
• Description: Unique identifier for the promotion line item.

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

• Field API Name: std__InvoiceGeographyId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_geography for invoice location.

• Field API Name: std__IsAnonymous__c
• Data Type: BOOLEAN
• Description: Boolean indicating if the customer is anonymous.

• Field API Name: std__LineItemId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_fact_line_item.

• Field API Name: std__LocalCurrencyId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_currency for local currency.

• Field API Name: std__LocaleId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_locale.

• Field API Name: std__LocalGrossMerchandiseValue__c
• Data Type: DOUBLE
• Description: The gross merchandise value of the line item (in tendered currency).

• Field API Name: std__LocalManualDiscount__c
• Data Type: DOUBLE
• Description: The line item manual discounts associated with the line item.

• Field API Name: std__LocalManualDiscountOrderAlloc__c
• Data Type: DOUBLE
• Description: The order level manual discounts associated with the line item (pro-rated).

• Field API Name: std__LocalManualDiscountShippingAlloc__c
• Data Type: DOUBLE
• Description: The shipping level manual discounts associated with the line item (pro-rated).

• Field API Name: std__LocalPromotionDiscount__c
• Data Type: DOUBLE
• Description: The line item promotional discounts associated with the line item.

• Field API Name: std__LocalPromotionDiscountOrderAlloc__c
• Data Type: DOUBLE
• Description: The order level promotional discounts associated with the line item (pro-rated).

• Field API Name: std__LocalPromotionDiscountShippingAlloc__c
• Data Type: DOUBLE
• Description: The line item shipping level promotional discounts associated with the line item (pro-rated).

• Field API Name: std__LocalShipping__c
• Data Type: DOUBLE
• Description: The line item level shipping.

• Field API Name: std__LocalShippingOrderAlloc__c
• Data Type: DOUBLE
• Description: The order level shipping (pro-rated).

• Field API Name: std__LocalTax__c
• Data Type: DOUBLE
• Description: Line item tax in local currency.

• Field API Name: std__LocalTaxOrderAlloc__c
• Data Type: DOUBLE
• Description: The order level tax (pro-rated).

• Field API Name: std__NaturalLineItemIdentifier__c
• Data Type: TEXT
• Description: Normalized line item identifier.

• Field API Name: std__NaturalOrderIdentifier__c
• Data Type: TEXT
• Description: The natural key representing the order in the source system.

• Field API Name: std__OrderIdentifier__c
• Data Type: DOUBLE
• Description: A surrogate key representing the order associated with the line item.

• Field API Name: std__PromotionId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_promotion.

• Field API Name: std__PromotionInstanceIdentifier__c
• Data Type: DOUBLE
• Description: Unique key representing the usage/application of a promotion in an order.

• Field API Name: std__Quantity__c
• Data Type: DOUBLE
• Description: The number of units of this line item that were purchased.

• Field API Name: std__ShippingGeographyId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_geography for shipping location.

• Field API Name: std__SiteId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_site for the submission site.

• Field API Name: std__SkuId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_product for the SKU affected by the promotion.

• Field API Name: std__SourceCodeGroupId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_source_code_group.

• Field API Name: std__StandardCurrencyId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_currency for standard currency.

• Field API Name: std__StandardGrossMerchandiseValue__c
• Data Type: DOUBLE
• Description: The gross merchandise value of the line item as determined by the attribution of promotional GMV to promotions.

• Field API Name: std__StandardManualDiscount__c
• Data Type: DOUBLE
• Description: The line item manual discounts associated with the line item.

• Field API Name: std__StandardManualDiscountOrderAlloc__c
• Data Type: DOUBLE
• Description: The order level manual discounts associated with the line item (pro-rated).

• Field API Name: std__StandardManualDiscountShippingAlloc__c
• Data Type: DOUBLE
• Description: The shipping level manual discounts associated with the line item (pro-rated).

• Field API Name: std__StandardPromotionDiscount__c
• Data Type: DOUBLE
• Description: The line item promotional discounts associated with the line item.

• Field API Name: std__StandardPromotionDiscountOrderAlloc__c
• Data Type: DOUBLE
• Description: The order level promotional discounts associated with the line item (pro-rated).

• Field API Name: std__StandardPromotionDiscountShipAlloc__c
• Data Type: DOUBLE
• Description: The line item shipping level promotional discounts associated with the line item (pro-rated).

• Field API Name: std__StandardShipping__c
• Data Type: DOUBLE
• Description: The line item level shipping.

• Field API Name: std__StandardShippingOrderAlloc__c
• Data Type: DOUBLE
• Description: The order level shipping (pro-rated).

• Field API Name: std__StandardSubmitDayId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_date for the standard submission day.

• Field API Name: std__StandardSubmitTimeId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_time for the standard submission time.

• Field API Name: std__StandardSubmitTimestamp__c
• Data Type: DATETIME
• Description: Timestamp when the promotion was applied, in standard time.

• Field API Name: std__StandardTax__c
• Data Type: DOUBLE
• Description: Line item tax in local currency.

• Field API Name: std__StandardTaxOrderAlloc__c
• Data Type: DOUBLE
• Description: The order level tax (pro-rated).

• Field API Name: std__StandardTimeZoneId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_timezone for the standard time zone.

• Field API Name: std__UserAgentId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_user_agent.

• Field API Name: std__UtcSubmitDayId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_date for the UTC submission day.

• Field API Name: std__UtcSubmitTimeId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_time for the UTC submission time.

• Field API Name: std__UtcSubmitTimestamp__c
• Data Type: DATETIME
• Description: UTC timestamp when the promotion was applied.

• Field API Name: std__UtcUpdateTimestamp__c
• Data Type: DATETIME
• Description: Last modified UTC timestamp of this record.

• Field API Name: std__VisitorIdentifier__c
• Data Type: TEXT
• Description: Unique key representing an ID of the visitor.