---
title: "Non-Summary Entities"
date: "2025-01-29T18:40:24+00:00"
summary: "Explore join relationships among non-summary entities in our system. Understand data connections for effective analysis and queries."
image:
type: "page"
url: "/customer-data-platform/non-summary-entities"
id: "1d9e366d-d9e0-4c70-8d2e-d7a169067978"
---

The following tables outline the join relationships among Non-Summary Entities in the system:

Address
-------

A list of address records associated with child-customers.

**Entity Name**

**Key Join**

**Join**

ADDRESS

`id`

`address.id=customeraddressxref.addressid`

Customer
--------

Records of individual child-customers prior to the deduplication process by CDP.

**Entity Name**

**Key Join**

**Join**

CUSTOMER

`id`

`customer.id=mastercustomer.customerid`

`customer.id=transactionsummary.customerid`

`customer.id=event.customerid`

`customer.id=customeraddressxref.customerid`

Dispatch
--------

An organized structure that captures and maintains all system event activities related to an upstream source system of CDP. These dispatch activities aim to reconcile marketing campaigns with specific linked messages.

**Entity Name**

**Key Join**

**Join**

DISPATCH

`id`,`campaignid`

`dispatch.id=message.dispatchid`

`dispatch.campaignid=campaign.id`

Campaign
--------

List of all campaigns for your tenant, linked to dispatch records.

**Entity Name**

**Key Join**

**Join**

CAMPAIGN

`id`

`campaign.id=dispatch.campaignid`

Event
-----

A complete list of all customer events for your tenant.

**Entity Name**

**Key Join**

**Join**

EVENT

`customerid`, `productid`, `productcategoryid`, `transactionid`, `messageid`, `organizationid`

`event.customerid=customer.id`

`event.customerid=mastercustomer.customerid`

`event.productid=product.id`

`event.productcategoryid=productcategory.id`

`event.transactionid=transaction.id`  
`event.messageid=message.id`

`event.organizationid=organization.id`

Master Customer
---------------

This cross-reference links child-customer records to master-customer records to allow multiple child-customer records to aggregate under one master-customer record.

**Entity Name**

**Key Join**

**Join**

MASTERCUSTOMER

`mastercustomerid or customerid`

`mastercustomer.mastercustomerid=customersummary.mastercustomerid`

`mastercustomer.customerid=customer.id`

`mastercustomer.mastercustomerid=transactionsummary.mastercustomerid`

`mastercustomer.customerid=customeraddressxref.customerid`

`mastercustomer.customerid=event.customerid`

Message
-------

This cross-reference links child-customer records to master-customer records to allow multiple child-customer records to aggregate under one master-customer record.

**Entity Name**

**Key Join**

**Join**

MESSAGE

`id`, `dispatchid`

`message.id=event.messageid`

`message.dispatchid=dispatch.id`

Organization
------------

The records represent individual child-customers prior to the CDP deduplication process.

**Entity Name**

**Key Join**

**Join**

ORGANIZATION

`id`

`transaction.organizationid=organization.id`

`transactionitem.organization.id=organization.id`

Payment Method
--------------

This entity represents various payment methods and their associations with transaction records.

**Entity Name**

**Key Join**

**Join**

PAYMENTMETHOD

`id`

`transactionpaymentmethodxref.paymentmethodid=`  
`paymentmethod.id`

Product
-------

A list of products that have not been deduplicated with respect to transaction activities and customer data.

**Entity Name**

**Key Join**

**Join**

PRODUCT

`id`

`product.id=transactionitem.productid`

`product.id=productcategoryxref.productid`

Product Category
----------------

A list of product categories that have not been deduplicated in relation to transaction activities, product hierarchy, and customer data.

Entity Name
-----------

Key Join
--------

Join
----

PRODUCTCATEGORY

`id`

`productcategory.id=productcategoryxref.productcategoryid`

`productcategory.id=customerfirsttransactionproductcategory.productcategoryid`

`productcategory.id=customerlasttransactionproductcategory.productcategoryid`

`productcategory.id=event.productcategoryid`

Transaction
-----------

A list of individual transaction records before deduplication.

**Entity Name**

**Key Join**

**Join**

TRANSACTION

`id`, `customerid`, `organizationid`

`transaction.customerid=customer.id`

`transaction.id=transactionitem.transactionid`

`transaction.organizationid = organization.id`

`transaction.id = transactionmessagexref.transactionid`

Transaction Item
----------------

A list of individual transaction items before deduplication.

**Entity Name**

**Key Join**

**Join**

TRANSACTIONITEM

`id`, `productid`, `organizationid`

`transactionitem.productid = product.id`

`transactionitem.organizationid = organization.id`

`transactionitem.transactionid=transaction.id`

`transactionitemmessagexref.transactionitemid=transactionitem.id`

`transactionitempromotionxref.transactionitemid=transactionitem.id`