Vendor Bank Account

Dynamics 365 BC Table ReferenceTablesCompany TablesVVendor 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

   [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]
   ,[$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_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Vendor Bank Account].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Vendor Bank Account].[Post Code] = [Post Code].[Code]
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_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Vendor Bank Account].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code]
      ON
         [Vendor Bank Account].[SWIFT Code] = [SWIFT Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bank Clearing Standard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Clearing Standard]
      ON
         [Vendor Bank Account].[Bank Clearing Standard] = [Bank Clearing Standard].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Vendor Bank Account].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Vendor Bank Account].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Vendor Bank Account table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(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_]
2Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
3Name Primary Key SearchNameNormalText100Namenvarchar(200)
5Name 2 SearchName 2NormalText50Name 2nvarchar(100)
6Address SearchAddressNormalText100Addressnvarchar(200)
7Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
8City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Vendor Bank Account].[City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Vendor Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Vendor Bank Account].[City] = [Post Code].[City]
9Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Vendor Bank Account].[Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Vendor Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Vendor Bank Account].[Post Code] = [Post Code].[Code]
10Contact SearchContactNormalText100Contactnvarchar(200)
11Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
12Telex No. SearchTelex No.NormalText20Telex No_nvarchar(40)
13Bank Branch No. SearchBank Branch No.NormalText20Bank Branch No_nvarchar(40)
14Bank Account No. SearchBank Account No.NormalText30Bank Account No_nvarchar(60)
Key to join to the Bank Account table.

Show/hide example query

SELECT
	       [Vendor Bank Account].[Bank Account No_]
	       ,[Bank Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Vendor Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Account]
	              ON
	                     [Vendor Bank Account].[Bank Account No_] = [Bank Account].[No_]
15Transit No. SearchTransit No.NormalText20Transit No_nvarchar(40)
16Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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 SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
18County SearchStateNormalText30Countynvarchar(60)
19Fax No. SearchFax No.NormalText30Fax No_nvarchar(60)
20Telex Answer Back SearchTelex Answer BackNormalText20Telex Answer Backnvarchar(40)
21Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(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 SearchEmailNormalText80E-Mailnvarchar(160)
23Home Page SearchHome PageNormalText80Home Pagenvarchar(160)
24IBAN SearchIBANNormalCode50IBANnvarchar(100)
25SWIFT Code SearchSWIFT CodeNormalCode20SWIFT Codenvarchar(40)
Key to join to the SWIFT Code table.

Show/hide example query

SELECT
	       [Vendor Bank Account].[SWIFT Code]
	       ,[SWIFT Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Vendor Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$SWIFT Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [SWIFT Code]
	              ON
	                     [Vendor Bank Account].[SWIFT Code] = [SWIFT Code].[Code]
1211Bank Clearing Code SearchBank Clearing CodeNormalText50Bank Clearing Codenvarchar(100)
1212Bank Clearing Standard SearchBank Clearing StandardNormalText50Bank Clearing Standardnvarchar(100)
Key to join to the Bank Clearing Standard table.

Show/hide example query

SELECT
	       [Vendor Bank Account].[Bank Clearing Standard]
	       ,[Bank Clearing Standard].[Code]
	FROM
	       [CRONUS UK Ltd_$Vendor Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Bank Account]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bank Clearing Standard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bank Clearing Standard]
	              ON
	                     [Vendor Bank Account].[Bank Clearing Standard] = [Bank Clearing Standard].[Code]
10000Use for Electronic Payments SearchUse for Electronic PaymentsNormalBoolean4
27000Bank Code SearchBank CodeNormalCode3
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
	       [Vendor Bank Account].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Vendor Bank Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Bank Account]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Vendor Bank Account].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Vendor Bank Account table

CurrencyLanguagePost Code
Dynamics 365 BC Table ReferenceTablesCompany TablesVVendor Bank Account

Leave a Reply

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