RM00302 - Salesperson Master Summary File - table structure
Great Plains Table Structure
- RM00302 - Salesperson Master Summary File
- Technical Name - RM_Salesperson_MSTR_SUM
- Series - Sales
- Physical Name - RM00302
Column Listing:
| Name | Data Type | Description |
|---|---|---|
| SLPRSNID | char(15) | Salesperson ID |
| HISTTYPE | smallint | History Type |
| PERIODID | smallint | Period ID |
| YEAR1 | smallint | Year |
| COSTAMNT | numeric(19,5) | Cost Amount |
| TTLCOMAM | numeric(19,5) | Total Commission Amount |
| COMSLTDT | numeric(19,5) | Commissioned Sales To Date |
| NCOMAMNT | numeric(19,5) | Non-Commissioned Amount |
| DEX_ROW_ID | int | GPS_Reserved |