iadc_product_specs #27278

id
INTEGER
27278
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
651623
value
TEXT
CAPSCREW, 7/16 IN X 2 NC GRADE 5 HEX HEAD ZINC PLATED 7/16" 14 2" FINISH CAP | MFR: LAW | P/N: 651623 | MFG#: 650
key_normalized
VARCHAR
651623
value_normalized
VARCHAR
capscrew, 7/16 in x 2 nc grade 5 hex head zinc plated 7/16" 14 2" finish cap | mfr: law | p/n: 651623 | mfg#: 650
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.424549
source_page
INTEGER
null
source_context
TEXT
part_number: 651623 | description: CAPSCREW, 7/16 IN X 2 NC GRADE 5 HEX HEAD ZINC PLATED 7/16" 14 2" FINISH CAP | manufacturer: LAW | mfg_part_number: 650 | qty_on_hand: 0 | uom: EA