RM00303 - Sales Territory Master File - table structure
Great Plains Table Structure
- RM00303 - Sales Transaction Work
- Technical Name - SOP_HDR_WORK
- Series - Sales
- Physical Name - RM00303
Column Listing:
| Name | Data Type | Description |
| SALSTERR | char(15) | Sales Territory |
| SLTERDSC | char(31) | Sales Territory Description |
| INACTIVE | tinyint | Inactive |
| SLPRSNID | char(15) | Salesperson ID |
| STMGRFNM | char(15) | Sales Territory Managers First Name |
| STMGRMNM | char(15) | Sales Territory Managers Middle Name |
| STMGRLNM | char(21) | Sales Territory Managers Last Name |
| COUNTRY | char(61) | Country |
| COSTTODT | numeric(19,5) | Cost To Date |
| TTLCOMTD | numeric(19,5) | Total Commissions To Date |
| TTLCOMLY | numeric(19,5) | Total Commissions Last Year |
| NCOMSLYR | numeric(19,5) | Non-Commissioned Sales Last Year |
| COMSLLYR | numeric(19,5) | Commissioned Sales Last Year |
| CSTLSTYR | numeric(19,5) | Cost Last Year |
| COMSLTDT | numeric(19,5) | Commissioned Sales To Date |
| NCOMSLTD | numeric(19,5) | Non-Commissioned Sales To Date |
| KPCALHST | tinyint | Keep Calendar History |
| KPERHIST | tinyint | Keep Period History |
| NOTEINDX | numeric(19,5) | Note Index |
| MODIFDT | datetime | Modified Date |
| CREATDDT | datetime | Created Date |
| DEX_ROW_TS | datetime | Time Stamp |
| DEX_ROW_ID | int | GPS_Reserved |
Related
- GP Table Listing - Dynamics Great Plains Table listing
Last modified by Mohit @ 4/16/2025 4:16:47 AM