Table 1004 "Job WIP Entry"
Base Application · Microsoft.Projects.Project.WIP
Across versions
- BC23present
- BC245 fields changed
- BC25-27unchanged
- BC2823 fields changed
- BC29-30unchanged
Neighbourhood 11 connected objects and pages
Base Application · Microsoft.Projects.Project.WIP · captioned “Project WIP Entry” · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Project WIP 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 Calculate WIP batch job. | |
| 4 | G/L Account No. Δ BC28 | Code[20] | Specifies the general ledger account number to which the WIP on this entry will be posted, if you run the Project Post WIP to the general ledger batch job. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 5 | 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. | |
| 6 | WIP Entry Amount Δ BC28 | Decimal | Specifies the WIP amount that will be posted for this entry, if you run the Project Post WIP to G/L batch job. | |
| 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 will be posted to, if you run the Project Post WIP to general ledger batch job. | 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 | Job Complete Δ BC24 Δ BC28 | Boolean | Specifies whether the Project WIP Entry was created for a project with a Completed status. | |
| 12 | Job WIP Total Entry No. Δ BC24 Δ BC28 | Integer | Specifies the entry number of the WIP total. | TableRelation Table 1021 “Job WIP Total” (Job WIP Total) |
| 13 | Reverse Δ BC28 | Boolean | Specifies whether the entry has been part of a reverse transaction (correction) made by the reverse function. | |
| 14 | WIP Posting Method Used Δ BC24 Δ BC28 | Option | Specifies the WIP posting method used. The information in this field comes from the setting you have specified on the project card. | OptionCaption: Per Project,Per Project Ledger Entry |
| 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., Job Posting Group, WIP Posting Date, Type, Job Complete
- Key3: G/L Account No.
- Key4: Job No., Job Complete, Type
Procedures
DeleteEntriesForJob(Job: Record Job)GetLastEntryNo(): IntegerShowDimensions()
Relations
- drill-down page Page 1008 “Job WIP Entries”
- lookup page Page 1008 “Job WIP 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”
- 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
6 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 167 “Job”: Recog. Costs Amount, Recog. Sales Amount, Total WIP Cost Amount, Total WIP Sales Amount, WIP Completion Calculated, WIP Entries Exist
Pages and codeunits on this table
- Page 1008 “Job WIP 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 Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.