Material Certificate Reconciler - fictional demo

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

REC-1015

CONFLICTING PO-77445 · Vestland Metall AS

Certificate type is not the type the order requires

Certificate type required

Receipt record

3.1

versus pos 1 3 / 2
pos 3 1 / 2

Supplier certificate

2.2

Exportreceived_lots.csv

RowREC-1015

Recorded asCertificate type required

Value read3.1

DocumentMTR-V2211-7-2.2.pdf

Page1

Printed asEN 10204 Type

Value read2.2

In common

Heat number Heat-2211-7 · Lot number LOT-2211-01 · Purchase order PO-77445

Next step

Review the certificate-type mismatch against the order requirement.

Internal receipt record

Export received_lots.csv

Row REC-1015

Recorded as Certificate type required

Value read 3.1

Record reference	REC-1015
PO number	PO-77445
Receipt number	RCP-900015
Supplier	SUP-VESTLAND
Received heat	Heat-2211-7
Received lot	LOT-2211-01
Material	ASTM A572 Gr50 · Plate 40mm
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-1015,PO-77445,RCP-900015,SUP-VESTLAND,Heat-2211-7,LOT-2211-01,Heat-2211-7,ASTM A572 Gr50,Plate 40mm,40mm x 1800mm x 6000mm,16 t,3.1,"Certificate-type mismatch - identity matches, but a 2.2 certificate was supplied where the order expects 3.1."

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

Supplier certificate

Document MTR-V2211-7-2.2.pdf

Page 1

Printed as EN 10204 Type

Value read 2.2

Open the PDF →

Technical details

Run	3fe7e4f13e02cf7c
Rule	anchored_certificate_conflicts
Exception class	certificate_type_differs_from_order_requirement
Export column read	expected_cert_type
Reason recorded by the run	MTR-V2211-7-2.2.pdf is anchored to this record, but its certificate type 2.2 differs from the order requirement 3.1.

Checks for heat Heat-2211-7 · 1 certificate(s) considered

MTR-V2211-7-2.2.pdf is anchored to this record, but its certificate type 2.2 differs from the order requirement 3.1.

Certificate

Anchored by

Checks

MTR-V2211-7-2.2.pdf

Heat, Lot, Order reference

Heat	MATCH	received Heat-2211-7 / certificate Heat-2211-7 source: MTR-V2211-7-2.2.pdf page 1 [extract_vestland_metall]
Lot	MATCH	received LOT-2211-01 / certificate LOT-2211-01 source: MTR-V2211-7-2.2.pdf page 1 [extract_vestland_metall]
Order reference	MATCH	received PO-77445 / certificate PO-77445 source: MTR-V2211-7-2.2.pdf page 1 [extract_vestland_metall]
Certificate reference	MATCH	received - / certificate MTR-V2211-7-2.2 source: MTR-V2211-7-2.2.pdf page 1 [extract_vestland_metall]
Certificate type	CONFLICT	received 3.1 / certificate 2.2 source: MTR-V2211-7-2.2.pdf page 1 [extract_vestland_metall]
Supplier informational only	MATCH	received SUP-VESTLAND (Vestland Metall AS) / certificate Vestland Metall AS source: MTR-V2211-7-2.2.pdf page 1 [extract_vestland_metall]

Every value the rules read

MTR-V2211-7-2.2.pdf - page 1 - heat_number = Heat-2211-7   [heat_identity: MATCH, adapter extract_vestland_metall]
MTR-V2211-7-2.2.pdf - page 1 - lot_number = LOT-2211-01   [lot_identity: MATCH, adapter extract_vestland_metall]
MTR-V2211-7-2.2.pdf - page 1 - po_number = PO-77445   [transaction_reference: MATCH, adapter extract_vestland_metall]
MTR-V2211-7-2.2.pdf - page 1 - certificate_number = MTR-V2211-7-2.2   [certificate_reference: MATCH, adapter extract_vestland_metall]
MTR-V2211-7-2.2.pdf - page 1 - certificate_type = 2.2   [certificate_type: CONFLICT, adapter extract_vestland_metall]
MTR-V2211-7-2.2.pdf - page 1 - supplier = Vestland Metall AS   [supplier_identity: MATCH, adapter extract_vestland_metall]

← REC-1013

Review item 5 of 6

Next review item: REC-1021 →