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$16319982-4995-4fb1-8fb2-2b1e13773e3b

Table Number: 0

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$16319982-4995-4fb1-8fb2-2b1e13773e3b]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[AMC Bank Name]
   ,[Name]
   ,[AMC Bank File 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]
   ,[Statistics Group]
   ,[Our Contact Code]
   ,[Country_Region Code]
   ,[Amount]
   ,[Blocked]
   ,[Last Statement No_]
   ,[Last Payment Statement No_]
   ,[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]
   ,[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$16319982-4995-4fb1-8fb2-2b1e13773e3b]

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_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Bank Account].[Territory Code] = [Territory].[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_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Bank Account].[Country_Region Code] = [Country_Region].[Code]

Show/hide columns in Bank Account table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3AMC Bank Name Searchnvarchar(100)
3Name Searchnvarchar(200)
4AMC Bank File Name Searchnvarchar(500)
4Search Name Searchnvarchar(200)
5Name 2 Searchnvarchar(100)
6Address Searchnvarchar(200)
7Address 2 Searchnvarchar(100)
8City Searchnvarchar(60)
9Contact Searchnvarchar(200)
10Phone No_ Searchnvarchar(60)
11Telex No_ Searchnvarchar(40)
12Bank Account No_ Searchnvarchar(60)
13Transit No_ Searchnvarchar(40)
14Territory Code Searchnvarchar(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$16319982-4995-4fb1-8fb2-2b1e13773e3b] AS [Bank Account]
LEFT JOIN
       [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
              ON
                     [Bank Account].[Territory Code] = [Territory].[Code]
15Global Dimension 1 Code Searchnvarchar(40)
16Global Dimension 2 Code Searchnvarchar(40)
17Chain Name Searchnvarchar(20)
18Min_ Balance Searchdecimal(38,38)
19Bank Acc_ Posting Group Searchnvarchar(40)
20Currency Code Searchnvarchar(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$16319982-4995-4fb1-8fb2-2b1e13773e3b] AS [Bank Account]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Bank Account].[Currency Code] = [Currency].[Code]
21Language Code Searchnvarchar(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$16319982-4995-4fb1-8fb2-2b1e13773e3b] AS [Bank Account]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Bank Account].[Language Code] = [Language].[Code]
22Statistics Group Searchint
23Our Contact Code Searchnvarchar(40)
24Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Bank Account].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Bank Account$16319982-4995-4fb1-8fb2-2b1e13773e3b] AS [Bank Account]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Bank Account].[Country_Region Code] = [Country_Region].[Code]
25Amount Searchdecimal(38,38)
26Blocked Searchtinyint
27Last Statement No_ Searchnvarchar(40)
28Last Payment Statement No_ Searchnvarchar(40)
29Last Date Modified Searchdatetime
30Use as Default for Currency Searchtinyint
31Fax No_ Searchnvarchar(60)
32Telex Answer Back Searchnvarchar(40)
33Picture Searchimage
34Post Code Searchnvarchar(40)
35County Searchnvarchar(60)
36Last Check No_ Searchnvarchar(40)
37Balance Last Statement Searchdecimal(38,38)
38Bank Branch No_ Searchnvarchar(40)
39E-Mail Searchnvarchar(160)
40Home Page Searchnvarchar(160)
41No_ Series Searchnvarchar(40)
42Check Report ID Searchint
43IBAN Searchnvarchar(100)
44SWIFT Code Searchnvarchar(40)
45Bank Statement Import Format Searchnvarchar(40)
46Credit Transfer Msg_ Nos_ Searchnvarchar(40)
47Direct Debit Msg_ Nos_ Searchnvarchar(40)
48SEPA Direct Debit Exp_ Format Searchnvarchar(40)
49Bank Stmt_ Service Record ID Searchvarbinary(448)
50Transaction Import Timespan Searchint
51Automatic Stmt_ Import Enabled Searchtinyint
52Image Searchuniqueidentifier
53Creditor No_ Searchnvarchar(70)
54Payment Export Format Searchnvarchar(40)
55Bank Clearing Code Searchnvarchar(100)
56Bank Clearing Standard Searchnvarchar(100)
57Bank Name – Data Conversion Searchnvarchar(100)
58Match Tolerance Type Searchint
59Match Tolerance Value Searchdecimal(38,38)
60Disable Automatic Pmt Matching Searchtinyint
61Positive Pay Export Code Searchnvarchar(40)
62Mobile Phone No_ Searchnvarchar(60)
63$systemId Searchuniqueidentifier
64$systemCreatedAt Searchdatetime
65$systemCreatedBy Searchuniqueidentifier
66$systemModifiedAt Searchdatetime
67$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Bank Account table

Leave a Reply

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