---
title: "XRef Entities"
date: "2025-01-30T04:20:09+00:00"
summary: "Explore XRef entities: Join relationships for customer addresses, transactions, product categories, and payment methods in our system."
image:
type: "page"
url: "/customer-data-platform/xref-entities-0"
id: "7fd15943-8c9d-4f4d-b092-10df61a72f5d"
---

The following tables outline the join relationships among XREF entities, optionally visible within the system:

Customer Addressxref
--------------------

This entity provides a cross-reference between child-customers and their respective addresses.

**Entity Name**

**Key Join**

**Join**

CUSTOMERADDRESSXREF

`customerid`, `addressid`

`customeraddressxref.customerid=customer.id`

`customeraddressxref.addressid=address.id`

Customer First Transaction Product Category
-------------------------------------------

This entity cross-references master-customers with the product categories of their first transactions.

**Entity Name**

**Key Join**

**Join**

CUSTOMERFIRSTTRANSACTION  
PRODUCTCATEGORY

`productcategoryid`, `mastercustomerid`

`customerfirsttransactionproductcategory.productcategoryid=`  
`productcategorysummary.id`

`customerfirsttransactionproductcategory.mastercustomerid=`  
`customersummary.mastercustomerid`

Customer Last Transaction Product Category
------------------------------------------

This entity cross-references master-customers with the product categories of their last transactions.

**Entity Name**

**Key Join**

**Join**

CUSTOMERLASTTRANSACTION  
PRODUCTCATEGORY

`productcategoryid`, `mastercustomerid`

`customerlasttransactionproductcategory.productcategoryid=`  
`productcategorysummary.id`

`customerlasttransactionproductcategory.mastercustomerid=`  
`customersummary.mastercustomerid`

Product Categoryxref
--------------------

This entity cross-references products with their corresponding product categories.

**Entity Name**

**Key Join**

**Join**

PRODUCTCATEGORYXREF

`productid`, `productcategory`

`productcategoryxref.productid=product.id`

`productcategoryxref.productcategoryid=productcategory.id`

Transaction Payment Methodxref
------------------------------

This entity cross-references child-customers with their corresponding addresses.

**Entity Name**

**Key Join**

**Join**

TRANSACTIONPAYMENT  
METHODXREF

`paymentmethodid`, `transaction`

`transactionpaymentmethodxref.paymentmethodid=paymentmethod.id`

`transactionpaymentmethodxref.transactionid=transaction.id`