Data Migration Setup

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

Table Type: Company

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

Table Number: 1806

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 Data Migration Setup can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Primary Key]
   ,[Default Customer Template]
   ,[Default Vendor Template]
   ,[Default Item Template]
   ,[Default Account Template]
   ,[Default Posting Group Template]
   ,[Default Cust_ Posting Template]
   ,[Default Vend_ Posting Template]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Data Migration Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Migration Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Migration Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Migration Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Migration Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Data Migration Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Default Customer Template SearchDefault Customer TemplateNormalCode10Default Customer Templatenvarchar(20)
3Default Vendor Template SearchDefault Vendor TemplateNormalCode10Default Vendor Templatenvarchar(20)
4Default Item Template SearchDefault Item TemplateNormalCode10Default Item Templatenvarchar(20)
5Default Account Template SearchDefault Account TemplateNormalCode10Default Account Templatenvarchar(20)
6Default Posting Group Template SearchDefault Posting Group TemplateNormalCode10Default Posting Group Templatenvarchar(20)
7Default Cust. Posting Template SearchDefault Cust. Posting TemplateNormalCode10Default Cust_ Posting Templatenvarchar(20)
8Default Vend. Posting Template SearchDefault Vend. Posting TemplateNormalCode10Default Vend_ Posting Templatenvarchar(20)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Data Migration Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Data Migration Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Migration Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Data Migration Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Data Migration Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Data Migration Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Migration Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Data Migration Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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