Not logged in - Login

RM00101 - RM Customer MSTR - table structure

Great Plains Table Structure

  • RM00101 - Receivables Customer Master Files
  • Technical Name - RM_Customer_MSTR
  • Series - Sales
  • Physical Name - RM00101

Column Listing:

NameData TypeDescription
CUSTNMBRchar(15)Customer Number
CUSTNAMEchar(65)Customer Name
CUSTCLASchar(15)Customer Class
CPRCSTNMchar(15)Corporate Customer Number
CNTCPRSNchar(61)Contact Person
STMTNAMEchar(65)Statement Name
SHRTNAMEchar(15)Short Name
ADRSCODEchar(15)Address Code
UPSZONEchar(3)UPS Zone
SHIPMTHDchar(15)Shipping Method
TAXSCHIDchar(15)Tax Schedule ID
ADDRESS1char(61)Address 1
ADDRESS2char(61)Address 2
ADDRESS3char(61)Address 3
COUNTRYchar(61)Country
CITYchar(35)City
STATEchar(29)State
ZIPchar(11)Zip
PHONE1char(21)Phone 1
PHONE2char(21)Phone 2
PHONE3char(21)Phone 3
FAXchar(21)Fax
PRBTADCDchar(15)Primary Billto Address Code
PRSTADCDchar(15)Primary Shipto Address Code
STADDRCDchar(15)Statement Address Code
SLPRSNIDchar(15)Salesperson ID
CHEKBKIDchar(15)Checkbook ID
PYMTRMIDchar(21)Payment Terms ID
CRLMTTYPsmallintCredit Limit Type
CRLMTAMTnumeric(19,5)Credit Limit Amount
CRLMTPERsmallintCredit Limit Period
CRLMTPAMnumeric(19,5)Credit Limit Period Amount
CURNCYIDchar(15)Currency ID
RATETPIDchar(15)Rate Type ID
CUSTDISCsmallintCustomer Discount
PRCLEVELchar(11)PriceLevel
MINPYTYPsmallintMinimum Payment Type
MINPYDLRnumeric(19,5)Minimum Payment Dollar
MINPYPCTsmallintMinimum Payment Percent
FNCHATYPsmallintFinance Charge Amt Type
FNCHPCNTsmallintFinance Charge Percent
FINCHDLRnumeric(19,5)Finance Charge Dollar
MXWOFTYPsmallintMaximum Writeoff Type
MXWROFAMnumeric(19,5)Max Writeoff Amount
COMMENT1char(31)Comment1
COMMENT2char(31)Comment2
USERDEF1char(21)User Defined 1
USERDEF2char(21)User Defined 2
TAXEXMT1char(25)Tax Exempt 1
TAXEXMT2char(25)Tax Exempt 2
TXRGNNUMchar(25)Tax Registration Number
BALNCTYPsmallintBalance Type
STMTCYCLsmallintStatement Cycle
BANKNAMEchar(31)Bank Name
BNKBRNCHchar(21)Bank Branch
SALSTERRchar(15)Sales Territory
DEFCACTYsmallintDefault Cash Account Type
RMCSHACCintRM Cash Account Index
RMARACCintRM AR Account Index
RMSLSACCintRM Sales Account Index
RMIVACCintRM IV Account Index
RMCOSACCintRM Cost Of Sales Account Index
RMTAKACCintRM Discounts Taken Account Index
RMAVACCintRM Discounts Avail Account Index
RMFCGACCintRM Finance Charge Account Index
RMWRACCintRM Writeoff Account Index
RMSORACCintRM Sales Order Returns Account Index
FRSTINDTdatetimeFirst Invoice Date
INACTIVEtinyintInactive
HOLDtinyintHold
CRCARDIDchar(15)Credit Card ID
CRCRDNUMchar(21)Credit Card Number
CCRDXPDTdatetimeCredit Card Exp Date
KPDSTHSTtinyintKeep Distribution History
KPCALHSTtinyintKeep Calendar History
KPERHISTtinyintKeep Period History
KPTRXHSTtinyintKeep Trx History
NOTEINDXnumeric(19,5)Note Index
CREATDDTdatetimeCreated Date
MODIFDTdatetimeModified Date
Revalue_CustomertinyintRevalue Customer
Post_Results_TosmallintPost Results To
FINCHIDchar(15)Finance Charge ID
GOVCRPIDchar(31)Governmental Corporate ID
GOVINDIDchar(31)Governmental Individual ID
DISGRPERsmallintDiscount Grace Period
DUEGRPERsmallintDue Date Grace Period
DOCFMTIDchar(15)Document Format ID
Send_Email_StatementstinyintSend Email Statements
USERLANGsmallintUser Language ID
GPSFOINTEGRATIONIDchar(31)GPSFO Integration ID
INTEGRATIONSOURCEsmallintIntegration Source
INTEGRATIONIDchar(31)Integration ID
ORDERFULFILLDEFAULTsmallintOrder Fulfillment Shortage Default
CUSTPRIORITYsmallintCustomer Priority
CCodechar(7)Country Code
DECLIDchar(15)Declarant ID
RMOvrpymtWrtoffAcctIdxintRM Overpayment Writeoff Account Index
SHIPCOMPLETEtinyintShip Complete Document
CBVATtinyintCash Based VAT
INCLUDEINDPtinyintInclude in Demand Planning
DEX_ROW_TSdatetimeTime Stamp
DEX_ROW_IDintGPS_Reserved