---
id: object/table/5222
type: object
title: Table 5222 "Employee Ledger Entry"
summary: Table 5222 "Employee Ledger Entry" in Base Application (Microsoft.HumanResources.Payables). 62 fields, 4 public procedures, 3 events. Present since at least BC23, still in BC30, changed in BC24, BC28-30.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "30"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 648927bad942e92f1470269148fc75e1ed2e0876f6c4ea80394f9ad9bdf8c936
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/HumanResources/Payables/EmployeeLedgerEntry.Table.al
    title: src/Layers/W1/BaseApp/HumanResources/Payables/EmployeeLedgerEntry.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/finance-how-record-reimburse-employee-expenses
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/expense-management-preview/work-with-expenses-in-business-central
  localizations:
    - localization/nl
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/10878
    - change/bcapps/10498
object_type: table
object_id: 5222
name: Employee Ledger Entry
namespace: Microsoft.HumanResources.Payables
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "28"
  - "29"
  - "30"
source_major: "29"
obsolete: null
countries:
  - nl
ms_search_form_ids: []
counts:
  fields: 62
  procedures: 8
  events: 3
  subscribers: 0
relations:
  out: 39
  referenced_by: 10
  pages: 4
  extended_by: 1
  event_subscribers: 2
  calls: 2
  called_by: 0
  implements: 0
---

# Table 5222 "Employee Ledger Entry"

> Table 5222 "Employee Ledger Entry" in Base Application (Microsoft.HumanResources.Payables). 62 fields, 4 public procedures, 3 events. Present since at least BC23, still in BC30, changed in BC24, BC28-30.

Base Application · Microsoft.HumanResources.Payables · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/HumanResources/Payables/EmployeeLedgerEntry.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 63 "Applied Employee Entries"](../page/63.md) (1 Learn page), [Page 234 "Apply Employee Entries"](../page/234.md) (1), [Page 5237 "Employee Ledger Entries"](../page/5237.md) (1), [Page 5239 "Empl. Ledger Entries Preview"](../page/5239.md) (1).

## Properties

