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
   [timestamp]
   ,[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
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Business Unit Information].[Currency Code] = [Currency].[Code]

Show/hide columns in Business Unit Information table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Name Searchnvarchar(60)
4Company Name Searchnvarchar(60)
5Currency Code Searchnvarchar(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]
6Currency Exchange Rate Table Searchint
7Starting Date Searchdatetime
8Ending Date Searchdatetime
9Exch_ Rate Gains Acc_ Searchnvarchar(40)
10Exch_ Rate Losses Acc_ Searchnvarchar(40)
11Residual Account Searchnvarchar(40)
12Comp_ Exch_ Rate Gains Acc_ Searchnvarchar(40)
13Comp_ Exch_ Rate Losses Acc_ Searchnvarchar(40)
14Equity Exch_ Rate Gains Acc_ Searchnvarchar(40)
15Equity Exch_ Rate Losses Acc_ Searchnvarchar(40)
16Minority Exch_ Rate Gains Acc_ Searchnvarchar(40)
17Minority Exch_ Rate Losses Acc Searchnvarchar(40)
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Business Unit Information table

Leave a Reply

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