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

Table 5223 "Detailed Employee Ledger Entry"

Base Application · Microsoft.HumanResources.Payables

Across versions

  1. BC23present
  2. BC241 fields added, 1 procedures added
  3. BC25unchanged
  4. BC261 procedures changed
  5. BC271 fields added
  6. BC2823 fields changed
  7. BC291 fields changed, 1 fields added
  8. BC30unchanged

Neighbourhood 19 connected objects and pages

Table 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 230 "Source Code" (relates to)Source CodeTable 231 "Reason Code" (relates to)Reason CodeTable 4 "Currency" (relates to)CurrencyTable 45 "G/L Register" (relates to)G/L RegisterTable 5200 "Employee" (relates to)EmployeeTable 5221 "Employee Posting Group" (relates to)Employee Posting GroupTable 5222 "Employee Ledger Entry" (relates to)Employee Ledger EntryTable 57 "G/L Transaction" (relates to)G/L TransactionTable 86 "Exch. Rate Adjmt. Reg." (relates to)Exch. Rate Adjmt. Reg.Page 5238 "Detailed Empl. Ledger Entries" (pages and codeunits on it, 3 links)Detailed Empl. Ledger EntriesPage 5240 "Detailed Empl. Entries Preview" (pages and codeunits on it)Page 625 "Unapply Employee Entries" (pages and codeunits on it)Codeunit 20 "Posting Preview Event Handler" (event subscribers, 2 links)Posting Preview Event HandlerCodeunit 703 "Find Record Management" (calls)Table 5222 "Employee Ledger Entry" (referenced by, 10 links)Employee Ledger EntryTable 5200 "Employee" (referenced by, 2 links)EmployeeTable 86 "Exch. Rate Adjmt. Reg." (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 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

Procedures

  • GetLastEntryNo(): Integer Δ BC26
  • UpdateDebitCredit(Correction: Boolean)
  • SetZeroTransNo(TransactionNo: Integer)
  • GetUnrealizedGainLossAmount(EntryNo: Integer): Decimal + BC24

Plus 1 local procedures.

Triggers

OnInsert

Relations

Referenced by

14 fields in 4 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this 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.

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.

Evidence 1 sources