Contact 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Contact No_ Primary Key Searchnvarchar(40)
3Code Primary Key Searchnvarchar(20)
4Company Name Searchnvarchar(200)
5Company Name 2 Searchnvarchar(100)
6Address Searchnvarchar(200)
7Address 2 Searchnvarchar(100)
8City Searchnvarchar(60)
9Post Code Searchnvarchar(40)
10County Searchnvarchar(60)
11Country_Region Code Searchnvarchar(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]
12Phone No_ Searchnvarchar(60)
13Telex No_ Searchnvarchar(40)
14Extension No_ Searchnvarchar(60)
15Mobile Phone No_ Searchnvarchar(60)
16Pager Searchnvarchar(60)
17E-Mail Searchnvarchar(160)
18Home Page Searchnvarchar(160)
19Fax No_ Searchnvarchar(60)
20Telex Answer Back Searchnvarchar(40)
21Last Date Modified Searchdatetime
22Search E-Mail Searchnvarchar(160)
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Contact Alt_ Address table

Leave a Reply

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