iadc_product_specs #28396

id
INTEGER
28396
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
664712
value
TEXT
VALVE, BALL 3/4 IN 600 PSI COLD WP FULL PORT BRONZE B584 INLINE 2 PIECE PIPE | MFR: NIB | P/N: 664712 | MFG#: T585-70-3/4
key_normalized
VARCHAR
664712
value_normalized
VARCHAR
valve, ball 3/4 in 600 psi cold wp full port bronze b584 inline 2 piece pipe | mfr: nib | p/n: 664712 | mfg#: t585-70-3/4
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.425718
source_page
INTEGER
null
source_context
TEXT
part_number: 664712 | description: VALVE, BALL 3/4 IN 600 PSI COLD WP FULL PORT BRONZE B584 INLINE 2 PIECE PIPE | manufacturer: NIB | mfg_part_number: T585-70-3/4 | qty_on_hand: 4 | uom: EA