GP RM00201 – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP RM00201

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

Table Type: Company

Table Name: GP RM00201
Database Table Name:

Table Number: 40115

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 RM00201 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 RM00201]
LEFT JOIN
   [User] AS [User]
      ON
         [GP RM00201].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP RM00201].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP RM00201 table

Field No.	Field Name	Field Caption	Class	Type	Length
1	CLASSID	CLASSID	Normal	Text	15
2	CLASDSCR	CLASDSCR	Normal	Text	31
3	CRLMTTYP	CRLMTTYP	Normal	Integer	4
4	CRLMTAMT	CRLMTAMT	Normal	Decimal	12
5	CRLMTPER	CRLMTPER	Normal	Integer	4
6	CRLMTPAM	CRLMTPAM	Normal	Decimal	12
7	DEFLTCLS	DEFLTCLS	Normal	Boolean	4
8	BALNCTYP	BALNCTYP	Normal	Integer	4
9	CHEKBKID	CHEKBKID	Normal	Text	15
10	BANKNAME	BANKNAME	Normal	Text	31
11	TAXSCHID	TAXSCHID	Normal	Text	15
12	SHIPMTHD	SHIPMTHD	Normal	Text	15
13	PYMTRMID	PYMTRMID	Normal	Text	21
14	CUSTDISC	CUSTDISC	Normal	Integer	4
15	CSTPRLVL	CSTPRLVL	Normal	Text	11
16	MINPYTYP	MINPYTYP	Normal	Integer	4
17	MINPYDLR	MINPYDLR	Normal	Decimal	12
18	MINPYPCT	MINPYPCT	Normal	Integer	4
19	MXWOFTYP	MXWOFTYP	Normal	Integer	4
20	MXWROFAM	MXWROFAM	Normal	Decimal	12
21	FINCHARG	FINCHARG	Normal	Boolean	4
22	FNCHATYP	FNCHATYP	Normal	Integer	4
23	FINCHDLR	FINCHDLR	Normal	Decimal	12
24	FNCHPCNT	FNCHPCNT	Normal	Integer	4
25	PRCLEVEL	PRCLEVEL	Normal	Text	11
26	CURNCYID	CURNCYID	Normal	Text	15
27	RATETPID	RATETPID	Normal	Text	15
28	DEFCACTY	DEFCACTY	Normal	Integer	4
29	RMCSHACC	RMCSHACC	Normal	Integer	4
30	RMARACC	RMARACC	Normal	Integer	4
31	RMCOSACC	RMCOSACC	Normal	Integer	4
32	RMIVACC	RMIVACC	Normal	Integer	4
33	RMSLSACC	RMSLSACC	Normal	Integer	4
34	RMAVACC	RMAVACC	Normal	Integer	4
35	RMTAKACC	RMTAKACC	Normal	Integer	4
36	RMFCGACC	RMFCGACC	Normal	Integer	4
37	RMWRACC	RMWRACC	Normal	Integer	4
38	RMSORACC	RMSORACC	Normal	Integer	4
39	SALSTERR	SALSTERR	Normal	Text	15
40	SLPRSNID	SLPRSNID	Normal	Text	15
41	STMTCYCL	STMTCYCL	Normal	Integer	4
42	SNDSTMNT	SNDSTMNT	Normal	Boolean	4
43	INACTIVE	INACTIVE	Normal	Boolean	4
44	KPCALHST	KPCALHST	Normal	Boolean	4
45	KPDSTHST	KPDSTHST	Normal	Boolean	4
46	KPERHIST	KPERHIST	Normal	Boolean	4
47	KPTRXHST	KPTRXHST	Normal	Boolean	4
48	NOTEINDX	NOTEINDX	Normal	Decimal	12
49	MODIFDT	MODIFDT	Normal	DateTime	8
50	CREATDDT	CREATDDT	Normal	DateTime	8
51	Revalue_Customer	Revalue_Customer	Normal	Boolean	4
52	Post_Results_To	Post_Results_To	Normal	Integer	4
53	DISGRPER	DISGRPER	Normal	Integer	4
54	DUEGRPER	DUEGRPER	Normal	Integer	4
55	ORDERFULFILLDEFAULT	ORDERFULFILLDEFAULT	Normal	Integer	4
56	CUSTPRIORITY	CUSTPRIORITY	Normal	Integer	4
57	RMOvrpymtWrtoffAcctIdx	RMOvrpymtWrtoffAcctIdx	Normal	Integer	4
58	CBVAT	CBVAT	Normal	Boolean	4
59	INCLUDEINDP	INCLUDEINDP	Normal	Boolean	4
60	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 RM00201].[] ,[User].[User Security ID] FROM [] AS [GP RM00201] LEFT JOIN [User] AS [User] ON [GP RM00201].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16

Dynamics 365 BC Table Reference Tables Company Tables GGP RM00201

Show/hide an example select of all columns

Show/hide an example select of all columns by name

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

Show/hide columns in GP RM00201 table

Show/hide example query

Leave a Reply Cancel reply