Bank 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20No_nvarchar(40)
2Name Primary Key SearchNameNormalText100Namenvarchar(200)
3Search Name SearchSearch NameNormalCode100Search Namenvarchar(200)
4Name 2 SearchName 2NormalText50Name 2nvarchar(100)
5Address SearchAddressNormalText100Addressnvarchar(200)
6Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
7City SearchCityNormalText30Citynvarchar(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]
8Contact SearchContactNormalText100Contactnvarchar(200)
9Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
10Telex No. SearchTelex No.NormalText20Telex No_nvarchar(40)
13Bank Account No. SearchBank Account No.NormalText30Bank Account No_nvarchar(60)
14Transit No. SearchTransit No.NormalText20Transit No_nvarchar(40)
15Territory Code SearchTerritory CodeNormalCode10Territory Codenvarchar(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]
16Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(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]
17Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(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]
18Chain Name SearchChain NameNormalCode10Chain Namenvarchar(20)
20Min. Balance SearchMin. BalanceNormalDecimal12Min_ Balancedecimal(38,38)
21Bank Acc. Posting Group SearchBank Acc. Posting GroupNormalCode20Bank Acc_ Posting Groupnvarchar(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]
22Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
24Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(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]
25Format Region SearchFormat RegionNormalText80Format Regionnvarchar(160)
26Statistics Group SearchStatistics GroupNormalInteger4Statistics Groupint
29Our Contact Code SearchOur Contact CodeNormalCode20Our Contact Codenvarchar(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]
35Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
37Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
38Comment SearchCommentFlowFieldBoolean4
39Blocked SearchBlockedNormalBoolean4Blockedtinyint
41Last Statement No. SearchLast Statement No.NormalCode20Last Statement No_nvarchar(40)
42Last Payment Statement No. SearchLast Payment Statement No.NormalCode20Last Payment Statement No_nvarchar(40)
43Pmt. Rec. No. Series SearchPayment Reconciliation No. SeriesNormalCode20Pmt_ Rec_ No_ Seriesnvarchar(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]
54Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
55Date Filter SearchDate FilterFlowFilterDate4
56Global Dimension 1 Filter SearchGlobal Dimension 1 FilterFlowFilterCode20
57Global Dimension 2 Filter SearchGlobal Dimension 2 FilterFlowFilterCode20
58Balance SearchBalanceFlowFieldDecimal12
59Balance (LCY) SearchBalance ($)FlowFieldDecimal12
60Net Change SearchNet ChangeFlowFieldDecimal12
61Net Change (LCY) SearchNet Change ($)FlowFieldDecimal12
62Total on Checks SearchTotal on ChecksFlowFieldDecimal12
70Use as Default for Currency SearchUse as Default for CurrencyNormalBoolean4Use as Default for Currencytinyint
84Fax No. SearchFax No.NormalText30Fax No_nvarchar(60)
85Telex Answer Back SearchTelex Answer BackNormalText20Telex Answer Backnvarchar(40)
89Picture SearchPictureNormalBLOB8Pictureimage
91Post Code SearchZIP CodeNormalCode20Post Codenvarchar(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]
92County SearchStateNormalText30Countynvarchar(60)
93Last Check No. SearchLast Check No.NormalCode20Last Check No_nvarchar(40)
94Balance Last Statement SearchBalance Last StatementNormalDecimal12Balance Last Statementdecimal(38,38)
95Balance at Date SearchBalance at DateFlowFieldDecimal12
96Balance at Date (LCY) SearchBalance at Date ($)FlowFieldDecimal12
97Debit Amount SearchDebit AmountFlowFieldDecimal12
98Credit Amount SearchCredit AmountFlowFieldDecimal12
99Debit Amount (LCY) SearchDebit Amount ($)FlowFieldDecimal12
100Credit Amount (LCY) SearchCredit Amount ($)FlowFieldDecimal12
101Bank Branch No. SearchBank Branch No.NormalText20Bank Branch No_nvarchar(40)
102E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
103Home Page SearchHome PageNormalText80Home Pagenvarchar(160)
107No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(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]
108Check Report ID SearchCheck Report IDNormalInteger4Check Report IDint
109Check Report Name SearchCheck Report NameFlowFieldText250
110IBAN SearchIBANNormalCode50IBANnvarchar(100)
111SWIFT Code SearchSWIFT CodeNormalCode20SWIFT Codenvarchar(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]
113Bank Statement Import Format SearchBank Statement Import FormatNormalCode20Bank Statement Import Formatnvarchar(40)
115Credit Transfer Msg. Nos. SearchCredit Transfer Msg. Nos.NormalCode20Credit 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]
116Direct Debit Msg. Nos. SearchDirect Debit Msg. Nos.NormalCode20Direct 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]
117SEPA Direct Debit Exp. Format SearchSEPA Direct Debit Exp. FormatNormalCode20SEPA Direct Debit Exp_ Formatnvarchar(40)
121Bank Stmt. Service Record ID SearchBank Stmt. Service Record IDNormalRecordID448Bank Stmt_ Service Record IDvarbinary(448)
123Transaction Import Timespan SearchTransaction Import TimespanNormalInteger4Transaction Import Timespanint
124Automatic Stmt. Import Enabled SearchAutomatic Stmt. Import EnabledNormalBoolean4Automatic Stmt_ Import Enabledtinyint
130IntercompanyEnable SearchEnable for Intercompany transactionsNormalBoolean4IntercompanyEnabletinyint
140Image SearchImageNormalMedia16Imageuniqueidentifier
170Creditor No. SearchCreditor No.NormalCode35Creditor No_nvarchar(70)
1210Payment Export Format SearchPayment Export FormatNormalCode20Payment Export Formatnvarchar(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]
1211Bank Clearing Code SearchBank Clearing CodeNormalText50Bank Clearing Codenvarchar(100)
1212Bank Clearing Standard SearchBank Clearing StandardNormalText50Bank Clearing Standardnvarchar(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]
1213Bank Name – Data Conversion SearchBank Name – Data ConversionNormalText50Bank Name – Data Conversionnvarchar(100)
1250Match Tolerance Type SearchMatch Tolerance TypeNormalOption4Match Tolerance Typeint
Available options are:
  • “Percentage”
  • “Amount”
