GP Table for SOP Notes

(0) Share

Report

Posted on by kuroneko1313

2,119

Hello GP Experts,

I have a quick question. Our users have been putting in notes into the Sales Orders. And now I have to make a query to retrieve the content of those Sales Order notes. Unfortunately GP tables confuse me; I'm not sure which table these notes are stored into. Does anyone know which GP table brings this Sales Order notes information?

The notes are stored and can be retrieved by clicking on this button in Sales Order:

When clicked it displays this note:

Thanks in advanced for your help!!

-Elizabeth

*This post is locked for comments

All responses (2)

Answers (0)

kuroneko1313 2,119 on at

Like (0)

Report

Re: Re: GP Table for SOP Notes

Richard, thank you very much for your reply; this helps me a lot!
Have a great day :)

-Elizabeth
Richard Whaley 25,195 on at

Like (0)

Report

Re: GP Table for SOP Notes

These notes (called Record Notes) are stored in the SY03900 table in the company database. The individual records (in SOP10100) contain a field named NOTEINDX. Use this field to relate the sales order to the NOTEINDX field of the SY03900 table to pull the appropriate note.