| Property | Value |
|---|---|
| Caption | Employee Ledger Entry |
| DataClassification | CustomerContent |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. | Integer | Specifies the entry number that is assigned to the entry. |  |
| 3 | Employee No. | Code[20] | Specifies the number of the employee that the entry is linked to. | TableRelation [Table 5200 "Employee"](../table/5200.md) |
| 4 | Posting Date | Date | Specifies the employee entry's posting date. |  |
| 5 | Document Type | Enum "Gen. Journal Document Type" | Specifies the document type that the employee entry belongs to. | enum [Enum 6 "Gen. Journal Document Type"](../enum/6.md) |
| 6 | Document No. | Code[20] | Specifies the employee entry's document number. |  |
| 7 | Description | Text[100] | Specifies a description of the employee entry. |  |
| 11 | Currency Code | Code[10] | Specifies the currency code for the amount on the line. | TableRelation [Table 4 "Currency"](../table/4.md) |
| 13 | Amount | Decimal | Specifies the amount of the entry. | FlowField: sum("Detailed Employee Ledger Entry".Amount where("Ledger Entry Amount" = const(true), "Employee Ledger Entry No." = field("Entry No."), "Posting Date" = field("Date Filter"))); not editable |
| 14 | Remaining Amount | Decimal | Specifies the amount that remains to be applied to before the entry is totally applied to. | FlowField: sum("Detailed Employee Ledger Entry".Amount where("Employee Ledger Entry No." = field("Entry No."), "Posting Date" = field("Date Filter"))); not editable |
| 15 | Original Amt. (LCY) | Decimal | Specifies the amount that the entry originally consisted of, in LCY. <small>via [Page 5237 "Employee Ledger Entries"](../page/5237.md)</small> | FlowField: sum("Detailed Employee Ledger Entry"."Amount (LCY)" where("Employee Ledger Entry No." = field("Entry No."), "Entry Type" = filter("Initial Entry"), "Posting Date" = field("Date Filter"))); not editable |
| 16 | Remaining Amt. (LCY) | Decimal | Specifies the amount that remains to be applied to before the entry is totally applied to. <small>via [Page 5237 "Employee Ledger Entries"](../page/5237.md)</small> | FlowField: sum("Detailed Employee Ledger Entry"."Amount (LCY)" where("Employee Ledger Entry No." = field("Entry No."), "Posting Date" = field("Date Filter"))); not editable |
| 17 | Amount (LCY) | Decimal | Specifies the amount of the entry in LCY. <small>via [Page 5237 "Employee Ledger Entries"](../page/5237.md)</small> | FlowField: sum("Detailed Employee Ledger Entry"."Amount (LCY)" where("Ledger Entry Amount" = const(true), "Employee Ledger Entry No." = field("Entry No."), "Posting Date" = field("Date Filter"))); not editable |
| 22 | Employee Posting Group | Code[20] | — | TableRelation [Table 5221 "Employee Posting Group"](../table/5221.md) (Employee Posting Group) |
| 23 | Global Dimension 1 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists. | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1))) |
| 24 | Global Dimension 2 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists. | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2))) |
| 25 | Salespers./Purch. Code | Code[20] | Specifies which purchaser is assigned to the employee. | TableRelation [Table 13 "Salesperson/Purchaser"](../table/13.md) (Salesperson/Purchaser) |
| 27 | User ID | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. | TableRelation User."User Name"; DataClassification EndUserIdentifiableInformation |
| 28 | Source Code | Code[10] | — | TableRelation [Table 230 "Source Code"](../table/230.md) (Source Code) |
| 34 | Applies-to Doc. Type | Enum "Gen. Journal Document Type" | — | enum [Enum 6 "Gen. Journal Document Type"](../enum/6.md) |
| 35 | Applies-to Doc. No. | Code[20] | — |  |
| 36 | Open | Boolean | Specifies whether the amount on the entry has been fully paid or there is still a remaining amount that must be applied to. |  |
| 43 | Positive | Boolean | Specifies if the entry to be applied is positive. |  |
| 44 | Closed by Entry No. | Integer | — | TableRelation [Table 5222 "Employee Ledger Entry"](../table/5222.md) (Employee Ledger Entry) |
| 45 | Closed at Date | Date | — |  |
| 46 | Closed by Amount | Decimal | Specifies the amount that the entry was finally applied to (closed) with. |  |
| 47 | Applies-to ID | Code[50] | Specifies the ID of entries that will be applied to when you choose the Apply Entries action. |  |
| 48 | Journal Templ. Name | Code[10] | Journal Template Name <small>caption</small> | DataClassification SystemMetadata |
| 49 | Journal Batch Name | Code[10] | — |  |
| 50 | Reason Code | Code[10] | — | TableRelation [Table 231 "Reason Code"](../table/231.md) (Reason Code) |
| 51 | Bal. Account Type | Enum "Gen. Journal Account Type" | Specifies the type of balancing account that is used for the entry. | enum [Enum 81 "Gen. Journal Account Type"](../enum/81.md) |
| 52 | Bal. Account No. | Code[20] | Specifies the number of the balancing account that is used for the entry. | TableRelation [Table 15 "G/L Account"](../table/15.md), [Table 18 "Customer"](../table/18.md), [Table 23 "Vendor"](../table/23.md) (if ("Bal. Account Type" = const("G/L Account")) "G/L Account" else if ("Bal. Account Type" = const(Customer)) Customer else if ("Bal. Account Type" = const(Vendor)) Vendor else if ("Bal. Account Type" = const("Bank Account")) "Bank Account" else if ("Bal. Account Type" = const("Fixed Asset")) "Fixed...) |
| 53 | Transaction No. | Integer | Specifies the transaction number that groups related G/L entries from the same posting. | TableRelation [Table 57 "G/L Transaction"](../table/57.md) (G/L Transaction) |
| 54 | Closed by Amount (LCY) | Decimal | — |  |
| 58 | Debit Amount | Decimal | Specifies the total of the ledger entries that represent debits. | FlowField: sum("Detailed Employee Ledger Entry"."Debit Amount" where("Ledger Entry Amount" = const(true), "Employee Ledger Entry No." = field("Entry No."), "Posting Date" = field("Date Filter"))); not editable |
| 59 | Credit Amount | Decimal | Specifies the total of the ledger entries that represent credits. | FlowField: sum("Detailed Employee Ledger Entry"."Credit Amount" where("Ledger Entry Amount" = const(true), "Employee Ledger Entry No." = field("Entry No."), "Posting Date" = field("Date Filter"))); not editable |
| 60 | Debit Amount (LCY) | Decimal | — | FlowField: sum("Detailed Employee Ledger Entry"."Debit Amount (LCY)" where("Ledger Entry Amount" = const(true), "Employee Ledger Entry No." = field("Entry No."), "Posting Date" = field("Date Filter"))); not editable |
| 61 | Credit Amount (LCY) | Decimal | — | FlowField: sum("Detailed Employee Ledger Entry"."Credit Amount (LCY)" where("Ledger Entry Amount" = const(true), "Employee Ledger Entry No." = field("Entry No."), "Posting Date" = field("Date Filter"))); not editable |
| 64 | No. Series | Code[20] | — | TableRelation [Table 308 "No. Series"](../table/308.md) (No. Series) |
| 65 | Closed by Currency Code | Code[10] | Specifies the currency code of the entry that was applied to (and closed) this employee ledger entry. | TableRelation [Table 4 "Currency"](../table/4.md) |
| 66 | Closed by Currency Amount | Decimal | Specifies the amount that was finally applied to (and closed) this employee ledger entry. |  |
| 73 | Adjusted Currency Factor | Decimal | — |  |
| 74 | Original Currency Factor | Decimal | — |  |
| 75 | Original Amount | Decimal | Specifies the amount of the original entry. | FlowField: sum("Detailed Employee Ledger Entry".Amount where("Employee Ledger Entry No." = field("Entry No."), "Entry Type" = filter("Initial Entry"), "Posting Date" = field("Date Filter"))); not editable |
| 76 | Date Filter | Date | — | FlowFilter |
| 84 | Amount to Apply | Decimal | Specifies the amount to apply. |  |
| 86 | Applying Entry | Boolean | Specifies whether the entry will be applied to when you choose the Apply Entries action. |  |
| 87 | Reversed | Boolean | — |  |
| 88 | Reversed by Entry No. | Integer | — | TableRelation [Table 5222 "Employee Ledger Entry"](../table/5222.md) (Employee Ledger Entry) |
| 89 | Reversed Entry No. | Integer | — | TableRelation [Table 5222 "Employee Ledger Entry"](../table/5222.md) (Employee Ledger Entry) |
| 95 | G/L Register No. | Integer | Specifies the G/L register number that groups related G/L entries from the same posting. | TableRelation [Table 45 "G/L Register"](../table/45.md) (G/L Register); not editable |
| 170 | Creditor No. | Code[20] | — |  |
| 171 | Payment Reference | Code[50] | Specifies the payment to the employee. |  |
| 172 | Payment Method Code | Code[10] | Specifies the payment method that was used to make the payment that resulted in the entry. | TableRelation [Table 289 "Payment Method"](../table/289.md) (Payment Method) |
| 289 | Message to Recipient | Text[140] | Specifies the message exported to the payment file when you use the Export Payments to File function in the Payment Journal window. |  |
| 290 | Exported to Payment File | Boolean | Specifies that the entry was created as a result of exporting a payment journal line. | not editable |
| 480 | Dimension Set ID | Integer | — | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry); not editable |
| 481 | Shortcut Dimension 3 Code | Code[20] | Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(3))); not editable |
| 482 | Shortcut Dimension 4 Code | Code[20] | Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(4))); not editable |
| 483 | Shortcut Dimension 5 Code | Code[20] | Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(5))); not editable |
| 484 | Shortcut Dimension 6 Code | Code[20] | Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(6))); not editable |
| 485 | Shortcut Dimension 7 Code | Code[20] | Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(7))); not editable |
| 486 | Shortcut Dimension 8 Code | Code[20] | Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(8))); not editable |

