Assisted Company Setup Status – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables AAssisted Company Setup Status

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

Table Type: System

Table Name: Assisted Company Setup Status
Database Table Name:

Table Number: 1802

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 Assisted Company Setup Status 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 [Assisted Company Setup Status]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Assisted Company Setup Status].[Company Name] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Assisted Company Setup Status].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Assisted Company Setup Status].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Assisted Company Setup Status table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Company Name	Company Name	Normal	Text	30
	Key to join to the Company table. Show/hide example query SELECT [Assisted Company Setup Status].[] ,[Company].[Name] FROM [] AS [Assisted Company Setup Status] LEFT JOIN [Company] AS [Company] ON [Assisted Company Setup Status].[] = [Company].[Name]
2	Enabled	Enabled	Normal	Boolean	4
3	Package Imported	Package Imported	Normal	Boolean	4
4	Import Failed	Import Failed	Normal	Boolean	4
5	Company Setup Session ID	Company Setup Session ID	Normal	Integer	4
6	Task ID	Task ID	Normal	GUID	16
7	Server Instance ID	Server Instance ID	Normal	Integer	4
	Key to join to the Server Instance table. Show/hide example query SELECT [Assisted Company Setup Status].[] ,[Server Instance].[Server Instance ID] FROM [] AS [Assisted Company Setup Status] LEFT JOIN [] AS [Server Instance] ON [Assisted Company Setup Status].[] = [Server Instance].[Server Instance ID]
4760	InstallAdditionalDemoData	InstallAdditionalDemoData	Normal	Boolean	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [Assisted Company Setup Status].[] ,[User].[User Security ID] FROM [] AS [Assisted Company Setup Status] LEFT JOIN [User] AS [User] ON [Assisted Company Setup Status].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16