Table 207 "Res. Journal Line"
Base Application · Microsoft.Projects.Resources.Journal
Across versions
- BC23present
- BC241 fields changed
- BC258 procedures added, 4 procedures removed
- BC262 procedures changed
- BC27unchanged
- BC2829 fields changed, 8 procedures removed
- BC29-30unchanged
Neighbourhood 37 connected objects and pages
Base Application · Microsoft.Projects.Resources.Journal · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 207 “Resource Journal” (2 Learn pages), Page 290 “Recurring Resource Jnl.” (2).
Properties
| Property | Value |
|---|---|
| Caption | Res. Journal Line |
| 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 | Journal Template Name | Code[10] | — | TableRelation Table 206 “Res. Journal Template” (Res. Journal Template) |
| 2 | Line No. | Integer | — | |
| 3 | Entry Type Δ BC28 | Enum “Res. Journal Line Entry Type” | Specifies an entry type for each line. | enum Enum 208 “Res. Journal Line Entry Type” |
| 4 | Document No. Δ BC28 | Code[20] | Specifies a document number for the journal line. | |
| 5 | Posting Date Δ BC28 | Date | Specifies the date when you want to assign. | |
| 6 | Resource No. Δ BC28 | Code[20] | Specifies the number of the resource that you want to post an entry for. | TableRelation Table 156 “Resource” |
| 7 | Resource Group No. Δ BC28 | Code[20] | Specifies the resource group that this resource is assigned to. | TableRelation Table 152 “Resource Group” (Resource Group); not editable |
| 8 | Description Δ BC28 | Text[100] | Specifies the description or name of the resource you chose in the Resource No. field. | |
| 9 | 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) |
| 10 | Job No. Δ BC24 Δ BC28 | Code[20] | Specifies the number of the related project. | TableRelation Table 167 “Job” |
| 11 | 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 205 “Resource Unit of Measure” (“Resource Unit of Measure”.Code where(“Resource No.” = field(“Resource No.”))) |
| 12 | Quantity Δ BC28 | Decimal | Specifies the number of units of the item or resource specified on the line. | |
| 13 | Direct Unit Cost Δ BC28 | Decimal | Specifies the cost of one unit of the selected item or resource. | |
| 14 | Unit Cost Δ BC28 | Decimal | Specifies the cost of one unit of the item or resource on the line. | |
| 15 | Total Cost Δ BC28 | Decimal | Specifies the total cost for this journal line. | |
| 16 | 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. | |
| 17 | Total Price Δ BC28 | Decimal | Specifies the total price on the journal line. | |
| 18 | Shortcut Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 19 | Shortcut Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 21 | Source Code | Code[10] | — | TableRelation Table 230 “Source Code” (Source Code); not editable |
| 23 | Journal Batch Name | Code[10] | — | TableRelation Table 236 “Res. Journal Batch” (“Res. Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”))) |
| 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 | Recurring Method Δ BC28 | Option | Specifies what happens to the quantity on the journal line after posting. | OptionCaption: ,Fixed,Variable |
| 26 | Expiration Date Δ BC28 | Date | Specifies the last date when a recurring journal can be posted. | |
| 27 | Recurring Frequency Δ BC28 | DateFormula | Specifies a recurring frequency if you have indicated in the Recurring field of the Res. Journal Template the journal is recurring. | |
| 28 | Gen. Bus. Posting Group Δ BC28 | Code[20] | Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 29 | Gen. Prod. Posting Group Δ BC28 | Code[20] | Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. | TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group) |
| 30 | Document Date Δ BC28 | Date | Specifies the date when the related document was created. | |
| 31 | External Document No. Δ BC28 | Code[35] | Specifies a document number that refers to the customer’s or vendor’s numbering system. | |
| 32 | Posting No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 33 | Source Type | Enum “Res. Journal Line Source Type” | — | enum Enum 207 “Res. Journal Line Source Type” |
| 34 | Source No. | Code[20] | — | TableRelation if (“Source Type” = const(Customer)) Customer.“No.” |
| 35 | Qty. per Unit of Measure Δ BC28 | Decimal | — | |
| 90 | Order Type | Enum “Inventory Order Type” | — | enum Enum 90 “Inventory Order Type”; not editable |
| 91 | Order No. | Code[20] | — | not editable |
| 92 | Order Line No. | Integer | — | not editable |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 950 | Time Sheet No. Δ BC28 | Code[20] | Specifies the number of a time sheet. | TableRelation Table 950 “Time Sheet Header” (Time Sheet Header) |
| 951 | Time Sheet Line No. Δ BC28 | Integer | Specifies the line number for a time sheet. | TableRelation Table 951 “Time Sheet Line” (“Time Sheet Line”.“Line No.” where(“Time Sheet No.” = field(“Time Sheet No.”))) |
| 952 | Time Sheet Date Δ BC28 | Date | Specifies the date when a time sheet is created. | TableRelation Table 952 “Time Sheet Detail” (“Time Sheet Detail”.Date where(“Time Sheet No.” = field(“Time Sheet No.”), “Time Sheet Line No.” = field(“Time Sheet Line No.”))) |
| 959 | System-Created Entry | Boolean | — | not editable |
Keys
- Key1: Journal Template Name, Journal Batch Name, Line No. (clustered)
Events published
OnAfterInitDefaultDimensionSources(var ResJournalLine: Record "Res. Journal Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; FieldNo: Integer)(integration)OnAfterCreateDimProcedure(var ResJournalLine: Record "Res. Journal Line"; CurrFieldNo: Integer; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; xResJournalLine: Record "Res. Journal Line"; OldDimSetID: Integer)(integration)OnAfterCopyResJnlLineFromSalesHeader(var SalesHeader: Record "Sales Header"; var ResJournalLine: Record "Res. Journal Line")(integration)OnAfterCopyResJnlLineFromSalesLine(var SalesLine: Record "Sales Line"; var ResJnlLine: Record "Res. Journal Line")(integration)- subscribers: Codeunit 5012 “Service Declaration Mgt.” OnAfterCopyResJnlLineFromSalesLine
OnAfterCopyResJnlLineFromJobJnlLine(var ResJnlLine: Record "Res. Journal Line"; var JobJnlLine: Record "Job Journal Line")(integration)OnAfterSetUpNewLine(var ResJournalLine: Record "Res. Journal Line"; LastResJournalLine: Record "Res. Journal Line")(integration)OnAfterShowDimensions(var ResJnlLine: Record "Res. Journal Line")(integration)OnAfterValidateShortcutDimCode(var ResJournalLine: Record "Res. Journal Line"; xResJournalLine: Record "Res. Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnBeforeFindResPrice(ResJournalLine: Record "Res. Journal Line"; var ResourcePrice: Record "Resource Price")Δ BC28 (integration)OnBeforeValidateShortcutDimCode(var ResJournalLine: Record "Res. Journal Line"; xResJournalLine: Record "Res. Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnAfterCopyResJnlLineFromPurchaseHeader(PurchaseHeader: Record "Purchase Header"; var ResJournalLine: Record "Res. Journal Line")(integration)OnAfterCopyResJnlLineFromPurchaseLine(PurchaseLine: Record "Purchase Line"; var ResJournalLine: Record "Res. Journal Line")(integration)- subscribers: Codeunit 5012 “Service Declaration Mgt.” OnAfterCopyResJnlLineFromPurchaseLine
OnAfterGetLineWithPrice(var LineWithPrice: Interface "Line With Price")(integration)OnValidateResourceNoOnAfterChecks(var Resource: Record Resource; var ResJournalLine: Record "Res. Journal Line"; xResJournalLine: Record "Res. Journal Line")(integration)OnAfterInitResourceCost(var ResJournalLine: Record "Res. Journal Line"; var ResourceCost: Record "Resource Cost")Δ BC28 (integration)OnAfterFindResUnitCost(var ResJournalLine: Record "Res. Journal Line"; var ResourceCost: Record "Resource Cost")Δ BC28 (integration)OnAfterFindResPrice(var ResJournalLine: Record "Res. Journal Line"; var ResPrice: Record "Resource Price")Δ BC28 (integration)
Procedures
FindResUnitCost(CalledByFieldNo: Integer)Δ BC26FindResPrice(CalledByFieldNo: Integer)Δ BC26GetLineWithPrice(var LineWithPrice: Interface "Line With Price")AfterFindResUnitCost(var ResourceCost: Record "Resource Cost")Δ BC28AfterFindResPrice(var ResourcePrice: Record "Resource Price")Δ BC28BeforeFindResPrice(var ResourcePrice: Record "Resource Price")Δ BC28EmptyLine(): BooleanSetUpNewLine(LastResJnlLine: Record "Res. Journal Line")CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])CopyDocumentFields(DocNo: Code[20]; ExtDocNo: Text[35]; SourceCode: Code[10]; NoSeriesCode: Code[20])CopyFromSalesHeader(SalesHeader: Record "Sales Header")CopyFromSalesLine(SalesLine: Record "Sales Line")CopyFromJobJnlLine(JobJnlLine: Record "Job Journal Line")ShowDimensions()IsOpenedFromBatch(): BooleanCopyFrom(PurchaseHeader: Record "Purchase Header")SwitchLinesWithErrorsFilter(var ShowAllLinesEnabled: Boolean)CopyFrom(PurchaseLine: Record "Purchase Line")CreateDimFromDefaultDim(FieldNo: Integer)AfterInitResourceCost(var ResourceCost: Record "Resource Cost")Δ BC28
Plus 3 local procedures.
Triggers
OnInsert
Relations
- 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 205 “Resource Unit of Measure”
- Journal Template Name: TableRelation Table 206 “Res. Journal Template”
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Journal Batch Name: TableRelation Table 236 “Res. Journal Batch”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Posting No. Series: TableRelation Table 308 “No. Series”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Time Sheet No.: TableRelation Table 950 “Time Sheet Header”
- Time Sheet Line No.: TableRelation Table 951 “Time Sheet Line”
- Time Sheet Date: TableRelation Table 952 “Time Sheet Detail”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 236 “Res. Journal Batch”: No. of Lines
Pages and codeunits on this table
- Page 207 “Resource Journal” (source table)
- Page 290 “Recurring Resource Jnl.” (source table)
- Page 9123 “Res. Journal Errors Factbox” (source table)
- Codeunit 211 “Res. Jnl.-Check Line” (codeunit runs on it)
- Codeunit 212 “Res. Jnl.-Post Line” (codeunit runs on it)
- Codeunit 213 “Res. Jnl.-Post Batch” (codeunit runs on it)
- Codeunit 271 “Res. Jnl.-Post” (codeunit runs on it)
- Codeunit 272 “Res. Jnl.-Post+Print” (codeunit runs on it)
Extended by
- Table extension 5038 “Serv. Decl. Res. Jnl. Line”
- Table extension 6279 “Sust. Resource Journal Line”
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” (8 calls:
CreateDim → GetRecDefaultDimID,InitDefaultDimensionSources → AddDimSource,LookupShortcutDimCode → LookupDimValueCode, …) - Codeunit 7001 “Price Calculation Mgt.” (1 call:
FindPrice → GetHandler) - Codeunit 9076 “Res. Journal Errors Mgt.” (1 call:
SwitchLinesWithErrorsFilter → GetErrorMessages) - Page 456 “No. Series” (1 call:
SetUpNewLine → (object))
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. Journal Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.