Not logged in - Login

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:

NameData TypeDescription
SALSTERRchar(15)Sales Territory
HISTTYPEsmallintHistory Type
PERIODIDsmallintPeriod ID
YEAR1smallintYear
SMRYDATEdatetimeSummary Date
COSTAMNTnumeric(19,5)Cost Amount
TTLCOMAMnumeric(19,5)Total Commission Amount
COMSLTDTnumeric(19,5)Commissioned Sales To Date
NCOMAMNTnumeric(19,5)Non-Commissioned Amount
DEX_ROW_IDintGPS_Reserved