GP BM30200 – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP BM30200

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

Table Type: Company

Table Name: GP BM30200
Database Table Name:

Table Number: 41003

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

Show/hide columns in GP BM30200 table

Field No.	Field Name	Field Caption	Class	Type	Length
1	TRX_ID	TRX_ID	Normal	Text	19
2	BM_Trx_Status	BM_Trx_Status	Normal	Integer	4
3	BCHSOURC	BCHSOURC	Normal	Text	15
4	BACHNUMB	BACHNUMB	Normal	Text	15
5	Batch_ID_Note_Index	Batch_ID_Note_Index	Normal	Decimal	12
6	Completion_Date	Completion_Date	Normal	DateTime	8
7	BM_Start_Date	BM_Start_Date	Normal	DateTime	8
8	TRXDATE	TRXDATE	Normal	DateTime	8
9	PSTGDATE	PSTGDATE	Normal	DateTime	8
10	REFRENCE	REFRENCE	Normal	Text	31
13	NOTEINDX	NOTEINDX	Normal	Decimal	12
14	MODIFDT	MODIFDT	Normal	DateTime	8
15	USER2ENT	USER2ENT	Normal	Text	15
16	CREATDDT	CREATDDT	Normal	DateTime	8
17	PTDUSRID	PTDUSRID	Normal	Text	15
18	POSTEDDT	POSTEDDT	Normal	DateTime	8
19	TRXSORCE	TRXSORCE	Normal	Text	13
20	USERDEF1	USERDEF1	Normal	Text	21
21	USERDEF2	USERDEF2	Normal	Text	21
22	USRDEF03	USRDEF03	Normal	Text	21
23	USRDEF04	USRDEF04	Normal	Text	21
24	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 BM30200].[] ,[User].[User Security ID] FROM [] AS [GP BM30200] LEFT JOIN [User] AS [User] ON [GP BM30200].[] = [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 BM30200

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 BM30200 table

Show/hide example query

Leave a Reply Cancel reply