RM00303 - Sales Territory Master File - table structure
Great Plains Table Structure
- RM00303 - Sales Territory Master File
- Technical Name - RM_Sales_Territory_MSTR
- 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 |