iadc_product_specs #27579

id
INTEGER
27579
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
664780
value
TEXT
VALVE, BALL 1 1/2 IN 600 PSI BRONZE PIPE SIZE | MFR: LUN | P/N: 664780 | MFG#: 747-1 1/2
key_normalized
VARCHAR
664780
value_normalized
VARCHAR
valve, ball 1 1/2 in 600 psi bronze pipe size | mfr: lun | p/n: 664780 | mfg#: 747-1 1/2
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.424860
source_page
INTEGER
null
source_context
TEXT
part_number: 664780 | description: VALVE, BALL 1 1/2 IN 600 PSI BRONZE PIPE SIZE | manufacturer: LUN | mfg_part_number: 747-1 1/2 | qty_on_hand: 3 | uom: EA