Fictional receipt / order export

Internal receipt/PO/lot/requirement data — fictional
← Back to REC-1013 - summary

Highlighted below: the exported row for REC-1013 — the internal source of the record you were reviewing. This is the whole export, unedited; nothing was filtered or recomputed for you.

Source file: received_lots.csv

Fictional internal export. This is one side of the reconciliation; the other side is the folder of supplier material-certificate PDFs.

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-1001,PO-77432,RCP-900001,SUP-NORTHBAY,Heat-4821-A,LOT-4821-01,Heat-4821-A,S355J2+N,Plate 20mm,20mm x 1500mm x 6000mm,18 t,3.1,"Clean control - Northbay layout, 1:1 with its own certificate."
REC-1002,PO-77432,RCP-900002,SUP-NORTHBAY,Heat-4821-A,LOT-4821-02,Heat-4821-A,S355J2+N,Plate 20mm,20mm x 1500mm x 6000mm,17 t,3.1,"Clean control - second lot on the same PO and heat, with its own certificate."
REC-1003,PO-77433,RCP-900003,SUP-NORTHBAY,Heat-4822-B,LOT-4822-01,Heat-4822-B,S355J2+N,Plate 25mm,25mm x 1800mm x 5000mm,12 t,3.1,Clean control - Northbay layout.
REC-1004,PO-77434,RCP-900004,SUP-NORTHBAY,Heat-4823-C,LOT-4823-01,Heat-4823-C,S355J2+N,Beam UB 254x254,254mm x 254mm x 24 kg/m,9 t,3.1,Clean control - Northbay layout.
REC-1005,PO-77435,RCP-900005,SUP-NORTHBAY,Heat-4890-W,LOT-4890-01,Heat-4890-W,S355J2+N,Plate 20mm,20mm x 1500mm x 6000mm,20 t,3.1,Wrong-heat exception - the only certificate quoting this PO names a different heat and lot.
REC-1006,PO-77437,RCP-900006,SUP-NORTHBAY,Heat-4901-D,LOT-4901-02,Heat-4901-D,S355J2+N,Pipe SCH40 200mm,200mm NB x 8.2mm,6 t,3.1,Many:1 coverage - shares one heat certificate with REC-1007.
REC-1007,PO-77437,RCP-900007,SUP-NORTHBAY,Heat-4901-D,LOT-4901-03,Heat-4901-D,S355J2+N,Pipe SCH40 200mm,200mm NB x 8.2mm,6 t,3.1,Many:1 coverage - shares one heat certificate with REC-1006.
REC-1008,PO-77438,RCP-900008,SUP-NORTHBAY,Heat-4910-F,LOT-4910-01,Heat-4910-F,S355J2+N,Cylinder 300mm,300mm OD x 25mm wall,4 t,3.1,"Missing exception - no certificate quotes this PO, heat or lot. Same supplier as other Northbay lots is not enough."
REC-1009,PO-77439,RCP-900009,SUP-VESTLAND,Heat-2204-1,LOT-2204-01,Heat-2204-1,ASTM A572 Gr50,Plate 25mm,25mm x 1200mm x 4000mm,10 t,3.1,Clean control - Vestland layout.
REC-1010,PO-77440,RCP-900010,SUP-VESTLAND,Heat-2205-2,LOT-2205-01,Heat-2205-2,ASTM A572 Gr50,Plate 25mm,25mm x 1200mm x 4000mm,9 t,3.1,Clean control - Vestland layout.
REC-1011,PO-77441,RCP-900011,SUP-VESTLAND,Heat-2206-3,LOT-2206-01,Heat-2206-3,ASTM A572 Gr50,Beam UB 305x305,305mm x 305mm x 28 kg/m,11 t,3.1,Clean control - Vestland layout.
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.
REC-1013,PO-77442,RCP-900013,SUP-VESTLAND,Heat-2208-5,LOT-2208-01,Heat-2208-5,ASTM A572 Gr50,Plate 30mm,30mm x 1500mm x 5000mm,14 t,3.1,Ambiguous exception - partner of REC-1012 on PO-77442.
REC-1014,PO-77452,RCP-900014,SUP-KVARNBACKEN,,LOT-3320-01,Heat-3320-X|Heat-3320-Y,S355J2+N,Plate 20mm,20mm x 1200mm x 4000mm,9 t,3.1,"1:many coverage - one internal record spanning two heats, each with its own certificate."
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."
REC-1016,PO-77446,RCP-900016,SUP-LAHTI,Heat-5511-H,LOT-5511-01,Heat-5511-H,S355J2+N,Rebar 20mm,20mm dia,22 t,3.1,"Clean control - Lahti layout, three-page report with the identity block on page 2."
REC-1017,PO-77447,RCP-900017,SUP-LAHTI,Heat-5512-I,LOT-5512-01,Heat-5512-I,S355J2+N,Rebar 20mm,20mm dia,20 t,3.1,Clean control - Lahti layout.
REC-1018,PO-77448,RCP-900018,SUP-LAHTI,Heat-5513-J,LOT-5513-01,Heat-5513-J,S355J2+N,Rebar 25mm,25mm dia,14 t,3.1,Clean control - Lahti layout.
REC-1019,PO-77449,RCP-900019,SUP-KVARNBACKEN,Heat-3314-K,LOT-3314-01,Heat-3314-K,S355J2+N,Plate 16mm,16mm x 1000mm x 3000mm,7 t,3.1,Clean control - Kvarnbacken layout.
REC-1020,PO-77450,RCP-900020,SUP-KVARNBACKEN,Heat-3315-L,LOT-3315-01,Heat-3315-L,S355J2+N,Plate 16mm,16mm x 1000mm x 3000mm,7 t,3.1,Clean control - Kvarnbacken layout.
REC-1021,PO-77451,RCP-900021,SUP-KVARNBACKEN,Heat-3316-M,LOT-3316-01,Heat-3316-M,S355J2+N,Plate 20mm,20mm x 1200mm x 4000mm,9 t,3.1,Duplicate certificate reference - two files identify this heat and lot under the same certificate reference.
REC-1022,PO-77453,RCP-900022,SUP-BOREALIS,Heat-7741-P,LOT-7741-01,Heat-7741-P,EN AW-6060 T6,Profile 45x45mm,45mm x 45mm x 3.0mm,12 t,3.1,Clean control - Borealis layout.
REC-1023,PO-77454,RCP-900023,SUP-BOREALIS,Heat-7742-Q,LOT-7742-01,Heat-7742-Q,EN AW-6060 T6,Profile 45x45mm,45mm x 45mm x 3.0mm,11 t,3.1,Clean control - Borealis layout.
REC-1024,PO-77455,RCP-900024,SUP-BOREALIS,Heat-7743-R,LOT-7743-01,Heat-7743-R,EN AW-6082 T6,Plate 10mm,10mm x 1000mm x 2000mm,6 t,3.1,Clean control - Borealis layout.
REC-1025,PO-77456,RCP-900025,SUP-SUNDSVALL,Heat-6611-S,LOT-6611-01,Heat-6611-S,AISI 4140,Rod 30mm,30mm dia,5 t,3.1,Clean control - Sundsvall layout.
← Back to REC-1013· Back to summary
Fictional-demo material-certificate reconciler. All companies, suppliers, mills, PO/receipt numbers, heat/lot identifiers, grades, dimensions, certificate numbers, dates and values in this demo are fictional. This tool does not determine whether material is safe, compliant, authentic or fit for use. See what this demo does and does not decide.