The Customer Windows from RM in Dynamics GP. these are the most common customer tables I run across. For the most commonly used tables in the Customer/RM module go here.
–All check boxes in GP: unchecked is a 0 (zero) in the DB and checked is a 1.
–All drop down menus on windows, just count down the selection in the drop down: the first item listed is a 1 in the DB, second a 2, etc.
Customer Maintenance
In RM00101 much of the customer info is also in RM00102. The Customer Maintenance windows just shows you the last SAVED addressid for the Customer Address Maintenance window. If you are trying to get a mailing list you need to join the RM00101 with RM00102 table and look for the Primary Bill To Address ID or Primary Ship To. There should be a query for that along with sales history here.
Customer Address Maintenance
Customer Maintenance Options
Customer Summary
Customer Payment Summary Inquiry
Internet Information
All Internet Information (vendor, customer, etc.) is in SY10200. A vendor and a customer can have the same Master_ID they will just have their corresponding Master_type (CUS, VEN, etc).