RM00101 - RM Customer MSTR
Dynamics GP table RM00101 (RM Customer MSTR) contains 101 columns including CUSTNMBR, CUSTNAME, CUSTCLAS....
SQL Query Builder
101 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | ||
| CUSTNAME | Customer Name | String | 66 | ||
| CUSTCLAS | Customer Class | String | 16 | ||
| CPRCSTNM | Corporate Customer Number | String | 16 | ||
| CNTCPRSN | Contact Person | String | 62 | ||
| STMTNAME | Statement Name | String | 66 | ||
| SHRTNAME | Short Name | String | 16 | ||
| ADRSCODE | Address Code | String | 16 | ||
| UPSZONE | UPS Zone | String | 4 | ||
| SHIPMTHD | Shipping Method | String | 16 | ||
| TAXSCHID | Tax Schedule ID | String | 16 | ||
| ADDRESS1 | Address 1 | String | 62 | ||
| ADDRESS2 | Address 2 | String | 62 | ||
| ADDRESS3 | Address 3 | String | 62 | ||
| COUNTRY | Country | String | 62 | ||
| CITY | City | String | 36 | ||
| STATE | State | String | 30 | ||
| ZIP | Zip | String | 12 | ||
| PHONE1 | Phone 1 | String | 22 | ||
| PHONE2 | Phone 2 | String | 22 | ||
| PHONE3 | Phone 3 | String | 22 | ||
| FAX | Fax | String | 22 | ||
| PRBTADCD | Primary Billto Address Code | String | 16 | ||
| PRSTADCD | Primary Shipto Address Code | String | 16 | ||
| STADDRCD | Statement Address Code | String | 16 | ||
| SLPRSNID | Salesperson ID | String | 16 | ||
| CHEKBKID | Checkbook ID | String | 16 | ||
| PYMTRMID | Payment Terms ID | String | 22 | ||
| CRLMTTYP | Credit Limit Type | Integer | 2 | ||
| CRLMTAMT | Credit Limit Amount | Currency | 10 | ||
| CRLMTPER | Credit Limit Period | Integer | 2 | ||
| CRLMTPAM | Credit Limit Period Amount | Currency | 10 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| RATETPID | Rate Type ID | String | 16 | ||
| CUSTDISC | Customer Discount | Integer | 2 | ||
| PRCLEVEL | PriceLevel | String | 12 | ||
| MINPYTYP | Minimum Payment Type | Integer | 2 | ||
| MINPYDLR | Minimum Payment Dollar | Currency | 10 | ||
| MINPYPCT | Minimum Payment Percent | Integer | 2 | ||
| FNCHATYP | Finance Charge Amt Type | Integer | 2 | ||
| FNCHPCNT | Finance Charge Percent | Integer | 2 | ||
| FINCHDLR | Finance Charge Dollar | Currency | 10 | ||
| MXWOFTYP | Maximum Writeoff Type | Integer | 2 | ||
| MXWROFAM | Max Writeoff Amount | Currency | 10 | ||
| COMMENT1 | Comment1 | String | 32 | ||
| COMMENT2 | Comment2 | String | 32 | ||
| USERDEF1 | User Defined 1 | String | 22 | ||
| USERDEF2 | User Defined 2 | String | 22 | ||
| TAXEXMT1 | Tax Exempt 1 | String | 26 | ||
| TAXEXMT2 | Tax Exempt 2 | String | 26 | ||
| TXRGNNUM | Tax Registration Number | String | 26 | ||
| BALNCTYP | Balance Type | Integer | 2 | ||
| STMTCYCL | Statement Cycle1. No Statement2. Weekly3. Biweekly4. Semi Monthly5. Monthly6. Bimonthly7. Quarterly | Integer | 2 | ||
| BANKNAME | Bank Name | String | 32 | ||
| BNKBRNCH | Bank Branch | String | 22 | ||
| SALSTERR | Sales Territory | String | 16 | ||
| DEFCACTY | Default Cash Account Type0. Checkbook1. Customer | Integer | 2 | ||
| RMCSHACC | RM Cash Account Index | Long Integer | 4 | ||
| RMARACC | RM AR Account Index | Long Integer | 4 | ||
| RMSLSACC | RM Sales Account Index | Long Integer | 4 | ||
| RMIVACC | RM IV Account Index | Long Integer | 4 | ||
| RMCOSACC | RM Cost Of Sales Account Index | Long Integer | 4 | ||
| RMTAKACC | RM Discounts Taken Account Index | Long Integer | 4 | ||
| RMAVACC | RM Discounts Avail Account Index | Long Integer | 4 | ||
| RMFCGACC | RM Finance Charge Account Index | Long Integer | 4 | ||
| RMWRACC | RM Writeoff Account Index | Long Integer | 4 | ||
| RMSORACC | RM Sales Order Returns Account Index | Long Integer | 4 | ||
| FRSTINDT | First Invoice Date | Date | 4 | ||
| INACTIVE | Inactive | Boolean | 2 | ||
Active Status values (2) 0 = Active1 = Inactive | |||||
| HOLD | Hold | Boolean | 2 | ||
Hold Status values (2) 0 = Not on hold1 = On hold | |||||
| CRCARDID | Credit Card ID | String | 16 | ||
| CRCRDNUM | Credit Card Number | String | 22 | ||
| CCRDXPDT | Credit Card Exp Date | Date | 4 | ||
| KPDSTHST | Keep Distribution History | Boolean | 2 | ||
| KPCALHST | Keep Calendar History | Boolean | 2 | ||
| KPERHIST | Keep Period History | Boolean | 2 | ||
| KPTRXHST | Keep Trx History | Boolean | 2 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| CREATDDT | Created Date | Date | 4 | ||
| MODIFDT | Modified Date | Date | 4 | ||
| Revalue_Customer | Revalue Customer | Boolean | 2 | ||
| Post_Results_To | Post Results To | Integer | 2 | ||
| FINCHID | Finance Charge ID | String | 16 | ||
| GOVCRPID | Governmental Corporate ID | String | 32 | ||
| GOVINDID | Governmental Individual ID | String | 32 | ||
| DISGRPER | Discount Grace Period | Integer | 2 | ||
| DUEGRPER | Due Date Grace Period | Integer | 2 | ||
| DOCFMTID | Document Format ID | String | 16 | ||
| Send_Email_Statements | Send Email Statements | Boolean | 2 | ||
| USERLANG | User Language ID | Integer | 2 | ||
| GPSFOINTEGRATIONID | GPSFO Integration ID | String | 32 | ||
| INTEGRATIONSOURCE | Integration Source | Integer | 2 | ||
| INTEGRATIONID | Integration ID | String | 32 | ||
| ORDERFULFILLDEFAULT | Order Fulfillment Shortage Default | Integer | 2 | ||
| CUSTPRIORITY | Customer Priority | Integer | 2 | ||
| CCode | Country Code | String | 8 | ||
| DECLID | Declarant ID | String | 16 | ||
| RMOvrpymtWrtoffAcctIdx | RM Overpayment Writeoff Account Index | Long Integer | 4 | ||
| SHIPCOMPLETE | Ship Complete Document | Boolean | 2 | ||
| CBVAT | Cash Based VAT | Boolean | 2 | ||
| INCLUDEINDP | Include in Demand Planning | Boolean | 2 | ||
Related Tables
Tables that share columns with RM00101. Click "Join" to add to your query.