Claro

The Spare Parts Data Model Reference

For catalog architects, product data leads, and technical teams designing or evaluating a data model for spare-parts catalogs, electronic parts catalogs (EPC), or aftermarket platforms.

14 pages 20 minutes Printable PDF

Summary

Spare-parts data has requirements that generic product-data models do not anticipate: supersession chains with direction, quantity ratios and effective dates; applicability scoped by machine, model and serial range; position-based parts lists linked to exploded-view diagrams; cross-references typed by relationship (REPLACED_BY, EQUIVALENT_TO, SUPPLIED_BY) with evidence and confidence; and a service BOM that differs from the engineering BOM. This reference lays out the entities, relationships and attributes that a spare-parts data model needs, with worked examples for supersession chains (including splits and merges), serial-range applicability, parts-book position linking, and multi-brand cross-reference with evidence. The page you are reading is only the summary; the PDF contains the full entity-relationship diagrams, attribute tables, and worked examples.

What's inside

  • Entity definitions: Part, Assembly, Position, Equipment, Fitment Link, Supersession Link, Cross-Reference Link — with required and optional attributes for each.
  • Supersession modeling: one-to-one, one-to-many (split), many-to-one (merge), quantity-ratio recording, chain resolution, cycle detection, and broken-chain alerts.
  • Applicability modeling: equipment hierarchy (make → model → variant → serial range), fitment scoping, mid-serial engineering changes, and open-ended range handling.
  • Parts-book position linking: the four-layer model (visual, positional, identity, applicability) and how to keep positions stable while part numbers change through supersession.
  • Cross-reference modeling: typed relationships (REPLACED_BY vs EQUIVALENT_TO vs SUPPLIED_BY), confidence levels, evidence sources, and the difference between manufacturer-confirmed and spec-matched equivalence.
  • Worked examples with illustrative data for a hydraulic-pump assembly showing supersession chain resolution, serial-range applicability override, and OEM-to-aftermarket cross-reference with evidence.

Get the PDF

Request the whitepaper

Enter your name and email and we'll send The Spare Parts Data Model Reference straight to your inbox.

Or book a 30-min catalog review

We only use your email to send the PDF and occasionally useful catalog-data content. No spam, unsubscribe anytime.

Related resources

glossary

Spare Parts Data Glossary: Supersession, Crosswalks, Form-Fit-Function, BOMs and Part Status

Plain definitions of spare-parts data terms — supersession, crosswalk, form-fit-function, BOM variants, part status, applicability and more — with where each shows up in your catalog and what to read next.

guides

Parts Book Data Model: From PDF Pages to Structured Catalog Data

A parts book is a collection of assemblies, exploded views, position numbers and part lists. This guide covers the data model that keeps a parts book current when part numbers change, and the layers (visual, positional, identity, applicability) that a flat PDF collapses into one.

guides

Spare Parts Applicability Data: Machine, Model and Serial Range

Applicability data says which machines, models and serial-number ranges a part fits. This guide covers the data model, the common problems (open-ended ranges, mid-serial changes, overlapping fitment), and what a clean applicability record needs.

Free download

Get the file

Tell us where to send it and we'll email you a direct download link for .

Download links work for 7 days. We use your details to send the file and to understand who uses our resources. No spam.