Customer Bank Account

Dynamics 365 BC Table ReferenceTablesCompany TablesCCustomer Bank Account

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

Table Type: Company

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

Table Number: 287

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Customer No_]
   ,[Code]
   ,[Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Post Code]
   ,[Contact]
   ,[Phone No_]
   ,[Telex No_]
   ,[Bank Branch No_]
   ,[Bank Account No_]
   ,[Transit No_]
   ,[Currency Code]
   ,[Country_Region Code]
   ,[County]
   ,[Fax No_]
   ,[Telex Answer Back]
   ,[Language Code]
   ,[E-Mail]
   ,[Home Page]
   ,[IBAN]
   ,[SWIFT Code]
   ,[Bank Clearing Code]
   ,[Bank Clearing Standard]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Customer 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_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Customer Bank Account].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Customer Bank Account].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Customer Bank Account].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Customer Bank Account].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code]
      ON
         [Customer Bank Account].[SWIFT Code] = [SWIFT Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bank Clearing Standard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Clearing Standard]
      ON
         [Customer Bank Account].[Bank Clearing Standard] = [Bank Clearing Standard].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Customer Bank Account].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Customer Bank Account].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Customer Bank Account table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Customer Bank Account].[Customer No_]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Customer Bank Account].[Customer No_] = [Customer].[No_]
2Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
3Name Primary Key SearchNameNormalText100Namenvarchar(200)
5Name 2 SearchName 2NormalText50Name 2nvarchar(100)
6Address SearchAddressNormalText100Addressnvarchar(200)
7Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
8City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Customer Bank Account].[City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Customer Bank Account].[City] = [Post Code].[City]
9Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Customer Bank Account].[Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Customer Bank Account].[Post Code] = [Post Code].[Code]
10Contact SearchContactNormalText100Contactnvarchar(200)
11Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
12Telex No. SearchTelex No.NormalText20Telex No_nvarchar(40)
13Bank Branch No. SearchBank Branch No.NormalText20Bank Branch No_nvarchar(40)
14Bank Account No. SearchBank Account No.NormalText30Bank Account No_nvarchar(60)
Key to join to the Bank Account table.

Show/hide example query

SELECT
	       [Customer Bank Account].[Bank Account No_]
	       ,[Bank Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
	              ON
	                     [Customer Bank Account].[Bank Account No_] = [Bank Account].[No_]
15Transit No. SearchTransit No.NormalText20Transit No_nvarchar(40)
16Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Customer Bank Account].[Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Customer Bank Account].[Currency Code] = [Currency].[Code]
17Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
18County SearchStateNormalText30Countynvarchar(60)
19Fax No. SearchFax No.NormalText30Fax No_nvarchar(60)
20Telex Answer Back SearchTelex Answer BackNormalText20Telex Answer Backnvarchar(40)
21Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
	       [Customer Bank Account].[Language Code]
	       ,[Language].[Code]
	FROM
	       [CRONUS UK Ltd_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
	              ON
	                     [Customer Bank Account].[Language Code] = [Language].[Code]
22E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
23Home Page SearchHome PageNormalText80Home Pagenvarchar(160)
24IBAN SearchIBANNormalCode50IBANnvarchar(100)
25SWIFT Code SearchSWIFT CodeNormalCode20SWIFT Codenvarchar(40)
Key to join to the SWIFT Code table.

Show/hide example query

SELECT
	       [Customer Bank Account].[SWIFT Code]
	       ,[SWIFT Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code]
	              ON
	                     [Customer Bank Account].[SWIFT Code] = [SWIFT Code].[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
	       [Customer Bank Account].[Bank Clearing Standard]
	       ,[Bank Clearing Standard].[Code]
	FROM
	       [CRONUS UK Ltd_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bank Clearing Standard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Clearing Standard]
	              ON
	                     [Customer Bank Account].[Bank Clearing Standard] = [Bank Clearing Standard].[Code]
10000Use for Electronic Payments SearchUse for Electronic PaymentsNormalBoolean4
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
	       [Customer Bank Account].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Customer Bank Account].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Customer Bank Account table

CurrencyLanguagePost Code
Dynamics 365 BC Table ReferenceTablesCompany TablesCCustomer Bank Account

Leave a Reply

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