Currency Exchange Rate

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

Table Type: Company

Table Name: Currency Exchange Rate
Database Table Name: CRONUS UK Ltd_$Currency Exchange Rate$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 330

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 Currency Exchange Rate can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Currency Code]
   ,[Starting Date]
   ,[Exchange Rate Amount]
   ,[Adjustment Exch_ Rate Amount]
   ,[Relational Currency Code]
   ,[Relational Exch_ Rate Amount]
   ,[Fix Exchange Rate Amount]
   ,[Relational Adjmt Exch Rate Amt]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Currency Exchange Rate$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Currency Exchange Rate table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Currency Code Primary Key Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Currency Exchange Rate].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Currency Exchange Rate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency Exchange Rate]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Currency Exchange Rate].[Currency Code] = [Currency].[Code]
3Starting Date Primary Key Searchdatetime
4Exchange Rate Amount Searchdecimal(38,38)
5Adjustment Exch_ Rate Amount Searchdecimal(38,38)
6Relational Currency Code Searchnvarchar(20)
7Relational Exch_ Rate Amount Searchdecimal(38,38)
8Fix Exchange Rate Amount Searchint
9Relational Adjmt Exch Rate Amt Searchdecimal(38,38)
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Currency Exchange Rate table

Leave a Reply

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