Employee 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
   [timestamp]
   ,[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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Employee Ledger Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Employee Ledger Entry].[Payment Method Code] = [Payment Method].[Code]

Show/hide columns in Employee Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Employee No_ Searchnvarchar(40)
4Posting Date Searchdatetime
5Document Type Searchint
6Document No_ Searchnvarchar(40)
7Description Searchnvarchar(200)
8Currency Code Searchnvarchar(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]
9Employee Posting Group Searchnvarchar(40)
10Global Dimension 1 Code Searchnvarchar(40)
11Global Dimension 2 Code Searchnvarchar(40)
12Salespers__Purch_ Code Searchnvarchar(40)
13User ID Searchnvarchar(100)
14Source Code Searchnvarchar(20)
15Applies-to Doc_ Type Searchint
16Applies-to Doc_ No_ Searchnvarchar(40)
17Open Searchtinyint
18Positive Searchtinyint
19Closed by Entry No_ Searchint
20Closed at Date Searchdatetime
21Closed by Amount Searchdecimal(38,38)
22Applies-to ID Searchnvarchar(100)
23Journal Templ_ Name Searchnvarchar(20)
24Journal Batch Name Searchnvarchar(20)
25Reason Code Searchnvarchar(20)
26Bal_ Account Type Searchint
27Bal_ Account No_ Searchnvarchar(40)
28Transaction No_ Searchint
29Closed by Amount (LCY) Searchdecimal(38,38)
30No_ Series Searchnvarchar(40)
31Amount to Apply Searchdecimal(38,38)
32Applying Entry Searchtinyint
33Reversed Searchtinyint
34Reversed by Entry No_ Searchint
35Reversed Entry No_ Searchint
36Creditor No_ Searchnvarchar(40)
37Payment Reference Searchnvarchar(100)
38Payment Method Code Searchnvarchar(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] AS [Payment Method]
              ON
                     [Employee Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
39Message to Recipient Searchnvarchar(280)
40Exported to Payment File Searchtinyint
41Dimension Set ID Searchint
42$systemId Searchuniqueidentifier
43$systemCreatedAt Searchdatetime
44$systemCreatedBy Searchuniqueidentifier
45$systemModifiedAt Searchdatetime
46$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Employee Ledger Entry table

Leave a Reply

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