Notes Table ?

[Lambro]

What table are the notes kept in for customer maintenance window?

 

[PTina]

The table is called Records Notes Master (SY03900) and holds all the notes for the company.

 

[Lambro]

I want to delete all notes for 1 company. Do you think it's safe to open this table and delete all rows?

 

[PTina]

No this is not a safe approach. This is because other tables have a reference to the data in the notes table.

You would also need to delete the reference to the notes master from these other tables. I think these fields are called Noteidx and Noteid. However it's quite a lot of tables that you would have to check.

The safest way to remove notes is to do so from the entry screens. This removes all references in all linked tables.

 

[winthropdc]

It would be possible to do a join between the Customer Master table and the Record Note Master and delete only notes that have a Note Index which exists in the Customer Master table.

David Musgrave
Senior Development Consultant
Asia Pacific Professional Services

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

mailto:dmusgrav@nospam-microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

 

[Ahssan]

HI All,

Im currently very new with greatplains can somebody tell me what table in the database holds the profile of the customer ?

thanks

 

[jymm]

if it is SQL you might want to look at RM00101 --- it has most of the info, but the rest I use is in RM00102, 103, 104 & 105

btw - you might want to make new posts instead of posting in old threads - this one might get missed.

 

[Ahssan]

thanks jymm,

well i was just searching for this and found it in this thread so i just gave it a try. hey one more thing have you worked directly with the tables to make it a source of some other database of some other application ? i am into such development at the moment where i might have to make one database as a meta database of all the databases. its getting quite complex for me how to go through it.

 

[jymm]

I used SQL to something similar integrating our CRM product with Dynamics, Outlook and our plant production system. If you know SQL, things are not that bad. Finding data in Dynamics though often is a pain --- I had to get a shovel and dig to find some things that were not documented too well.

My applications are all triggers, stored procedures, custom views & DTS that I installed onto our Dynamics databases to pull the info one way or the other. I also push things to a reporting db for my intranet reporting.

Quite complex (check)