Cc Fact Order Line Item DMO

This DMO contains order line item fact data from ccdw_fact_line_item. Each record represents a line item on an order with pricing, discounts, taxes, shipping, and geography dimensions in both local and standard currencies.

Object Properties

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

Relationships

• 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.
• SkuId has a FOREIGNKEY relationship with the Cc Dim Product 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.
• 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.

Fields

• AiAgentSessionIdentifier
• BusinessChannelId
• BuyerEmail
• cdp_sys_record_currency
• CustomerGeographyId
• CustomerId
• DataSourceId
• DataSourceObjectId
• DocumentNo
• HasTrackingOptedOut
• Id
• InternalOrganizationId
• InvoiceGeographyId
• IsAnonymous
• KQ_BusinessChannelId
• KQ_CustomerGeographyId
• KQ_CustomerId
• KQ_Id
• KQ_InvoiceGeographyId
• KQ_LocalCurrencyId
• KQ_LocaleId
• KQ_ShippingGeographyId
• KQ_SiteId
• KQ_SkuId
• KQ_SourceCodeGroupId
• KQ_StandardCurrencyId
• KQ_StandardSubmitDayId
• KQ_StandardSubmitTimeId
• KQ_StandardTimeZoneId
• KQ_UserAgentId
• KQ_UtcSubmitDayId
• KQ_UtcSubmitTimeId
• LocalCurrencyId
• LocaleId
• LocalGrossMerchandiseValue
• LocalManualDiscount
• LocalManualDiscountOrderAlloc
• LocalManualDiscountShippingAlloc
• LocalMarkdown
• LocalMarkdownDiscount
• LocalMarkdownPrice
• LocalNetMerchandiseValue
• LocalPromotionDiscount
• LocalPromotionDiscountOrderAlloc
• LocalPromotionDiscountShippingAlloc
• LocalRetailPrice
• LocalShipping
• LocalShippingOrderAlloc
• LocalTax
• LocalTaxOrderAlloc
• LocalUnitPrice
• NaturalLineItemIdentifier
• NaturalOrderIdentifier
• OrderIdentifier
• PurchaseNumber
• Quantity
• ShippingGeographyId
• SiteId
• SkuId
• SourceCodeGroupId
• StandardCurrencyId
• StandardGrossMerchandiseValue
• StandardManualDiscount
• StandardManualDiscountOrderAlloc
• StandardManualDiscountShippingAlloc
• StandardMarkdown
• StandardMarkdownDiscount
• StandardMarkdownPrice
• StandardNetMerchandiseValue
• StandardPromotionDiscount
• StandardPromotionDiscountOrderAlloc
• StandardPromotionDiscountShipAlloc
• StandardRetailPrice
• StandardShipping
• StandardShippingOrderAlloc
• StandardSubmitDayId
• StandardSubmitTimeId
• StandardSubmitTimestamp
• StandardTax
• StandardTaxOrderAlloc
• StandardTimeZoneId
• StandardUnitPrice
• UserAgentId
• UtcSubmitDayId
• UtcSubmitTimeId
• UtcSubmitTimestamp
• UtcUpdateTimestamp
• VisitorIdentifier

AiAgentSessionIdentifier

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

BusinessChannelId

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

BuyerEmail

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

cdp_sys_record_currency

• Field API Name: cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

CustomerGeographyId

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

CustomerId

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

DataSourceId

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

DataSourceObjectId

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

DocumentNo

• Field API Name: DocumentNo__c
• Data Type: TEXT
• Description: Document number associated with the order.

HasTrackingOptedOut

• Field API Name: HasTrackingOptedOut__c
• Data Type: BOOLEAN
• Description: Boolean indicating if the customer has opted out of tracking.

Id

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

InternalOrganizationId

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

InvoiceGeographyId

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

IsAnonymous

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

KQ_BusinessChannelId

• Field API Name: KQ_BusinessChannelId__c
• Data Type: TEXT
• Description: Key Qualifier system field for BusinessChannelId

KQ_CustomerGeographyId

• Field API Name: KQ_CustomerGeographyId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CustomerGeographyId

KQ_CustomerId

• Field API Name: KQ_CustomerId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CustomerId

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

KQ_InvoiceGeographyId

• Field API Name: KQ_InvoiceGeographyId__c
• Data Type: TEXT
• Description: Key Qualifier system field for InvoiceGeographyId

KQ_LocalCurrencyId

• Field API Name: KQ_LocalCurrencyId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocalCurrencyId

KQ_LocaleId

• Field API Name: KQ_LocaleId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocaleId

KQ_ShippingGeographyId

• Field API Name: KQ_ShippingGeographyId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ShippingGeographyId

KQ_SiteId

• Field API Name: KQ_SiteId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SiteId

KQ_SkuId

• Field API Name: KQ_SkuId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SkuId

KQ_SourceCodeGroupId

• Field API Name: KQ_SourceCodeGroupId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SourceCodeGroupId

KQ_StandardCurrencyId

• Field API Name: KQ_StandardCurrencyId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardCurrencyId

KQ_StandardSubmitDayId

• Field API Name: KQ_StandardSubmitDayId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardSubmitDayId

KQ_StandardSubmitTimeId

• Field API Name: KQ_StandardSubmitTimeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardSubmitTimeId

KQ_StandardTimeZoneId

• Field API Name: KQ_StandardTimeZoneId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardTimeZoneId

KQ_UserAgentId

• Field API Name: KQ_UserAgentId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UserAgentId

KQ_UtcSubmitDayId

• Field API Name: KQ_UtcSubmitDayId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtcSubmitDayId

KQ_UtcSubmitTimeId

