RM Customer MSTR (RM00101)

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
Physical Name: RM00101
Technical Name: RM_Customer_MSTR

Group Display Name: Receivables Customer Master Files
Group Technical Name: RM_Customer_MSTR_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	16	15
2	CUSTNAME	Customer Name	STR64_Customer_Name	String	66	64
3	CUSTCLAS	Customer Class	STR15_Customer_Class	String	16	15
4	CPRCSTNM	Corporate Customer Number	STR15_RM_Customer_Number	String	16	15
5	CNTCPRSN	Contact Person	STR60	String	62	60
6	STMTNAME	Statement Name	STR64	String	66	64
7	SHRTNAME	Short Name	STR15	String	16	15
8	ADRSCODE	Address Code	STR15_Address_Code	String	16	15
9	UPSZONE	UPS Zone	STR3	String	4	3
10	SHIPMTHD	Shipping Method	STR15_Shipping_Method	String	16	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['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	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['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	62	60
13	ADDRESS2	Address 2	STR60	String	62	60
14	ADDRESS3	Address 3	STR60	String	62	60
15	COUNTRY	Country	STR60	String	62	60
16	CITY	City	STR35	String	36	35
17	STATE	State	STR30_State	String	30	29
18	ZIP	Zip	STR10	String	12	10
19	PHONE1	Phone 1	Phone_Number	String	22	14
20	PHONE2	Phone 2	Phone_Number	String	22	14
21	PHONE3	Phone 3	Phone_Number3	String	22	14
22	FAX	Fax	STR14_FAX	String	22	14
23	PRBTADCD	Primary Billto Address Code	STR15_LBAU	String	16	15
24	PRSTADCD	Primary Shipto Address Code	STR15_LBAU	String	16	15
25	STADDRCD	Statement Address Code	STR15_LBAU	String	16	15
26	SLPRSNID	Salesperson ID	STR15_Salesperson_ID	String	16	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['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	16	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['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	22	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['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	2	0
30	CRLMTAMT	Credit Limit Amount	DLR17_RBS0_UTR$	Currency	10	17
31	CRLMTPER	Credit Limit Period	DDL	Integer	2	0
32	CRLMTPAM	Credit Limit Period Amount	DLR17_RBS0_UTR$	Currency	10	17
33	CURNCYID	Currency ID	STR15_Currency_ID	String	16	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['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	16	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['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	2	5
36	PRCLEVEL	PriceLevel	STR10_LBAU	String	12	10
37	MINPYTYP	Minimum Payment Type	GB_Amt_Type	Integer	2	0
38	MINPYDLR	Minimum Payment Dollar	DLR17_RBS0_UTR$	Currency	10	17
39	MINPYPCT	Minimum Payment Percent	INT5_%2	Integer	2	5
40	FNCHATYP	Finance Charge Amt Type	GB_Amt_Type	Integer	2	0
41	FNCHPCNT	Finance Charge Percent	INT5_%2	Integer	2	5
42	FINCHDLR	Finance Charge Dollar	DLR17_RBS0_UTR$	Currency	10	17
43	MXWOFTYP	Maximum Writeoff Type	GP_Max_Writeoff	Integer	2	0
44	MXWROFAM	Max Writeoff Amount	DLR17_RBS0_UTR$	Currency	10	17
45	COMMENT1	Comment1	STR30	String	32	30
46	COMMENT2	Comment2	STR30	String	32	30
47	USERDEF1	User Defined 1	STR20	String	22	20
48	USERDEF2	User Defined 2	STR20	String	22	20
49	TAXEXMT1	Tax Exempt 1	STR25	String	26	25
50	TAXEXMT2	Tax Exempt 2	STR25	String	26	25
51	TXRGNNUM	Tax Registration Number	STR25	String	26	25
52	BALNCTYP	Balance Type	GB_Bal_Type	Integer	2	0
53	STMTCYCL	Statement Cycle	DDL_Stmt_Cycle	Integer	2	0
54	BANKNAME	Bank Name	STR30	String	32	30
55	BNKBRNCH	Bank Branch	STR20	String	22	20
56	SALSTERR	Sales Territory	STR15_Sales_Territory	String	16	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['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	2	0
58	RMCSHACC	RM Cash Account Index	LI_14	Long Integer	4	14
59	RMARACC	RM AR Account Index	LI_14	Long Integer	4	14
60	RMSLSACC	RM Sales Account Index	LI_14	Long Integer	4	14
61	RMIVACC	RM IV Account Index	LI_14	Long Integer	4	14
62	RMCOSACC	RM Cost Of Sales Account Index	LI_14	Long Integer	4	14
63	RMTAKACC	RM Discounts Taken Account Index	LI_14	Long Integer	4	14
64	RMAVACC	RM Discounts Avail Account Index	LI_14	Long Integer	4	14
65	RMFCGACC	RM Finance Charge Account Index	LI_14	Long Integer	4	14
66	RMWRACC	RM Writeoff Account Index	LI_14	Long Integer	4	14
67	RMSORACC	RM Sales Order Returns Account Index	LI_14	Long Integer	4	14
68	FRSTINDT	First Invoice Date	DT_Date	Date	4	6
69	INACTIVE	Inactive	CB_Inactive	Boolean	2	0
70	HOLD	Hold	CB_Hold	Boolean	2	0
71	CRCARDID	Credit Card ID	STR15	String	16	15
72	CRCRDNUM	Credit Card Number	STR20	String	22	20
73	CCRDXPDT	Credit Card Exp Date	DT_Date	Date	4	6
74	KPDSTHST	Keep Distribution History	CB_Keep_Dist_History	Boolean	2	0
75	KPCALHST	Keep Calendar History	CB_Keep_Calendar_History	Boolean	2	0
76	KPERHIST	Keep Period History	CB_Keep_Period_History	Boolean	2	0
77	KPTRXHST	Keep Trx History	CB_Keep_Trx_History	Boolean	2	0
78	NOTEINDX	Note Index	DLR14	Currency	10	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['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	4	8
80	MODIFDT	Modified Date	DT	Date	4	8
81	Revalue_Customer	Revalue Customer	CB Revalue Customer	Boolean	2	0
82	Post_Results_To	Post Results To	GB	Integer	2	0
83	FINCHID	Finance Charge ID	STR15_Charge_ID	String	16	15
84	GOVCRPID	Governmental Corporate ID	STR30_Gov_Corp_ID	String	32	30
85	GOVINDID	Governmental Individual ID	STR30_Gov_Indiv_ID	String	32	30
86	DISGRPER	Discount Grace Period	INT2_U0	Integer	2	2
87	DUEGRPER	Due Date Grace Period	INT2_U0	Integer	2	2
88	DOCFMTID	Document Format ID	STR15_LBU	String	16	15
89	Send_Email_Statements	Send Email Statements	CB	Boolean	2	0
90	USERLANG	User Language ID	INT	Integer	2	0
91	GPSFOINTEGRATIONID	GPSFO Integration ID	STR30	String	32	30
92	INTEGRATIONSOURCE	Integration Source	INT	Integer	2	0
93	INTEGRATIONID	Integration ID	STR30	String	32	30
94	ORDERFULFILLDEFAULT	Order Fulfillment Shortage Default	DDL_OrderFulfillDefault	Integer	2	0
95	CUSTPRIORITY	Customer Priority	DDL_CustomerPriority	Integer	2	0
96	CCode	Country Code	STR6_VAT	String	8	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['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	16	15
98	RMOvrpymtWrtoffAcctIdx	RM Overpayment Writeoff Account Index	LI_14	Long Integer	4	14
99	SHIPCOMPLETE	Ship Complete Document	CB_ShipComplete	Boolean	2	0
100	CBVAT	Cash Based VAT	CB_CashBasedVAT	Boolean	2	0
101	INCLUDEINDP	Include in Demand Planning	CB_IncludeInDemandPlanning	Boolean	2	0
102	DEX_ROW_TS		datetime	datetime	3	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	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.

azurecurve Products Microsoft Dynamics GP (0)SalesRM Customer MSTR (RM00101)

Leave a Reply Cancel reply