Unify and manage your data

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 Console > Data Modeler > Entity Types > <entity> > Match rules.

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
(
    Exact on
        Material Number Within Industry Sector And Type
)
Fuzzy (Short Description Within Material Type And Group) Creates a potential match
(
    Fuzzy on
        Short Description Within Material Type And Group
)

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 on
        GTIN-14 Within Target Market
)
Exact (Internal Trade Item Reference) Creates a potential match
(
    Exact on
        Internal Trade Item Reference
)
Exact (Brand, GPC, and Target Market); Fuzzy (Description) Creates a potential match
(
    Exact on
        Brand
        and
        GPC
        and
        Target Market
)
and
    Fuzzy on
        Description

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 on
        One Label Profile Per GTIN-14
        and
        Target Market
)
Exact (Internal Label Profile Reference) Creates a potential match
(
    Exact on
        Internal Label Profile Reference
)
Exact (GTIN And Label Status Across Markets) Creates a potential match
(
    Exact on
        GTIN And Label Status Across Markets
)

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 on
        Suspect Match On Complete Postal Address
)
Exact (Auto-merge On GLN) Automatically merges records
(
    Exact on
        Auto-merge On GLN
)
Exact (Suspect Match On External Plant Code) Creates a potential match
(
    Exact on
        Suspect Match On External Plant Code
)
Exact (Suspect Match On Location Name And Country) Creates a potential match
(
    Exact on
        Suspect Match On Location Name And Country
)
Exact (Verified Address: Address Line, City, State, Region, Country And Postal Code; Address Line 2 Exact, or Empty) Automatically merges records
(
    Exact on
        Verified Address: Address Line
        or
        City
        or
        State
        or
        Region
        or
        Country And Postal Code; Address Line 2 Exact
        or
        Empty
)

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
(
    Exact on
        Regulation / Standard Identifier
)
Fuzzy (Short Title Within Jurisdiction And Document Type) Creates a potential match
(
    Fuzzy on
        Short Title Within Jurisdiction And Document Type
)

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 on
        Internal Obligation ID
)
Exact (Obligation Code Within Enforcement Jurisdiction) Automatically merges records
(
    Exact on
        Obligation Code Within Enforcement Jurisdiction
)
Fuzzy (Obligation Name Within Regulatory Domain And Jurisdiction) Creates a potential match
(
    Fuzzy on
        Obligation Name Within Regulatory Domain And Jurisdiction
)

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 on
        Official Authority ID
)
Exact (Internal Regulatory Authority Reference) Creates a potential match
(
    Exact on
        Internal Regulatory Authority Reference
)
Fuzzy (Authority Name Within Jurisdiction And Type) Creates a potential match
(
    Fuzzy on
        Authority Name Within Jurisdiction And Type
)

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 on
        Composite Listing ID
)
Exact (GTIN and Retailer GLN) Creates a potential match
(
    Exact on
        GTIN
        and
        Retailer GLN
)
Exact (Retailer Article Number Within Retailer GLN) Creates a potential match
(
    Exact on
        Retailer Article Number Within Retailer GLN
)

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 on
        IBAN Match
)
Exact (Bank Key, Account Number, and Bank Country) Automatically merges records
(
    Exact on
        Bank Key
        and
        Account Number
        and
        Bank Country
)
Exact (BIC and Currency); Fuzzy (Account Holder Name) Creates a potential match
(
    Exact on
        BIC
        and
        Currency
)
and
    Fuzzy on
        Account Holder Name

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 on
        LEI
)
Exact (GLN) Automatically merges records
(
    Exact on
        GLN
)
Exact (DUNS Number) Automatically merges records
(
    Exact on
        DUNS Number
)
Exact (Controlling Area); Fuzzy (Organization Name) Creates a potential match
(
    Exact on
        Controlling Area
)
and
    Fuzzy on
        Organization Name
Exact (BP Number) Creates a potential match
(
    Exact on
        BP Number
)
Exact (Retailer GLN) Creates a potential match
(
    Exact on
        Retailer GLN
)

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 on
        LEI
)
Exact (GLN) Automatically merges records
(
    Exact on
        GLN
)
Exact (DUNS Number) Automatically merges records
(
    Exact on
        DUNS Number
)
Exact (Controlling Area); Fuzzy (Organization Name) Creates a potential match
(
    Exact on
        Controlling Area
)
and
    Fuzzy on
        Organization Name
Exact (BP Number) Creates a potential match
(
    Exact on
        BP Number
)

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 on
        Suspect Match On Name
)
Exact (Suspect Match On External Contact ID) Creates a potential match
(
    Exact on
        Suspect Match On External Contact ID
)
Exact (Suspect Match On Name, Role, or And Department) Creates a potential match
(
    Exact on
        Suspect Match On Name
        or
        Role
        or
        And Department
)
Exact (BP Number) Creates a potential match
(
    Exact on
        BP Number
)

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 on
        Plant Code
)
Exact (GLN) Automatically merges records
(
    Exact on
        GLN
)
Fuzzy (Plant Name Within Country And Type) Creates a potential match
(
    Fuzzy on
        Plant Name Within Country And Type
)

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 on
        Recipe Code And Version
)
Exact (External Recipe ID) Creates a potential match
(
    Exact on
        External Recipe ID
)
Fuzzy (Recipe Description) Creates a potential match
(
    Fuzzy on
        Recipe Description
)

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 on
        Promotion ID
)
Exact (External Promotion ID) Creates a potential match
(
    Exact on
        External Promotion ID
)

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 on
        Internal Ingredient Code
)
Exact (Source Material Number) Creates a potential match
(
    Exact on
        Source Material Number
)
Fuzzy (Ingredient Name) Creates a potential match
(
    Fuzzy on
        Ingredient Name
)

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 on
        Batch Number With Material And Optional Plant
)
Exact (External Batch Number) Creates a potential match
(
    Exact on
        External Batch Number
)
Exact (Internal Lot Reference) Creates a potential match
(
    Exact on
        Internal Lot Reference
)