SQL View – GP Notes
The following view just pulls the raw table data out of the SY03900 (notes) table and gives it a friendly name. It just helps me when I can’t remember what table the notes are stored in 
.
You can name the view whatever you want by changing the [tspvGPNotes] below. Also the USE [TSP] tells the script to only execute on my database named TSP. You will need to modify the [TSP] to be whatever your database name is.
USE [TSP]
GO
/****** Object: View [dbo].[tspvGPNotes] Script Date: 06/17/2010 15:11:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[tspvGPNotes1]
AS
SELECT * FROM sy03900
You may want this one as well. To link back customer details to any notes they have. You can also do the same with vendors in replacing RM0010 with PM00200
select a.*, b.txtfield from rm00101 a
left outer join sy03900 b on a.noteindx = b.noteindx
order by a.custnmbr
Cheers.
R.
Thanks Rockfield. I am modifying my view for Customers and will post it today adding the Notes field. Great thinking.