RM00302 - Salesperson Master Summary File - table structure
Great Plains Table Structure
- RM00302 - Sales Transaction Work
- Technical Name - SOP_HDR_WORK
- 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 |
Related
- GP Table Listing - Dynamics Great Plains Table listing
Last modified by Mohit @ 4/16/2025 4:13:42 AM