Employee Ledger Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables EEmployee 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 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_$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_$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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
3	Employee No.	Employee No.	Normal	Code	20	Employee 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_]
4	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
5	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
6	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
7	Description	Description	Normal	Text	100	Description	nvarchar(200)
11	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
13	Amount	Amount	FlowField	Decimal	12
14	Remaining Amount	Remaining Amount	FlowField	Decimal	12
15	Original Amt. (LCY)	Original Amt. ($)	FlowField	Decimal	12
16	Remaining Amt. (LCY)	Remaining Amt. ($)	FlowField	Decimal	12
17	Amount (LCY)	Amount ($)	FlowField	Decimal	12
22	Employee Posting Group	Employee Posting Group	Normal	Code	20	Employee Posting Group	nvarchar(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]
23	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(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]
24	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(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]
25	Salespers./Purch. Code	Salespers./Purch. Code	Normal	Code	20	Salespers__Purch_ Code	nvarchar(40)
27	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
28	Source Code	Source Code	Normal	Code	10	Source Code	nvarchar(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]
34	Applies-to Doc. Type	Applies-to Doc. Type	Normal	Option	4	Applies-to Doc_ Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
35	Applies-to Doc. No.	Applies-to Doc. No.	Normal	Code	20	Applies-to Doc_ No_	nvarchar(40)
36	Open	Open	Normal	Boolean	4	Open	tinyint
43	Positive	Positive	Normal	Boolean	4	Positive	tinyint
44	Closed by Entry No.	Closed by Entry No.	Normal	Integer	4	Closed by Entry No_	int
45	Closed at Date	Closed at Date	Normal	Date	4	Closed at Date	datetime
46	Closed by Amount	Closed by Amount	Normal	Decimal	12	Closed by Amount	decimal(38,38)
47	Applies-to ID	Applies-to ID	Normal	Code	50	Applies-to ID	nvarchar(100)
48	Journal Templ. Name	Journal Template Name	Normal	Code	10	Journal Templ_ Name	nvarchar(20)
49	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
50	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(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]
51	Bal. Account Type	Bal. Account Type	Normal	Option	4	Bal_ Account Type	int
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
52	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
53	Transaction No.	Transaction No.	Normal	Integer	4	Transaction No_	int
54	Closed by Amount (LCY)	Closed by Amount ($)	Normal	Decimal	12	Closed by Amount (LCY)	decimal(38,38)
58	Debit Amount	Debit Amount	FlowField	Decimal	12
59	Credit Amount	Credit Amount	FlowField	Decimal	12
60	Debit Amount (LCY)	Debit Amount ($)	FlowField	Decimal	12
61	Credit Amount (LCY)	Credit Amount ($)	FlowField	Decimal	12
64	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(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]
75	Original Amount	Original Amount	FlowField	Decimal	12
76	Date Filter	Date Filter	FlowFilter	Date	4
84	Amount to Apply	Amount to Apply	Normal	Decimal	12	Amount to Apply	decimal(38,38)
86	Applying Entry	Applying Entry	Normal	Boolean	4	Applying Entry	tinyint
87	Reversed	Reversed	Normal	Boolean	4	Reversed	tinyint
88	Reversed by Entry No.	Reversed by Entry No.	Normal	Integer	4	Reversed by Entry No_	int
89	Reversed Entry No.	Reversed Entry No.	Normal	Integer	4	Reversed Entry No_	int
170	Creditor No.	Creditor No.	Normal	Code	20	Creditor No_	nvarchar(40)
171	Payment Reference	Payment Reference	Normal	Code	50	Payment Reference	nvarchar(100)
172	Payment Method Code	Payment Method Code	Normal	Code	10	Payment Method Code	nvarchar(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]
289	Message to Recipient	Message to Recipient	Normal	Text	140	Message to Recipient	nvarchar(280)
290	Exported to Payment File	Exported to Payment File	Normal	Boolean	4	Exported to Payment File	tinyint
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	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]
481	Shortcut Dimension 3 Code	Shortcut Dimension 3 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Employee Ledger Entry].[] ,[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].[] = [Dimension].[Code]
482	Shortcut Dimension 4 Code	Shortcut Dimension 4 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Employee Ledger Entry].[] ,[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].[] = [Dimension].[Code]
483	Shortcut Dimension 5 Code	Shortcut Dimension 5 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Employee Ledger Entry].[] ,[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].[] = [Dimension].[Code]
484	Shortcut Dimension 6 Code	Shortcut Dimension 6 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Employee Ledger Entry].[] ,[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].[] = [Dimension].[Code]
485	Shortcut Dimension 7 Code	Shortcut Dimension 7 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Employee Ledger Entry].[] ,[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].[] = [Dimension].[Code]
486	Shortcut Dimension 8 Code	Shortcut Dimension 8 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [Employee Ledger Entry].[] ,[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].[] = [Dimension].[Code]
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Employee Ledger Entry table

Currency Payment Method Sales Header Sales Header Archive

Dynamics 365 BC Table Reference Tables Company Tables EEmployee Ledger Entry

Leave a Reply Cancel reply