Edit #2613 — 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": "Siemens", "equipment_type": "SITRANS PROBE LU", "model_number": "DRILER'S CONSOLE MONITORING S", "serial_number": "SPBD M1240084", "part_number": "7ML5221-1DA18", "tag_number": null, "equipment_description": "PROBE, SITRANS LU ULTRASONIC, 24 VDC, 4-20 MA, 2\" NPT THREAT, 0 TO 12 METERS, FOR MUD PITS, LEVEL SENSOR, P/N: ML5221-1DA18 HAS 2 X M20 ENTRYS", "visible_text": ["SIEMENS", "SITRANS PROBE LU", "\u8d85\u58f0\u6ce2\u53d8\u9001\u5668 Probe LU", "1P 7ML52211DA18", "SPBD M1240084", "01 DEVICE: 3 OF 4", "ORD NO: 0001843359-000010-US / 000017404012", "ITEM: 4508346213 / 000010 / RC-US PO PA / 7MLS", "14K 1843359 000010 US", "SK 17404012", "CAUTION! Please read the notes in the relevant manual before system startup. The SIMATIC catalog contains ordering data for the manuals.", "\u8d28\u91cf A056TOPA", "FW: 2.05.00", "12m", "MFG P/N: 7ML5221-1DA18", "PROBE, SITRANS LU ULTRASONIC, 24 VDC, 4-20 MA, 2\" NPT THREAT, 0 TO 12 METERS, FOR MUD PITS, LEVEL SENSOR, P/N: ML5221-1DA18 HAS 2 X M20 ENTRYS", "Stock last Receipt: 13-Mar-2020 1666", "Last PO: 177-112634", "Model: DRILER'S CONSOLE MONITORING S", "MFG: Siemens", "Exp. Date: OH: 4 10201307"]}

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