Employee Ledger Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesEEmployee Ledger Entry

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

Table Type: Company

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

Table Number: 5222

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Employee No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Currency Code]
   ,[Employee Posting Group]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Salespers__Purch_ Code]
   ,[User ID]
   ,[Source Code]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Open]
   ,[Positive]
   ,[Closed by Entry No_]
   ,[Closed at Date]
   ,[Closed by Amount]
   ,[Applies-to ID]
   ,[Journal Templ_ Name]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[Transaction No_]
   ,[Closed by Amount (LCY)]
   ,[No_ Series]
   ,[Amount to Apply]
   ,[Applying Entry]
   ,[Reversed]
   ,[Reversed by Entry No_]
   ,[Reversed Entry No_]
   ,[Creditor No_]
   ,[Payment Reference]
   ,[Payment Method Code]
   ,[Message to Recipient]
   ,[Exported to Payment File]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$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_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Employee Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Employee Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Employee Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Employee Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Employee Ledger Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Employee Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Posting Group]
      ON
         [Employee Ledger Entry].[Employee Posting Group] = [Employee Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Employee Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Employee Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Employee Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Employee Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Employee Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Employee Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Employee Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Employee Ledger Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
3Employee No. SearchEmployee No.NormalCode20Employee No_nvarchar(40)
Key to join to the Employee table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[Employee No_]
       ,[Employee].[No_]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
              ON
                     [Employee Ledger Entry].[Employee No_] = [Employee].[No_]
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
6Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
11Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Employee Ledger Entry].[Currency Code] = [Currency].[Code]
13Amount SearchAmountFlowFieldDecimal12
14Remaining Amount SearchRemaining AmountFlowFieldDecimal12
15Original Amt. (LCY) SearchOriginal Amt. ($)FlowFieldDecimal12
16Remaining Amt. (LCY) SearchRemaining Amt. ($)FlowFieldDecimal12
17Amount (LCY) SearchAmount ($)FlowFieldDecimal12
22Employee Posting Group SearchEmployee Posting GroupNormalCode20Employee Posting Groupnvarchar(40)
Key to join to the Employee Posting Group table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[Employee Posting Group]
       ,[Employee Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Employee Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Posting Group]
              ON
                     [Employee Ledger Entry].[Employee Posting Group] = [Employee Posting Group].[Code]
23Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Employee Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
24Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Employee Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
25Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[Salespers__Purch_ Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Employee Ledger Entry].[Salespers__Purch_ Code] = [Salesperson/Purchaser].[Code]
27User ID SearchUser IDNormalCode50User IDnvarchar(100)
28Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Employee Ledger Entry].[Source Code] = [Source Code].[Code]
34Applies-to Doc. Type SearchApplies-to Doc. TypeNormalOption4Applies-to Doc_ Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
35Applies-to Doc. No. SearchApplies-to Doc. No.NormalCode20Applies-to Doc_ No_nvarchar(40)
36Open SearchOpenNormalBoolean4Opentinyint
43Positive SearchPositiveNormalBoolean4Positivetinyint
44Closed by Entry No. SearchClosed by Entry No.NormalInteger4Closed by Entry No_int
45Closed at Date SearchClosed at DateNormalDate4Closed at Datedatetime
46Closed by Amount SearchClosed by AmountNormalDecimal12Closed by Amountdecimal(38,38)
47Applies-to ID SearchApplies-to IDNormalCode50Applies-to IDnvarchar(100)
48Journal Templ. Name SearchJournal Template NameNormalCode10Journal Templ_ Namenvarchar(20)
49Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
50Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Employee Ledger Entry].[Reason Code] = [Reason Code].[Code]
51Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
52Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
53Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
54Closed by Amount (LCY) SearchClosed by Amount ($)NormalDecimal12Closed by Amount (LCY)decimal(38,38)
58Debit Amount SearchDebit AmountFlowFieldDecimal12
59Credit Amount SearchCredit AmountFlowFieldDecimal12
60Debit Amount (LCY) SearchDebit Amount ($)FlowFieldDecimal12
61Credit Amount (LCY) SearchCredit Amount ($)FlowFieldDecimal12
64No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Employee Ledger Entry].[No_ Series] = [No. Series].[Code]
75Original Amount SearchOriginal AmountFlowFieldDecimal12
76Date Filter SearchDate FilterFlowFilterDate4
84Amount to Apply SearchAmount to ApplyNormalDecimal12Amount to Applydecimal(38,38)
86Applying Entry SearchApplying EntryNormalBoolean4Applying Entrytinyint
87Reversed SearchReversedNormalBoolean4Reversedtinyint
88Reversed by Entry No. SearchReversed by Entry No.NormalInteger4Reversed by Entry No_int
89Reversed Entry No. SearchReversed Entry No.NormalInteger4Reversed Entry No_int
170Creditor No. SearchCreditor No.NormalCode20Creditor No_nvarchar(40)
171Payment Reference SearchPayment ReferenceNormalCode50Payment Referencenvarchar(100)
172Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Employee Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
289Message to Recipient SearchMessage to RecipientNormalText140Message to Recipientnvarchar(280)
290Exported to Payment File SearchExported to Payment FileNormalBoolean4Exported to Payment Filetinyint
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Employee Ledger Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Employee Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
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
       [Employee Ledger Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Employee Ledger Entry].[$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
       [Employee Ledger Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Employee Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Employee Ledger Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Employee Ledger Entry table

CurrencyPayment MethodSales HeaderSales Header Archive
Dynamics 365 BC Table ReferenceTablesCompany TablesEEmployee Ledger Entry

Leave a Reply

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