Table 1005 "Job WIP G/L Entry"

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

Properties

Property	Value
Caption	Project WIP G/L 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	Job No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the related project.	TableRelation Table 167 “Job”
3	Document No. Δ BC28	Code[20]	Specifies the document number you entered in the Document No. field on the Options FastTab in the Project Post WIP to G/L batch job.
4	G/L Account No. Δ BC28	Code[20]	Specifies the general ledger account number to which the WIP, on this entry, is posted.	TableRelation Table 15 “G/L Account” (G/L Account)
5	Posting Date Δ BC28	Date	Specifies the posting date you entered in the Posting Date field, on the Options FastTab, in the Project Post WIP to G/L batch job.
6	WIP Entry Amount Δ BC28	Decimal	Specifies the WIP amount that was posted in the general ledger for this entry.
7	Job Posting Group Δ BC24 Δ BC28	Code[20]	Specifies the posting group related to this entry.	TableRelation Table 208 “Job Posting Group” (Job Posting Group)
8	Type Δ BC28	Enum “Job WIP Buffer Type”	Specifies the WIP type for this entry.	enum Enum 1018 “Job WIP Buffer Type”
9	G/L Bal. Account No. Δ BC28	Code[20]	Specifies the general ledger balancing account number that WIP on this entry was posted to.	TableRelation Table 15 “G/L Account” (G/L Account)
10	WIP Method Used Δ BC28	Code[20]	Specifies the WIP method that was specified for the project when you ran the Project Calculate WIP batch job.	TableRelation Table 1006 “Job WIP Method” (Job WIP Method); not editable
11	WIP Posting Method Used Δ BC24 Δ BC28	Option	Specifies the WIP posting method used in the context of the general ledger. The information in this field comes from the setting you have specified on the project card.	OptionCaption: Per Project,Per Project Ledger Entry
12	WIP Posting Date Δ BC28	Date	Specifies the posting date you entered in the Posting Date field, on the Options FastTab, in the Project Calculate WIP batch job.
13	Description	Text[100]	—
14	G/L Entry No. Δ BC28	Integer	Specifies the G/L Entry No. to which this entry is linked.	TableRelation Table 17 “G/L Entry” (G/L Entry)
15	Reversed Δ BC28	Boolean	Specifies whether the entry has been reversed. If the check box is selected, the entry has been reversed from the G/L.
16	Reverse Δ BC28	Boolean	Specifies whether the entry has been part of a reverse transaction (correction) made by the reverse function.
17	WIP Transaction No. Δ BC28	Integer	Specifies the transaction number assigned to all the entries involved in the same transaction.
18	Reverse Date Δ BC28	Date	Specifies the reverse date. If the WIP on this entry is reversed, you can see the date of the reversal in the Reverse Date field.
19	Job Complete Δ BC24 Δ BC28	Boolean	Specifies whether a project is complete. This check box is selected if the Project WIP G/L Entry was created for a Project with a Completed status.
20	Job WIP Total Entry No. Δ BC24 Δ BC28	Integer	Specifies the entry number from the associated project WIP total.	TableRelation Table 1021 “Job WIP Total” (Job WIP Total)
60	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)))
61	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)))
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: Job No., Reversed, Job Complete, Type
Key3: Job No., Reverse, Job Complete, Type
Key4: Document No., Posting Date
Key5: WIP Transaction No.

Procedures

GetLastEntryNo(): Integer
ShowDimensions()

Relations

drill-down page Page 1009 “Job WIP G/L Entries”
lookup page Page 1009 “Job WIP G/L Entries”
WIP Method Used: TableRelation Table 1006 “Job WIP Method”
Job WIP Total Entry No.: TableRelation Table 1021 “Job WIP Total”
G/L Account No.: TableRelation Table 15 “G/L Account”
G/L Bal. Account No.: TableRelation Table 15 “G/L Account”
Job No.: TableRelation Table 167 “Job”
G/L Entry No.: TableRelation Table 17 “G/L Entry”
Job Posting Group: TableRelation Table 208 “Job Posting Group”
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

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

Table 167 “Job”: Applied Costs G/L Amount, Applied Sales G/L Amount, Recog. Costs G/L Amount, Recog. Sales G/L Amount, Total WIP Cost G/L Amount, Total WIP Sales G/L Amount, WIP Completion Posted, WIP G/L Posting Date

Pages and codeunits on this table

Page 1009 “Job WIP G/L Entries” (source 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.

Codeunit 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)
Codeunit 703 “Find Record Management” (1 call: GetLastEntryNo → GetLastEntryIntFieldValue)

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 WIP G/L Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.