Table 203 "Res. Ledger Entry"

Base Application · Microsoft.Projects.Resources.Ledger · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Res. 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 number of the entry, as assigned from the specified number series when the entry was created.
2	Entry Type Δ BC28	Enum “Res. Journal Line Entry Type”	Specifies the type of entry.	enum Enum 208 “Res. Journal Line Entry Type”
3	Document No. Δ BC28	Code[20]	Specifies the document number on the resource ledger entry.
4	Posting Date Δ BC28	Date	Specifies the date when the entry was posted.
5	Resource No. Δ BC28	Code[20]	Specifies the number of the resource.	TableRelation Table 156 “Resource”
6	Resource Group No. Δ BC28	Code[20]	Specifies the number of the resource group.	TableRelation Table 152 “Resource Group” (Resource Group)
7	Description Δ BC28	Text[100]	Specifies the description of the posted entry.
8	Work Type Code Δ BC28	Code[10]	Specifies which work type the resource applies to. Prices are updated based on this entry.	TableRelation Table 200 “Work Type” (Work Type)
9	Job No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the related project.	TableRelation Table 167 “Job”
10	Unit of Measure Code Δ BC28	Code[10]	Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.	TableRelation Table 204 “Unit of Measure” (Unit of Measure)
11	Quantity Δ BC28	Decimal	Specifies the number of units of the item or resource specified on the line.
12	Direct Unit Cost Δ BC28	Decimal	Specifies the cost of one unit of the selected item or resource.
13	Unit Cost Δ BC28	Decimal	Specifies the cost of one unit of the item or resource on the line.
14	Total Cost Δ BC28	Decimal	Specifies the total cost of the posted entry.
15	Unit Price Δ BC28	Decimal	Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card.
16	Total Price Δ BC28	Decimal	Specifies the total price of the posted entry.
17	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)))
18	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)))
20	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
21	Source Code Δ BC28	Code[10]	Specifies the source code that specifies where the entry was created.	TableRelation Table 230 “Source Code” (Source Code)
22	Chargeable Δ BC28	Boolean	Specifies if a resource transaction is chargeable.
23	Journal Batch Name	Code[10]	—
24	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)
25	Gen. Bus. Posting Group	Code[20]	—	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
26	Gen. Prod. Posting Group	Code[20]	—	TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
27	Document Date	Date	—
28	External Document No.	Code[35]	—
29	No. Series	Code[20]	—	TableRelation Table 308 “No. Series” (No. Series)
30	Source Type	Enum “Res. Journal Line Source Type”	—	enum Enum 207 “Res. Journal Line Source Type”
31	Source No.	Code[20]	—	TableRelation if (“Source Type” = const(Customer)) Customer.“No.” else if (“Source Type” = const(Vendor)) Vendor.“No.”
32	Qty. per Unit of Measure Δ BC28	Decimal	—
33	Quantity (Base) Δ BC28	Decimal	—
34	Resource Register No. + BC26	Integer	—	TableRelation Table 240 “Resource Register” (Resource Register); not editable
90	Order Type	Enum “Inventory Order Type”	—	enum Enum 90 “Inventory Order Type”
91	Order No.	Code[20]	—
92	Order Line No.	Integer	—
480	Dimension Set ID Δ BC28	Integer	Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table.	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: Resource No., Posting Date
Key3: Entry Type, Chargeable, Unit of Measure Code, Resource No., Posting Date
Key4: Entry Type, Chargeable, Unit of Measure Code, Resource Group No., Posting Date
Key5: Document No., Posting Date
Key6: Order Type, Order No., Order Line No., Entry Type
Key7: Source No., Source Type, Entry Type, Posting Date
Key8: Job No.

Events published

OnAfterCopyFromResJnlLine(var ResLedgerEntry: Record "Res. Ledger Entry"; ResJournalLine: Record "Res. Journal Line") (integration)
- subscribers: Codeunit 5012 “Service Declaration Mgt.” OnAfterCopyFromResJnlLine

Trigger event subscribers

OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertResourceLedgerEntry
OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifyResLedgerEntry

Procedures

GetNextEntryNo(): Integer + BC26
GetLastEntryNo(): Integer Δ BC26
CopyFromResJnlLine(ResJnlLine: Record "Res. Journal Line")
ShowDimensions()

Relations

drill-down page Page 202 “Resource Ledger Entries”
lookup page Page 202 “Resource Ledger Entries”
Resource Group No.: TableRelation Table 152 “Resource Group”
Resource No.: TableRelation Table 156 “Resource”
Job No.: TableRelation Table 167 “Job”
Work Type Code: TableRelation Table 200 “Work Type”
Unit of Measure Code: TableRelation Table 204 “Unit of Measure”
Source Code: TableRelation Table 230 “Source Code”
Reason Code: TableRelation Table 231 “Reason Code”
Resource Register No.: TableRelation Table 240 “Resource Register”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
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”
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”

Referenced by

18 fields in 7 objects relate to this table (TableRelation or CalcFormula).

Table 152 “Resource Group”: Sales (Cost), Sales (Price), Sales (Qty.), Usage (Cost), Usage (Price), Usage (Qty.)
Table 156 “Resource”: Sales (Cost), Sales (Price), Sales (Qty.), Usage (Cost), Usage (Price), Usage (Qty.)
Table 240 “Resource Register”: From Entry No., To Entry No.
Table 1003 “Job Planning Line”: Ledger Entry No.
Table 169 “Job Ledger Entry”: Ledger Entry No.
Table 210 “Job Journal Line”: Ledger Entry No.
Table 5137 “Job Planning Line Archive”: Ledger Entry No.

Pages and codeunits on this table

Page 162 “Resource Ledg. Entries Preview” (source table)
Page 202 “Resource Ledger Entries” (source table)

Extended by

Table extension 5037 “Serv. Decl. Res. Ledg. Entry”

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)

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