CN00100 - Collections - Notes
Dynamics GP table CN00100 (Collections - Notes) contains 29 columns including CUSTNMBR, CPRCSTNM, DATE1....
SQL Query Builder
29 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | |
| CPRCSTNM | Corporate Customer Number | String | 16 | |
| DATE1 | Date | Date | 4 | |
| Contact_Date | Contact Date | Date | 4 | |
| TIME1 | Time | Time | 4 | |
| Contact_Time | Contact Time | Time | 4 | |
| NOTEINDX | Note Index | Currency | 10 | |
| RevisionNumber | CN Revision Number | Integer | 2 | |
| CN_Group_Note | CN Group Note | Boolean | 2 | |
| Caller_ID_String | Caller ID String | String | 16 | |
| Action_Promised | Action Promised | String | 18 | |
| ActionType | Action Type | Integer | 2 | |
| Action_Date | Action Date | Date | 4 | |
| Action_Assigned_To | Action Assigned To | String | 16 | |
| Action_Completed | Action Completed | Boolean | 2 | |
| ACTCMDSP | Action Completed Sort By | Boolean | 2 | |
| Action_Completed_Date | Action Completed Date | Date | 4 | |
| Action_Completed_Time | Action Completed Time | Time | 4 | |
| Amount_Promised | Amount Promised | Currency | 10 | |
| Amount_Received | Amount Received | Currency | 10 | |
| USERID | User ID | String | 16 | |
| Note_Display_String | Note Display String | String | 72 | |
| CNTCPRSN | Contact Person | String | 62 | |
| ADRSCODE | Address Code | String | 16 | |
| USERDEF1 | User Defined 1 | String | 22 | |
| USERDEF2 | User Defined 2 | String | 22 | |
| USRDAT01 | User Defined Date 1 | Date | 4 | |
| PRIORT | Note Priority | Integer | 2 | |
| NOTECAT | Note Category | String | 16 |
Related Tables
Tables that share columns with CN00100. Click "Join" to add to your query.