GP RM00101 – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP RM00101

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/40114

Table Type: Company

Table Name: GP RM00101
Database Table Name:

Table Number: 40114

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how GP RM00101 can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [GP RM00101]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [GP RM00101].[CUSTNMBR] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [GP RM00101].[City] = [Post Code].[City]
LEFT JOIN
   [User] AS [User]
      ON
         [GP RM00101].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP RM00101].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP RM00101 table

Field No.	Field Name	Field Caption	Class	Type	Length
1	CUSTNMBR	CUSTNMBR	Normal	Text	15
	Key to join to the Customer table. Show/hide example query SELECT [GP RM00101].[] ,[Customer].[No_] FROM [] AS [GP RM00101] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [GP RM00101].[] = [Customer].[No_]
2	CUSTNAME	CUSTNAME	Normal	Text	65
3	CUSTCLAS	CUSTCLAS	Normal	Text	15
4	CPRCSTNM	CPRCSTNM	Normal	Text	15
5	CNTCPRSN	CNTCPRSN	Normal	Text	61
6	STMTNAME	STMTNAME	Normal	Text	65
7	SHRTNAME	SHRTNAME	Normal	Text	15
8	ADRSCODE	ADRSCODE	Normal	Text	15
9	UPSZONE	UPSZONE	Normal	Text	3
10	SHIPMTHD	SHIPMTHD	Normal	Text	15
11	TAXSCHID	TAXSCHID	Normal	Text	15
12	ADDRESS1	ADDRESS1	Normal	Text	61
13	ADDRESS2	ADDRESS2	Normal	Text	61
14	ADDRESS3	ADDRESS3	Normal	Text	61
15	COUNTRY	COUNTRY	Normal	Text	61
16	CITY	CITY	Normal	Text	35
	Key to join to the Post Code table. Show/hide example query SELECT [GP RM00101].[] ,[Post Code].[City] FROM [] AS [GP RM00101] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [GP RM00101].[] = [Post Code].[City]
