tableHuman Resourcesofficial - Microsoftderived - from the source, no model text

Table 5222 "Employee Ledger Entry"

Base Application · Microsoft.HumanResources.Payables

Across versions

  1. BC23present
  2. BC244 fields added, 1 procedures added
  3. BC25-27unchanged
  4. BC2844 fields changed
  5. BC291 fields changed, 1 fields added
  6. BC30declaration changed

Neighbourhood 32 connected objects and pages

Table 5223 "Detailed Employee Ledger Entry" (relates to, 10 links)Detailed Employee Ledger EntryTable 480 "Dimension Set Entry" (relates to, 7 links)Dimension Set EntryTable 349 "Dimension Value" (relates to, 2 links)Table 4 "Currency" (relates to, 2 links)CurrencyTable 13 "Salesperson/Purchaser" (relates to)Table 15 "G/L Account" (relates to)G/L AccountTable 18 "Customer" (relates to)Table 23 "Vendor" (relates to)VendorTable 230 "Source Code" (relates to)Table 231 "Reason Code" (relates to)Reason CodeTable 270 "Bank Account" (relates to)Bank AccountTable 289 "Payment Method" (relates to)Payment MethodTable 308 "No. Series" (relates to)No. SeriesTable 45 "G/L Register" (relates to)Table 5200 "Employee" (relates to)EmployeeTable 5221 "Employee Posting Group" (relates to)Employee Posting GroupTable 57 "G/L Transaction" (relates to)Page 5237 "Employee Ledger Entries" (pages and codeunits on it, 3 links)Employee Ledger EntriesCodeunit 114 "Empl. Entry-Edit" (pages and codeunits on it)Codeunit 224 "EmplEntry-Apply Posted Entries" (pages and codeunits on it)Page 234 "Apply Employee Entries" (pages and codeunits on it)Page 5239 "Empl. Ledger Entries Preview" (pages and codeunits on it)Page 63 "Applied Employee Entries" (pages and codeunits on it)Table extension 6810 "WHT Empl. Ledger Entry Ext" (extended by)Codeunit 20 "Posting Preview Event Handler" (event subscribers, 2 links)Posting Preview Event HandlerCodeunit 408 "DimensionManagement" (calls)Codeunit 710 "Math" (calls)Table 5225 "Employee Payment Buffer" (referenced by, 4 links)Employee Payment BufferTable 5223 "Detailed Employee Ledger Entry" (referenced by)Table 5224 "Payable Employee Ledger Entry" (referenced by)Table 57 "G/L Transaction" (referenced by)Record and reimburse employees' expenses (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

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

Referenced by

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

Pages and codeunits on this table

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.

Recent changes

Countries that replace it

NL

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.

Evidence 1 sources