Detailed Employee Ledger Entry #5223

Other table in Microsoft Dynamics 365 Business Central. 34 fields, 0 records in Cronus demo.

34
Fields
0
Records
1
Primary key
0
FlowFields
13
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (34)

Detailed Employee Ledger Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Employee Ledger Entry No. Integer Normal → Employee Ledger Entry #5222
3 Entry Type Option Normal
4 Posting Date Date Normal
5 Document Type Option Normal
6 Document No. Code Normal
7 Amount Decimal Normal
8 Amount (LCY) Decimal Normal
9 Employee No. Code Normal → Employee #5200
10 Currency Code Code Normal → Currency #4
11 User ID Code Normal
12 Source Code Code Normal → Source Code #230
13 Transaction No. Integer Normal
14 Journal Batch Name Code Normal
15 Reason Code Code Normal → Reason Code #231
16 Debit Amount Decimal Normal
17 Credit Amount Decimal Normal
18 Debit Amount (LCY) Decimal Normal
19 Credit Amount (LCY) Decimal Normal
21 Initial Entry Global Dim. 1 Code Normal → Dimension Value #349
22 Initial Entry Global Dim. 2 Code Normal → Dimension Value #349
35 Initial Document Type Option Normal
36 Applied Empl. Ledger Entry No. Integer Normal
37 Unapplied Boolean Normal
38 Unapplied by Entry No. Integer Normal → Detailed Employee Ledger Entry #5223
42 Application No. Integer Normal
43 Ledger Entry Amount Boolean Normal
44 Employee Posting Group Code Normal → Employee Posting Group #5221
45 Exch. Rate Adjmt. Reg. No. Integer Normal → Exch. Rate Adjmt. Reg. #86
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (10)

Tables referenced by fields on the Detailed Employee Ledger Entry table through TableRelation properties.

Employee Ledger Entry
#5222 · Human Resources · via Employee Ledger Entry No.
Employee
#5200 · Human Resources · via Employee No.
Currency
#4 · General Ledger · via Currency Code
Source Code
#230 · Other · via Source Code
Reason Code
#231 · Other · via Reason Code
Dimension Value
#349 · Dimensions · via Initial Entry Global Dim. 1, Initial Entry Global Dim. 2
Detailed Employee Ledger Entry
#5223 · Other · via Unapplied by Entry No.
Employee Posting Group
#5221 · Human Resources · via Employee Posting Group
Exch. Rate Adjmt. Reg.
#86 · Other · via Exch. Rate Adjmt. Reg. No.