iadc_product_specs #26866

id
INTEGER
26866
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
753096
value
TEXT
TRAP, SINK WITH CLEANOUT 1-1/4 IN | MFR: JHC | P/N: 753096 | MFG#: 100033
key_normalized
VARCHAR
753096
value_normalized
VARCHAR
trap, sink with cleanout 1-1/4 in | mfr: jhc | p/n: 753096 | mfg#: 100033
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.424098
source_page
INTEGER
null
source_context
TEXT
part_number: 753096 | description: TRAP, SINK WITH CLEANOUT 1-1/4 IN | manufacturer: JHC | mfg_part_number: 100033 | qty_on_hand: 4 | uom: EA