CN00100 - Collections - Notes | Prospr - Dynamics GP Table Reference

CN00100 - Collections - Notes

Query Builder

Select * from CN00100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
CPRCSTNM	Corporate Customer Number	String	16	View
DATE1	Date	Date	4	View
Contact_Date	Contact Date	Date	4	View
TIME1	Time	Time	4	View
Contact_Time	Contact Time	Time	4	View
NOTEINDX	Note Index	Currency	10	View
RevisionNumber	CN Revision Number	Integer	2	View
CN_Group_Note	CN Group Note	Boolean	2	View
Caller_ID_String	Caller ID String	String	16	View
Action_Promised	Action Promised	String	18	View
ActionType	Action Type	Integer	2	View
Action_Date	Action Date	Date	4	View
Action_Assigned_To	Action Assigned To	String	16	View
Action_Completed	Action Completed	Boolean	2	View
ACTCMDSP	Action Completed Sort By	Boolean	2	View
Action_Completed_Date	Action Completed Date	Date	4	View
Action_Completed_Time	Action Completed Time	Time	4	View
Amount_Promised	Amount Promised	Currency	10	View
Amount_Received	Amount Received	Currency	10	View
USERID	User ID	String	16	View
Note_Display_String	Note Display String	String	72	View
CNTCPRSN	Contact Person	String	62	View
ADRSCODE	Address Code	String	16	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
USRDAT01	User Defined Date 1	Date	4	View
PRIORT	Note Priority	Integer	2	View
NOTECAT	Note Category	String	16	View