Edit #2586 — 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": null, "equipment_type": "COUPLING", "model_number": null, "serial_number": null, "part_number": "1627423004", "tag_number": null, "equipment_description": "ELEMENT COUPLING, DRIVE, E30TM", "visible_text": ["MFG P/N:", "CHANGED TO LOT TYPE USE 10851822", "COUPLING, E30TM", "Stock Item - Last Receipt:", "Last PO: 173-114877", "Model: null", "MFG:", "Exp. Date:", "OH: 2", "17-Oct-2021", "400 97", "10282650", "A006 6378", "LFMNT", "162/123004", "Omega", "ELEMENT, DRIVE", "HU: 2000160372", "25/Dec/2019", "14:43", "USZ3REMANOE", "Receiving HU Label", "1627423004", "ELEMENT COUPLING, DRIVE", "QTY: 4 PC", "PO: 4500019277 - 1", "1001937", "L X W X H 0 X 0 X 0", "97.004 LB", "PL-TOT - GNRL", "THU", "Put: -1.0", "SN32-", "CG:", "ING", "Product: 1627423004", "USZ21MOXLIF", "Pick Item Label", "RTE: 10036", "Order: 130422", "ELEMENT COUPLING DRIVE", "AA/WT: 00G1/101045115", "SeqBIN: B80361", "Pick: Pack: Stage:", "10:00 - 10:45 - 19:00", "002", "1.00 PC", "CG: 4000000029", "0PQ1", "1801", "QUTR", "Quincy", "01/Dec/2020", "18:10"]}

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