iadc_product_specs #30039

id
INTEGER
30039
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
664709
value
TEXT
VALVE, BALL 1/2 IN 600 PSI BRONZE B584 INLINE 2 PIECE PIPE SIZE CONNECTION TYPE | MFR: PPN | P/N: 664709 | MFG#: V500P-8
key_normalized
VARCHAR
664709
value_normalized
VARCHAR
valve, ball 1/2 in 600 psi bronze b584 inline 2 piece pipe size connection type | mfr: ppn | p/n: 664709 | mfg#: v500p-8
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.427458
source_page
INTEGER
null
source_context
TEXT
part_number: 664709 | description: VALVE, BALL 1/2 IN 600 PSI BRONZE B584 INLINE 2 PIECE PIPE SIZE CONNECTION TYPE | manufacturer: PPN | mfg_part_number: V500P-8 | qty_on_hand: 7 | uom: EA