CN100100 - Collections - Query

Dynamics GP table CN100100 (Collections - Query) contains 24 columns including USERID, CUSTNMBR, CPRCSTNM....

SQL Query Builder

SELECT * FROM CN100100

Select all

Column	Description	Type	Length	Shared With
USERID	User ID	String	16	338 tables
CUSTNMBR	Customer Number	String	16	230 tables
CPRCSTNM	Corporate Customer Number	String	16	37 tables
CUSTNAME	Customer Name	String	66	41 tables
BALOVER	Balance Overdue	Currency	10	-
CUSTBLNC	Customer Balance	Currency	10	9 tables
CUSTCLAS	Customer Class	String	16	11 tables
CNTCPRSN	Contact Person	String	62	25 tables
STMTNAME	Statement Name	String	66	15 tables
ADRSCODE	Address Code	String	16	164 tables
ADDRESS1	Address 1	String	62	51 tables
ADDRESS2	Address 2	String	62	45 tables
CITY	City	String	36	53 tables
STATE	State	String	30	49 tables
ZIP	Zip	String	12	17 tables
COUNTRY	Country	String	62	39 tables
PHONE1	Phone 1	String	22	31 tables
FAX	Fax	String	22	22 tables
SLPRSNID	Salesperson ID	String	16	83 tables
SALSTERR	Sales Territory	String	16	44 tables
USERDEF1	User Defined 1	String	22	138 tables
USERDEF2	User Defined 2	String	22	138 tables
PreferredContactMethod	Preferred Contact Method	Integer	2	1 tables
Time_Zone	Time Zone	Integer	2	273 tables