Customer 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
   [timestamp]
   ,[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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Customer Bank Account].[Customer No_] = [Customer].[No_]
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_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Customer Bank Account].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Customer Bank Account].[Language Code] = [Language].[Code]

Show/hide columns in Customer Bank Account table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Customer No_ Primary Key Searchnvarchar(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_]
3Code Primary Key Searchnvarchar(40)
4Name Searchnvarchar(200)
5Name 2 Searchnvarchar(100)
6Address Searchnvarchar(200)
7Address 2 Searchnvarchar(100)
8City Searchnvarchar(60)
9Post Code Searchnvarchar(40)
10Contact Searchnvarchar(200)
11Phone No_ Searchnvarchar(60)
12Telex No_ Searchnvarchar(40)
13Bank Branch No_ Searchnvarchar(40)
14Bank Account No_ Searchnvarchar(60)
15Transit No_ Searchnvarchar(40)
16Currency Code Searchnvarchar(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 Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Customer Bank Account].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Customer Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Bank Account]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Customer Bank Account].[Country_Region Code] = [Country_Region].[Code]
18County Searchnvarchar(60)
19Fax No_ Searchnvarchar(60)
20Telex Answer Back Searchnvarchar(40)
21Language Code Searchnvarchar(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 Searchnvarchar(160)
23Home Page Searchnvarchar(160)
24IBAN Searchnvarchar(100)
25SWIFT Code Searchnvarchar(40)
26Bank Clearing Code Searchnvarchar(100)
27Bank Clearing Standard Searchnvarchar(100)
28$systemId Searchuniqueidentifier
29$systemCreatedAt Searchdatetime
30$systemCreatedBy Searchuniqueidentifier
31$systemModifiedAt Searchdatetime
32$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Customer Bank Account table

Leave a Reply

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