Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/4008
Table Type: System
Table Name: Post Migration Checklist
Database Table Name:
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 Post Migration Checklist can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[]Show/hide an example select of all columns by name
SELECT
FROM
[]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[] AS [Post Migration Checklist]
LEFT JOIN
[Company] AS [Company]
ON
[Post Migration Checklist].[Company Name] = [Company].[Name]
LEFT JOIN
[User] AS [User]
ON
[Post Migration Checklist].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Post Migration Checklist].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Post Migration Checklist table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Company Name   | Company Name | Normal | Text | 250 | ||
| 2 | Help | Help | Normal | Boolean | 4 | ||
| 3 | Users Setup | Users Setup | Normal | Boolean | 4 | ||
| 4 | Disable Intelligent Cloud | Disable Intelligent Cloud | Normal | Boolean | 4 | ||
| 5 | D365 Sales | D365 Sales | Normal | Boolean | 4 | ||
| 6 | Define User Mappings | Define User Mappings | Normal | Boolean | 4 | ||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | ||
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | ||
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | ||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | ||
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 |