identification_materials #16858

id
INTEGER
16858
job_id
INTEGER
141 → jobs
picker_id
INTEGER
26 → pickers
source_type
ENUM
NAMEPLATE
match_type
ENUM
AI_SPARE
match_status
ENUM
YELLOW
qr_code_string
VARCHAR
W4-h-f2oTuhQ3w
storage_qr_string
VARCHAR
loc=V1-BY-ZN01-SZ05-RCK04-SLF01;SRL=59
storage_label
VARCHAR
Shelf: Shelf 1
nameplate_image_path
VARCHAR
yard/141/images/nameplate_141_20260918070607622933_2da.jpg
equipment_image_path
VARCHAR
yard/141/images/equipment_141_20260918070607623274_2a1.jpg
extraction_status
VARCHAR
completed
extraction_result
JSON
{"manufacturer": "BEI TECHNOLOGIES, INDUSTRIAL ENCODER DIVISION", "equipment_type": "ENCODER, BARRIER-IS", "model_number": null, "serial_number": "10160529", "part_number": "0000-9610-42", "tag_number": "F056C", "equipment_description": "ENCODER, BARRIER-IS 5V, F/BEI, SPARES FOR DRAWWORKS PLC, CABINET", "visible_text": ["MFG P/N:", "0000-9610-42", "F056C", "ENCODER, BARRIER-IS 5V, F/BEI, SPARES FOR DRAWWORKS PLC", "CABINET", "Stock Item -Last Receipt:", "Last PO:", "Model: N/A", "MFG: NOV", "Exp. Date:", "OH: 2", "$0.00", "10160529", "BEI", "BEI TECHNOLOGIES", "INDUSTRIAL ENCODER DIVISION", "SYSTEM DIAGRAM", "GALVANICALLY ISOLATED BARRIER", "DWG NO 924-08067-001", "SHEET 1 OF 2", "MULTIPLE CHANNEL ASSOCIATED APPARATUS", "BEI INTRINSIC SAFETY BARRIER", "P/N: 924-XXXX-XXX", "DATE", "11/30/01", "11/27/01", "FRON NO", "1R890", "SCALE", "DRAWING", "NONE", "AEO4N2", "THIS PROPRIETARY INFORMATION OF BEI TECHNOLOGIES, INC", "USE OR DISCLOSURE OF THIS DOCUMENT WITHOUT WRITTEN", "IS EXCLUSIVELY PROHIBITED.", "AND COPYRIGHTS ARE THE PROPERTY OF BEI TECHNOLOGIES,", "INC. AND SHALL NOT BE REPRODUCED OR COPIED OR USED", "FOR ANY MANUFACTURING OR COMMERCIAL PURPOSE", "WITHOUT WRITTEN CONSENT OF BEI TECHNOLOGIES, INC.", "IT IS IN ACCORDANCE WITH", "US LAW IS PROHIBITED"]}
extraction_retries
INTEGER
0
matched_iadc_material_id
INTEGER
null
matched_spare_material_id
INTEGER
null
match_confidence
DOUBLE_PRECISION
null
match_details
JSON
null
material_id
INTEGER
71594 → materials
cross_reference_id
VARCHAR
DE-71594
manual_selected_name
VARCHAR
ENCODER, BARRIER-IS
notes
TEXT
null
created_at
TIMESTAMP
2026-09-18T07:06:07.624111
updated_at
TIMESTAMP
2026-09-18T07:06:25.635433
is_active
BOOLEAN
Active
disposition
VARCHAR
SHIFT_TO_STORAGE
admin_notes
TEXT
[auto-publish: new_material]
admin_status
VARCHAR
AUTO_PUBLISHED
reviewed_by
INTEGER
null
reviewed_at
TIMESTAMP
null
condition
VARCHAR
New
grade
VARCHAR
Excellent
nameplate_image_paths
JSON
["yard/141/images/nameplate_141_20260918070607622933_2da.jpg"]
equipment_image_paths
JSON
["yard/141/images/equipment_141_20260918070607623274_2a1.jpg"]
origin
VARCHAR
YARD