Onboarding Signal – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables OOnboarding Signal

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

Table Type: System

Table Name: Onboarding Signal
Database Table Name:

Table Number: 5490

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

Show/hide columns in Onboarding Signal table

Field No.	Field Name	Field Caption	Class	Type	Length
1	No.	Used as primary key	Normal	Integer	4
2	Company Name	Company Name	Normal	Text	30
	Key to join to the Company table. Show/hide example query SELECT [Onboarding Signal].[] ,[Company].[Name] FROM [] AS [Onboarding Signal] LEFT JOIN [Company] AS [Company] ON [Onboarding Signal].[] = [Company].[Name]
3	Onboarding Completed	Onboarding Completed	Normal	Boolean	4
4	Onboarding Signal Type	Onboarding Signal Type	Normal	Option	4
5	Onboarding Start Date	Onboarding Start Date	Normal	Date	4
6	Onboarding Complete Date	Onboarding Complete Date	Normal	Date	4
7	Extension ID	Extension ID	Normal	GUID	16
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 [Onboarding Signal].[] ,[User].[User Security ID] FROM [] AS [Onboarding Signal] LEFT JOIN [User] AS [User] ON [Onboarding Signal].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16