iadc_product_specs #27673

id
INTEGER
27673
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
1000471
value
TEXT
UNION, PIPE 3 IN SCH 80 SOCKET WELD FORGED STEEL 3000 PSI | MFR: MCM | P/N: 1000471 | MFG#: 45005K262
key_normalized
VARCHAR
1000471
value_normalized
VARCHAR
union, pipe 3 in sch 80 socket weld forged steel 3000 psi | mfr: mcm | p/n: 1000471 | mfg#: 45005k262
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.424964
source_page
INTEGER
null
source_context
TEXT
part_number: 1000471 | description: UNION, PIPE 3 IN SCH 80 SOCKET WELD FORGED STEEL 3000 PSI | manufacturer: MCM | mfg_part_number: 45005K262 | qty_on_hand: 0 | uom: EA