The single view of the customer the entity ERPs & order desks never had — the same CPG account, mastered across SAP SD, the order desk / CRM, Asepto scheduling, export docs and the overseas Flex Films ERPs, resolved into one.
24 fragmented records across 6 source masters resolve to 9 golden records — a 63% duplicate rate collapsed on merge. Reconcile the 7 customers with conflicting payment terms to stop cash leakage and unlock the 9 cross-system CPG accounts.
9 of 24 records resolved to golden · 15 duplicates collapsed · 7 term conflicts open
The same buyer sits on Net 30 in one brand and Net 60 in another across 7 accounts — direct cash leakage and credit risk a single master removes.
24 raw records reduce to 9 golden — finishing survivorship gives every team one account, one team, one set of terms.
9 golden records are already served across ≥2 systems / businesses — the resolved master is the cross-sell base no single entity ERP or order desk could see alone.
Golden record is the join key for Customers & CPG Accounts 360 and Cash 360
Each business and entity kept its own customer list, so PepsiCo, Nestlé and Amul each exist several times across SAP SD, the order desk / CRM, Asepto scheduling and the overseas Flex Films entity ERPs — 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 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 |
|---|---|---|---|---|---|
| ★Flex Films entity ERP (overseas) | Overseas CPG accounts (8 plants) | FFI-9001 | Net 90 | ₹700 Cr | master |
| 0SAP SD (core ERP) | Global CPG exports (India-billed) | ACCT-40077 | Net 90 | ₹180 Cr | 91% |
| 0Export documentation (LC) | Films export buyers (LC) | EXP-771 | LC at sight | ₹380 Cr | 88% |
Conflict: payment terms differ across systems (Net 90 vs LC at sight). Survivorship keeps the master's Net 90; the others are flagged for credit to reconcile — exactly the kind of leakage a single view removes.
Cross-sell signal: Global CPGs — overseas films (150+ countries) is served across 3 UFlex systems / businesses. 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 'Nestlé India Ltd', 'Nestle - low-migration inks' and 'Nestlé SA (Europe films)' 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 businesses.
The golden record is the join key for everything else: it lets Customers & CPG Accounts 360 show one account, Cash 360 net one exposure, and the cross-sell engine see that a CPG already buys films and laminates but not aseptic — the same entity-resolution layer that powers the plant-grain and order/tender views.