---
title: "Summary Entities"
date: "2025-01-29T18:29:58+00:00"
summary: "Explore key relationships between Summary Entities in our system. Learn how customer, organization, product, and transaction data interconnect."
image:
type: "page"
url: "/customer-data-platform/summary-entities"
id: "4274b928-4d10-4e00-abea-e3e337103dd1"
---

The following tables outline the join relationships among Summary Entities within the system:

Customer Summary
----------------

These entities represent individual master-customer records after the Customer Data Platform (CDP) deduplicated the raw child-customer data.

**Entity Name**

**Key  Join**

**Join**

CUSTOMERSUMMARY

`mastercustomerid`

`customersummary.mastercustomerid=transactionsummary.mastercustomerid`

`customersummary.mastercustomerid=mastercustomer.mastercustomerid`

`customersummary.mastercustomerid=`  
`customerfirsttransactionproductcategory.mastercustomerid`

`customersummary.mastercustomerid=`  
`customerlasttransactionproductcategory.mastercustomerid`

`customersummary.FirstPromoID=promotiontypesummary.id`

`customersummary.FirstOfflinePromoID=promotiontypesummary.id`

`customersummary.closeststoreid=organizationsummary.id`

`customersummary.primarystoreid=organizationsummary.id`

Organization Summary
--------------------

A list of sales organizations and their associated stores.

**Entity Name**

**Key Join**

**Join**

ORGANIZATIONSUMMARY

`id`

`transactionsummary.organizationid=organizationsummary.id`

Product Summary
---------------

A list of products available in the catalog.

**Entity Name**

**Key Join**

**Join**

PRODUCTSUMMARY

`id`

`productsummary.id=transactionsummary.productid`

Product Category Summary
------------------------

A list of available product categories.

**Entity Name**

**Key Join**

**Join**

PRODUCTCATEGORYSUMMARY

`id`

`productcategorysummary.id=productcategoryxref.productcategoryid`

`productcategorysummary.id=customerfirsttransaction`  
`productcategory.productcategoryid`

`productcategorysummary.id=customerlasttransaction`  
`productcategory.productcategoryid`

`productcategorysummary.id=event.productcategoryid`

Promotion Type Summary
----------------------

A list of online and offline marketing promotions that influenced transactions.

**Entity Name**

**Key Join**

**Join**

PROMOTIONTYPESUMMARY

`id`

`promotiontypesummary.id=event.messageid`

`promotiontypesummary.id=customersummary.FirstPromoID`

`promotiontypesummary.id=transactionsummary.TransactionLastMarketingTouchID`

`promotiontypesummary.id=transactionsummary.TransactionLastOfflineMarketingTouchID`

`promotiontypesummary.id=transactionsummary.TransactionLastOffline`  
`MarketingTouchIDHousehold`

Time Summary
------------

Fiscal calendar mapping for each calendar date enables any datetime attribute to join with the `timesummary` table to find the corresponding fiscal calendar date. The following are a few examples: 

**Entity Name**

**Key Join**

**Join**

TIMESUMMARY

`id`

`TO_CHAR(timesummary.id)=TO_CHAR(transactionsummary.transactiontimestamp, ‘YYYYMMDD’)`

`TO_CHAR(timesummary.id)=TO_CHAR(transactionsummary.shipdate, ‘YYYYMMDD’)`

`TO_CHAR(timesummary.id)=TO_CHAR(customersummary.FirstTransactionDate, ‘YYYYMMDD’)`

`TO_CHAR(timesummary.id)=TO_CHAR(customersummary.LastTransactionDate, ‘YYYYMMDD’)`

Transaction Summary
-------------------

Line-level transaction records across all sales channels.

**Entity Name**

**Key Join**

**Join**

TRANSACTIONSUMMARY

`mastercustomerid`, `customerid`, `organizationid`, `productid`

`transactionsummary.customerid=customer.id`

`transactionsummary.mastercustomerid=customersummary.mastercustomerid`

`transactionsummary.organizationid=organization.id`

`transactionsummary.organizationid=organizationsummary.id`

`transactionsummary.productid=productsummary.id`