Edit #13856 — 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": "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 · 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 #13856 in identification_materials