GP RM20101 – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP RM20101

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

Table Type: Company

Table Name: GP RM20101
Database Table Name:

Table Number: 40132

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 RM20101 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 RM20101]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [GP RM20101].[CUSTNMBR] = [Customer].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [GP RM20101].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP RM20101].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP RM20101 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 RM20101].[] ,[Customer].[No_] FROM [] AS [GP RM20101] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [GP RM20101].[] = [Customer].[No_]
2	CPRCSTNM	CPRCSTNM	Normal	Text	15
3	DOCNUMBR	DOCNUMBR	Normal	Text	21
4	CHEKNMBR	CHEKNMBR	Normal	Text	21
5	BACHNUMB	BACHNUMB	Normal	Text	15
6	BCHSOURC	BCHSOURC	Normal	Text	15
7	TRXSORCE	TRXSORCE	Normal	Text	13
8	RMDTYPAL	RMDTYPAL	Normal	Integer	4
9	CSHRCTYP	CSHRCTYP	Normal	Integer	4
10	CBKIDCRD	CBKIDCRD	Normal	Text	15
11	CBKIDCSH	CBKIDCSH	Normal	Text	15
12	CBKIDCHK	CBKIDCHK	Normal	Text	15
13	DUEDATE	DUEDATE	Normal	Date	4
14	DOCDATE	DOCDATE	Normal	Date	4
15	POSTDATE	POSTDATE	Normal	Date	4
16	PSTUSRID	PSTUSRID	Normal	Text	15
17	GLPOSTDT	GLPOSTDT	Normal	DateTime	8
18	LSTEDTDT	LSTEDTDT	Normal	DateTime	8
19	LSTUSRED	LSTUSRED	Normal	Text	15
20	ORTRXAMT	ORTRXAMT	Normal	Decimal	12
21	CURTRXAM	CURTRXAM	Normal	Decimal	12
22	SLSAMNT	SLSAMNT	Normal	Decimal	12
23	COSTAMNT	COSTAMNT	Normal	Decimal	12
24	FRTAMNT	FRTAMNT	Normal	Decimal	12
25	MISCAMNT	MISCAMNT	Normal	Decimal	12
26	TAXAMNT	TAXAMNT	Normal	Decimal	12
27	COMDLRAM	COMDLRAM	Normal	Decimal	12
28	CASHAMNT	CASHAMNT	Normal	Decimal	12
29	DISTKNAM	DISTKNAM	Normal	Decimal	12
30	DISAVAMT	DISAVAMT	Normal	Decimal	12
31	DISAVTKN	DISAVTKN	Normal	Decimal	12
32	DISCRTND	DISCRTND	Normal	Decimal	12
33	DISCDATE	DISCDATE	Normal	Date	4
34	DSCDLRAM	DSCDLRAM	Normal	Decimal	12
35	DSCPCTAM	DSCPCTAM	Normal	Integer	4
36	WROFAMNT	WROFAMNT	Normal	Decimal	12
37	TRXDSCRN	TRXDSCRN	Normal	Text	31
38	CSPORNBR	CSPORNBR	Normal	Text	21
39	SLPRSNID	SLPRSNID	Normal	Text	15
40	SLSTERCD	SLSTERCD	Normal	Text	15
41	DINVPDOF	DINVPDOF	Normal	Date	4
42	PPSAMDED	PPSAMDED	Normal	Decimal	12
43	GSTDSAMT	GSTDSAMT	Normal	Decimal	12
44	DELETE1	DELETE1	Normal	Boolean	4
45	AGNGBUKT	AGNGBUKT	Normal	Integer	4
46	VOIDSTTS	VOIDSTTS	Normal	Integer	4
47	VOIDDATE	VOIDDATE	Normal	Date	4
48	TAXSCHID	TAXSCHID	Normal	Text	15
49	CURNCYID	CURNCYID	Normal	Text	15
50	PYMTRMID	PYMTRMID	Normal	Text	21
51	SHIPMTHD	SHIPMTHD	Normal	Text	15
52	TRDISAMT	TRDISAMT	Normal	Decimal	12
53	SLSCHDID	SLSCHDID	Normal	Text	15
54	FRTSCHID	FRTSCHID	Normal	Text	15
55	MSCSCHID	MSCSCHID	Normal	Text	15
56	NOTEINDX	NOTEINDX	Normal	Decimal	12
57	Tax_Date	Tax_Date	Normal	Date	4
58	APLYWITH	APLYWITH	Normal	Boolean	4
59	SALEDATE	SALEDATE	Normal	Date	4
60	CORRCTN	CORRCTN	Normal	Boolean	4
61	SIMPLIFD	SIMPLIFD	Normal	Boolean	4
62	Electronic	Electronic	Normal	Boolean	4
63	ECTRX	ECTRX	Normal	Boolean	4
64	BKTSLSAM	BKTSLSAM	Normal	Decimal	12
65	BKTFRTAM	BKTFRTAM	Normal	Decimal	12
66	BKTMSCAM	BKTMSCAM	Normal	Decimal	12
67	BackoutTradeDisc	BackoutTradeDisc	Normal	Decimal	12
68	Factoring	Factoring	Normal	Boolean	4
69	DIRECTDEBIT	DIRECTDEBIT	Normal	Boolean	4
70	ADRSCODE	ADRSCODE	Normal	Text	15
71	EFTFLAG	EFTFLAG	Normal	Boolean	4
72	DEX_ROW_TS	DEX_ROW_TS	Normal	DateTime	8
73	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 RM20101].[] ,[User].[User Security ID] FROM [] AS [GP RM20101] LEFT JOIN [User] AS [User] ON [GP RM20101].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16