Business Unit Information

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

Table Type: Company

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

Table Number: 1828

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[Name]
   ,[Company Name]
   ,[Currency Code]
   ,[Currency Exchange Rate Table]
   ,[Starting Date]
   ,[Ending Date]
   ,[Exch_ Rate Gains Acc_]
   ,[Exch_ Rate Losses Acc_]
   ,[Residual Account]
   ,[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]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Business Unit Information$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 Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Business Unit Information].[Company Name] = [Company].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Business Unit Information].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Business Unit Information].[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 Information].[Residual Account] = [G/L Account].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Business Unit Information].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Business Unit Information].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Business Unit Information table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Name SearchNameNormalText30Namenvarchar(60)
3Company Name SearchCompany NameNormalText30Company Namenvarchar(60)
Key to join to the Company table.

Show/hide example query

SELECT
       [Business Unit Information].[Company Name]
       ,[Company].[Name]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [Company] AS [Company]
              ON
                     [Business Unit Information].[Company Name] = [Company].[Name]
4Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Business Unit Information].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Business Unit Information].[Currency Code] = [Currency].[Code]
5Currency Exchange Rate Table SearchCurrency Exchange Rate TableNormalOption4Currency Exchange Rate Tableint
Available options are:
  • “Local”
  • “Business Unit”
6Starting Date SearchStarting DateNormalDate4Starting Datedatetime
7Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [Business Unit Information].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Business Unit Information].[Ending Date] = [Inventory Period].[Ending Date]
8Exch. 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 Information].[Exch_ Rate Gains Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Business Unit Information].[Exch_ Rate Gains Acc_] = [G/L Account].[No_]
9Exch. 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 Information].[Exch_ Rate Losses Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Business Unit Information].[Exch_ Rate Losses 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 Information].[Residual Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Business Unit Information].[Residual Account] = [G/L Account].[No_]
11Comp. 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 Information].[Comp_ Exch_ Rate Gains Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Business Unit Information].[Comp_ Exch_ Rate Gains Acc_] = [G/L Account].[No_]
12Comp. 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 Information].[Comp_ Exch_ Rate Losses Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Business Unit Information].[Comp_ Exch_ Rate Losses Acc_] = [G/L Account].[No_]
13Equity 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 Information].[Equity Exch_ Rate Gains Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Business Unit Information].[Equity Exch_ Rate Gains Acc_] = [G/L Account].[No_]
14Equity 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 Information].[Equity Exch_ Rate Losses Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Business Unit Information].[Equity Exch_ Rate Losses Acc_] = [G/L Account].[No_]
15Minority 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 Information].[Minority Exch_ Rate Gains Acc_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Business Unit Information].[Minority Exch_ Rate Gains Acc_] = [G/L Account].[No_]
16Minority 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 Information].[Minority Exch_ Rate Losses Acc]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Business Unit Information].[Minority Exch_ Rate Losses Acc] = [G/L Account].[No_]
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 Information].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [User] AS [User]
              ON
                     [Business Unit Information].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Business Unit Information].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Business Unit Information$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit Information]
LEFT JOIN
       [User] AS [User]
              ON
                     [Business Unit Information].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Business Unit Information table

Leave a Reply

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