Table 1021 "Job WIP Total"
Base Application · Microsoft.Projects.Project.WIP
Across versions
- BC23present
- BC243 fields changed
- BC25-27unchanged
- BC2816 fields changed
- BC29-30unchanged
Neighbourhood 9 connected objects and pages
Base Application · Microsoft.Projects.Project.WIP · captioned “Project WIP Total” · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Project WIP Total |
| 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. | Integer | — | AutoIncrement |
| 2 | Job No. Δ BC24 | Code[20] | Project No. caption | TableRelation Table 167 “Job”; not editable; NotBlank |
| 3 | Job Task No. Δ BC24 Δ BC28 | Code[20] | Specifies the number of the project task that is associated with the project WIP total. The project task number is generally the final task in a group of tasks that is set to Total or the last project task line. | TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))); NotBlank |
| 4 | WIP Method Δ BC28 | Code[20] | Specifies the name of the work in process (WIP) calculation method that is associated with a project. The value in the field comes from the WIP method specified on the project card. | TableRelation Table 1006 “Job WIP Method” (“Job WIP Method”.Code); not editable |
| 5 | WIP Posting Date Δ BC28 | Date | Specifies the date when work in process (WIP) was last calculated and entered in the Project WIP Entries window. | not editable |
| 6 | WIP Posting Date Filter | Text[250] | — | not editable |
| 7 | WIP Planning Date Filter | Text[250] | — | not editable |
| 8 | WIP Warnings Δ BC24 Δ BC28 | Boolean | Specifies if there are WIP warnings associated with a project for which you have calculated WIP. | FlowField: exist(“Job WIP Warning” where(“Job WIP Total Entry No.” = field(“Entry No.”))) |
| 9 | Posted to G/L | Boolean | — | |
| 10 | Schedule (Total Cost) Δ BC28 | Decimal | Specifies the total of the budgeted costs for the project. via Page 1028 “Job WIP Totals” | not editable |
| 11 | Schedule (Total Price) Δ BC28 | Decimal | Specifies the total of the budgeted prices for the project. via Page 1028 “Job WIP Totals” | not editable |
| 12 | Usage (Total Cost) Δ BC28 | Decimal | Specifies project usage in relation to total cost up to the date of the last project WIP calculation. via Page 1028 “Job WIP Totals” | not editable |
| 13 | Usage (Total Price) Δ BC28 | Decimal | Specifies project usage in relation to total price up to the date of the last project WIP calculation. via Page 1028 “Job WIP Totals” | not editable |
| 14 | Contract (Total Cost) Δ BC28 | Decimal | Specifies the value of the billable in relation to total cost up to the date of the last project WIP calculation. via Page 1028 “Job WIP Totals” | not editable |
| 15 | Contract (Total Price) Δ BC28 | Decimal | Specifies the value of the billable in relation to the total price up to the date of the last project WIP calculation. via Page 1028 “Job WIP Totals” | not editable |
| 16 | Contract (Invoiced Price) Δ BC28 | Decimal | Specifies the price amount that has been invoiced and posted in relation to the billable for the current WIP calculation. via Page 1028 “Job WIP Totals” | not editable |
| 17 | Contract (Invoiced Cost) Δ BC28 | Decimal | Specifies the cost amount that has been invoiced and posted in relation to the billable for the current WIP calculation. via Page 1028 “Job WIP Totals” | not editable |
| 20 | Calc. Recog. Sales Amount Δ BC28 | Decimal | Specifies the calculated sum of recognized sales amounts in the current WIP calculation. | not editable |
| 21 | Calc. Recog. Costs Amount Δ BC28 | Decimal | Specifies the calculated sum of recognized costs amounts in the current WIP calculation. | not editable |
| 30 | Cost Completion % Δ BC28 | Decimal | Specifies the cost completion percentage for project tasks that have been budgeted in the current WIP calculation. | not editable |
| 31 | Invoiced % Δ BC28 | Decimal | Specifies the percentage of contracted project tasks that have been invoiced in the current WIP calculation. | not editable |
Keys
- Key1: Entry No. (clustered)
- Key2: Job No., Job Task No.
- Key3: Job No., Posted to G/L
Procedures
DeleteEntriesForJobTask(JobTask: Record "Job Task")
Triggers
OnDelete
Relations
- drill-down page Page 1028 “Job WIP Totals”
- lookup page Page 1028 “Job WIP Totals”
- Job Task No.: TableRelation Table 1001 “Job Task”
- WIP Method: TableRelation Table 1006 “Job WIP Method”
- WIP Warnings: CalcFormula Table 1007 “Job WIP Warning”
- Job No.: TableRelation Table 167 “Job”
Referenced by
4 fields in 4 objects relate to this table (TableRelation or CalcFormula).
- Table 1004 “Job WIP Entry”: Job WIP Total Entry No.
- Table 1005 “Job WIP G/L Entry”: Job WIP Total Entry No.
- Table 1007 “Job WIP Warning”: Job WIP Total Entry No.
- Table 1018 “Job WIP Buffer”: Job WIP Total Entry No.
Pages and codeunits on this table
- Page 1028 “Job WIP Totals” (source table)
Ask your agent
Procedure bodies are not stored here (D10). 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 Total"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.