Bank Account – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables BBank Account

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

Table Type: Company

Table Name: Bank Account
Database Table Name: CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 270

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 Bank Account can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[Name]
   ,[Search Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Contact]
   ,[Phone No_]
   ,[Telex No_]
   ,[Bank Account No_]
   ,[Transit No_]
   ,[Territory Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Chain Name]
   ,[Min_ Balance]
   ,[Bank Acc_ Posting Group]
   ,[Currency Code]
   ,[Language Code]
   ,[Format Region]
   ,[Statistics Group]
   ,[Our Contact Code]
   ,[Country_Region Code]
   ,[Amount]
   ,[Blocked]
   ,[Last Statement No_]
   ,[Last Payment Statement No_]
   ,[Pmt_ Rec_ No_ Series]
   ,[Last Date Modified]
   ,[Use as Default for Currency]
   ,[Fax No_]
   ,[Telex Answer Back]
   ,[Picture]
   ,[Post Code]
   ,[County]
   ,[Last Check No_]
   ,[Balance Last Statement]
   ,[Bank Branch No_]
   ,[E-Mail]
   ,[Home Page]
   ,[No_ Series]
   ,[Check Report ID]
   ,[IBAN]
   ,[SWIFT Code]
   ,[Bank Statement Import Format]
   ,[Credit Transfer Msg_ Nos_]
   ,[Direct Debit Msg_ Nos_]
   ,[SEPA Direct Debit Exp_ Format]
   ,[Bank Stmt_ Service Record ID]
   ,[Transaction Import Timespan]
   ,[Automatic Stmt_ Import Enabled]
   ,[IntercompanyEnable]
   ,[Image]
   ,[Creditor No_]
   ,[Payment Export Format]
   ,[Bank Clearing Code]
   ,[Bank Clearing Standard]
   ,[Bank Name - Data Conversion]
   ,[Match Tolerance Type]
   ,[Match Tolerance Value]
   ,[Disable Automatic Pmt Matching]
   ,[Positive Pay Export Code]
   ,[Mobile Phone No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Bank Account].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Bank Account].[Territory Code] = [Territory].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Bank Account].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Bank Account].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Bank Account].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Bank Account].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Bank Account].[Our Contact Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Bank Account].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code]
      ON
         [Bank Account].[SWIFT Code] = [SWIFT Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bank Export_Import Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Export/Import Setup]
      ON
         [Bank Account].[Payment Export Format] = [Bank Export/Import Setup].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bank Clearing Standard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Clearing Standard]
      ON
         [Bank Account].[Bank Clearing Standard] = [Bank Clearing Standard].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Bank Account].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Bank Account].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Bank Account table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Code	20	No_	nvarchar(40)
2	Name	Name	Normal	Text	100	Name	nvarchar(200)
3	Search Name	Search Name	Normal	Code	100	Search Name	nvarchar(200)
4	Name 2	Name 2	Normal	Text	50	Name 2	nvarchar(100)
5	Address	Address	Normal	Text	100	Address	nvarchar(200)
6	Address 2	Address 2	Normal	Text	50	Address 2	nvarchar(100)
7	City	City	Normal	Text	30	City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Bank Account].[City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Bank Account].[City] = [Post Code].[City]
8	Contact	Contact	Normal	Text	100	Contact	nvarchar(200)
9	Phone No.	Phone No.	Normal	Text	30	Phone No_	nvarchar(60)
10	Telex No.	Telex No.	Normal	Text	20	Telex No_	nvarchar(40)
13	Bank Account No.	Bank Account No.	Normal	Text	30	Bank Account No_	nvarchar(60)
14	Transit No.	Transit No.	Normal	Text	20	Transit No_	nvarchar(40)
15	Territory Code	Territory Code	Normal	Code	10	Territory Code	nvarchar(20)
	Key to join to the Territory table. Show/hide example query SELECT [Bank Account].[Territory Code] ,[Territory].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory] ON [Bank Account].[Territory Code] = [Territory].[Code]
16	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Bank Account].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Bank Account].[Global Dimension 1 Code] = [Dimension].[Code]
17	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Bank Account].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Bank Account].[Global Dimension 2 Code] = [Dimension].[Code]
18	Chain Name	Chain Name	Normal	Code	10	Chain Name	nvarchar(20)
20	Min. Balance	Min. Balance	Normal	Decimal	12	Min_ Balance	decimal(38,38)
21	Bank Acc. Posting Group	Bank Acc. Posting Group	Normal	Code	20	Bank Acc_ Posting Group	nvarchar(40)
	Key to join to the Bank Account Posting Group table. Show/hide example query SELECT [Bank Account].[Bank Acc_ Posting Group] ,[Bank Account Posting Group].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Bank Account Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account Posting Group] ON [Bank Account].[Bank Acc_ Posting Group] = [Bank Account Posting Group].[Code]
