Online Bank Acc_ Link

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

Table Type: Company

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

Table Number: 777

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 Online Bank Acc_ Link can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Online Bank Acc_ Link$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Online Bank Account ID]
   ,[Online Bank ID]
   ,[Automatic Logon Possible]
   ,[Name]
   ,[Currency Code]
   ,[Contact]
   ,[Bank Account No_]
   ,[Temp Linked Bank Account No_]
   ,[ProviderId]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Online Bank Acc_ Link$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Online Bank Acc_ Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Online Bank Acc_ Link]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Online Bank Acc_ Link].[Currency Code] = [Currency].[Code]

Show/hide columns in Online Bank Acc_ Link table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Online Bank Account ID Searchnvarchar(500)
4Online Bank ID Searchnvarchar(500)
5Automatic Logon Possible Searchtinyint
6Name Searchnvarchar(100)
7Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Online Bank Acc_ Link].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Online Bank Acc_ Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Online Bank Acc_ Link]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Online Bank Acc_ Link].[Currency Code] = [Currency].[Code]
8Contact Searchnvarchar(100)
9Bank Account No_ Searchnvarchar(60)
10Temp Linked Bank Account No_ Searchnvarchar(40)
11ProviderId Searchnvarchar(100)
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Online Bank Acc_ Link table

Leave a Reply

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