|
id
INTEGER
|
13856 |
|
job_id
INTEGER
|
117 → jobs |
|
picker_id
INTEGER
|
17 → pickers |
|
source_type
ENUM
|
NAMEPLATE |
|
match_type
ENUM
|
AI_SPARE |
|
match_status
ENUM
|
GREEN |
|
qr_code_string
VARCHAR
|
AFHLGIeIkeygng |
|
storage_qr_string
VARCHAR
|
loc=V1-BY-ZN01-SZ10-RCK04-SLF02-BIN05;SRL=345 |
|
storage_label
VARCHAR
|
Bin: Bin 5 |
|
nameplate_image_path
VARCHAR
|
yard/117/images/nameplate_117_20260831093246095306_814.jpg |
|
equipment_image_path
VARCHAR
|
yard/117/images/equipment_117_20260831093246095949_721.jpg |
|
extraction_status
VARCHAR
|
completed |
|
extraction_result
JSON
|
{"manufacturer": "Honeywell Analytics", "equipment_type": "Universal Transmitter", "model_number": "XNX-BTAV-NNXBN", "serial_number": "44265457", "part_number": null, "tag_number": null, "equipment_description": "XNX Universal Transmitter for use in Class I, Div 1 Groups B, C & D Class I Zone 1, Groups IIB+H2 Haz Loc. Tamb -40 \u00b0C to 65 \u00b0C Temp Code T4. UL Classified Only as to Explosion, Fire, Electrical Shock Hazard. XNX-BT*Ex****** XNX-BT*-H* provide IS Circuitry /Assoc. Appt Per 1226E0454 CD & Manual Uin=250V. Contact Ratings: 250 VAC 5A, 24VDC 5A Resistive Loads Only. Class 2 Supply Req'd to 32 Vcc/DC Max. IIB+H2 T4 (Tamb=-40\u00b0C to 65\u00b0C) IP66. BR-EX d. INMETRO OCP 0016 ATEX 1272X-X. ATEN\u00c7\u00c3O: N\u00c3O ABRA QUANDO ENERGIZADO OU N\u00c3O ABRA ONDE UMA ATMOSFERA EXPLOSIVA POSSA ESTAR PRESENTE.", "visible_text": ["ZELL", "AMBIENTAL", "11-2107-2555", "zell@zell.com.br", "Calibra\u00e7\u00e3o", "Data Calib.", "11/05", "O.S.", "40003", "35YL", "UL CLASSIFIED", "XNX-BTAV-NNXBN SN: 44265457", "XNX Universal Transmitter for use in Class I, Div 1 Groups B, C & D", "Class I Zone 1, Groups IIB+H2 Haz Loc. Tamb -40 \u00b0C to 65 \u00b0C Temp Code T4", "Only as to Explosion, Fire, Electrical Shock Hazard", "XNX-BT*Ex****** XNX-BT*-H* provide IS Circuitry /Assoc.", "Appt Per 1226E0454 CD & Manual Uin=250V", "XNX-BT****** Contact Ratings: 250 VAC", "Mfg by: Honeywell Analytics, Inc. 415 Barclay Blvd.", "to 32 Vcc/DC Max.", "IIB+H2 T4 (Tamb=-40\u00b0C to 65\u00b0C) IP66", "BR-EX d", "Seguran\u00e7a", "INMETRO OCP 0016", "ATEX 1272X-X", "ATEN\u00c7\u00c3O: N\u00c3O ABRA QUANDO", "ENERGIZADO OU N\u00c3O ABRA ONDE UMA", "ATMOSFERA EXPLOSIVA POSSA ESTAR", "PRESENTE", "250 VAC 5A, 24VDC 5A Resistive Loads Only", "Lincolnshire, IL 60069 USA", "Class 2 Supply Req'd", "XNX UNIVERSAL TRANSMITTER"]}
|
|
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
|
69609 → materials |
|
cross_reference_id
VARCHAR
|
DE-69609 |
|
manual_selected_name
VARCHAR
|
Universal Transmitter |
|
notes
TEXT
|
null |
|
created_at
TIMESTAMP
|
2026-08-31T09:32:46.096766 |
|
updated_at
TIMESTAMP
|
2026-08-31T09:33:01.444256 |
|
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/117/images/nameplate_117_20260831093246095306_814.jpg", "yard/117/images/nameplate_117_20260831093246095648_eb5.jpg"] |
|
equipment_image_paths
JSON
|
["yard/117/images/equipment_117_20260831093246095949_721.jpg"] |
|
origin
VARCHAR
|
YARD |