Table 169 "Job Ledger Entry"

Base Application · Microsoft.Projects.Project.Ledger · captioned “Project Ledger Entry” · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 92 “Job Ledger Entries” (2 Learn pages).

Properties

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.

Keys

• Key1: Entry No. (clustered)
• Key2: Job No., Job Task No., Entry Type, Posting Date
• Key3: Document No., Posting Date
• Key4: Job No., Posting Date
• Key5: Entry Type, Type, No., Posting Date
• Key7: Job No., Entry Type, Type, No.
• Key8: Type, Entry Type, Country/Region Code, Source Code, Posting Date
• Key9: Job No., Entry Type, Type, Posting Date
• Key10: Ledger Entry Type, Ledger Entry No.
• Key11: Type, No.

Events published

• OnAfterCopyTrackingFromJobJnlLine(var JobLedgerEntry: Record "Job Ledger Entry"; JobJnlLine: Record "Job Journal Line") (integration)
  • subscribers: Codeunit 6516 “Package Management” JobLedgerEntryCopyTrackingFromJobJnlLine

Trigger event subscribers

• OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertJobLedgEntry
• OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifyJobLedgEntry

Procedures

• GetNextEntryNo(): Integer + BC26
• GetLastEntryNo(): Integer Δ BC26
• CopyTrackingFromJobJnlLine(JobJnlLine: Record "Job Journal Line")
• ShowDimensions()

Plus 1 local procedures.

Triggers

OnDelete, OnInsert, OnModify

Relations

• drill-down page Page 92 “Job Ledger Entries”
• lookup page Page 92 “Job Ledger Entries”
• Shpt. Method Code: TableRelation Table 10 “Shipment Method”
• Job Task No.: TableRelation Table 1001 “Job Task”
• Location Code: TableRelation Table 14 “Location”
• No.: TableRelation Table 15 “G/L Account” (conditional)
• Resource Group No.: TableRelation Table 152 “Resource Group”
• No.: TableRelation Table 156 “Resource” (conditional)
• Job No.: TableRelation Table 167 “Job”
• Ledger Entry No.: TableRelation Table 17 “G/L Entry” (conditional)
• Work Type Code: TableRelation Table 200 “Work Type”
• Ledger Entry No.: TableRelation Table 203 “Res. Ledger Entry” (conditional)
• Unit of Measure Code: TableRelation Table 205 “Resource Unit of Measure” (conditional)
• Source Code: TableRelation Table 230 “Source Code”
• Reason Code: TableRelation Table 231 “Reason Code”
• Job Register No.: TableRelation Table 241 “Job Register”
• Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
• Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
• Transaction Type: TableRelation Table 258 “Transaction Type”
• Transport Method: TableRelation Table 259 “Transport Method”
• No.: TableRelation Table 27 “Item” (conditional)
• Entry/Exit Point: TableRelation Table 282 “Entry/Exit Point”
• Area: TableRelation Table 284 “Area”
• Transaction Specification: TableRelation Table 285 “Transaction Specification”
• No. Series: TableRelation Table 308 “No. Series”
• Ledger Entry No.: TableRelation Table 32 “Item Ledger Entry” (conditional)
• Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• Currency Code: TableRelation Table 4 “Currency”
• 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”
• Variant Code: TableRelation Table 5401 “Item Variant”
• Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
• Customer Price Group: TableRelation Table 6 “Customer Price Group”
• Bin Code: TableRelation Table 7354 “Bin”
• Country/Region Code: TableRelation Table 9 “Country/Region”
• Job Posting Group: TableRelation Table 94 “Inventory Posting Group”

Referenced by

12 fields in 8 objects relate to this table (TableRelation or CalcFormula).

• Table 1001 “Job Task”: Contract (Invoiced Cost), Contract (Invoiced Price), Usage (Total Cost), Usage (Total Price)
• Table 241 “Job Register”: From Entry No., To Entry No.
• Table 1003 “Job Planning Line”: Job Ledger Entry No.
• Table 1022 “Job Planning Line Invoice”: Job Ledger Entry No.
• Table 4812 “Intrastat Report Line”: Source Entry No.
• Table 5137 “Job Planning Line Archive”: Job Ledger Entry No.
• Table 5802 “Value Entry”: Job Ledger Entry No.
• Table 6916 “Posted Expense Report Line”: Job Ledger Entry No.

Pages and codeunits on this table

• Page 92 “Job Ledger Entries” (source table)
• Page 93 “Job Ledger Entries Preview” (source table)

Extended by

• Table extension 6459 “Serv. Job Ledger Entry”
• Table extension 6906 “Exp. Project Ledg. Entry Ext”

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 703 “Find Record Management” (1 call: GetLastEntryNo → GetLastEntryIntFieldValue)
• Codeunit 9500 “Sequence No. Mgt.” (1 call: GetNextEntryNo → GetNextSeqNo)

Countries that replace it

ES, GB

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: "Job Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.