Business Unit

Dynamics 365 BC Table ReferenceTablesCompany TablesBBusiness 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode20Codenvarchar(40)
2Consolidate Primary Key SearchConsolidateNormalBoolean4Consolidatetinyint
3Consolidation % SearchConsolidation %NormalDecimal12Consolidation _decimal(38,38)
4Starting Date SearchStarting DateNormalDate4Starting Datedatetime
5Ending Date SearchEnding DateNormalDate4Ending Datedatetime
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]
6Income Currency Factor SearchIncome Currency FactorNormalDecimal12Income Currency Factordecimal(38,38)
7Balance Currency Factor SearchBalance Currency FactorNormalDecimal12Balance Currency Factordecimal(38,38)
8Exch. Rate Losses Acc. SearchExch. Rate Losses Acc.NormalCode20Exch_ 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_]
9Exch. Rate Gains Acc. SearchExch. Rate Gains Acc.NormalCode20Exch_ 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_]
10Residual Account SearchResidual AccountNormalCode20Residual Accountnvarchar(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_]
11Last Balance Currency Factor SearchLast Balance Currency FactorNormalDecimal12Last Balance Currency Factordecimal(38,38)
12Name SearchNameNormalText100Namenvarchar(200)
13Company Name SearchCompany NameNormalText30Company Namenvarchar(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]
14Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
15Comp. Exch. Rate Gains Acc. SearchComp. Exch. Rate Gains Acc.NormalCode20Comp_ 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_]
16Comp. Exch. Rate Losses Acc. SearchComp. Exch. Rate Losses Acc.NormalCode20Comp_ 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_]
17Equity Exch. Rate Gains Acc. SearchEquity Exch. Rate Gains Acc.NormalCode20Equity 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_]
18Equity Exch. Rate Losses Acc. SearchEquity Exch. Rate Losses Acc.NormalCode20Equity 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_]
19Minority Exch. Rate Gains Acc. SearchMinority Exch. Rate Gains Acc.NormalCode20Minority 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_]
20Minority Exch. Rate Losses Acc SearchMinority Exch. Rate Losses AccNormalCode20Minority Exch_ Rate Losses Accnvarchar(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_]
21Currency Exchange Rate Table SearchCurrency Exchange Rate TableNormalOption4Currency Exchange Rate Tableint
Available options are:
  • “Local”
  • “Business Unit”
22Data Source SearchData SourceNormalOption4Data Sourceint
Available options are:
  • “Local Curr. (LCY)”
  • “Add. Rep. Curr. (ACY)”
23File Format SearchFile FormatNormalOption4File Formatint
Available options are:
  • “Version 4.00 or Later (.xml)”
  • “Version 3.70 or Earlier (.txt)”
24Last Run SearchLast RunNormalDate4Last Rundatetime
25Default Data Import Method SearchDefault Data Import MethodNormalOption4Default Data Import Methodint
Available options are:
  • “Database”
  • “API”
26BC API URL SearchBC API URLNormalText2048BC API URLnvarchar(4096)
27AAD Tenant ID SearchMicrosoft Entra tenant IDNormalGUID16AAD Tenant IDuniqueidentifier
28External Company Id SearchExternal Company IdNormalGUID16External Company Iduniqueidentifier
29External Company Name SearchExternal Company NameNormalText1024External Company Namenvarchar(2048)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Business Unit table

Currency
Dynamics 365 BC Table ReferenceTablesCompany TablesBBusiness Unit

Leave a Reply

Your email address will not be published. Required fields are marked *