## Keys

- Key1: Entry No. (clustered)
- Key2: Employee No., Applies-to ID, Open, Positive
- PmtReconCandidates: Document Type, Open, Posting Date

## Events published

- `OnAfterCopyEmployeeLedgerEntryFromGenJnlLine(var EmployeeLedgerEntry: Record "Employee Ledger Entry"; GenJournalLine: Record "Gen. Journal Line")` (integration)
- `OnAfterCopyEmplLedgerEntryFromCVLedgEntryBuffer(var EmployeeLedgerEntry: Record "Employee Ledger Entry"; CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer")` (integration)
- `OnAfterRecalculateAmounts(var EmployeeLedgerEntry: Record "Employee Ledger Entry"; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; PostingDate: Date)` (integration)

## Trigger event subscribers

- OnAfterInsertEvent: [Codeunit 20 "Posting Preview Event Handler"](../codeunit/20.md) OnInsertEmployeeLedgerEntry
- OnAfterModifyEvent: [Codeunit 20 "Posting Preview Event Handler"](../codeunit/20.md) OnModifyEmployeeLedgerEntry

## Procedures

- `CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")`
- `ShowDimensions()`
- `CopyFromCVLedgEntryBuffer(var CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer")`
- `RecalculateAmounts(FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; PostingDate: Date)`

Plus 1 local procedures.

