Exch_ Rate Adjmt_ Ledg_ Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables EExch_ Rate Adjmt_ Ledg_ Entry

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

Table Type: Company

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

Table Number: 186

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_ Ledg_ Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Register No_]
   ,[Entry No_]
   ,[Account No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Due Date]
   ,[Account Type]
   ,[Account Name]
   ,[Currency Code]
   ,[Currency Factor]
   ,[Base Amount]
   ,[Base Amount (LCY)]
   ,[Adjustment Amount]
   ,[Detailed Ledger Entry Type]
   ,[Detailed Ledger Entry No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Ledg_ Entry$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_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Exch_ Rate Adjmt_ Ledg_ Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Exch_ Rate Adjmt_ Ledg_ Entry].[Currency Code] = [Currency].[Code]

Show/hide columns in Exch_ Rate Adjmt_ Ledg_ Entry table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Register No_	int
3	Entry No_	int
4	Account No_	nvarchar(40)
5	Posting Date	datetime
6	Document Type	int
7	Document No_	nvarchar(40)
8	Due Date	datetime
9	Account Type	int
10	Account Name	nvarchar(200)
11	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Exch_ Rate Adjmt_ Ledg_ Entry].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Exch_ Rate Adjmt_ Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Exch_ Rate Adjmt_ Ledg_ Entry] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Exch_ Rate Adjmt_ Ledg_ Entry].[Currency Code] = [Currency].[Code]
12	Currency Factor	decimal(38,38)
13	Base Amount	decimal(38,38)
14	Base Amount (LCY)	decimal(38,38)
15	Adjustment Amount	decimal(38,38)
16	Detailed Ledger Entry Type	int
17	Detailed Ledger Entry No_	decimal(38,38)
18	$systemId	uniqueidentifier
19	$systemCreatedAt	datetime
20	$systemCreatedBy	uniqueidentifier
21	$systemModifiedAt	datetime
22	$systemModifiedBy	uniqueidentifier