Edit #5413 — 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": "NATIONAL OILWELL VARCO, L.P.", "equipment_type": "ASSEMBLY", "model_number": "11037534-001", "serial_number": null, "part_number": "WEMF00649253", "tag_number": "223583", "equipment_description": "PRES-LOK(R) ASSEMBLY, Seal,Seal ID 17 in;Seal OD 18 In;Wiper;Rod.200K Tension, Pres - Loo Type, Material: Zurcon 461", "visible_text": ["P.O. #", "889574", "Item Number", "11037534-001", "Item", "Seal,Seal ID 17 in;Seal OD 18 In;Wiper;Rod.200K Tension, Pres - Loo Type, Material: Zurcon 461", "Req. #", "90806", "Project #", "202007151484", "Serial #", "Legacy #", "223583", "Task #", "Host Number", "UOM", "Each", "Lot #", "Lot Mfg", "00-JUL-20", "OSP Oper Seq", "OSP Req", "W/O", "Assy #", "Lpg", "600-I I", "Country of Origin", "United States", "NATIONAL OILWELL VARCO, L.P.", "Customer Part Number", "Description", "PRES-LOK(R) ASSEMBLY", "Customer Order Number", "TSS Part Number", "WEMF00649253", "TSS Stock Number", "SHELF LIFE 10 YRS", "TRELLEBORG", "Stock Number", "400609", "Pack Slip Number", "2646030", "Cage Date", "09257", "Label Printed", "8/10/20", "Supplier Name", "TSS LOGISTICS CENTER AMER", "SHELF LIFE (YEARS)", "10", "EXP DATE", "2030", "Lot Code", "3020", "Lot Number", "Quantity", "1", "EA", "VARBSSH P", "WWM 001.000", "D.I.", "2-12", "TY 2 CL C", "CSTY 1", "117H !B & B"]}

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