The item master, and why it is not a parts list

Almost every PLM problem that looks like a data problem is an identity problem underneath: two records for one thing, or one record for two things.

ERPShipped in segment S04 · 853 words
PLM PARTSERP ITEMS330-1140mpn TE-1734592-1510-0090no mpn on file700-0012firmware · newMATCH ORDER1 · manufacturer part number2 · internal part number3 · configured tie-breakCTRL-BOARD-Amatched on mpnPKG-0044 CartonERP-only · keeps its identity510-0090matched on internal numberFRT-STD FreightERP-only · never an engineering part700-0012 — NO MATCHsurfaced for a person: create it, link it, or leave it engineering-onlyTwo namespaces that overlap, not one namespace with two owners. Forcing every ERP item into engineering's numbering is the usual early mistake.Never matched on description similarity — a wrong merge is close to unpickable.

What an item is

An item is a persistent identifier for a real thing. A capacitor, a bracket, a firmware image, a finished product. It exists from the moment somebody decides the thing needs a name and it never goes away, because things that stopped being made were still bought and still shipped.

A revision is a version of that item, and it is where nearly all the data lives — the structure, the documents, the approved manufacturers, the state. The item itself holds very little: an identifier, a type, a classification, and a description that is allowed to be dull.

That distribution is deliberate. Anything that can change without changing what the thing is belongs on the item; anything that changes because the thing changed belongs on the revision. The test resolves most field-placement arguments in one pass, and it is worth having the argument once at configuration time rather than every quarter afterwards.

When two items are one item

The most expensive data condition in any PLM is duplicate identity: the same physical component entered twice, under two numbers, by two engineers who searched for it differently.

It is expensive because the duplicates are individually correct. Both records describe a real part accurately. Nothing is malformed, no validation fires, and the only symptom is that where-used returns half the truth and the buyer negotiates two smaller volumes instead of one larger one.

Manufacturing PLM attacks it at creation rather than by cleanup. Semantic search runs before a new item is created, against classification attributes rather than description text, and a near match is presented with its differences named — not as a similarity score, but as a statement that this candidate matches on eleven of thirteen attributes and differs on tolerance and package.

The inverse condition also exists and gets less attention: one item covering two things, usually because a part was quietly changed in a way that should have been a new item and was recorded as a revision instead. The revision-versus-new-item test — whether the change is backward compatible in every application — is what keeps that from happening.

The failure it prevents

A company runs an obsolescence check on a connector that has gone end-of-life. Where-used returns two products. The redesign is scoped, executed and released over five weeks.

Nine months later a third product fails certification with the same obsolete connector in it. That product's BOM referenced a duplicate item — same connector, different number, created eighteen months earlier by an engineer in a different office who searched for *header* rather than *connector*.

The obsolescence check was correct and the answer was incomplete, which is the worst combination available. A wrong answer gets challenged; a confidently incomplete one gets acted on. Duplicate identity is what turns every structural query in the system into a partial one.

How it meets the rest of the product

Numbering schemes attach at item creation and are per-tenant: significant, non-significant, or a hybrid where the classification contributes a prefix. Manufacturing PLM holds a position — non-significant numbers age better — and implements whichever scheme you choose without complaint.

Classification is what makes search work, which is the real reason it is enforced. An item classified as a chip resistor has typed attributes for resistance, tolerance, package and power rating, and those attributes are what a duplicate check compares. Free-text descriptions cannot support the query.

Where-used, effectivity, variant resolution and impact analysis all resolve against item identity. Every one of them degrades in exactly the same way when identity is loose, which is why this is the first thing configured and the hardest to fix later.

How it meets your ERP

The item number is the join key between the two systems, and it needs to be stable in a way that revisions are not. Manufacturing PLM publishes items to your ERP; the ERP does not need to know what a revision is unless you have decided it should.

Most deployments publish the item with the currently released revision's attributes flattened onto it, which is what an ERP item master expects. The revision history stays here, where it has a change process attached to it, rather than being replicated into a system with no concept of approval.

Where your ERP already holds the item master and Manufacturing PLM adopts it, the numbering scheme is theirs and the reconciliation runs the other way. The system-of-record matrix records that decision per field, so the direction is explicit rather than inferred from whichever integration was built first.

Where the boundary is

Manufacturing PLM does not merge duplicate items automatically. Where a duplicate is confirmed, the merge is an explicit operation with a preview showing every structure affected, and it is recorded as a change. An automatic merge on a false positive is a silent structural edit across products nobody was looking at.

It also does not hold inventory, cost or lead time as authored data. Those are read from your ERP with a source and an as-of stamp where the integration exists, and left empty where it does not — an empty field is honest and a stale one is not.

Facts

An itemA persistent identifier for a real thing; never deleted
A revisionA version of it — structure, documents, AML, state
Placement testChanges without the thing changing? Item. Otherwise, revision
Duplicate checkAt creation, on classification attributes, not description text
Presented asMatches on 11 of 13 attributes, differs on tolerance and package
MergesExplicit, previewed, recorded — never automatic
ERP join keyThe item number; revisions stay here
Not authored hereInventory · cost · lead time

Frequently asked

What is the difference between an item and a revision?

The item is the thing and the revision is a version of it. The item holds an identifier, a type, a classification and a description; the revision holds the structure, the documents, the approved manufacturers and the state. Nearly all the data lives on the revision rather than the item.

How do I decide which fields go where?

Anything that can change without changing what the thing is belongs on the item; anything that changes because the thing itself changed belongs on the revision. That single test settles most field-placement arguments in one pass, and it is worth settling them at configuration time.

Why are duplicate items so damaging?

Because both records are individually correct. Nothing is malformed and no validation fires — the only symptom is that where-used returns half the truth. A wrong answer gets challenged; a confidently incomplete one gets acted on, and that is considerably worse in practice.

How does the duplicate check work?

Semantic search runs before an item is created, comparing classification attributes rather than description text. A near match is presented with its differences named — this candidate matches on eleven of thirteen attributes and differs on tolerance and package — rather than as a bare similarity score.

Can Manufacturing PLM merge duplicates for us?

Only explicitly. A merge shows a preview of every structure it would affect and is recorded as a change with an attributed actor. An automatic merge on a false positive would be a silent structural edit across products that nobody happened to be looking at.

Do revisions need to reach our ERP?

Usually not. Most deployments publish the item with the released revision's attributes flattened onto it, which is what an ERP item master expects. The revision history stays here, where a change process is attached to it, rather than in a system with no concept of approval.

What if our ERP already owns the item master?

Then the numbering scheme is theirs and reconciliation runs the other way, with Manufacturing PLM adopting the identifiers rather than issuing them. The system-of-record matrix records that decision per field, so direction is explicit rather than inferred from whichever integration got built first.