Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM00101
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: RM Customer MSTR Group Display Name: Receivables Customer Master Files
Physical Name: RM00101
Technical Name: RM_Customer_MSTR
Group Technical Name: RM_Customer_MSTR_Logical_File
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | CUSTNMBR ![]() | Customer Number | STR15_RM_Customer_Number | String | 15 | |
2 | CUSTNAME ![]() | Customer Name | STR64_Customer_Name | String | 64 | |
3 | CUSTCLAS ![]() | Customer Class | STR15_Customer_Class | String | 15 | |
4 | CPRCSTNM ![]() | Corporate Customer Number | STR15_RM_Customer_Number | String | 15 | |
5 | CNTCPRSN ![]() | Contact Person | STR60 | String | 60 | |
6 | STMTNAME ![]() | Statement Name | STR64 | String | 64 | |
7 | SHRTNAME ![]() | Short Name | STR15 | String | 15 | |
8 | ADRSCODE ![]() | Address Code | STR15_Address_Code | String | 15 | |
9 | UPSZONE ![]() | UPS Zone | STR3 | String | 3 | |
10 | SHIPMTHD ![]() | Shipping Method | STR15_Shipping_Method | String | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['RM Customer MSTR'].SHIPMTHD AS 'RM Customer MSTR-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
RM00101 AS ['RM Customer MSTR']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['RM Customer MSTR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
11 | TAXSCHID ![]() | Tax Schedule ID | STR15_Tax_Schedule_ID | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['RM Customer MSTR'].TAXSCHID AS 'RM Customer MSTR-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
RM00101 AS ['RM Customer MSTR']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Customer MSTR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
12 | ADDRESS1 ![]() | Address 1 | STR60 | String | 60 | |
13 | ADDRESS2 ![]() | Address 2 | STR60 | String | 60 | |
14 | ADDRESS3 ![]() | Address 3 | STR60 | String | 60 | |
15 | COUNTRY ![]() | Country | STR60 | String | 60 | |
16 | CITY ![]() | City | STR35 | String | 35 | |
17 | STATE ![]() | State | STR30_State | String | 29 | |
18 | ZIP ![]() | Zip | STR10 | String | 10 | |
19 | PHONE1 ![]() | Phone 1 | Phone_Number | String | 14 | |
20 | PHONE2 ![]() | Phone 2 | Phone_Number | String | 14 | |
21 | PHONE3 ![]() | Phone 3 | Phone_Number3 | String | 14 | |
22 | FAX ![]() | Fax | STR14_FAX | String | 14 | |
23 | PRBTADCD ![]() | Primary Billto Address Code | STR15_LBAU | String | 15 | |
24 | PRSTADCD ![]() | Primary Shipto Address Code | STR15_LBAU | String | 15 | |
25 | STADDRCD ![]() | Statement Address Code | STR15_LBAU | String | 15 | |
26 | SLPRSNID ![]() | Salesperson ID | STR15_Salesperson_ID | String | 15 | |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['RM Customer MSTR'].SLPRSNID AS 'RM Customer MSTR-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
RM00101 AS ['RM Customer MSTR']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['RM Customer MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
27 | CHEKBKID ![]() | Checkbook ID | STR15_Checkbook_ID | String | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['RM Customer MSTR'].CHEKBKID AS 'RM Customer MSTR-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
RM00101 AS ['RM Customer MSTR']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['RM Customer MSTR'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
28 | PYMTRMID ![]() | Payment Terms ID | STR20_Payment_Terms_ID | String | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['RM Customer MSTR'].PYMTRMID AS 'RM Customer MSTR-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
RM00101 AS ['RM Customer MSTR']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['RM Customer MSTR'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
29 | CRLMTTYP ![]() | Credit Limit Type | GB_Amt_Type | Integer | 0 | |
30 | CRLMTAMT ![]() | Credit Limit Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
31 | CRLMTPER ![]() | Credit Limit Period | DDL | Integer | 0 | |
32 | CRLMTPAM ![]() | Credit Limit Period Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
33 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['RM Customer MSTR'].CURNCYID AS 'RM Customer MSTR-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
RM00101 AS ['RM Customer MSTR']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Customer MSTR'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
34 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['RM Customer MSTR'].RATETPID AS 'RM Customer MSTR-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
RM00101 AS ['RM Customer MSTR']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['RM Customer MSTR'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
35 | CUSTDISC ![]() | Customer Discount | INT5_%2 | Integer | 5 | |
36 | PRCLEVEL ![]() | PriceLevel | STR10_LBAU | String | 10 | |
37 | MINPYTYP ![]() | Minimum Payment Type | GB_Amt_Type | Integer | 0 | |
38 | MINPYDLR ![]() | Minimum Payment Dollar | DLR17_RBS0_UTR$ | Currency | 17 | |
39 | MINPYPCT ![]() | Minimum Payment Percent | INT5_%2 | Integer | 5 | |
40 | FNCHATYP ![]() | Finance Charge Amt Type | GB_Amt_Type | Integer | 0 | |
41 | FNCHPCNT ![]() | Finance Charge Percent | INT5_%2 | Integer | 5 | |
42 | FINCHDLR ![]() | Finance Charge Dollar | DLR17_RBS0_UTR$ | Currency | 17 | |
43 | MXWOFTYP ![]() | Maximum Writeoff Type | GP_Max_Writeoff | Integer | 0 | |
44 | MXWROFAM ![]() | Max Writeoff Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
45 | COMMENT1 ![]() | Comment1 | STR30 | String | 30 | |
46 | COMMENT2 ![]() | Comment2 | STR30 | String | 30 | |
47 | USERDEF1 ![]() | User Defined 1 | STR20 | String | 20 | |
48 | USERDEF2 ![]() | User Defined 2 | STR20 | String | 20 | |
49 | TAXEXMT1 ![]() | Tax Exempt 1 | STR25 | String | 25 | |
50 | TAXEXMT2 ![]() | Tax Exempt 2 | STR25 | String | 25 | |
51 | TXRGNNUM ![]() | Tax Registration Number | STR25 | String | 25 | |
52 | BALNCTYP ![]() | Balance Type | GB_Bal_Type | Integer | 0 | |
53 | STMTCYCL ![]() | Statement Cycle | DDL_Stmt_Cycle | Integer | 0 | |
54 | BANKNAME ![]() | Bank Name | STR30 | String | 30 | |
55 | BNKBRNCH ![]() | Bank Branch | STR20 | String | 20 | |
56 | SALSTERR ![]() | Sales Territory | STR15_Sales_Territory | String | 15 | |
Key to the Sales Territory Master File (RM00303).
Click to show/hideSELECT
['RM Customer MSTR'].SALSTERR AS 'RM Customer MSTR-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
RM00101 AS ['RM Customer MSTR']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['RM Customer MSTR'].SALSTERR = ['Sales Territory Master File'].SALSTERR | ||||||
57 | DEFCACTY ![]() | Default Cash Account Type | GB | Integer | 0 | |
58 | RMCSHACC ![]() | RM Cash Account Index | LI_14 | Long Integer | 14 | |
59 | RMARACC ![]() | RM AR Account Index | LI_14 | Long Integer | 14 | |
60 | RMSLSACC ![]() | RM Sales Account Index | LI_14 | Long Integer | 14 | |
61 | RMIVACC ![]() | RM IV Account Index | LI_14 | Long Integer | 14 | |
62 | RMCOSACC ![]() | RM Cost Of Sales Account Index | LI_14 | Long Integer | 14 | |
63 | RMTAKACC ![]() | RM Discounts Taken Account Index | LI_14 | Long Integer | 14 | |
64 | RMAVACC ![]() | RM Discounts Avail Account Index | LI_14 | Long Integer | 14 | |
65 | RMFCGACC ![]() | RM Finance Charge Account Index | LI_14 | Long Integer | 14 | |
66 | RMWRACC ![]() | RM Writeoff Account Index | LI_14 | Long Integer | 14 | |
67 | RMSORACC ![]() | RM Sales Order Returns Account Index | LI_14 | Long Integer | 14 | |
68 | FRSTINDT ![]() | First Invoice Date | DT_Date | Date | 6 | |
69 | INACTIVE ![]() | Inactive | CB_Inactive | Boolean | 0 | |
70 | HOLD ![]() | Hold | CB_Hold | Boolean | 0 | |
71 | CRCARDID ![]() | Credit Card ID | STR15 | String | 15 | |
72 | CRCRDNUM ![]() | Credit Card Number | STR20 | String | 20 | |
73 | CCRDXPDT ![]() | Credit Card Exp Date | DT_Date | Date | 6 | |
74 | KPDSTHST ![]() | Keep Distribution History | CB_Keep_Dist_History | Boolean | 0 | |
75 | KPCALHST ![]() | Keep Calendar History | CB_Keep_Calendar_History | Boolean | 0 | |
76 | KPERHIST ![]() | Keep Period History | CB_Keep_Period_History | Boolean | 0 | |
77 | KPTRXHST ![]() | Keep Trx History | CB_Keep_Trx_History | Boolean | 0 | |
78 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['RM Customer MSTR'].NOTEINDX AS 'RM Customer MSTR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RM00101 AS ['RM Customer MSTR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['RM Customer MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
79 | CREATDDT ![]() | Created Date | DT | Date | 8 | |
80 | MODIFDT ![]() | Modified Date | DT | Date | 8 | |
81 | Revalue_Customer ![]() | Revalue Customer | CB Revalue Customer | Boolean | 0 | |
82 | Post_Results_To ![]() | Post Results To | GB | Integer | 0 | |
83 | FINCHID ![]() | Finance Charge ID | STR15_Charge_ID | String | 15 | |
84 | GOVCRPID ![]() | Governmental Corporate ID | STR30_Gov_Corp_ID | String | 30 | |
85 | GOVINDID ![]() | Governmental Individual ID | STR30_Gov_Indiv_ID | String | 30 | |
86 | DISGRPER ![]() | Discount Grace Period | INT2_U0 | Integer | 2 | |
87 | DUEGRPER ![]() | Due Date Grace Period | INT2_U0 | Integer | 2 | |
88 | DOCFMTID ![]() | Document Format ID | STR15_LBU | String | 15 | |
89 | Send_Email_Statements ![]() | Send Email Statements | CB | Boolean | 0 | |
90 | USERLANG ![]() | User Language ID | INT | Integer | 0 | |
91 | GPSFOINTEGRATIONID ![]() | GPSFO Integration ID | STR30 | String | 30 | |
92 | INTEGRATIONSOURCE ![]() | Integration Source | INT | Integer | 0 | |
93 | INTEGRATIONID ![]() | Integration ID | STR30 | String | 30 | |
94 | ORDERFULFILLDEFAULT ![]() | Order Fulfillment Shortage Default | DDL_OrderFulfillDefault | Integer | 0 | |
95 | CUSTPRIORITY ![]() | Customer Priority | DDL_CustomerPriority | Integer | 0 | |
96 | CCode ![]() | Country Code | STR6_VAT | String | 6 | |
Key to the VAT Country Code MSTR (VAT10001).
Click to show/hideSELECT
['RM Customer MSTR'].CCode AS 'RM Customer MSTR-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
RM00101 AS ['RM Customer MSTR']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['RM Customer MSTR'].CCode = ['VAT Country Code MSTR'].CCode | ||||||
97 | DECLID ![]() | Declarant ID | STR15_Address_Code | String | 15 | |
98 | RMOvrpymtWrtoffAcctIdx ![]() | RM Overpayment Writeoff Account Index | LI_14 | Long Integer | 14 | |
99 | SHIPCOMPLETE ![]() | Ship Complete Document | CB_ShipComplete | Boolean | 0 | |
100 | CBVAT ![]() | Cash Based VAT | CB_CashBasedVAT | Boolean | 0 | |
101 | INCLUDEINDP ![]() | Include in Demand Planning | CB_IncludeInDemandPlanning | Boolean | 0 | |
102 | DEX_ROW_TS ![]() | datetime | datetime | 3 | ||
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised. | ||||||
103 | DEX_ROW_ID ![]() | int | int | 10 | ||
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column. |