Not logged in - Login

RM00201 - RM_Class_MSTR - table structure

Great Plains Table Structure

  • RM00201 - RM_Class_MSTR
  • Technical Name - RM_Class_MSTR
  • Series - Sales
  • Physical Name - RM00201

Column Listing:

NameData TypeDescription
CLASSIDchar(15)Class ID
CLASDSCRchar(31)Class Description
CRLMTTYPsmallintCredit Limit Type
CRLMTAMTnumeric(19,5)Credit Limit Amount
CRLMTPERsmallintCredit Limit Period
CRLMTPAMnumeric(19,5)Credit Limit Period Amount
DEFLTCLStinyintDefault Class
BALNCTYPsmallintBalance Type
CHEKBKIDchar(15)Checkbook ID
BANKNAMEchar(31)Bank Name
TAXSCHIDchar(15)Tax Schedule ID
SHIPMTHDchar(15)Shipping Method
PYMTRMIDchar(21)Payment Terms ID
CUSTDISCsmallintCustomer Discount
CSTPRLVLchar(11)Customer Price Level
MINPYTYPsmallintMinimum Payment Type
MINPYDLRnumeric(19,5)Minimum Payment Dollar
MINPYPCTsmallintMinimum Payment Percent
MXWOFTYPsmallintMaximum Writeoff Type
MXWROFAMnumeric(19,5)Max Writeoff Amount
FINCHARGtinyintFinance Charge
FNCHATYPsmallintFinance Charge Amt Type
FINCHDLRnumeric(19,5)Finance Charge Dollar
FNCHPCNTsmallintFinance Charge Percent
PRCLEVELchar(11)PriceLevel
CURNCYIDchar(15)Currency ID
RATETPIDchar(15)Rate Type ID
DEFCACTYsmallintDefault Cash Account Type
RMCSHACCintRM Cash Account Index
RMARACCintRM AR Account Index
RMCOSACCintRM Cost Of Sales Account Index
RMIVACCintRM IV Account Index
RMSLSACCintRM Sales Account Index
RMAVACCintRM Discounts Avail Account Index
RMTAKACCintRM Discounts Taken Account Index
RMFCGACCintRM Finance Charge Account Index
RMWRACCintRM Writeoff Account Index
RMSORACCintRM Sales Order Returns Account Index
SALSTERRchar(15)Sales Territory
SLPRSNIDchar(15)Salesperson ID
STMTCYCLsmallintStatement Cycle
SNDSTMNTtinyintSend Statement
INACTIVEtinyintInactive
KPCALHSTtinyintKeep Calendar History
KPDSTHSTtinyintKeep Distribution History
KPERHISTtinyintKeep Period History
KPTRXHSTtinyintKeep Trx History
NOTEINDXnumeric(19,5)Note Index
MODIFDTdatetimeModified Date
CREATDDTdatetimeCreated Date
Revalue_CustomertinyintRevalue Customer
Post_Results_TosmallintPost Results To
DISGRPERsmallintDiscount Grace Period
DUEGRPERsmallintDue Date Grace Period
ORDERFULFILLDEFAULTsmallintOrder Fulfillment Shortage Default
CUSTPRIORITYsmallintCustomer Priority
RMOvrpymtWrtoffAcctIdxintRM Overpayment Writeoff Account Index
CBVATtinyintCash Based VAT
INCLUDEINDPtinyintInclude in Demand Planning
DEX_ROW_IDintGPS_Reserved