Table 5223 "Detailed Employee Ledger Entry"
Base Application · Microsoft.HumanResources.Payables
Across versions
- BC23present
- BC241 fields added, 1 procedures added
- BC25unchanged
- BC261 procedures changed
- BC271 fields added
- BC2823 fields changed
- BC291 fields changed, 1 fields added
- BC30unchanged
Neighbourhood 19 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 625 “Unapply Employee Entries” (1 Learn page), Page 5238 “Detailed Empl. Ledger Entries” (1), Page 5240 “Detailed Empl. Entries Preview” (1).
Properties
| Property | Value |
|---|---|
| Caption | Detailed Employee Ledger Entry |
| DataClassification | CustomerContent |
| LookupPageId | Detailed Empl. Ledger Entries |
| DrillDownPageId | Detailed Empl. Ledger Entries |
| Permissions | TableData “Detailed Employee Ledger Entry” = m |
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 of the detailed employee ledger entry. | |
| 2 | Employee Ledger Entry No. Δ BC28 | Integer | Specifies the entry number of the employee ledger entry that the detailed employee ledger entry line was created for. | TableRelation Table 5222 “Employee Ledger Entry” (Employee Ledger Entry) |
| 3 | Entry Type Δ BC28 | Enum “Detailed CV Ledger Entry Type” | Specifies the entry type of the detailed employee ledger entry. | enum Enum 379 “Detailed CV Ledger Entry Type” |
| 4 | Posting Date Δ BC28 | Date | Specifies the posting date of the detailed employee ledger entry. | |
| 5 | Document Type Δ BC28 | Enum “Gen. Journal Document Type” | Specifies the document type of the detailed employee ledger entry. | enum Enum 6 “Gen. Journal Document Type” |
| 6 | Document No. Δ BC28 | Code[20] | Specifies the document number of the transaction that created the entry. | |
| 7 | Amount Δ BC28 | Decimal | Specifies the amount of the detailed employee ledger entry. | |
| 8 | Amount (LCY) Δ BC28 | Decimal | Specifies the amount of the entry in LCY. via Page 5238 “Detailed Empl. Ledger Entries” | |
| 9 | Employee No. Δ BC28 | Code[20] | Specifies the number of the employee to which the entry is posted. | TableRelation Table 5200 “Employee” |
| 10 | Currency Code Δ BC28 | Code[10] | Specifies the code for the currency if the amount is in a foreign currency. | TableRelation Table 4 “Currency” |
| 11 | 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 |
| 12 | Source Code Δ BC28 | Code[10] | Specifies the source code that specifies where the entry was created. | TableRelation Table 230 “Source Code” (Source Code) |
| 13 | Transaction No. Δ BC29 | Integer | — | TableRelation Table 57 “G/L Transaction” (G/L Transaction) |
| 14 | Journal Batch Name | Code[10] | — | |
| 15 | Reason Code Δ BC28 | Code[10] | Specifies the reason code, a supplementary source code that enables you to trace the entry. | TableRelation Table 231 “Reason Code” (Reason Code) |
| 16 | Debit Amount Δ BC28 | Decimal | Specifies the total of the ledger entries that represent debits. | |
| 17 | Credit Amount Δ BC28 | Decimal | Specifies the total of the ledger entries that represent credits. | |
| 18 | Debit Amount (LCY) Δ BC28 | Decimal | Specifies the total of the ledger entries that represent debits, expressed in LCY. via Page 5238 “Detailed Empl. Ledger Entries” | |
| 19 | Credit Amount (LCY) Δ BC28 | Decimal | Specifies the total of the ledger entries that represent credits, expressed in the local currency. via Page 5238 “Detailed Empl. Ledger Entries” | |
| 21 | Initial Entry Global Dim. 1 Δ BC28 | Code[20] | Specifies the Global Dimension 1 code of the initial employee ledger entry. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 22 | Initial Entry Global Dim. 2 Δ BC28 | Code[20] | Specifies the Global Dimension 2 code of the initial employee ledger entry. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 35 | Initial Document Type Δ BC28 | Enum “Gen. Journal Document Type” | Specifies the document type that the initial vendor ledger entry was created with. | enum Enum 6 “Gen. Journal Document Type” |
| 36 | Applied Empl. Ledger Entry No. | Integer | — | |
| 37 | Unapplied Δ BC28 | Boolean | Specifies whether the entry has been unapplied (undone) from the Unapply Employee Entries window by the entry number shown in the Unapplied by Entry No. field. | |
| 38 | Unapplied by Entry No. Δ BC28 | Integer | Specifies the number of the correcting entry, if the original entry has been unapplied (undone) from the Unapply Employee Entries window. | TableRelation Table 5223 “Detailed Employee Ledger Entry” (Detailed Employee Ledger Entry) |
| 42 | Application No. | Integer | — | not editable |
| 43 | Ledger Entry Amount | Boolean | — | not editable |
| 44 | Posting Group + BC27 Δ BC28 | Code[20] | Specifies the employee’s market type to link business transactions to. | TableRelation Table 5221 “Employee Posting Group” (Employee Posting Group); not editable |
| 45 | Exch. Rate Adjmt. Reg. No. + BC24 | Integer | — | TableRelation Table 86 “Exch. Rate Adjmt. Reg.” (Exch. Rate Adjmt. Reg.); not editable |
| 95 | G/L Register No. + BC29 | Integer | — | TableRelation Table 45 “G/L Register” (G/L Register); not editable |
Keys
- Key1: Entry No. (clustered)
- Key2: Employee Ledger Entry No., Posting Date
- Key3: Transaction No., Employee No., Entry Type
Events published
OnAfterUpdateDebitCredit(var DetailedEmployeeLedgerEntry: Record "Detailed Employee Ledger Entry"; Correction: Boolean)(integration)OnSetZeroTransNoOnBeforeDetailedVendorLedgEntryModify(var DetailedEmployeeLedgerEntry: Record "Detailed Employee Ledger Entry")(integration)
Trigger event subscribers
- OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertDetailedEmployeeLedgerEntry
- OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifyDetailedEmployeeLedgerEntry
Procedures
GetLastEntryNo(): IntegerΔ BC26UpdateDebitCredit(Correction: Boolean)SetZeroTransNo(TransactionNo: Integer)GetUnrealizedGainLossAmount(EntryNo: Integer): Decimal+ BC24
Plus 1 local procedures.
Triggers
OnInsert
Relations
- drill-down page Page 5238 “Detailed Empl. Ledger Entries”
- lookup page Page 5238 “Detailed Empl. Ledger Entries”
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Initial Entry Global Dim. 1: TableRelation Table 349 “Dimension Value”
- Initial Entry Global Dim. 2: TableRelation Table 349 “Dimension Value”
- Currency Code: TableRelation Table 4 “Currency”
- G/L Register No.: TableRelation Table 45 “G/L Register”
- Employee No.: TableRelation Table 5200 “Employee”
- Posting Group: TableRelation Table 5221 “Employee Posting Group”
- Employee Ledger Entry No.: TableRelation Table 5222 “Employee Ledger Entry”
- Unapplied by Entry No.: TableRelation Table 5223 “Detailed Employee Ledger Entry”
- Transaction No.: TableRelation Table 57 “G/L Transaction”
- Exch. Rate Adjmt. Reg. No.: TableRelation Table 86 “Exch. Rate Adjmt. Reg.”
Referenced by
14 fields in 4 objects relate to this table (TableRelation or CalcFormula).
- Table 5222 “Employee Ledger Entry”: Amount, Amount (LCY), Credit Amount, Credit Amount (LCY), Debit Amount, Debit Amount (LCY), Original Amount, Original Amt. (LCY), Remaining Amount, Remaining Amt. (LCY)
- Table 5200 “Employee”: Balance, Balance (LCY)
- Table 5223 “Detailed Employee Ledger Entry”: Unapplied by Entry No.
- Table 86 “Exch. Rate Adjmt. Reg.”: Adjusted Employees
Pages and codeunits on this table
- Page 5238 “Detailed Empl. Ledger Entries” (source table)
- Page 5240 “Detailed Empl. Entries Preview” (source table)
- Page 625 “Unapply Employee Entries” (source table)
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 703 “Find Record Management” (1 call:
GetLastEntryNo → GetLastEntryIntFieldValue)
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: "Detailed Employee Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.