## Relations

- drill-down page [Page 5237 "Employee Ledger Entries"](../page/5237.md)
- lookup page [Page 5237 "Employee Ledger Entries"](../page/5237.md)
- Salespers./Purch. Code: TableRelation [Table 13 "Salesperson/Purchaser"](../table/13.md)
- Bal. Account No.: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional)
- Bal. Account No.: TableRelation [Table 18 "Customer"](../table/18.md) (conditional)
- Bal. Account No.: TableRelation [Table 23 "Vendor"](../table/23.md) (conditional)
- Source Code: TableRelation [Table 230 "Source Code"](../table/230.md)
- Reason Code: TableRelation [Table 231 "Reason Code"](../table/231.md)
- Bal. Account No.: TableRelation [Table 270 "Bank Account"](../table/270.md) (conditional)
- Payment Method Code: TableRelation [Table 289 "Payment Method"](../table/289.md)
- No. Series: TableRelation [Table 308 "No. Series"](../table/308.md)
- Global Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Global Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Closed by Currency Code: TableRelation [Table 4 "Currency"](../table/4.md)
- Currency Code: TableRelation [Table 4 "Currency"](../table/4.md)
- G/L Register No.: TableRelation [Table 45 "G/L Register"](../table/45.md)
- Shortcut Dimension 3 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 4 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 5 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 6 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 7 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 8 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Dimension Set ID: TableRelation [Table 480 "Dimension Set Entry"](../table/480.md)
- Employee No.: TableRelation [Table 5200 "Employee"](../table/5200.md)
- Employee Posting Group: TableRelation [Table 5221 "Employee Posting Group"](../table/5221.md)
- Closed by Entry No.: TableRelation [Table 5222 "Employee Ledger Entry"](../table/5222.md)
- Reversed by Entry No.: TableRelation [Table 5222 "Employee Ledger Entry"](../table/5222.md)
- Reversed Entry No.: TableRelation [Table 5222 "Employee Ledger Entry"](../table/5222.md)
- Amount: CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md)
- Amount (LCY): CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md)
- Credit Amount: CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md)
- Credit Amount (LCY): CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md)
- Debit Amount: CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md)
- Debit Amount (LCY): CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md)
- Original Amount: CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md)
- Original Amt. (LCY): CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md)
- Remaining Amount: CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md)
- Remaining Amt. (LCY): CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md)
- Transaction No.: TableRelation [Table 57 "G/L Transaction"](../table/57.md)

## Referenced by

10 fields in 5 objects relate to this table (TableRelation or CalcFormula).

- [Table 5225 "Employee Payment Buffer"](../table/5225.md): Creditor No., Employee Ledg. Entry No., Payment Method Code, Payment Reference
- [Table 5222 "Employee Ledger Entry"](../table/5222.md): Closed by Entry No., Reversed by Entry No., Reversed Entry No.
- [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md): Employee Ledger Entry No.
- [Table 5224 "Payable Employee Ledger Entry"](../table/5224.md): Employee Ledg. Entry No.
- [Table 57 "G/L Transaction"](../table/57.md): No. of Employee Ledger Entries

## Pages and codeunits on this table

- [Page 234 "Apply Employee Entries"](../page/234.md) (source table)
- [Page 5237 "Employee Ledger Entries"](../page/5237.md) (source table)
- [Page 5239 "Empl. Ledger Entries Preview"](../page/5239.md) (source table)
- [Page 63 "Applied Employee Entries"](../page/63.md) (source table)
- [Codeunit 114 "Empl. Entry-Edit"](../codeunit/114.md) (codeunit runs on it)
- [Codeunit 224 "EmplEntry-Apply Posted Entries"](../codeunit/224.md) (codeunit runs on it)

## Extended by

- [Table extension 6810 "WHT Empl. Ledger Entry Ext"](../tableextension/6810.md)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 408 "DimensionManagement"](../codeunit/408.md) (1 call: `ShowDimensions → ShowDimensionSet`)
- [Codeunit 710 "Math"](../codeunit/710.md) (1 call: `AreOppositeSign → Sign`)

## Recent changes

- 2026-09-03 [#10878 Ruleset hardening: promote five low-risk rules to Error](../../changes/bcapps/10878.md) (main, BC30, refactor)
- 2026-08-28 [#10498 [Pmt. Recon. Journal] Optimize opening of the Payment Application screen](../../changes/bcapps/10498.md) (main, BC30, performance)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC28-30

## Countries that replace it

[NL](../../localizations/nl.md)

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Employee Ledger Entry")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.