Union

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

Table Type: Company

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

Table Number: 5209

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Name]
   ,[Address]
   ,[Post Code]
   ,[City]
   ,[Phone No_]
   ,[Name 2]
   ,[Address 2]
   ,[County]
   ,[Fax No_]
   ,[E-Mail]
   ,[Home Page]
   ,[Country_Region Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Union$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Union table

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

Show/hide example query

SELECT
       [Union].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Union$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Union]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Union].[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 Union table

Leave a Reply

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