Table 5222 "Employee Ledger Entry"
Base Application · Microsoft.HumanResources.Payables
- 62fields
- 8procedures
- 3events
- 1Learn pages
- 1countries replace it
- 10fields reference it
- 2event subscribers
- 2objects it calls
Across versions
- BC23present
- BC244 fields added, 1 procedures added
- BC25-27unchanged
- BC2844 fields changed
- BC291 fields changed, 1 fields added
- BC30declaration changed
Neighbourhood 32 connected objects and pages
Base Application · Microsoft.HumanResources.Payables · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 63 “Applied Employee Entries” (1 Learn page), Page 234 “Apply Employee Entries” (1), Page 5237 “Employee Ledger Entries” (1), Page 5239 “Empl. Ledger Entries Preview” (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. Δ BC28 | Integer | Specifies the entry number that is assigned to the entry. | |
| 3 | Employee No. Δ BC28 | Code[20] | Specifies the number of the employee that the entry is linked to. | TableRelation Table 5200 “Employee” |
| 4 | Posting Date Δ BC28 | Date | Specifies the employee entry’s posting date. | |
| 5 | Document Type Δ BC28 | Enum “Gen. Journal Document Type” | Specifies the document type that the employee entry belongs to. | enum Enum 6 “Gen. Journal Document Type” |
| 6 | Document No. Δ BC28 | Code[20] | Specifies the employee entry’s document number. | |
| 7 | Description Δ BC28 | Text[100] | Specifies a description of the employee entry. | |
| 11 | Currency Code Δ BC28 | Code[10] | Specifies the currency code for the amount on the line. | TableRelation Table 4 “Currency” |
| 13 | Amount Δ BC28 | 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 Δ BC28 | 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) Δ BC28 | Decimal | Specifies the amount that the entry originally consisted of, in LCY. via Page 5237 “Employee Ledger Entries” | 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) Δ BC28 | Decimal | Specifies the amount that remains to be applied to before the entry is totally applied to. via Page 5237 “Employee Ledger Entries” | 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) Δ BC28 | Decimal | Specifies the amount of the entry in LCY. via Page 5237 “Employee Ledger Entries” | 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” (Employee Posting Group) |
| 23 | Global Dimension 1 Code Δ BC28 | 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” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 24 | Global Dimension 2 Code Δ BC28 | 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” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 25 | Salespers./Purch. Code Δ BC28 | Code[20] | Specifies which purchaser is assigned to the employee. | TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser) |
| 27 | User ID Δ BC28 | 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” (Source Code) |
| 34 | Applies-to Doc. Type | Enum “Gen. Journal Document Type” | — | enum Enum 6 “Gen. Journal Document Type” |
| 35 | Applies-to Doc. No. | Code[20] | — | |
| 36 | Open Δ BC28 | 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 Δ BC28 | Boolean | Specifies if the entry to be applied is positive. | |
| 44 | Closed by Entry No. | Integer | — | TableRelation Table 5222 “Employee Ledger Entry” (Employee Ledger Entry) |
| 45 | Closed at Date | Date | — | |
| 46 | Closed by Amount Δ BC28 | Decimal | Specifies the amount that the entry was finally applied to (closed) with. | |
| 47 | Applies-to ID Δ BC28 | 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 caption | DataClassification SystemMetadata |
| 49 | Journal Batch Name | Code[10] | — | |
| 50 | Reason Code | Code[10] | — | TableRelation Table 231 “Reason Code” (Reason Code) |
| 51 | Bal. Account Type Δ BC28 | Enum “Gen. Journal Account Type” | Specifies the type of balancing account that is used for the entry. | enum Enum 81 “Gen. Journal Account Type” |
| 52 | Bal. Account No. Δ BC28 | Code[20] | Specifies the number of the balancing account that is used for the entry. | TableRelation Table 15 “G/L Account”, Table 18 “Customer”, Table 23 “Vendor” (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. Δ BC29 | Integer | Specifies the transaction number that groups related G/L entries from the same posting. | TableRelation Table 57 “G/L Transaction” (G/L Transaction) |
| 54 | Closed by Amount (LCY) Δ BC28 | Decimal | — | |
| 58 | Debit Amount Δ BC28 | 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 Δ BC28 | 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) Δ BC28 | 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) Δ BC28 | 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” (No. Series) |
| 65 | Closed by Currency Code + BC24 Δ BC28 | Code[10] | Specifies the currency code of the entry that was applied to (and closed) this employee ledger entry. | TableRelation Table 4 “Currency” |
| 66 | Closed by Currency Amount + BC24 Δ BC28 | Decimal | Specifies the amount that was finally applied to (and closed) this employee ledger entry. | |
| 73 | Adjusted Currency Factor + BC24 Δ BC28 | Decimal | — | |
| 74 | Original Currency Factor + BC24 Δ BC28 | Decimal | — | |
| 75 | Original Amount Δ BC28 | 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 Δ BC28 | Decimal | Specifies the amount to apply. | |
| 86 | Applying Entry Δ BC28 | 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” (Employee Ledger Entry) |
| 89 | Reversed Entry No. | Integer | — | TableRelation Table 5222 “Employee Ledger Entry” (Employee Ledger Entry) |
| 95 | G/L Register No. + BC29 | Integer | Specifies the G/L register number that groups related G/L entries from the same posting. | TableRelation Table 45 “G/L Register” (G/L Register); not editable |
| 170 | Creditor No. | Code[20] | — | |
| 171 | Payment Reference Δ BC28 | Code[50] | Specifies the payment to the employee. | |
| 172 | Payment Method Code Δ BC28 | Code[10] | Specifies the payment method that was used to make the payment that resulted in the entry. | TableRelation Table 289 “Payment Method” (Payment Method) |
| 289 | Message to Recipient Δ BC28 | 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 Δ BC28 | 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” (Dimension Set Entry); not editable |
| 481 | Shortcut Dimension 3 Code Δ BC28 | 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 Δ BC28 | 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 Δ BC28 | 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 Δ BC28 | 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 Δ BC28 | 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 Δ BC28 | 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)+ BC24 (integration)
Trigger event subscribers
- OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertEmployeeLedgerEntry
- OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” 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)+ BC24
Plus 1 local procedures.
Relations
- drill-down page Page 5237 “Employee Ledger Entries”
- lookup page Page 5237 “Employee Ledger Entries”
- Salespers./Purch. Code: TableRelation Table 13 “Salesperson/Purchaser”
- Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Bal. Account No.: TableRelation Table 18 “Customer” (conditional)
- Bal. Account No.: TableRelation Table 23 “Vendor” (conditional)
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Bal. Account No.: TableRelation Table 270 “Bank Account” (conditional)
- Payment Method Code: TableRelation Table 289 “Payment Method”
- No. Series: TableRelation Table 308 “No. Series”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Closed by Currency Code: TableRelation Table 4 “Currency”
- Currency Code: TableRelation Table 4 “Currency”
- G/L Register No.: TableRelation Table 45 “G/L Register”
- Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Employee No.: TableRelation Table 5200 “Employee”
- Employee Posting Group: TableRelation Table 5221 “Employee Posting Group”
- Closed by Entry No.: TableRelation Table 5222 “Employee Ledger Entry”
- Reversed by Entry No.: TableRelation Table 5222 “Employee Ledger Entry”
- Reversed Entry No.: TableRelation Table 5222 “Employee Ledger Entry”
- Amount: CalcFormula Table 5223 “Detailed Employee Ledger Entry”
- Amount (LCY): CalcFormula Table 5223 “Detailed Employee Ledger Entry”
- Credit Amount: CalcFormula Table 5223 “Detailed Employee Ledger Entry”
- Credit Amount (LCY): CalcFormula Table 5223 “Detailed Employee Ledger Entry”
- Debit Amount: CalcFormula Table 5223 “Detailed Employee Ledger Entry”
- Debit Amount (LCY): CalcFormula Table 5223 “Detailed Employee Ledger Entry”
- Original Amount: CalcFormula Table 5223 “Detailed Employee Ledger Entry”
- Original Amt. (LCY): CalcFormula Table 5223 “Detailed Employee Ledger Entry”
- Remaining Amount: CalcFormula Table 5223 “Detailed Employee Ledger Entry”
- Remaining Amt. (LCY): CalcFormula Table 5223 “Detailed Employee Ledger Entry”
- Transaction No.: TableRelation Table 57 “G/L Transaction”
Referenced by
10 fields in 5 objects relate to this table (TableRelation or CalcFormula).
- Table 5225 “Employee Payment Buffer”: Creditor No., Employee Ledg. Entry No., Payment Method Code, Payment Reference
- Table 5222 “Employee Ledger Entry”: Closed by Entry No., Reversed by Entry No., Reversed Entry No.
- Table 5223 “Detailed Employee Ledger Entry”: Employee Ledger Entry No.
- Table 5224 “Payable Employee Ledger Entry”: Employee Ledg. Entry No.
- Table 57 “G/L Transaction”: No. of Employee Ledger Entries
Pages and codeunits on this table
- Page 234 “Apply Employee Entries” (source table)
- Page 5237 “Employee Ledger Entries” (source table)
- Page 5239 “Empl. Ledger Entries Preview” (source table)
- Page 63 “Applied Employee Entries” (source table)
- Codeunit 114 “Empl. Entry-Edit” (codeunit runs on it)
- Codeunit 224 “EmplEntry-Apply Posted Entries” (codeunit runs on it)
Extended by
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” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 710 “Math” (1 call:
AreOppositeSign → Sign)
Recent changes
- 2026-09-03 #10878 Ruleset hardening: promote five low-risk rules to Error (main, BC30, refactor)
- 2026-08-28 #10498 [Pmt. Recon. Journal] Optimize opening of the Payment Application screen (main, BC30, performance)
Countries that replace it
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.