Detailed Employee Ledger Entry

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

Table Type: Company

Table Name: Detailed Employee Ledger Entry
Database Table Name: CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5223

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 Detailed Employee Ledger Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Employee Ledger Entry No_]
   ,[Entry Type]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Amount]
   ,[Amount (LCY)]
   ,[Employee No_]
   ,[Currency Code]
   ,[User ID]
   ,[Source Code]
   ,[Transaction No_]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Debit Amount (LCY)]
   ,[Credit Amount (LCY)]
   ,[Initial Entry Global Dim_ 1]
   ,[Initial Entry Global Dim_ 2]
   ,[Initial Document Type]
   ,[Applied Empl_ Ledger Entry No_]
   ,[Unapplied]
   ,[Unapplied by Entry No_]
   ,[Application No_]
   ,[Ledger Entry Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Detailed Employee Ledger 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_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Employee Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Detailed Employee Ledger Entry].[Currency Code] = [Currency].[Code]

Show/hide columns in Detailed Employee Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Employee Ledger Entry No_ Searchint
4Entry Type Searchint
5Posting Date Searchdatetime
6Document Type Searchint
7Document No_ Searchnvarchar(40)
8Amount Searchdecimal(38,38)
9Amount (LCY) Searchdecimal(38,38)
10Employee No_ Searchnvarchar(40)
11Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Detailed Employee Ledger Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Detailed Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Detailed Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Detailed Employee Ledger Entry].[Currency Code] = [Currency].[Code]
12User ID Searchnvarchar(100)
13Source Code Searchnvarchar(20)
14Transaction No_ Searchint
15Journal Batch Name Searchnvarchar(20)
16Reason Code Searchnvarchar(20)
17Debit Amount Searchdecimal(38,38)
18Credit Amount Searchdecimal(38,38)
19Debit Amount (LCY) Searchdecimal(38,38)
20Credit Amount (LCY) Searchdecimal(38,38)
21Initial Entry Global Dim_ 1 Searchnvarchar(40)
22Initial Entry Global Dim_ 2 Searchnvarchar(40)
23Initial Document Type Searchint
24Applied Empl_ Ledger Entry No_ Searchint
25Unapplied Searchtinyint
26Unapplied by Entry No_ Searchint
27Application No_ Searchint
28Ledger Entry Amount Searchtinyint
29$systemId Searchuniqueidentifier
30$systemCreatedAt Searchdatetime
31$systemCreatedBy Searchuniqueidentifier
32$systemModifiedAt Searchdatetime
33$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Detailed Employee Ledger Entry table

Leave a Reply

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