Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1831
Table Type: Company
Table Name: Bus. Unit In Cons. Process
Database Table Name: CRONUS UK Ltd_$Bus_ Unit In Cons_ Process$437dbf0e-84ff-417a-965d-ed2bb9650972
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 Bus. Unit In Cons. Process can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Bus_ Unit In Cons_ Process$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Consolidation Process Id]
,[Business Unit Code]
,[Status]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Bus_ Unit In Cons_ Process$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Bus_ Unit In Cons_ Process$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bus. Unit In Cons. Process]
LEFT JOIN
[CRONUS UK Ltd_$Consolidation Process$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Consolidation Process]
ON
[Bus. Unit In Cons. Process].[Consolidation Process Id] = [Consolidation Process].[Id]
LEFT JOIN
[CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
ON
[Bus. Unit In Cons. Process].[Business Unit Code] = [Business Unit].[Code]
LEFT JOIN
[User] AS [User]
ON
[Bus. Unit In Cons. Process].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Bus. Unit In Cons. Process].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Bus. Unit In Cons. Process table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Consolidation Process Id   | Consolidation Process Id | Normal | Integer | 4 | Consolidation Process Id | int |
Key to join to the Consolidation Process table.Show/hide example querySELECT
[Bus. Unit In Cons. Process].[Consolidation Process Id]
,[Consolidation Process].[Id]
FROM
[CRONUS UK Ltd_$Bus_ Unit In Cons_ Process$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bus. Unit In Cons. Process]
LEFT JOIN
[CRONUS UK Ltd_$Consolidation Process$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Consolidation Process]
ON
[Bus. Unit In Cons. Process].[Consolidation Process Id] = [Consolidation Process].[Id] | |||||||
| 2 | Business Unit Code | Business Unit Code | Normal | Code | 20 | Business Unit Code | nvarchar(40) |
Key to join to the Business Unit table.Show/hide example querySELECT
[Bus. Unit In Cons. Process].[Business Unit Code]
,[Business Unit].[Code]
FROM
[CRONUS UK Ltd_$Bus_ Unit In Cons_ Process$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bus. Unit In Cons. Process]
LEFT JOIN
[CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
ON
[Bus. Unit In Cons. Process].[Business Unit Code] = [Business Unit].[Code] | |||||||
| 3 | Default Data Import Method | Default Data Import Method | FlowField | Option | 4 | ||
| 4 | Status | Status | Normal | Option | 4 | Status | int |
Available options are:
| |||||||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Bus. Unit In Cons. Process].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Bus_ Unit In Cons_ Process$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bus. Unit In Cons. Process]
LEFT JOIN
[User] AS [User]
ON
[Bus. Unit In Cons. Process].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Bus. Unit In Cons. Process].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Bus_ Unit In Cons_ Process$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bus. Unit In Cons. Process]
LEFT JOIN
[User] AS [User]
ON
[Bus. Unit In Cons. Process].[$systemModifiedBy] = [User].[User Security ID] | |||||||