Dashboard
/
identification_materials
/
Edit #19622
Edit row #19622 in
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": "BND", "equipment_type": "IGBT POWERSTACK WITHOUT CAPACITOR BANK", "model_number": "PU 330-1200MV 1.0", "serial_number": "0307 0115", "part_number": "ART-03688", "tag_number": null, "equipment_description": "IGBT POWERSTACK WITHOUT CAPACITOR BANK PU 330-1200MV 1.0 THYRISTOR # 2 serial number 0307 0115 PN 10150472", "visible_text": ["HOLD TO BE SENT ON BIG DEACTIVATION", "Shipper: Transocean Offshore (North Sea) 1 Ltd c/o Ceva Logistics Multitech Plant Hire Aberdeen Ltd Shed 7, Brimmond Plant & Storage Depot Echt, Westhill, Aberdeenshire AB32 6XU ANGOLA", "Consignee: TSSA - SERVICOS DE APOIO, LTD RUA ALBANO MACHADO 2422 MACULUSSO - LUANDA ANGOLA", "Requester: Scott Logue", "Request Date: 22 Dec 15", "Request Number: RRABZ009490425", "Broker Information: WOODWARD Poland Contact Person: Bartosz Nazarek Murchi Pancho Contact Email: Munchi.Karchu@woodward.com 48122851421", "Origin: LUANDA ANGOLA ADERDENUX", "Destination: WOODWARD Poland", "Mode of Transport: OCEAN", "Vendor Return Authorization Number: RMA 3321502", "Line Item Number", "Description", "MPN", "Manufacturer", "HS Code", "Quantity", "UOM", "Value (USD)", "Reason for Return", "Delivery instructions (company name, address and contact email)", "1: CARDBORD BOX OF BELGIUM ITEM CUBE: L45 x W26 x H29 WEIGHT: 80 KG UMK BND HSCB04149090 1 EACH $0.00 Other WOODWARD POLAND UL. SKARBOWA 22 32-009 NIEPOLOMICE POLAND", "2: HSCB04149090 1 EACH $25,349.07 Other WOODWARD POLAND UL. SKARBOWA 22 32-009 NIEPOLOMICE POLAND", "3: IGBT POWERSTACK WITHOUT CAPACITOR BANK PU 330-1200MV 1.0 THYRISTOR # 3 serial number 0108 0402 PN 10150473 ART-03688 BND HSCB04149090 1 EACH $25,349.07 Other WOODWARD POLAND UL. SKARBOWA 22 32-009 NIEPOLOMICE POLAND", "4: PWR 2200V/2940 REG 009/119042 & 009/118001 ART-03688 BND HSCB04149090 1 EACH $25,349.07 Other WOODWARD POLAND UL. SKARBOWA 22 32-009 NIEPOLOMICE POLAND"]}
extraction_retries
INTEGER ·
required
matched_iadc_material_id
INTEGER
matched_spare_material_id
INTEGER
match_confidence
DOUBLE PRECISION
match_details
JSON
{"match_type": "MISCELLANEOUS", "match_status": "RED", "best_match": null, "all_matches": [], "match_confidence": 0.0, "ocr_input": {"manufacturer": "BND", "equipment_type": "IGBT POWERSTACK WITHOUT CAPACITOR BANK", "model_number": "PU 330-1200MV 1.0", "serial_number": "0307 0115", "part_number": "ART-03688", "tag_number": null, "equipment_description": "IGBT POWERSTACK WITHOUT CAPACITOR BANK PU 330-1200MV 1.0 THYRISTOR # 2 serial number 0307 0115 PN 10150472", "visible_text": ["HOLD TO BE SENT ON BIG DEACTIVATION", "Shipper: Transocean Offshore (North Sea) 1 Ltd c/o Ceva Logistics Multitech Plant Hire Aberdeen Ltd Shed 7, Brimmond Plant & Storage Depot Echt, Westhill, Aberdeenshire AB32 6XU ANGOLA", "Consignee: TSSA - SERVICOS DE APOIO, LTD RUA ALBANO MACHADO 2422 MACULUSSO - LUANDA ANGOLA", "Requester: Scott Logue", "Request Date: 22 Dec 15", "Request Number: RRABZ009490425", "Broker Information: WOODWARD Poland Contact Person: Bartosz Nazarek Murchi Pancho Contact Email: Munchi.Karchu@woodward.com 48122851421", "Origin: LUANDA ANGOLA ADERDENUX", "Destination: WOODWARD Poland", "Mode of Transport: OCEAN", "Vendor Return Authorization Number: RMA 3321502", "Line Item Number", "Description", "MPN", "Manufacturer", "HS Code", "Quantity", "UOM", "Value (USD)", "Reason for Return", "Delivery instructions (company name, address and contact email)", "1: CARDBORD BOX OF BELGIUM ITEM CUBE: L45 x W26 x H29 WEIGHT: 80 KG UMK BND HSCB04149090 1 EACH $0.00 Other WOODWARD POLAND UL. SKARBOWA 22 32-009 NIEPOLOMICE POLAND", "2: HSCB04149090 1 EACH $25,349.07 Other WOODWARD POLAND UL. SKARBOWA 22 32-009 NIEPOLOMICE POLAND", "3: IGBT POWERSTACK WITHOUT CAPACITOR BANK PU 330-1200MV 1.0 THYRISTOR # 3 serial number 0108 0402 PN 10150473 ART-03688 BND HSCB04149090 1 EACH $25,349.07 Other WOODWARD POLAND UL. SKARBOWA 22 32-009 NIEPOLOMICE POLAND", "4: PWR 2200V/2940 REG 009/119042 & 009/118001 ART-03688 BND HSCB04149090 1 EACH $25,349.07 Other WOODWARD POLAND UL. SKARBOWA 22 32-009 NIEPOLOMICE POLAND"]}}
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
True
False
disposition
VARCHAR(50) ·
required
admin_notes
TEXT
[auto-publish: new_material]
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
Cancel
Save Changes