RM00302 - Salesperson Master Summary File
Dynamics GP table RM00302 (Salesperson Master Summary File) contains 8 columns including SLPRSNID, HISTTYPE, PERIODID....
SQL Query Builder
8 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| SLPRSNID | Salesperson ID | String | 16 | |
| HISTTYPE | History Type | Integer | 2 | |
| PERIODID | Period ID | Integer | 2 | |
| YEAR1 | Year | Integer | 2 | |
| COSTAMNT | Cost Amount | Currency | 10 | |
| TTLCOMAM | Total Commission Amount | Currency | 10 | |
| COMSLTDT | Commissioned Sales To Date | Currency | 10 | |
| NCOMAMNT | Non-Commissioned Amount | Currency | 10 |
Related Tables
Tables that share columns with RM00302. Click "Join" to add to your query.
TTLCOMAM
COMSLTDT