Edit #21872 — identification_materials

id

INTEGER · required

Auto-generated

job_id

INTEGER · required

picker_id

INTEGER · required

source_type

VARCHAR(13) · required

match_type

VARCHAR(13) · required

match_status

VARCHAR(6) · required

qr_code_string

VARCHAR(120) · required

storage_qr_string

VARCHAR(200) · required

storage_label

VARCHAR(200) · required

nameplate_image_path

VARCHAR(300)

equipment_image_path

VARCHAR(300)

extraction_status

VARCHAR(30)

extraction_result

JSON

{"manufacturer": "PARKER HANNIFIN CORPORATION", "equipment_type": "GASKET", "model_number": null, "serial_number": null, "part_number": "978297", "tag_number": null, "equipment_description": "MARK VII GASK-O-SEAL", "visible_text": ["PARKER CSS-DIVISION", "SAN DIEGO CA. 92154", "MFG CODE. 83259", "PARKER:", "978297 REV B", "CUST P/N: 978297", "1 EACH", "COMP: V720-75", "BATCH: 80415131", "PO#: 000215536", "MARK VII GASK-O-SEAL", "GASKET", "CURE DATE: 2Q21", "MADE IN U.S.A.", "May 06, 2021", "0005", "FROM: PARKER HANNIFIN CORPORATION", "970 MONROE RD-Q", "HOUSTON TX 77065", "TO: NOV RIG SOLUTION SPARES & SERV", "5300 N SAN HOUSTON PARKWAY W", "HOUSTON TX 77086", "P.O.", "B.O.L.", "BATCH:", "CURE DT:", "ITEM", "SHIP DATE", "DISCARD DT", "REV LVL", "PART DESCRIPTION", "PARKER PART", "SPFG & REV", "SIZE", "#N/A", "COMPOUND", "HARDNESS", "GENERIC", "COO", "USA", "QUANTITY (1.1.)", "1", "WARNING!", "Check all dimensions & tolerances to A.S.", "www.PRSSeals.com", "P.O. 000793637", "B.O.L. 00496131", "BATCH 2021", "CURE DT 2Q21", "ITEM 14", "SHIP DATE 05/11/21", "DISCARD DT 2Q2120", "PARKER PART 978297", "PART NUMBER (P) 101851", "521032610", "10-UNIT (43)"]}

extraction_retries

INTEGER · required

matched_iadc_material_id

INTEGER

matched_spare_material_id

INTEGER

match_confidence

DOUBLE PRECISION

match_details

JSON

material_id

INTEGER

cross_reference_id

VARCHAR(50)

manual_selected_name

VARCHAR(200)

notes

TEXT

created_at

TIMESTAMP · required

updated_at

TIMESTAMP · required

is_active

BOOLEAN · required

disposition

VARCHAR(50) · required

admin_notes

TEXT

admin_status

VARCHAR(20) · required

reviewed_by

INTEGER

reviewed_at

TIMESTAMP

condition

VARCHAR(20)

grade

VARCHAR(30)

nameplate_image_paths

JSON

equipment_image_paths

JSON

origin

VARCHAR(20) · required

Edit row #21872 in identification_materials