• Field API Name: KQ_UtcSubmitTimeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtcSubmitTimeId

LocalCurrencyId

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

LocaleId

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

LocalGrossMerchandiseValue

• Field API Name: LocalGrossMerchandiseValue__c
• Data Type: DOUBLE
• Description: The Gross Merchandise Value (GMV) of the line item in the tendered currency. GMV is derived using the following row-based calculation (quantity * lcl_li_unit_price) - ((lcl_li_promo_disc + lcl_li_manual_disc_order_alloc) + (lcl_li_manual_disc + lcl_li_manual_disc_order_alloc))

LocalManualDiscount

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

LocalManualDiscountOrderAlloc

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

LocalManualDiscountShippingAlloc

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

LocalMarkdown

• Field API Name: LocalMarkdown__c
• Data Type: DOUBLE
• Description: Line item markdown amount in local currency.

LocalMarkdownDiscount

• Field API Name: LocalMarkdownDiscount__c
• Data Type: DOUBLE
• Description: Line item markdown discount in local currency.

LocalMarkdownPrice

• Field API Name: LocalMarkdownPrice__c
• Data Type: DOUBLE
• Description: Line item markdown price in local currency.

LocalNetMerchandiseValue

• Field API Name: LocalNetMerchandiseValue__c
• Data Type: DOUBLE
• Description: Line item net merchandise value in tendered currency. This is derived using the following row-based calculation lcl_li_gross_merchandise_value + (lcl_li_tax + lcl_li_tax_order_alloc) + (lcl_li_shipping + lcl_li_shipping_order_alloc) - (lcl_li_promo_disc_ship_alloc + lcl_li_manual_disc_ship_alloc)

LocalPromotionDiscount

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

LocalPromotionDiscountOrderAlloc

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

LocalPromotionDiscountShippingAlloc

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

LocalRetailPrice

• Field API Name: LocalRetailPrice__c
• Data Type: DOUBLE
• Description: Line item retail price in local currency.

LocalShipping

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

LocalShippingOrderAlloc

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

LocalTax

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

LocalTaxOrderAlloc

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

LocalUnitPrice

• Field API Name: LocalUnitPrice__c
• Data Type: DOUBLE
• Description: The unit price, before promotional or manual discounts, associated with the line item.

NaturalLineItemIdentifier

• Field API Name: NaturalLineItemIdentifier__c
• Data Type: TEXT
• Description: The natural key representing the line item in the source system.

NaturalOrderIdentifier

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

OrderIdentifier

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

PurchaseNumber

• Field API Name: PurchaseNumber__c
• Data Type: DOUBLE
• Description: The sequential order number of this purchase for the customer used to identify first-time vs. repeat buyer behavior.

Quantity

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

ShippingGeographyId

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

SiteId

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

SkuId

• Field API Name: SkuId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_product for the SKU.

SourceCodeGroupId

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

StandardCurrencyId

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

StandardGrossMerchandiseValue

• Field API Name: StandardGrossMerchandiseValue__c
• Data Type: DOUBLE
• Description: The Gross Merchandise Value (GMV) of the line item in the standard currency. GMV is derived using the following row-based calculation (quantity * std_li_unit_price) - ((std_li_promo_disc + std_li_manual_disc_order_alloc) + (std_li_manual_disc + std_li_manual_disc_order_alloc))

StandardManualDiscount

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

StandardManualDiscountOrderAlloc

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

StandardManualDiscountShippingAlloc

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

StandardMarkdown

• Field API Name: StandardMarkdown__c
• Data Type: DOUBLE
• Description: Line item markdown amount in standard currency.

StandardMarkdownDiscount

• Field API Name: StandardMarkdownDiscount__c
• Data Type: DOUBLE
• Description: Line item markdown discount in standard currency.

StandardMarkdownPrice

• Field API Name: StandardMarkdownPrice__c
• Data Type: DOUBLE
• Description: Line item markdown price in standard currency.

StandardNetMerchandiseValue

• Field API Name: StandardNetMerchandiseValue__c
• Data Type: DOUBLE
• Description: Line item net merchandise value in standard currency. This is derived using the following row-based calculation std_li_gross_merchandise_value + (std_li_tax + std_li_tax_order_alloc) + (std_li_shipping + std_li_shipping_order_alloc) - (std_li_promo_disc_ship_alloc + std_li_manual_disc_ship_alloc)

StandardPromotionDiscount

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

StandardPromotionDiscountOrderAlloc

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

StandardPromotionDiscountShipAlloc

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

StandardRetailPrice

• Field API Name: StandardRetailPrice__c
• Data Type: DOUBLE
• Description: Line item retail price in standard currency.

StandardShipping

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

StandardShippingOrderAlloc

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

StandardSubmitDayId

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

StandardSubmitTimeId

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

StandardSubmitTimestamp

• Field API Name: StandardSubmitTimestamp__c
• Data Type: DATETIME
• Description: Timestamp when the line item was submitted, in standard time.

StandardTax

• Field API Name: StandardTax__c
• Data Type: DOUBLE
• Description: Line item tax in standard currency.

StandardTaxOrderAlloc

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

StandardTimeZoneId

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

StandardUnitPrice

• Field API Name: StandardUnitPrice__c
• Data Type: DOUBLE
• Description: The unit price, before promotional or manual discounts, associated with the line item.

UserAgentId

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

UtcSubmitDayId

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

UtcSubmitTimeId

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

UtcSubmitTimestamp

• Field API Name: UtcSubmitTimestamp__c
• Data Type: DATETIME
• Description: UTC timestamp when the line item was submitted.

UtcUpdateTimestamp

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

VisitorIdentifier

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