Contact Alt_ Addr_ Date Range

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

Table Type: Company

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

Table Number: 5052

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_ Addr_ Date Range can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Contact Alt_ Addr_ Date Range$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Contact No_]
   ,[Starting Date]
   ,[Contact Alt_ Address Code]
   ,[Ending Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Contact Alt_ Addr_ Date Range$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Contact Alt_ Addr_ Date Range table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Contact No_ Primary Key Searchnvarchar(40)
3Starting Date Primary Key Searchdatetime
4Contact Alt_ Address Code Searchnvarchar(20)
5Ending Date Searchdatetime
6$systemId Searchuniqueidentifier
7$systemCreatedAt Searchdatetime
8$systemCreatedBy Searchuniqueidentifier
9$systemModifiedAt Searchdatetime
10$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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