CN00500 - Collections - Customer Info

Dynamics GP table CN00500 (Collections - Customer Info) contains 14 columns including CUSTNMBR, CRDTMGR, PreferredContactMethod....

SQL Query Builder

SELECT * FROM CN00500

Select all

Column	Description	Type	Length	Shared With
CUSTNMBR	Customer Number	String	16	70 tables
CRDTMGR	Credit Manager	String	16	-
PreferredContactMethod	Preferred Contact Method	Integer	2	1 tables
NOMAIL	No Mail Merge	Boolean	2	-
ADRSCODE	Address Code	String	16	30 tables
Time_Zone	Time Zone	Integer	2	1 tables
CN_Credit_Control_Cycle	CN Credit Control Cycle	Integer	2	-
USRTAB01	User Defined Table 1	String	22	-
USRTAB09	User Defined Table 2	String	22	-
USERDEF1	User Defined 1	String	22	36 tables
USERDEF2	User Defined 2	String	22	36 tables
USRDAT01	User Defined Date 1	Date	4	2 tables
User_Defined_CB1	User Defined CB1	Boolean	2	-
User_Defined_CB2	User Defined CB2	Boolean	2	-

Tables that share columns with CN00500. Click "Join" to add to your query.

CUSTNMBR

USRDAT01

PreferredContactMethod

Time_Zone