CN10200 - Collections - Query Activity
Dynamics GP table CN10200 (Collections - Query Activity) contains 10 columns including Query_ID, USERID, DATE1....
SQL Query Builder
10 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| Query_ID | Query ID | String | 16 | |
| USERID | User ID | String | 16 | |
| DATE1 | Date | Date | 4 | |
| TIME1 | Time | Time | 4 | |
| QueryExecuteTime | Query Execute Time | Long Integer | 4 | |
| Query_Total_Records | Query Total Records | Long Integer | 4 | |
| QueryRecordsFound | Query Records Found | Long Integer | 4 | |
| QueryTotalBalance | Query Total Balance | Currency | 10 | |
| QueryTotalPastDue | Query Total Past Due | Currency | 10 | |
| QueryCurrentRecord | Query Current Record | String | 16 |
Related Tables
Tables that share columns with CN10200. Click "Join" to add to your query.