Match rules for SAP Reltio's velocity pack for Consumer Packaged Goods
Learn about the match rules used in SAP Reltio's velocity pack for Consumer Packaged Goods that are defined out-of-the-box.
SAP Reltio's velocity pack for Consumer Packaged Goods brings together systems and most of these systems duplicate customer information. Match rules define the criteria Reltio uses to determine whether two records are duplicates.
SAP Reltio's velocity pack for Consumer Packaged Goods comes with predefined match rules specific to the industry. Take a look at the match rules types defined for a specific entity in .
For general information on match rules, see topic Reltio match and merge. For information on working with match rules, see topic Configure match rules overview. For descriptions of the match rules that come with SAP Reltio's velocity pack for Consumer Packaged Goods, see the following sections.
Material entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the Material entity type. Use these match rules to create a record for an internal product golden record — enterprise SKU / material spine.
| Label | Description | Match queries |
|---|---|---|
| Exact (Material Number Within Industry Sector And Type) | Creates a potential match |
|
| Fuzzy (Short Description Within Material Type And Group) | Creates a potential match |
|
TradeItem entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the TradeItem entity type. Use these match rules to create a record for a retailer-facing trade item (GTIN-identified) with GS1/GDSN content, e-commerce merchandising attributes, and optional regulated-product identifiers.
| Label | Description | Match queries |
|---|---|---|
| Exact (GTIN-14 Within Target Market) | Automatically merges records |
|
| Exact (Internal Trade Item Reference) | Creates a potential match |
|
| Exact (Brand, GPC, and Target Market); Fuzzy (Description) | Creates a potential match |
|
TradeItemLabelProfile entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the TradeItemLabelProfile entity type. Use these match rules to create a record for a market-scoped label compliance extension of a TradeItem — nutrition panels, allergen declarations, and ingredient lists published to GDSN and retailer data pools.
| Label | Description | Match queries |
|---|---|---|
| Exact (One Label Profile Per GTIN-14 and Target Market) | Automatically merges records |
|
| Exact (Internal Label Profile Reference) | Creates a potential match |
|
| Exact (GTIN And Label Status Across Markets) | Creates a potential match |
|
Location entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the Location entity type. Use these match rules to create a record for a canonical location and address master shared by customer organizations, suppliers, individuals, and plants.
| Label | Description | Match queries |
|---|---|---|
| Exact (Suspect Match On Complete Postal Address) | Creates a potential match |
|
| Exact (Auto-merge On GLN) | Automatically merges records |
|
| Exact (Suspect Match On External Plant Code) | Creates a potential match |
|
| Exact (Suspect Match On Location Name And Country) | Creates a potential match |
|
| Exact (Verified Address: Address Line, City, State, Region, Country And Postal Code; Address Line 2 Exact, or Empty) | Automatically merges records |
|
RegulatoryDocument entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the RegulatoryDocument entity type. Use these match rules to create a record for an authoritative regulatory source document (e.g.
| Label | Description | Match queries |
|---|---|---|
| Exact (Regulation / Standard Identifier) | Automatically merges records |
|
| Fuzzy (Short Title Within Jurisdiction And Document Type) | Creates a potential match |
|
ComplianceObligation entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the ComplianceObligation entity type. Use these match rules to create a record for a specific compliance obligation, prohibition, or permission derived from a named regulatory document (e.g.
| Label | Description | Match queries |
|---|---|---|
| Exact (Internal Obligation ID) | Creates a potential match |
|
| Exact (Obligation Code Within Enforcement Jurisdiction) | Automatically merges records |
|
| Fuzzy (Obligation Name Within Regulatory Domain And Jurisdiction) | Creates a potential match |
|
RegulatoryAuthority entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the RegulatoryAuthority entity type. Use these match rules to create a record for a master record for a regulatory body or standards organization that issues and enforces compliance obligations applicable to CPG trade items and suppliers.
| Label | Description | Match queries |
|---|---|---|
| Exact (Official Authority ID) | Automatically merges records |
|
| Exact (Internal Regulatory Authority Reference) | Creates a potential match |
|
| Fuzzy (Authority Name Within Jurisdiction And Type) | Creates a potential match |
|
ProductListing entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the ProductListing entity type. Use these match rules to create a record for a specific record.
| Label | Description | Match queries |
|---|---|---|
| Exact (Composite Listing ID) | Automatically merges records |
|
| Exact (GTIN and Retailer GLN) | Creates a potential match |
|
| Exact (Retailer Article Number Within Retailer GLN) | Creates a potential match |
|
BankAccount entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the BankAccount entity type. Use these match rules to create a record for a payment-routing master for Organization, Supplier, or Individual holders.
| Label | Description | Match queries |
|---|---|---|
| Exact (IBAN Match) | Automatically merges records |
|
| Exact (Bank Key, Account Number, and Bank Country) | Automatically merges records |
|
| Exact (BIC and Currency); Fuzzy (Account Holder Name) | Creates a potential match |
|
Organization entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the Organization entity type. Use these match rules to create a record for a customer account master for retailers, distributors, and wholesalers.
| Label | Description | Match queries |
|---|---|---|
| Exact (LEI) | Automatically merges records |
|
| Exact (GLN) | Automatically merges records |
|
| Exact (DUNS Number) | Automatically merges records |
|
| Exact (Controlling Area); Fuzzy (Organization Name) | Creates a potential match |
|
| Exact (BP Number) | Creates a potential match |
|
| Exact (Retailer GLN) | Creates a potential match |
|
Supplier entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the Supplier entity type. Use these match rules to create a record for a vendor / supplier master for CPG procurement and qualification — parallel golden record to Organization (B2B-style).
| Label | Description | Match queries |
|---|---|---|
| Exact (LEI) | Automatically merges records |
|
| Exact (GLN) | Automatically merges records |
|
| Exact (DUNS Number) | Automatically merges records |
|
| Exact (Controlling Area); Fuzzy (Organization Name) | Creates a potential match |
|
| Exact (BP Number) | Creates a potential match |
|
Individual entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the Individual entity type. Use these match rules to create a record for a person master for CPG — contacts, employees, and affiliated individuals (B2B Individual parity).
| Label | Description | Match queries |
|---|---|---|
| Exact (Suspect Match On Name) | Creates a potential match |
|
| Exact (Suspect Match On External Contact ID) | Creates a potential match |
|
| Exact (Suspect Match On Name, Role, or And Department) | Creates a potential match |
|
| Exact (BP Number) | Creates a potential match |
|
Plant entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the Plant entity type. Use these match rules to create a record for a manufacturing, storage, or distribution facility (plant/site) linking materials to operational locations.
| Label | Description | Match queries |
|---|---|---|
| Exact (Plant Code) | Creates a potential match |
|
| Exact (GLN) | Automatically merges records |
|
| Fuzzy (Plant Name Within Country And Type) | Creates a potential match |
|
Recipe entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the Recipe entity type. Use these match rules to create a record for an optional formulation overlay — identity stub for an approved recipe version linked to a finished Material.
| Label | Description | Match queries |
|---|---|---|
| Exact (Recipe Code And Version) | Creates a potential match |
|
| Exact (External Recipe ID) | Creates a potential match |
|
| Fuzzy (Recipe Description) | Creates a potential match |
|
TradePromotion entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the TradePromotion entity type. Use these match rules to create a record for an optional trade-promotion identity overlay scoped to trade items and customer Organizations.
| Label | Description | Match queries |
|---|---|---|
| Exact (Promotion ID) | Creates a potential match |
|
| Exact (External Promotion ID) | Creates a potential match |
|
Ingredient entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the Ingredient entity type. Use these match rules to create a record for an optional ingredient / substance identity overlay.
| Label | Description | Match queries |
|---|---|---|
| Exact (Internal Ingredient Code) | Creates a potential match |
|
| Exact (Source Material Number) | Creates a potential match |
|
| Fuzzy (Ingredient Name) | Creates a potential match |
|
MaterialLot entity type match rules
This table identifies the SAP Reltio's velocity pack for Consumer Packaged Goods match rules used to master data for the MaterialLot entity type. Use these match rules to create a record for an optional lot / batch identity overlay for FEFO and recall identity.
| Label | Description | Match queries |
|---|---|---|
| Exact (Batch Number With Material And Optional Plant) | Creates a potential match |
|
| Exact (External Batch Number) | Creates a potential match |
|
| Exact (Internal Lot Reference) | Creates a potential match |
|