Vendor Bank Account

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

Table Type: Company

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

Table Number: 288

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

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

Show/hide columns in Vendor Bank Account table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Vendor No_ Primary Key Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Vendor Bank Account].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Vendor Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Bank Account]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Vendor Bank Account].[Vendor No_] = [Vendor].[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
       [Vendor Bank Account].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Bank Account]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Vendor Bank Account].[Currency Code] = [Currency].[Code]
17Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Vendor Bank Account].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Bank Account]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Vendor 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
       [Vendor Bank Account].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Bank Account]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Vendor 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)
28Reference No_ Searchnvarchar(60)
29$systemId Searchuniqueidentifier
30$systemCreatedAt Searchdatetime
31$systemCreatedBy Searchuniqueidentifier
32$systemModifiedAt Searchdatetime
33$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Vendor Bank Account table

Leave a Reply

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