Vendor Bank Account – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables VVendor 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Vendor 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_]
3	Code	nvarchar(40)
4	Name	nvarchar(200)
5	Name 2	nvarchar(100)
6	Address	nvarchar(200)
7	Address 2	nvarchar(100)
8	City	nvarchar(60)
9	Post Code	nvarchar(40)
10	Contact	nvarchar(200)
11	Phone No_	nvarchar(60)
12	Telex No_	nvarchar(40)
13	Bank Branch No_	nvarchar(40)
14	Bank Account No_	nvarchar(60)
15	Transit No_	nvarchar(40)
16	Currency Code	nvarchar(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]
17	Country_Region Code	nvarchar(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]
18	County	nvarchar(60)
19	Fax No_	nvarchar(60)
20	Telex Answer Back	nvarchar(40)
21	Language Code	nvarchar(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]
22	E-Mail	nvarchar(160)
23	Home Page	nvarchar(160)
24	IBAN	nvarchar(100)
25	SWIFT Code	nvarchar(40)
26	Bank Clearing Code	nvarchar(100)
27	Bank Clearing Standard	nvarchar(100)
28	Reference No_	nvarchar(60)
29	$systemId	uniqueidentifier
30	$systemCreatedAt	datetime
31	$systemCreatedBy	uniqueidentifier
32	$systemModifiedAt	datetime
33	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Vendor Bank Account table

Country_Region Currency Language Vendor

Dynamics 365 BC Table Reference Tables Company Tables VVendor Bank Account

Leave a Reply Cancel reply