22	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Bank Account].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Bank Account].[Currency Code] = [Currency].[Code]
24	Language Code	Language Code	Normal	Code	10	Language Code	nvarchar(20)
	Key to join to the Language table. Show/hide example query SELECT [Bank Account].[Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Bank Account].[Language Code] = [Language].[Code]
25	Format Region	Format Region	Normal	Text	80	Format Region	nvarchar(160)
26	Statistics Group	Statistics Group	Normal	Integer	4	Statistics Group	int
29	Our Contact Code	Our Contact Code	Normal	Code	20	Our Contact Code	nvarchar(40)
	Key to join to the Salesperson/Purchaser table. Show/hide example query SELECT [Bank Account].[Our Contact Code] ,[Salesperson/Purchaser].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser] ON [Bank Account].[Our Contact Code] = [Salesperson/Purchaser].[Code]
35	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(20)
	Key to join to the Country/Region table. Show/hide example query SELECT [Bank Account].[Country_Region Code] ,[Country/Region].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region] ON [Bank Account].[Country_Region Code] = [Country/Region].[Code]
37	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
38	Comment	Comment	FlowField	Boolean	4
39	Blocked	Blocked	Normal	Boolean	4	Blocked	tinyint
41	Last Statement No.	Last Statement No.	Normal	Code	20	Last Statement No_	nvarchar(40)
42	Last Payment Statement No.	Last Payment Statement No.	Normal	Code	20	Last Payment Statement No_	nvarchar(40)
43	Pmt. Rec. No. Series	Payment Reconciliation No. Series	Normal	Code	20	Pmt_ Rec_ No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Bank Account].[Pmt_ Rec_ No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Bank Account].[Pmt_ Rec_ No_ Series] = [No. Series].[Code]
54	Last Date Modified	Last Date Modified	Normal	Date	4	Last Date Modified	datetime
55	Date Filter	Date Filter	FlowFilter	Date	4
56	Global Dimension 1 Filter	Global Dimension 1 Filter	FlowFilter	Code	20
57	Global Dimension 2 Filter	Global Dimension 2 Filter	FlowFilter	Code	20
58	Balance	Balance	FlowField	Decimal	12
59	Balance (LCY)	Balance ($)	FlowField	Decimal	12
60	Net Change	Net Change	FlowField	Decimal	12
61	Net Change (LCY)	Net Change ($)	FlowField	Decimal	12
62	Total on Checks	Total on Checks	FlowField	Decimal	12
70	Use as Default for Currency	Use as Default for Currency	Normal	Boolean	4	Use as Default for Currency	tinyint
84	Fax No.	Fax No.	Normal	Text	30	Fax No_	nvarchar(60)
85	Telex Answer Back	Telex Answer Back	Normal	Text	20	Telex Answer Back	nvarchar(40)
89	Picture	Picture	Normal	BLOB	8	Picture	image
91	Post Code	ZIP Code	Normal	Code	20	Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Bank Account].[Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Bank Account].[Post Code] = [Post Code].[Code]
92	County	State	Normal	Text	30	County	nvarchar(60)
93	Last Check No.	Last Check No.	Normal	Code	20	Last Check No_	nvarchar(40)
94	Balance Last Statement	Balance Last Statement	Normal	Decimal	12	Balance Last Statement	decimal(38,38)
95	Balance at Date	Balance at Date	FlowField	Decimal	12
96	Balance at Date (LCY)	Balance at Date ($)	FlowField	Decimal	12
97	Debit Amount	Debit Amount	FlowField	Decimal	12
98	Credit Amount	Credit Amount	FlowField	Decimal	12
99	Debit Amount (LCY)	Debit Amount ($)	FlowField	Decimal	12
100	Credit Amount (LCY)	Credit Amount ($)	FlowField	Decimal	12
101	Bank Branch No.	Bank Branch No.	Normal	Text	20	Bank Branch No_	nvarchar(40)
102	E-Mail	Email	Normal	Text	80	E-Mail	nvarchar(160)
103	Home Page	Home Page	Normal	Text	80	Home Page	nvarchar(160)
107	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Bank Account].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Bank Account].[No_ Series] = [No. Series].[Code]
108	Check Report ID	Check Report ID	Normal	Integer	4	Check Report ID	int
109	Check Report Name	Check Report Name	FlowField	Text	250
110	IBAN	IBAN	Normal	Code	50	IBAN	nvarchar(100)
111	SWIFT Code	SWIFT Code	Normal	Code	20	SWIFT Code	nvarchar(40)
	Key to join to the SWIFT Code table. Show/hide example query SELECT [Bank Account].[SWIFT Code] ,[SWIFT Code].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code] ON [Bank Account].[SWIFT Code] = [SWIFT Code].[Code]
