Table "Job Ledger Entry"
Properties
| Name | Value |
|---|---|
| Caption | Project Ledger Entry |
| DrillDownPageID | Page Microsoft.Projects.Project.Ledger."Job Ledger Entries" |
| LookupPageID | Page Microsoft.Projects.Project.Ledger."Job Ledger Entries" |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Entry No." | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. |
| "Job No." | Code[20] | Specifies the number of the project. |
| "Posting Date" | Date | Specifies the posting date for the entry. |
| "Document No." | Code[20] | Specifies the document number on the project ledger entry. |
| Type | Enum Microsoft.Projects.Project.Journal."Job Journal Line Type" | Specifies the type of account to which the project ledger entry is posted. |
| "No." | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. |
| Description | Text[100] | Specifies the description of the project ledger entry. |
| Quantity | Decimal | Specifies the quantity that was posted on the entry. |
| "Direct Unit Cost (LCY)" | Decimal | |
| "Unit Cost (LCY)" | Decimal | |
| "Total Cost (LCY)" | Decimal | |
| "Unit Price (LCY)" | Decimal | |
| "Total Price (LCY)" | Decimal | |
| "Resource Group No." | Code[20] | |
| "Unit of Measure Code" | 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. |
| "Job Register No." | Integer | |
| "Location Code" | Code[10] | Specifies the relevant location code if an item is posted. |
| "Job Posting Group" | Code[20] | Specifies the posting group that was used when the entry was posted. The value depends on the account type. For inventoriable items, the field contains the Inventory Posting Group. For other account types the field is blank. |
| "Global Dimension 1 Code" | 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. |
| "Global Dimension 2 Code" | 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. |
| "Work Type Code" | Code[10] | Specifies which work type the resource applies to. Prices are updated based on this entry. |
| "Customer Price Group" | Code[10] | |
| "User ID" | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. |
| "Source Code" | Code[10] | Specifies the source code that specifies where the entry was created. |
| "Shpt. Method Code" | Code[10] | |
| "Amt. to Post to G/L" | Decimal | Specifies the amount that will be posted to the general ledger. |
| "Amt. Posted to G/L" | Decimal | Specifies the amount that has been posted to the general ledger. |
| "Entry Type" | Enum Microsoft.Projects.Project.Journal."Job Journal Line Entry Type" | Specifies the type of the entry. There are two types of entries: |
| "Journal Batch Name" | Code[10] | |
| "Reason Code" | Code[10] | Specifies the reason code, a supplementary source code that enables you to trace the entry. |
| "Transaction Type" | Code[10] | |
| "Transport Method" | Code[10] | |
| "Country/Region Code" | Code[10] | |
| "Gen. Bus. Posting Group" | 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. |
| "Gen. Prod. Posting Group" | 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. |
| "Entry/Exit Point" | Code[10] | |
| "Document Date" | Date | |
| "External Document No." | Code[35] | |
| "Area" | Code[10] | |
| "Transaction Specification" | Code[10] | |
| "No. Series" | Code[20] | |
| "Additional-Currency Total Cost" | Decimal | |
| "Add.-Currency Total Price" | Decimal | |
| "Add.-Currency Line Amount" | Decimal | |
| "Dimension Set ID" | Integer | Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. |
| "Shortcut Dimension 3 Code" | 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. |
| "Shortcut Dimension 4 Code" | 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. |
| "Shortcut Dimension 5 Code" | 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. |
| "Shortcut Dimension 6 Code" | 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. |
| "Shortcut Dimension 7 Code" | 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. |
| "Shortcut Dimension 8 Code" | 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. |
| "Job Task No." | Code[20] | Specifies the number of the related project task. |
| "Line Amount (LCY)" | Decimal | |
| "Unit Cost" | Decimal | Specifies the cost of one unit of the item or resource on the line. |
| "Total Cost" | Decimal | Specifies the total cost for the posted entry, in the currency specified for the project. |
| "Unit Price" | 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. |
| "Total Price" | Decimal | Specifies the total price for the posted entry, in the currency specified for the project. |
| "Line Amount" | Decimal | Specifies the value of products on the entry. |
| "Line Discount Amount" | Decimal | Specifies the line discount amount for the posted entry, in the currency specified for the project. |
| "Line Discount Amount (LCY)" | Decimal | |
| "Currency Code" | Code[10] | |
| "Currency Factor" | Decimal | |
| "Description 2" | Text[50] | |
| "Ledger Entry Type" | Enum Microsoft.Projects.Project.Ledger."Job Ledger Entry Type" | Specifies the entry type that the project ledger entry is linked to. |
| "Ledger Entry No." | Integer | Specifies the entry number (Resource, Item or G/L) to which the project ledger entry is linked. |
| "Serial No." | Code[50] | Specifies the serial number if the project ledger entry Specifies an item usage that was posted with serial number tracking. |
| "Lot No." | Code[50] | Specifies the lot number if the project ledger entry Specifies an item usage that was posted with lot number tracking. |
| "Line Discount %" | Decimal | Specifies the line discount percent of the posted entry. |
| "Line Type" | Enum Microsoft.Projects.Project.Job."Job Line Type" | |
| "Original Unit Cost (LCY)" | Decimal | |
| "Original Total Cost (LCY)" | Decimal | |
| "Original Unit Cost" | Decimal | Specifies the unit cost for the posted entry at the time of posting, in the currency specified for the project. No item cost adjustments are included. |
| "Original Total Cost" | Decimal | Specifies the total cost for the posted entry at the time of posting, in the currency specified for the project. No item cost adjustments are included. |
| "Original Total Cost (ACY)" | Decimal | |
| Adjusted | Boolean | Specifies whether a project ledger entry has been modified or adjusted. The value in this field is inserted by the Adjust Cost - Item Entries batch job. The Adjusted check box is selected if applicable. |
| "DateTime Adjusted" | DateTime | Specifies the time stamp of a project ledger entry adjustment or modification. |
| "Variant Code" | Code[10] | Specifies the variant of the item on the line. |
| "Bin Code" | Code[20] | |
| "Qty. per Unit of Measure" | Decimal | |
| "Quantity (Base)" | Decimal | |
| "Package No." | Code[50] | |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |
Methods
GetNextEntryNo
[InherentPermissions(TableData,169,r)]
procedure GetNextEntryNo(): IntegerReturns
| Type | Description |
|---|---|
| Integer |
GetLastEntryNo
[InherentPermissions(TableData,169,r)]
procedure GetLastEntryNo(): IntegerReturns
| Type | Description |
|---|---|
| Integer |
CopyTrackingFromJobJnlLine
procedure CopyTrackingFromJobJnlLine(JobJnlLine: Record "Job Journal Line")Parameters
| Name | Type | Description |
|---|---|---|
| JobJnlLine | Table Microsoft.Projects.Project.Journal."Job Journal Line" |
ShowDimensions
procedure ShowDimensions()Events
OnAfterCopyTrackingFromJobJnlLine
[IntegrationEvent(False,False)]
local procedure OnAfterCopyTrackingFromJobJnlLine(var JobLedgerEntry: Record "Job Ledger Entry"; JobJnlLine: Record "Job Journal Line")Parameters
| Name | Type | Description |
|---|---|---|
| JobLedgerEntry | Table Microsoft.Projects.Project.Ledger."Job Ledger Entry" | |
| JobJnlLine | Table Microsoft.Projects.Project.Journal."Job Journal Line" |