Material Certificate Reconciler - fictional demo

25 checked = 19 established from evidence + 6 left for human judgment · summary

REC-1012

AMBIGUOUS PO-77442 · Vestland Metall AS

Certificate does not say which heat it covers

Received heat

Receipt record

Heat-2207-4

versus

Supplier certificate

(not stated)

the document states no such value anywhere

Exportreceived_lots.csv

RowREC-1012

Recorded asReceived heat

Value readHeat-2207-4

No certificate was assigned because the evidence was not sufficient to identify a unique match.

In common

Purchase order PO-77442

Next step

Confirm which received record this certificate belongs to.

Internal receipt record

Export received_lots.csv

Row REC-1012

Recorded as Received heat

Value read Heat-2207-4

Record reference	REC-1012
PO number	PO-77442
Receipt number	RCP-900012
Supplier	SUP-VESTLAND
Received heat	Heat-2207-4
Received lot	LOT-2207-01
Material	ASTM A572 Gr50 · Plate 30mm
Certificate type required	3.1

Show the original export row

lot_ref,po_number,receipt_number,supplier_id,heat_number,lot_number,required_heat_numbers,material_grade,material_designation,dimensions,quantity,expected_cert_type,note REC-1012,PO-77442,RCP-900012,SUP-VESTLAND,Heat-2207-4,LOT-2207-01,Heat-2207-4,ASTM A572 Gr50,Plate 30mm,30mm x 1500mm x 5000mm,14 t,3.1,Ambiguous exception - shares PO-77442 with REC-1013; the only certificate on that PO carries no heat or lot identity.

The line this record was read from, in received_lots.csv. Open the whole export →

Supplier certificate

Document MTR-V2207-UNIDENTIFIED-3.1.pdf

Page 1

Value read (not stated)

Open the PDF →

Technical details

Run	3fe7e4f13e02cf7c
Rule	association_not_resolvable
Exception class	association_not_deterministically_resolvable
Export column read	heat_number
Reason recorded by the run	This certificate references the transaction only and carries no heat or lot identity, and more than one received record on that transaction could claim it.

Checks for heat Heat-2207-4 · 1 certificate(s) considered

This certificate references the transaction only and carries no heat or lot identity, and more than one received record on that transaction could claim it.

Certificate

Anchored by

Checks

MTR-V2207-UNIDENTIFIED-3.1.pdf
not assignable

Order reference

Heat	NOT_STATED	received Heat-2207-4 / certificate (not stated)
Lot	NOT_STATED	received LOT-2207-01 / certificate (not stated)
Order reference	MATCH	received PO-77442 / certificate PO-77442 source: MTR-V2207-UNIDENTIFIED-3.1.pdf page 1 [extract_vestland_metall]
Certificate reference	MATCH	received - / certificate MTR-V2207-UNIDENTIFIED-3.1 source: MTR-V2207-UNIDENTIFIED-3.1.pdf page 1 [extract_vestland_metall]
Certificate type	MATCH	received 3.1 / certificate 3.1 source: MTR-V2207-UNIDENTIFIED-3.1.pdf page 1 [extract_vestland_metall]
Supplier informational only	MATCH	received SUP-VESTLAND (Vestland Metall AS) / certificate Vestland Metall AS source: MTR-V2207-UNIDENTIFIED-3.1.pdf page 1 [extract_vestland_metall]

This certificate references the transaction only and carries no heat or lot identity, and more than one received record on that transaction could claim it.

Every value the rules read

MTR-V2207-UNIDENTIFIED-3.1.pdf - page 1 - po_number = PO-77442   [transaction_reference: MATCH, adapter extract_vestland_metall]
MTR-V2207-UNIDENTIFIED-3.1.pdf - page 1 - certificate_number = MTR-V2207-UNIDENTIFIED-3.1   [certificate_reference: MATCH, adapter extract_vestland_metall]
MTR-V2207-UNIDENTIFIED-3.1.pdf - page 1 - certificate_type = 3.1   [certificate_type: MATCH, adapter extract_vestland_metall]
MTR-V2207-UNIDENTIFIED-3.1.pdf - page 1 - supplier = Vestland Metall AS   [supplier_identity: MATCH, adapter extract_vestland_metall]

← REC-1008

Review item 3 of 6

Next review item: REC-1013 →