iadc_product_specs #27370

id
INTEGER
27370
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
651662
value
TEXT
CAPSCREW, 3/4 IN X 2 IN NC GRADE 5 HEX HEAD ZINC PLATED | MFR: LER | P/N: 651662 | MFG#: 0-2-118
key_normalized
VARCHAR
651662
value_normalized
VARCHAR
capscrew, 3/4 in x 2 in nc grade 5 hex head zinc plated | mfr: ler | p/n: 651662 | mfg#: 0-2-118
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.424644
source_page
INTEGER
null
source_context
TEXT
part_number: 651662 | description: CAPSCREW, 3/4 IN X 2 IN NC GRADE 5 HEX HEAD ZINC PLATED | manufacturer: LER | mfg_part_number: 0-2-118 | qty_on_hand: 0 | uom: EA