Real Life Dynamics GP User has posted a unified view for Customer information including notes.
SQL View – Customers
SQL & DataPayables & Receivables
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.