Exch_ 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Register No_ Primary Key Searchint
3Entry No_ Primary Key Searchint
4Account No_ Searchnvarchar(40)
5Posting Date Searchdatetime
6Document Type Searchint
7Document No_ Searchnvarchar(40)
8Due Date Searchdatetime
9Account Type Searchint
10Account Name Searchnvarchar(200)
11Currency Code Searchnvarchar(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]
12Currency Factor Searchdecimal(38,38)
13Base Amount Searchdecimal(38,38)
14Base Amount (LCY) Searchdecimal(38,38)
15Adjustment Amount Searchdecimal(38,38)
16Detailed Ledger Entry Type Searchint
17Detailed Ledger Entry No_ Searchdecimal(38,38)
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Exch_ Rate Adjmt_ Ledg_ Entry table

Leave a Reply

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