1251Match Tolerance Value SearchMatch Tolerance ValueNormalDecimal12Match Tolerance Valuedecimal(38,38)
1252Disable Automatic Pmt Matching SearchDisable Automatic Payment MatchingNormalBoolean4Disable Automatic Pmt Matchingtinyint
1260Positive Pay Export Code SearchPositive Pay Export CodeNormalCode20Positive Pay Export Codenvarchar(40)
5061Mobile Phone No. SearchMobile Phone No.NormalText30Mobile Phone No_nvarchar(60)
10005E-Pay Export File Path SearchE-Pay Export File PathNormalText250
10006Last E-Pay Export File Name SearchLast E-Pay Export File NameNormalText30
10007E-Pay Trans. Program Path SearchE-Pay Trans. Program PathNormalText250
10008E-Pay Trans. Program Command SearchE-Pay Trans. Program CommandNormalText80
10009Last ACH File ID Modifier SearchLast ACH File ID ModifierNormalCode1
10010Last Remittance Advice No. SearchLast Remittance Advice No.NormalCode20
10011Export Format SearchExport FormatNormalOption4
10012Last E-Pay File Creation No. SearchLast E-Pay File Creation No.NormalInteger4
10013Client No. SearchClient No.NormalCode10
10014Client Name SearchClient NameNormalCode30
10015Input Qualifier SearchInput QualifierNormalCode30
10017Bank Communication SearchBank CommunicationNormalOption4
10018Check Date Format SearchCheck Date FormatNormalOption4
10019Check Date Separator SearchCheck Date SeparatorNormalOption4
10020EFT Export Code SearchEFT IAT Export FormatNormalCode20
20100AMC Bank Name SearchBank NameNormalText50
20101AMC Bank File Name SearchBank file NameNormalText250
27000Bank Code SearchBank CodeNormalCode3
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Bank Account table

Leave a Reply

Your email address will not be published. Required fields are marked *