CN01400 - Collections - Collector Master

Dynamics GP table CN01400 (Collections - Collector Master) contains 23 columns including CollectorID, CollectorName, Position_Name....

SQL Query Builder

SELECT * FROM CN01400

Select all

Column	Description	Type	Length	Shared With
CollectorID	Collector ID	String	16	1 tables
CollectorName	Collector Name	String	66	-
Position_Name	Position Name	String	32	-
CN_Email_Address	CN Email Address	String	62	-
CN_Collector_Phone1	CN Collector Phone1	String	26	-
CN_Collector_Phone2	CN Collector Phone2	String	26	-
CN_Collector_Fax	CN Collector Fax	String	26	-
CN_User_Defined1	CN User Defined1	String	52	-
CN_User_Defined2	CN User Defined2	String	52	-
CollectionsUser	Collections User	Boolean	2	-
USERID	User ID	String	16	80 tables
PASSWORD	Password	String	16	2 tables
eCollectUser	eCollect User	Boolean	2	-
Open_CollectPro_Main	Open CollectPro Main	Boolean	2	-
Open_CollectPro_Query	Open CollectPro Query	Boolean	2	-
Open_CollectPro_To_Do	Open CollectPro To Do	Boolean	2	-
CN_Default_Action_Assign	CN Default Action Assign To	Integer	2	-
NOTEINDX	Note Index	Currency	10	114 tables
CREATDDT	Created Date	Date	4	53 tables
MODIFDT	Modified Date	Date	4	58 tables
LSTUSRED	Last User to Edit	String	16	21 tables
CN_Signature_ID	CN_Signature_ID	String	16	1 tables
Refresh_Collections_Main	Refresh Collections Main	Boolean	2	-

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

NOTEINDX

USERID

MODIFDT

CREATDDT

PASSWORD

CollectorID

CN_Signature_ID