iadc_product_specs #30864

id
INTEGER
30864
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
651667
value
TEXT
CAPSCREW, 1/2 IN X 1 NC GRADE 8 HEX H EAD ZINC PLATED 1/2" 13 1" YELLOW FINISH | MFR: SHA | P/N: 651667 | MFG#: 637-08013-08
key_normalized
VARCHAR
651667
value_normalized
VARCHAR
capscrew, 1/2 in x 1 nc grade 8 hex h ead zinc plated 1/2" 13 1" yellow finish | mfr: sha | p/n: 651667 | mfg#: 637-08013-08
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.428317
source_page
INTEGER
null
source_context
TEXT
part_number: 651667 | description: CAPSCREW, 1/2 IN X 1 NC GRADE 8 HEX H EAD ZINC PLATED 1/2" 13 1" YELLOW FINISH | manufacturer: SHA | mfg_part_number: 637-08013-08 | qty_on_hand: 0 | uom: EA