# Cc Fact Order Payment DMO

This DMO contains order payment fact data from ccdw_fact_order_payment. Each record represents a payment transaction associated with an order, capturing payment method, amounts, and customer context.

## Object Properties

**Object API Name:** `CcFactOrderPayment_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](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimdatedmo-dmo.md) `Id` field.
- **UtcSubmitTimeId** has a FOREIGNKEY relationship with the [Cc Dim Time DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimtimedmo-dmo.md) `Id` field.
- **StandardSubmitDayId** has a FOREIGNKEY relationship with the [Cc Dim Date DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimdatedmo-dmo.md) `Id` field.
- **StandardSubmitTimeId** has a FOREIGNKEY relationship with the [Cc Dim Time DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimtimedmo-dmo.md) `Id` field.
- **StandardTimeZoneId** has a FOREIGNKEY relationship with the [Cc Dim Time Zone DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimtimezonedmo-dmo.md) `Id` field.
- **LocaleId** has a FOREIGNKEY relationship with the [Cc Dim Locale DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimlocaledmo-dmo.md) `Id` field.
- **SiteId** has a FOREIGNKEY relationship with the [Cc Dim Site DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimsitedmo-dmo.md) `Id` field.
- **BusinessChannelId** has a FOREIGNKEY relationship with the [Cc Dim Business Channel DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimbusinesschanneldmo-dmo.md) `Id` field.
- **UserAgentId** has a FOREIGNKEY relationship with the [Cc Dim User Agent DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimuseragentdmo-dmo.md) `Id` field.
- **SourceCodeGroupId** has a FOREIGNKEY relationship with the [Cc Dim Source Code Group DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimsourcecodegroupdmo-dmo.md) `Id` field.
- **PaymentMethodId** has a FOREIGNKEY relationship with the [Cc Dim Payment Method DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimpaymentmethoddmo-dmo.md) `Id` field.
- **CustomerId** has a FOREIGNKEY relationship with the [Cc Dim Customer DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimcustomerdmo-dmo.md) `Id` field.
- **LocalCurrencyId** has a FOREIGNKEY relationship with the [Cc Dim Currency DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimcurrencydmo-dmo.md) `Id` field.
- **StandardCurrencyId** has a FOREIGNKEY relationship with the [Cc Dim Currency DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimcurrencydmo-dmo.md) `Id` field.
- **ShippingGeographyId** has a FOREIGNKEY relationship with the [Cc Dim Geography DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimgeographydmo-dmo.md) `Id` field.
- **InvoiceGeographyId** has a FOREIGNKEY relationship with the [Cc Dim Geography DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimgeographydmo-dmo.md) `Id` field.
- **CustomerGeographyId** has a FOREIGNKEY relationship with the [Cc Dim Geography DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimgeographydmo-dmo.md) `Id` field.

## Fields

- [AiAgentSessionIdentifier](#aiagentsessionidentifier)
- [BusinessChannelId](#businesschannelid)
- [BuyerEmail](#buyeremail)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CustomerGeographyId](#customergeographyid)
- [CustomerId](#customerid)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [HasTrackingOptedOut](#hastrackingoptedout)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [InvoiceGeographyId](#invoicegeographyid)
- [IsAnonymous](#isanonymous)
- [KQ_BusinessChannelId](#kq_businesschannelid)
- [KQ_CustomerGeographyId](#kq_customergeographyid)
- [KQ_CustomerId](#kq_customerid)
- [KQ_Id](#kq_id)
- [KQ_InvoiceGeographyId](#kq_invoicegeographyid)
- [KQ_LocalCurrencyId](#kq_localcurrencyid)
- [KQ_LocaleId](#kq_localeid)
- [KQ_PaymentMethodId](#kq_paymentmethodid)
- [KQ_ShippingGeographyId](#kq_shippinggeographyid)
- [KQ_SiteId](#kq_siteid)
- [KQ_SourceCodeGroupId](#kq_sourcecodegroupid)
- [KQ_StandardCurrencyId](#kq_standardcurrencyid)
- [KQ_StandardSubmitDayId](#kq_standardsubmitdayid)
- [KQ_StandardSubmitTimeId](#kq_standardsubmittimeid)
- [KQ_StandardTimeZoneId](#kq_standardtimezoneid)
- [KQ_UserAgentId](#kq_useragentid)
- [KQ_UtcSubmitDayId](#kq_utcsubmitdayid)
- [KQ_UtcSubmitTimeId](#kq_utcsubmittimeid)
- [LocalCapturedAmount](#localcapturedamount)
- [LocalCurrencyId](#localcurrencyid)
- [LocaleId](#localeid)
- [LocalRefundedAmount](#localrefundedamount)
- [LocalTransactionAmount](#localtransactionamount)
- [NaturalOrderIdentifier](#naturalorderidentifier)
- [PaymentMethodId](#paymentmethodid)
- [ShippingGeographyId](#shippinggeographyid)
- [SiteId](#siteid)
- [SourceCodeGroupId](#sourcecodegroupid)
- [StandardCapturedAmount](#standardcapturedamount)
- [StandardCurrencyId](#standardcurrencyid)
- [StandardRefundedAmount](#standardrefundedamount)
- [StandardSubmitDayId](#standardsubmitdayid)
- [StandardSubmitTimeId](#standardsubmittimeid)
- [StandardSubmitTimestamp](#standardsubmittimestamp)
- [StandardTimeZoneId](#standardtimezoneid)
- [StandardTransactionAmount](#standardtransactionamount)
- [UserAgentId](#useragentid)
- [UtcSubmitDayId](#utcsubmitdayid)
- [UtcSubmitTimeId](#utcsubmittimeid)
- [UtcSubmitTimestamp](#utcsubmittimestamp)
- [UtcUpdateTimestamp](#utcupdatetimestamp)
- [VisitorIdentifier](#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.

### 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 order payment record.

### 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_PaymentMethodId

- **Field API Name:** `KQ_PaymentMethodId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for PaymentMethodId

### 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_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

### LocalCapturedAmount

- **Field API Name:** `LocalCapturedAmount__c`
- **Data Type:** DOUBLE
- **Description:** Captured amount in local currency.

### 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.

### LocalRefundedAmount

- **Field API Name:** `LocalRefundedAmount__c`
- **Data Type:** DOUBLE
- **Description:** Refunded amount in local currency.

### LocalTransactionAmount

- **Field API Name:** `LocalTransactionAmount__c`
- **Data Type:** DOUBLE
- **Description:** Transaction amount in local currency.

### NaturalOrderIdentifier

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

### PaymentMethodId

- **Field API Name:** `PaymentMethodId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_payment_method.

### 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.

### SourceCodeGroupId

- **Field API Name:** `SourceCodeGroupId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_source_code_group.

### StandardCapturedAmount

- **Field API Name:** `StandardCapturedAmount__c`
- **Data Type:** DOUBLE
- **Description:** Captured amount in standard currency.

### StandardCurrencyId

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

### StandardRefundedAmount

- **Field API Name:** `StandardRefundedAmount__c`
- **Data Type:** DOUBLE
- **Description:** Refunded amount in standard currency.

### 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 payment was submitted, in standard time.

### StandardTimeZoneId

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

### StandardTransactionAmount

- **Field API Name:** `StandardTransactionAmount__c`
- **Data Type:** DOUBLE
- **Description:** Transaction amount in standard currency.

### 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 payment 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.