|
id
INTEGER
|
19622 |
|
job_id
INTEGER
|
154 → jobs |
|
picker_id
INTEGER
|
25 → pickers |
|
source_type
ENUM
|
NAMEPLATE |
|
match_type
ENUM
|
MISCELLANEOUS |
|
match_status
ENUM
|
RED |
|
qr_code_string
VARCHAR
|
F6rU0eQocqy-Ug |
|
storage_qr_string
VARCHAR
|
loc=V1-BY-ZN07-L-126-RCK01-SLF01-BIN86;SRL=920 |
|
storage_label
VARCHAR
|
Bin: Bin 86 |
|
nameplate_image_path
VARCHAR
|
identification/154/images/nameplate_154_20260925070426761807_d6c.jpg |
|
equipment_image_path
VARCHAR
|
identification/154/images/equipment_154_20260925070426762189_507.jpg |
|
extraction_status
VARCHAR
|
completed |
|
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
|
0 |
|
matched_iadc_material_id
INTEGER
|
null |
|
matched_spare_material_id
INTEGER
|
null |
|
match_confidence
DOUBLE_PRECISION
|
0.0 |
|
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
|
73103 → materials |
|
cross_reference_id
VARCHAR
|
DE-73103 |
|
manual_selected_name
VARCHAR
|
null |
|
notes
TEXT
|
null |
|
created_at
TIMESTAMP
|
2026-09-25T07:04:26.763209 |
|
updated_at
TIMESTAMP
|
2026-09-25T07:05:08.194110 |
|
is_active
BOOLEAN
|
Active |
|
disposition
VARCHAR
|
vessel |
|
admin_notes
TEXT
|
[auto-publish: new_material] |
|
admin_status
VARCHAR
|
AUTO_PUBLISHED |
|
reviewed_by
INTEGER
|
null |
|
reviewed_at
TIMESTAMP
|
null |
|
condition
VARCHAR
|
New |
|
grade
VARCHAR
|
Excellent |
|
nameplate_image_paths
JSON
|
null |
|
equipment_image_paths
JSON
|
null |
|
origin
VARCHAR
|
VESSEL |