# 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](/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.
- **SkuId** has a FOREIGNKEY relationship with the [Cc Dim Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimproductdmo-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.
- **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)
- [DocumentNo](#documentno)
- [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_ShippingGeographyId](#kq_shippinggeographyid)
- [KQ_SiteId](#kq_siteid)
- [KQ_SkuId](#kq_skuid)
- [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)
- [LocalCurrencyId](#localcurrencyid)
- [LocaleId](#localeid)
- [LocalGrossMerchandiseValue](#localgrossmerchandisevalue)
- [LocalManualDiscount](#localmanualdiscount)
- [LocalManualDiscountOrderAlloc](#localmanualdiscountorderalloc)
- [LocalManualDiscountShippingAlloc](#localmanualdiscountshippingalloc)
- [LocalMarkdown](#localmarkdown)
- [LocalMarkdownDiscount](#localmarkdowndiscount)
- [LocalMarkdownPrice](#localmarkdownprice)
- [LocalNetMerchandiseValue](#localnetmerchandisevalue)
- [LocalPromotionDiscount](#localpromotiondiscount)
- [LocalPromotionDiscountOrderAlloc](#localpromotiondiscountorderalloc)
- [LocalPromotionDiscountShippingAlloc](#localpromotiondiscountshippingalloc)
- [LocalRetailPrice](#localretailprice)
- [LocalShipping](#localshipping)
- [LocalShippingOrderAlloc](#localshippingorderalloc)
- [LocalTax](#localtax)
- [LocalTaxOrderAlloc](#localtaxorderalloc)
- [LocalUnitPrice](#localunitprice)
- [NaturalLineItemIdentifier](#naturallineitemidentifier)
- [NaturalOrderIdentifier](#naturalorderidentifier)
- [OrderIdentifier](#orderidentifier)
- [PurchaseNumber](#purchasenumber)
- [Quantity](#quantity)
- [ShippingGeographyId](#shippinggeographyid)
- [SiteId](#siteid)
- [SkuId](#skuid)
- [SourceCodeGroupId](#sourcecodegroupid)
- [StandardCurrencyId](#standardcurrencyid)
- [StandardGrossMerchandiseValue](#standardgrossmerchandisevalue)
- [StandardManualDiscount](#standardmanualdiscount)
- [StandardManualDiscountOrderAlloc](#standardmanualdiscountorderalloc)
- [StandardManualDiscountShippingAlloc](#standardmanualdiscountshippingalloc)
- [StandardMarkdown](#standardmarkdown)
- [StandardMarkdownDiscount](#standardmarkdowndiscount)
- [StandardMarkdownPrice](#standardmarkdownprice)
- [StandardNetMerchandiseValue](#standardnetmerchandisevalue)
- [StandardPromotionDiscount](#standardpromotiondiscount)
- [StandardPromotionDiscountOrderAlloc](#standardpromotiondiscountorderalloc)
- [StandardPromotionDiscountShipAlloc](#standardpromotiondiscountshipalloc)
- [StandardRetailPrice](#standardretailprice)
- [StandardShipping](#standardshipping)
- [StandardShippingOrderAlloc](#standardshippingorderalloc)
- [StandardSubmitDayId](#standardsubmitdayid)
- [StandardSubmitTimeId](#standardsubmittimeid)
- [StandardSubmitTimestamp](#standardsubmittimestamp)
- [StandardTax](#standardtax)
- [StandardTaxOrderAlloc](#standardtaxorderalloc)
- [StandardTimeZoneId](#standardtimezoneid)
- [StandardUnitPrice](#standardunitprice)
- [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.

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