GP Bank MSTR – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP Bank MSTR

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

Table Type: Company

Table Name: GP Bank MSTR
Database Table Name:

Table Number: 40100

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 Bank MSTR 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 Bank MSTR]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [GP Bank MSTR].[City] = [Post Code].[City]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Bank MSTR].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Bank MSTR].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP Bank MSTR table

Field No.	Field Name	Field Caption	Class	Type	Length
1	BANKID	BANKID	Normal	Text	15
2	BANKNAME	BANKNAME	Normal	Text	31
3	ADDRESS1	ADDRESS1	Normal	Text	61
4	ADDRESS2	ADDRESS2	Normal	Text	61
5	ADDRESS3	ADDRESS3	Normal	Text	61
6	CITY	CITY	Normal	Text	35
	Key to join to the Post Code table. Show/hide example query SELECT [GP Bank MSTR].[] ,[Post Code].[City] FROM [] AS [GP Bank MSTR] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [GP Bank MSTR].[] = [Post Code].[City]
7	STATE	STATE	Normal	Text	29
8	ZIPCODE	ZIPCODE	Normal	Text	11
9	COUNTRY	COUNTRY	Normal	Text	61
10	PHNUMBR1	PHNUMBR1	Normal	Text	21
11	PHNUMBR2	PHNUMBR2	Normal	Text	21
12	PHONE3	PHONE3	Normal	Text	21
13	FAXNUMBR	FAXNUMBR	Normal	Text	21
14	TRNSTNBR	TRNSTNBR	Normal	Text	9
15	BNKBRNCH	BNKBRNCH	Normal	Text	21
16	NOTEINDX	NOTEINDX	Normal	Decimal	12
17	DDTRANUM	DDTRANUM	Normal	Text	9
18	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 Bank MSTR].[] ,[User].[User Security ID] FROM [] AS [GP Bank MSTR] LEFT JOIN [User] AS [User] ON [GP Bank MSTR].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16