Contact Alt_ Address – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CContact Alt_ Address

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

Table Type: Company

Table Name: Contact Alt_ Address
Database Table Name: CRONUS UK Ltd_$Contact Alt_ Address$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5051

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 Contact Alt_ Address can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Contact Alt_ Address$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Contact No_]
   ,[Code]
   ,[Company Name]
   ,[Company Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Post Code]
   ,[County]
   ,[Country_Region Code]
   ,[Phone No_]
   ,[Telex No_]
   ,[Extension No_]
   ,[Mobile Phone No_]
   ,[Pager]
   ,[E-Mail]
   ,[Home Page]
   ,[Fax No_]
   ,[Telex Answer Back]
   ,[Last Date Modified]
   ,[Search E-Mail]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Contact Alt_ Address$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Contact Alt_ Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Alt_ Address]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Contact Alt_ Address].[Country_Region Code] = [Country_Region].[Code]

Show/hide columns in Contact Alt_ Address table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Contact No_	nvarchar(40)
3	Code	nvarchar(20)
4	Company Name	nvarchar(200)
5	Company Name 2	nvarchar(100)
6	Address	nvarchar(200)
7	Address 2	nvarchar(100)
8	City	nvarchar(60)
9	Post Code	nvarchar(40)
10	County	nvarchar(60)
11	Country_Region Code	nvarchar(20)
	Key to join to the Country_Region table. Show/hide example query SELECT [Contact Alt_ Address].[Country_Region Code] ,[Country_Region].[Code] FROM [CRONUS UK Ltd_$Contact Alt_ Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Alt_ Address] LEFT JOIN [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region] ON [Contact Alt_ Address].[Country_Region Code] = [Country_Region].[Code]
12	Phone No_	nvarchar(60)
13	Telex No_	nvarchar(40)
14	Extension No_	nvarchar(60)
15	Mobile Phone No_	nvarchar(60)
16	Pager	nvarchar(60)
17	E-Mail	nvarchar(160)
18	Home Page	nvarchar(160)
19	Fax No_	nvarchar(60)
20	Telex Answer Back	nvarchar(40)
21	Last Date Modified	datetime
22	Search E-Mail	nvarchar(160)
23	$systemId	uniqueidentifier
24	$systemCreatedAt	datetime
25	$systemCreatedBy	uniqueidentifier
26	$systemModifiedAt	datetime
27	$systemModifiedBy	uniqueidentifier