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	230 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	164 tables
Time_Zone	Time Zone	Integer	2	273 tables
CN_Credit_Control_Cycle	CN Credit Control Cycle	Integer	2	-
USRTAB01	User Defined Table 1	String	22	1 tables
USRTAB09	User Defined Table 2	String	22	1 tables
USERDEF1	User Defined 1	String	22	138 tables
USERDEF2	User Defined 2	String	22	138 tables
USRDAT01	User Defined Date 1	Date	4	100 tables
User_Defined_CB1	User Defined CB1	Boolean	2	-
User_Defined_CB2	User Defined CB2	Boolean	2	-