iadc_product_specs #33785

id
INTEGER
33785
iadc_material_id
INTEGER
2713 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
BC05270408
value
TEXT
RING, CASING WEAR, FIRE JOCKEY PUMP EPTEC PUMP TYPE EF40-250-BMG 12K1 | MFR: BJO | P/N: BC05270408 | MFG#: BC05270408
key_normalized
VARCHAR
bc05270408
value_normalized
VARCHAR
ring, casing wear, fire jockey pump eptec pump type ef40-250-bmg 12k1 | mfr: bjo | p/n: bc05270408 | mfg#: bc05270408
value_numeric
DOUBLE_PRECISION
1666.79
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-22T09:48:31.936366
source_page
INTEGER
null
source_context
TEXT
part_number: BC05270408 | description: RING, CASING WEAR, FIRE JOCKEY PUMP EPTEC PUMP TYPE EF40-250-BMG 12K1 | manufacturer: BJO | mfg_part_number: BC05270408 | store: C320-B | bin_location: C320-B | qty_on_hand: 3 | uom: EA | unit_price: 1666.79