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
   [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]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Currency Exchange Rate].[Relational Currency Code] = [Currency].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Currency Exchange Rate].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Currency Exchange Rate].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Currency Exchange Rate table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Currency Code Primary Key SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
2Starting Date Primary Key SearchStarting DateNormalDate4Starting Datedatetime
3Exchange Rate Amount SearchExchange Rate AmountNormalDecimal12Exchange Rate Amountdecimal(38,38)
4Adjustment Exch. Rate Amount SearchAdjustment Exch. Rate AmountNormalDecimal12Adjustment Exch_ Rate Amountdecimal(38,38)
5Relational Currency Code SearchRelational Currency CodeNormalCode10Relational Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Currency Exchange Rate].[Relational 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].[Relational Currency Code] = [Currency].[Code]
6Relational Exch. Rate Amount SearchRelational Exch. Rate AmountNormalDecimal12Relational Exch_ Rate Amountdecimal(38,38)
7Fix Exchange Rate Amount SearchFix Exchange Rate AmountNormalOption4Fix Exchange Rate Amountint
Available options are:
  • “Currency”
  • “Relational Currency”
  • “Both”
8Relational Adjmt Exch Rate Amt SearchRelational Adjmt Exch Rate AmtNormalDecimal12Relational Adjmt Exch Rate Amtdecimal(38,38)
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
       [Currency Exchange Rate].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Currency Exchange Rate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency Exchange Rate]
LEFT JOIN
       [User] AS [User]
              ON
                     [Currency Exchange Rate].[$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
       [Currency Exchange Rate].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Currency Exchange Rate$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency Exchange Rate]
LEFT JOIN
       [User] AS [User]
              ON
                     [Currency Exchange Rate].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Currency Exchange Rate table

Leave a Reply

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