iadc_product_specs #21303

id
INTEGER
21303
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
683288
value
TEXT
CLAMP, MALLEABLE BEAM SIZE 2 IN NOMINAL CONDUIT/PIPE/THREADED ROD 31/32 JAW | MFR: APP | P/N: 683288 | MFG#: BH-502
key_normalized
VARCHAR
683288
value_normalized
VARCHAR
clamp, malleable beam size 2 in nominal conduit/pipe/threaded rod 31/32 jaw | mfr: app | p/n: 683288 | mfg#: bh-502
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.418258
source_page
INTEGER
null
source_context
TEXT
part_number: 683288 | description: CLAMP, MALLEABLE BEAM SIZE 2 IN NOMINAL CONDUIT/PIPE/THREADED ROD 31/32 JAW | manufacturer: APP | mfg_part_number: BH-502 | qty_on_hand: 3 | uom: EA