17	STATE	STATE	Normal	Text	29
18	ZIP	ZIP	Normal	Text	11
19	PHONE1	PHONE1	Normal	Text	21
20	PHONE2	PHONE2	Normal	Text	21
21	PHONE3	PHONE3	Normal	Text	21
22	FAX	FAX	Normal	Text	21
23	PRBTADCD	PRBTADCD	Normal	Text	15
24	PRSTADCD	PRSTADCD	Normal	Text	15
25	STADDRCD	STADDRCD	Normal	Text	15
26	SLPRSNID	SLPRSNID	Normal	Text	15
27	CHEKBKID	CHEKBKID	Normal	Text	15
28	PYMTRMID	PYMTRMID	Normal	Text	21
29	CRLMTTYP	CRLMTTYP	Normal	Integer	4
30	CRLMTAMT	CRLMTAMT	Normal	Decimal	12
31	CRLMTPER	CRLMTPER	Normal	Integer	4
32	CRLMTPAM	CRLMTPAM	Normal	Decimal	12
33	CURNCYID	CURNCYID	Normal	Text	15
34	RATETPID	RATETPID	Normal	Text	15
35	CUSTDISC	CUSTDISC	Normal	Integer	4
36	PRCLEVEL	PRCLEVEL	Normal	Text	11
37	MINPYTYP	MINPYTYP	Normal	Integer	4
38	MINPYDLR	MINPYDLR	Normal	Decimal	12
39	MINPYPCT	MINPYPCT	Normal	Integer	4
40	FNCHATYP	FNCHATYP	Normal	Integer	4
41	FNCHPCNT	FNCHPCNT	Normal	Integer	4
42	FINCHDLR	FINCHDLR	Normal	Decimal	12
43	MXWOFTYP	MXWOFTYP	Normal	Integer	4
44	MXWROFAM	MXWROFAM	Normal	Decimal	12
45	COMMENT1	COMMENT1	Normal	Text	31
46	COMMENT2	COMMENT2	Normal	Text	31
47	USERDEF1	USERDEF1	Normal	Text	21
48	USERDEF2	USERDEF2	Normal	Text	21
49	TAXEXMT1	TAXEXMT1	Normal	Text	25
50	TAXEXMT2	TAXEXMT2	Normal	Text	25
51	TXRGNNUM	TXRGNNUM	Normal	Text	25
52	BALNCTYP	BALNCTYP	Normal	Integer	4
53	STMTCYCL	STMTCYCL	Normal	Integer	4
54	BANKNAME	BANKNAME	Normal	Text	31
55	BNKBRNCH	BNKBRNCH	Normal	Text	21
56	SALSTERR	SALSTERR	Normal	Text	15
57	DEFCACTY	DEFCACTY	Normal	Integer	4
58	RMCSHACC	RMCSHACC	Normal	Integer	4
59	RMARACC	RMARACC	Normal	Integer	4
60	RMSLSACC	RMSLSACC	Normal	Integer	4
61	RMIVACC	RMIVACC	Normal	Integer	4
62	RMCOSACC	RMCOSACC	Normal	Integer	4
63	RMTAKACC	RMTAKACC	Normal	Integer	4
64	RMAVACC	RMAVACC	Normal	Integer	4
65	RMFCGACC	RMFCGACC	Normal	Integer	4
66	RMWRACC	RMWRACC	Normal	Integer	4
67	RMSORACC	RMSORACC	Normal	Integer	4
68	FRSTINDT	FRSTINDT	Normal	DateTime	8
69	INACTIVE	INACTIVE	Normal	Boolean	4
70	HOLD	HOLD	Normal	Boolean	4
71	CRCARDID	CRCARDID	Normal	Text	15
72	CRCRDNUM	CRCRDNUM	Normal	Text	21
73	CCRDXPDT	CCRDXPDT	Normal	DateTime	8
74	KPDSTHST	KPDSTHST	Normal	Boolean	4
75	KPCALHST	KPCALHST	Normal	Boolean	4
76	KPERHIST	KPERHIST	Normal	Boolean	4
77	KPTRXHST	KPTRXHST	Normal	Boolean	4
78	NOTEINDX	NOTEINDX	Normal	Decimal	12
79	CREATDDT	CREATDDT	Normal	DateTime	8
80	MODIFDT	MODIFDT	Normal	DateTime	8
81	Revalue_Customer	Revalue_Customer	Normal	Boolean	4
82	Post_Results_To	Post_Results_To	Normal	Integer	4
83	FINCHID	FINCHID	Normal	Text	15
84	GOVCRPID	GOVCRPID	Normal	Text	31
85	GOVINDID	GOVINDID	Normal	Text	31
86	DISGRPER	DISGRPER	Normal	Integer	4
87	DUEGRPER	DUEGRPER	Normal	Integer	4
88	DOCFMTID	DOCFMTID	Normal	Text	15
89	Send_Email_Statements	Send_Email_Statements	Normal	Boolean	4
90	USERLANG	USERLANG	Normal	Integer	4
91	GPSFOINTEGRATIONID	GPSFOINTEGRATIONID	Normal	Text	31
92	INTEGRATIONSOURCE	INTEGRATIONSOURCE	Normal	Integer	4
93	INTEGRATIONID	INTEGRATIONID	Normal	Text	31
94	ORDERFULFILLDEFAULT	ORDERFULFILLDEFAULT	Normal	Integer	4
95	CUSTPRIORITY	CUSTPRIORITY	Normal	Integer	4
96	CCode	CCode	Normal	Text	7
97	DECLID	DECLID	Normal	Text	15
98	RMOvrpymtWrtoffAcctIdx	RMOvrpymtWrtoffAcctIdx	Normal	Integer	4
99	SHIPCOMPLETE	SHIPCOMPLETE	Normal	Boolean	4
100	CBVAT	CBVAT	Normal	Boolean	4
101	INCLUDEINDP	INCLUDEINDP	Normal	Boolean	4
102	DEX_ROW_TS	DEX_ROW_TS	Normal	DateTime	8
103	DEX_ROW_ID	DEX_ROW_ID	Normal	Integer	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [GP RM00101].[] ,[User].[User Security ID] FROM [] AS [GP RM00101] LEFT JOIN [User] AS [User] ON [GP RM00101].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16