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

Show/hide columns in Business Unit table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Consolidate Searchtinyint
4Consolidation _ Searchdecimal(38,38)
5Starting Date Searchdatetime
6Ending Date Searchdatetime
7Income Currency Factor Searchdecimal(38,38)
8Balance Currency Factor Searchdecimal(38,38)
9Exch_ Rate Losses Acc_ Searchnvarchar(40)
10Exch_ Rate Gains Acc_ Searchnvarchar(40)
11Residual Account Searchnvarchar(40)
12Last Balance Currency Factor Searchdecimal(38,38)
13Name Searchnvarchar(200)
14Company Name Searchnvarchar(60)
15Currency Code Searchnvarchar(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]
16Comp_ Exch_ Rate Gains Acc_ Searchnvarchar(40)
17Comp_ Exch_ Rate Losses Acc_ Searchnvarchar(40)
18Equity Exch_ Rate Gains Acc_ Searchnvarchar(40)
19Equity Exch_ Rate Losses Acc_ Searchnvarchar(40)
20Minority Exch_ Rate Gains Acc_ Searchnvarchar(40)
21Minority Exch_ Rate Losses Acc Searchnvarchar(40)
22Currency Exchange Rate Table Searchint
23Data Source Searchint
24File Format Searchint
25Last Run Searchdatetime
26$systemId Searchuniqueidentifier
27$systemCreatedAt Searchdatetime
28$systemCreatedBy Searchuniqueidentifier
29$systemModifiedAt Searchdatetime
30$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Business Unit table

Leave a Reply

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