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

Show/hide columns in Exch. Rate Adjmt. Reg. table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalInteger4No_int
2Creation Date Primary Key SearchCreation DateNormalDate4Creation Datedatetime
3Account Type SearchAccount TypeNormalOption4Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
4Posting Group SearchPosting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
	       [Exch. Rate Adjmt. Reg.].[Posting Group]
	       ,[Customer Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Reg_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Exch. Rate Adjmt. Reg.]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
	              ON
	                     [Exch. Rate Adjmt. Reg.].[Posting Group] = [Customer Posting Group].[Code]
5Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
6Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
7Adjusted Base SearchAdjusted BaseNormalDecimal12Adjusted Basedecimal(38,38)
8Adjusted Base (LCY) SearchAdjusted Base ($)NormalDecimal12Adjusted Base (LCY)decimal(38,38)
9Adjusted Amt. (LCY) SearchAdjusted Amt. ($)NormalDecimal12Adjusted Amt_ (LCY)decimal(38,38)
10Adjusted Base (Add.-Curr.) SearchAdjusted Base (Add.-Curr.)NormalDecimal12Adjusted Base (Add_-Curr_)decimal(38,38)
11Adjusted Amt. (Add.-Curr.) SearchAdjusted Amt. (Add.-Curr.)NormalDecimal12Adjusted Amt_ (Add_-Curr_)decimal(38,38)
14Journal Template Name SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
15Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
21Adjusted Customers SearchNo. of Adj. Cust. Ledger EntriesFlowFieldInteger4
22Adjusted Vendors SearchNo. of Adj. Vend. Ledger EntriesFlowFieldInteger4
23Adjustment Amount SearchAdjustment AmountFlowFieldDecimal12
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
	       [Exch. Rate Adjmt. Reg.].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Reg_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Exch. Rate Adjmt. Reg.]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Exch. Rate Adjmt. Reg.].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Exch. Rate Adjmt. Reg. table

Leave a Reply

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