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
   [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]
LEFT JOIN
   [User] AS [User]
      ON
         [Online Bank Acc. Link].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Online Bank Acc. Link].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Online Bank Acc. Link table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Online Bank Account ID SearchOnline Bank Account IDNormalText250Online Bank Account IDnvarchar(500)
3Online Bank ID SearchOnline Bank IDNormalText250Online Bank IDnvarchar(500)
4Automatic Logon Possible SearchAutomatic Logon PossibleNormalBoolean4Automatic Logon Possibletinyint
5Name SearchNameNormalText50Namenvarchar(100)
6Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
7Contact SearchContactNormalText50Contactnvarchar(100)
8Bank Account No. SearchBank Account No.NormalText30Bank Account No_nvarchar(60)
Key to join to the Bank Account table.

Show/hide example query

SELECT
       [Online Bank Acc. Link].[Bank Account No_]
       ,[Bank Account].[No_]
FROM
       [CRONUS UK Ltd_$Online Bank Acc_ Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Online Bank Acc. Link]
LEFT JOIN
       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
              ON
                     [Online Bank Acc. Link].[Bank Account No_] = [Bank Account].[No_]
100Temp Linked Bank Account No. SearchTemp Linked Bank Account No.NormalCode20Temp Linked Bank Account No_nvarchar(40)
101ProviderId SearchProviderIdNormalText50ProviderIdnvarchar(100)
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
       [Online Bank Acc. Link].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Online Bank Acc_ Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Online Bank Acc. Link]
LEFT JOIN
       [User] AS [User]
              ON
                     [Online Bank Acc. Link].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Online Bank Acc. Link].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Online Bank Acc_ Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Online Bank Acc. Link]
LEFT JOIN
       [User] AS [User]
              ON
                     [Online Bank Acc. Link].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Online Bank Acc. Link table

Leave a Reply

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