113	Bank Statement Import Format	Bank Statement Import Format	Normal	Code	20	Bank Statement Import Format	nvarchar(40)
115	Credit Transfer Msg. Nos.	Credit Transfer Msg. Nos.	Normal	Code	20	Credit Transfer Msg_ Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Bank Account].[Credit Transfer Msg_ Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Bank Account].[Credit Transfer Msg_ Nos_] = [No. Series].[Code]
116	Direct Debit Msg. Nos.	Direct Debit Msg. Nos.	Normal	Code	20	Direct Debit Msg_ Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Bank Account].[Direct Debit Msg_ Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Bank Account].[Direct Debit Msg_ Nos_] = [No. Series].[Code]
117	SEPA Direct Debit Exp. Format	SEPA Direct Debit Exp. Format	Normal	Code	20	SEPA Direct Debit Exp_ Format	nvarchar(40)
121	Bank Stmt. Service Record ID	Bank Stmt. Service Record ID	Normal	RecordID	448	Bank Stmt_ Service Record ID	varbinary(448)
123	Transaction Import Timespan	Transaction Import Timespan	Normal	Integer	4	Transaction Import Timespan	int
124	Automatic Stmt. Import Enabled	Automatic Stmt. Import Enabled	Normal	Boolean	4	Automatic Stmt_ Import Enabled	tinyint
130	IntercompanyEnable	Enable for Intercompany transactions	Normal	Boolean	4	IntercompanyEnable	tinyint
140	Image	Image	Normal	Media	16	Image	uniqueidentifier
170	Creditor No.	Creditor No.	Normal	Code	35	Creditor No_	nvarchar(70)
1210	Payment Export Format	Payment Export Format	Normal	Code	20	Payment Export Format	nvarchar(40)
	Key to join to the Bank Export/Import Setup table. Show/hide example query SELECT [Bank Account].[Payment Export Format] ,[Bank Export/Import Setup].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Bank Export_Import Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Export/Import Setup] ON [Bank Account].[Payment Export Format] = [Bank Export/Import Setup].[Code]
1211	Bank Clearing Code	Bank Clearing Code	Normal	Text	50	Bank Clearing Code	nvarchar(100)
1212	Bank Clearing Standard	Bank Clearing Standard	Normal	Text	50	Bank Clearing Standard	nvarchar(100)
	Key to join to the Bank Clearing Standard table. Show/hide example query SELECT [Bank Account].[Bank Clearing Standard] ,[Bank Clearing Standard].[Code] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [CRONUS UK Ltd_$Bank Clearing Standard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Clearing Standard] ON [Bank Account].[Bank Clearing Standard] = [Bank Clearing Standard].[Code]
1213	Bank Name – Data Conversion	Bank Name – Data Conversion	Normal	Text	50	Bank Name – Data Conversion	nvarchar(100)
1250	Match Tolerance Type	Match Tolerance Type	Normal	Option	4	Match Tolerance Type	int
	Available options are: “Percentage” “Amount”
1251	Match Tolerance Value	Match Tolerance Value	Normal	Decimal	12	Match Tolerance Value	decimal(38,38)
1252	Disable Automatic Pmt Matching	Disable Automatic Payment Matching	Normal	Boolean	4	Disable Automatic Pmt Matching	tinyint
1260	Positive Pay Export Code	Positive Pay Export Code	Normal	Code	20	Positive Pay Export Code	nvarchar(40)
5061	Mobile Phone No.	Mobile Phone No.	Normal	Text	30	Mobile Phone No_	nvarchar(60)
10005	E-Pay Export File Path	E-Pay Export File Path	Normal	Text	250
10006	Last E-Pay Export File Name	Last E-Pay Export File Name	Normal	Text	30
10007	E-Pay Trans. Program Path	E-Pay Trans. Program Path	Normal	Text	250
10008	E-Pay Trans. Program Command	E-Pay Trans. Program Command	Normal	Text	80
10009	Last ACH File ID Modifier	Last ACH File ID Modifier	Normal	Code	1
10010	Last Remittance Advice No.	Last Remittance Advice No.	Normal	Code	20
10011	Export Format	Export Format	Normal	Option	4
10012	Last E-Pay File Creation No.	Last E-Pay File Creation No.	Normal	Integer	4
10013	Client No.	Client No.	Normal	Code	10
10014	Client Name	Client Name	Normal	Code	30
10015	Input Qualifier	Input Qualifier	Normal	Code	30
10017	Bank Communication	Bank Communication	Normal	Option	4
10018	Check Date Format	Check Date Format	Normal	Option	4
10019	Check Date Separator	Check Date Separator	Normal	Option	4
10020	EFT Export Code	EFT IAT Export Format	Normal	Code	20
20100	AMC Bank Name	Bank Name	Normal	Text	50
20101	AMC Bank File Name	Bank file Name	Normal	Text	250
27000	Bank Code	Bank Code	Normal	Code	3
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Bank Account].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [User] AS [User] ON [Bank Account].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Bank Account].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account] LEFT JOIN [User] AS [User] ON [Bank Account].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Bank Account table

Currency Language Post Code Territory

Dynamics 365 BC Table Reference Tables Company Tables BBank Account

Leave a Reply Cancel reply