Alternative Address

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

Table Type: Company

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

Table Number: 5201

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Alternative Address$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Employee No_]
   ,[Code]
   ,[Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Post Code]
   ,[County]
   ,[Phone No_]
   ,[Fax No_]
   ,[E-Mail]
   ,[Country_Region Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Alternative 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_$Alternative Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Alternative Address]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Alternative Address].[Country_Region Code] = [Country_Region].[Code]

Show/hide columns in Alternative Address table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Employee No_ Primary Key Searchnvarchar(40)
3Code Primary Key Searchnvarchar(20)
4Name Searchnvarchar(200)
5Name 2 Searchnvarchar(100)
6Address Searchnvarchar(200)
7Address 2 Searchnvarchar(100)
8City Searchnvarchar(60)
9Post Code Searchnvarchar(40)
10County Searchnvarchar(60)
11Phone No_ Searchnvarchar(60)
12Fax No_ Searchnvarchar(60)
13E-Mail Searchnvarchar(160)
14Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Alternative Address].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Alternative Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Alternative Address]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Alternative Address].[Country_Region Code] = [Country_Region].[Code]
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Alternative Address table

Leave a Reply

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