The single view of the customer the legacy channel & franchise-bottler systems never had — the same account, mastered across SAP S/4, DMS, Q-commerce and every source system, resolved into one.
13 fragmented records across 8 source masters resolve to 6 golden records — a 54% duplicate rate collapsed on merge. Reconcile the 3 customers with conflicting payment terms to stop cash leakage and unify the 6 multi-system accounts.
6 of 13 records resolved to golden · 7 duplicates collapsed · 3 term conflicts open
The same buyer sits on one set of terms in one system and different terms in another across 3 accounts (e.g. domestic Net 30 vs export LC at sight) — direct cash leakage and credit risk a single master removes.
13 raw records reduce to 6 golden — finishing survivorship gives every team one account, one team, one set of terms.
6 golden records are already served across ≥2 systems — the resolved master is the single account view no single source system could see alone.
Golden record is the join key for Channels & Trade 360 and Cash 360
Each channel and legacy system kept its own account list, so the GT distributor network, modern-trade chains and Q-commerce platforms each exist several times across SAP, DMS, franchise-bottler and retail-audit systems — with different names, IDs and even payment terms. Until they're resolved, no one can see the true relationship, total exposure, or cross-sell base. This is the golden record AI builds on top of the data mesh.
The ★ master survives; the rest merge with a match confidence. Conflicting terms are flagged in red.
| Source system | Name as stored | ID | Terms | AR | Match |
|---|---|---|---|---|---|
| ★SAP S/4 (core ERP) | GT Distributors (primary sales) | ACCT-10011 | Net 15 | ₹90 Cr | master |
| 0DMS (Distributor Mgmt System) | GT super-stockists & distributors | DMS-2201 | Net 15 | ₹60 Cr | 96% |
| 0Retail audit (Nielsen) | Kirana / GT outlets (audited) | NLS-4471 | n/a | ₹0 Cr | 90% |
Conflict: payment terms differ across systems (Net 15 vs n/a). Survivorship keeps the master's Net 15; the others are flagged for credit to reconcile — exactly the kind of leakage a single view removes.
Cross-system signal: General Trade distributor network is served across 3 Parle Agro source systems. That's a relationship to coordinate (one account team, one set of terms) — and a cross-sell base already inside the house.
Fuzzy + LLM matching on name, address and tax ID links 'GT Distributors (primary sales)', 'GT super-stockists & distributors' and 'Kirana / GT outlets (audited)' to one entity — with a confidence score, not a blind merge.
Records above the confidence threshold collapse into one; borderline matches are queued for a human steward.
Survivorship rules pick the winning value field-by-field (most-recent, most-complete, or the governed source) to form the golden record.
Conflicts — different terms, duplicate AR — are surfaced to credit and sales, and total exposure is netted across the systems.
The golden record is the join key for everything else: it lets Channels & Trade 360 show one account, Cash 360 net one exposure, and the cross-sell engine see that a channel already buys across two systems — the same entity-resolution layer that powers the plant-grain and order/channel views.