Exch_ Rate Adjmt_ Reg_

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

Table Type: Company

Table Name: Exch_ Rate Adjmt_ Reg_
Database Table Name: CRONUS UK Ltd_$Exch_ Rate Adjmt_ Reg_$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 86

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 Exch_ Rate Adjmt_ Reg_ can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Reg_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Creation Date]
   ,[Account Type]
   ,[Posting Group]
   ,[Currency Code]
   ,[Currency Factor]
   ,[Adjusted Base]
   ,[Adjusted Base (LCY)]
   ,[Adjusted Amt_ (LCY)]
   ,[Adjusted Base (Add_-Curr_)]
   ,[Adjusted Amt_ (Add_-Curr_)]
   ,[Journal Template Name]
   ,[Journal Batch Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Reg_$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Reg_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Exch_ Rate Adjmt_ Reg_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Exch_ Rate Adjmt_ Reg_].[Currency Code] = [Currency].[Code]

Show/hide columns in Exch_ Rate Adjmt_ Reg_ table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchint
3Creation Date Searchdatetime
4Account Type Searchint
5Posting Group Searchnvarchar(40)
6Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Exch_ Rate Adjmt_ Reg_].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Reg_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Exch_ Rate Adjmt_ Reg_]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Exch_ Rate Adjmt_ Reg_].[Currency Code] = [Currency].[Code]
7Currency Factor Searchdecimal(38,38)
8Adjusted Base Searchdecimal(38,38)
9Adjusted Base (LCY) Searchdecimal(38,38)
10Adjusted Amt_ (LCY) Searchdecimal(38,38)
11Adjusted Base (Add_-Curr_) Searchdecimal(38,38)
12Adjusted Amt_ (Add_-Curr_) Searchdecimal(38,38)
13Journal Template Name Searchnvarchar(20)
14Journal Batch Name Searchnvarchar(20)
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Exch_ Rate Adjmt_ Reg_ table

Leave a Reply

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