Business Unit – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables BBusiness Unit

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

Table Type: Company

Table Name: Business Unit
Database Table Name: CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 220

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 Business Unit can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Consolidate]
   ,[Consolidation _]
   ,[Starting Date]
   ,[Ending Date]
   ,[Income Currency Factor]
   ,[Balance Currency Factor]
   ,[Exch_ Rate Losses Acc_]
   ,[Exch_ Rate Gains Acc_]
   ,[Residual Account]
   ,[Last Balance Currency Factor]
   ,[Name]
   ,[Company Name]
   ,[Currency Code]
   ,[Comp_ Exch_ Rate Gains Acc_]
   ,[Comp_ Exch_ Rate Losses Acc_]
   ,[Equity Exch_ Rate Gains Acc_]
   ,[Equity Exch_ Rate Losses Acc_]
   ,[Minority Exch_ Rate Gains Acc_]
   ,[Minority Exch_ Rate Losses Acc]
   ,[Currency Exchange Rate Table]
   ,[Data Source]
   ,[File Format]
   ,[Last Run]
   ,[Default Data Import Method]
   ,[BC API URL]
   ,[AAD Tenant ID]
   ,[External Company Id]
   ,[External Company Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Business Unit].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Business Unit].[Residual Account] = [G/L Account].[No_]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Business Unit].[Company Name] = [Company].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Business Unit].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Business Unit].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Business Unit].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Business Unit table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	20	Code	nvarchar(40)
2	Consolidate	Consolidate	Normal	Boolean	4	Consolidate	tinyint
3	Consolidation %	Consolidation %	Normal	Decimal	12	Consolidation _	decimal(38,38)
4	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
5	Ending Date	Ending Date	Normal	Date	4	Ending Date	datetime
	Key to join to the Inventory Period table. Show/hide example query SELECT [Business Unit].[Ending Date] ,[Inventory Period].[Ending Date] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period] ON [Business Unit].[Ending Date] = [Inventory Period].[Ending Date]
6	Income Currency Factor	Income Currency Factor	Normal	Decimal	12	Income Currency Factor	decimal(38,38)
7	Balance Currency Factor	Balance Currency Factor	Normal	Decimal	12	Balance Currency Factor	decimal(38,38)
8	Exch. Rate Losses Acc.	Exch. Rate Losses Acc.	Normal	Code	20	Exch_ Rate Losses Acc_	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Business Unit].[Exch_ Rate Losses Acc_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Business Unit].[Exch_ Rate Losses Acc_] = [G/L Account].[No_]
9	Exch. Rate Gains Acc.	Exch. Rate Gains Acc.	Normal	Code	20	Exch_ Rate Gains Acc_	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Business Unit].[Exch_ Rate Gains Acc_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Business Unit].[Exch_ Rate Gains Acc_] = [G/L Account].[No_]
10	Residual Account	Residual Account	Normal	Code	20	Residual Account	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Business Unit].[Residual Account] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Business Unit].[Residual Account] = [G/L Account].[No_]
11	Last Balance Currency Factor	Last Balance Currency Factor	Normal	Decimal	12	Last Balance Currency Factor	decimal(38,38)
12	Name	Name	Normal	Text	100	Name	nvarchar(200)
13	Company Name	Company Name	Normal	Text	30	Company Name	nvarchar(60)
	Key to join to the Company table. Show/hide example query SELECT [Business Unit].[Company Name] ,[Company].[Name] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [Company] AS [Company] ON [Business Unit].[Company Name] = [Company].[Name]
14	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Business Unit].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Business Unit].[Currency Code] = [Currency].[Code]
15	Comp. Exch. Rate Gains Acc.	Comp. Exch. Rate Gains Acc.	Normal	Code	20	Comp_ Exch_ Rate Gains Acc_	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Business Unit].[Comp_ Exch_ Rate Gains Acc_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Business Unit].[Comp_ Exch_ Rate Gains Acc_] = [G/L Account].[No_]
16	Comp. Exch. Rate Losses Acc.	Comp. Exch. Rate Losses Acc.	Normal	Code	20	Comp_ Exch_ Rate Losses Acc_	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Business Unit].[Comp_ Exch_ Rate Losses Acc_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Business Unit].[Comp_ Exch_ Rate Losses Acc_] = [G/L Account].[No_]
17	Equity Exch. Rate Gains Acc.	Equity Exch. Rate Gains Acc.	Normal	Code	20	Equity Exch_ Rate Gains Acc_	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Business Unit].[Equity Exch_ Rate Gains Acc_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Business Unit].[Equity Exch_ Rate Gains Acc_] = [G/L Account].[No_]
18	Equity Exch. Rate Losses Acc.	Equity Exch. Rate Losses Acc.	Normal	Code	20	Equity Exch_ Rate Losses Acc_	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Business Unit].[Equity Exch_ Rate Losses Acc_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Business Unit].[Equity Exch_ Rate Losses Acc_] = [G/L Account].[No_]
19	Minority Exch. Rate Gains Acc.	Minority Exch. Rate Gains Acc.	Normal	Code	20	Minority Exch_ Rate Gains Acc_	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Business Unit].[Minority Exch_ Rate Gains Acc_] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Business Unit].[Minority Exch_ Rate Gains Acc_] = [G/L Account].[No_]
20	Minority Exch. Rate Losses Acc	Minority Exch. Rate Losses Acc	Normal	Code	20	Minority Exch_ Rate Losses Acc	nvarchar(40)
	Key to join to the G/L Account table. Show/hide example query SELECT [Business Unit].[Minority Exch_ Rate Losses Acc] ,[G/L Account].[No_] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account] ON [Business Unit].[Minority Exch_ Rate Losses Acc] = [G/L Account].[No_]
21	Currency Exchange Rate Table	Currency Exchange Rate Table	Normal	Option	4	Currency Exchange Rate Table	int
	Available options are: “Local” “Business Unit”
22	Data Source	Data Source	Normal	Option	4	Data Source	int
	Available options are: “Local Curr. (LCY)” “Add. Rep. Curr. (ACY)”
23	File Format	File Format	Normal	Option	4	File Format	int
	Available options are: “Version 4.00 or Later (.xml)” “Version 3.70 or Earlier (.txt)”
24	Last Run	Last Run	Normal	Date	4	Last Run	datetime
25	Default Data Import Method	Default Data Import Method	Normal	Option	4	Default Data Import Method	int
	Available options are: “Database” “API”
26	BC API URL	BC API URL	Normal	Text	2048	BC API URL	nvarchar(4096)
27	AAD Tenant ID	Microsoft Entra tenant ID	Normal	GUID	16	AAD Tenant ID	uniqueidentifier
28	External Company Id	External Company Id	Normal	GUID	16	External Company Id	uniqueidentifier
29	External Company Name	External Company Name	Normal	Text	1024	External Company Name	nvarchar(2048)
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 query SELECT [Business Unit].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit] LEFT JOIN [User] AS [User] ON [Business Unit].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Business Unit table

Dynamics 365 BC Table Reference Tables Company Tables BBusiness Unit

Leave a Reply Cancel reply