RM00305 - Sales Territory Master Summary - table structure
Great Plains Table Structure
- RM00305 - Sales Territory Master Summary
- Technical Name - RM_Sales_Territory_MSTR_SUM
- Series - Sales
- Physical Name - RM00305
Column Listing:
| Name | Data Type | Description |
|---|---|---|
| SALSTERR | char(15) | Sales Territory |
| HISTTYPE | smallint | History Type |
| PERIODID | smallint | Period ID |
| YEAR1 | smallint | Year |
| SMRYDATE | datetime | Summary Date |
| 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 |