Edit #17105 — 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 CORP.", "equipment_type": "SEAL, BOOSTER ASSEMBLY, HYDRAULIC", "model_number": "2040 UDBE DRAWWORKS", "serial_number": null, "part_number": "10060261-001", "tag_number": null, "equipment_description": "SEAL, BOOSTER ASSEMBLY, HYDRAULIC, 3-1/2 X 4 X 1/4", "visible_text": ["10060281-001", "NATIONAL SEAL WORKS", "Exp. 29-09-23", "FRA", "org:US", "MFD P/N: 7918610", "F064B", "SEAL, BOOSTER ASSEMBLY, HYDRAULIC", "Stock Item -Last Receipt: 03-Feb-2022", "11:05", "Last PO: 173-116011", "Model: 2040 UDBE DRAWWORKS", "Mfg: NOV", "Exp. Date: 29-Sep-2028", "OH: 4", "10292298", "FROM", "PARKER HANNIFIN CORP.", "9119 MONROE ROAD", "HOUSTON, TX 77067", "5130 N.SAM HOUSTON PRWY WEST", "HOUSTON, TX 77086", "P.O. US-30014043", "ITEM 000006", "PART DESCRIPTION 3-1/2 X 4 X 1/4", "BATCH 4615G0002", "SHIP DATE 12/20/2021", "PARKER PART 461525003500", "SPEC & REV", "CURE DT 3Q18", "DISCARD DT 3Q2028", "PART NUMBER (P) 10060261-001", "REV LV", "SIZE 3 1/2 X 4", "COMPOUND P4615", "HARDNESS 90A", "GENERIC MOLYTHANE", "COO US", "PKG ID - UNIT (45) 10413448", "QUANTITY (Q) 1", "WARNING: Cancer and reproductive harm - www.P65Warnings.ca.gov"]}

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 #17105 in identification_materials