--- id: object/table/1021 type: object title: Table 1021 "Job WIP Total" summary: Table 1021 "Job WIP Total" in Base Application (Microsoft.Projects.Project.WIP). 21 fields, 1 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC28. tier: official language: en tags: - table - base application versions: introduced: null last_changed: "28" deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: 2a7f76ccfad43f48cf0db472a631430e94311fa042d30f1e4456a731db7a3f3b evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Projects/Project/WIP/JobWIPTotal.Table.al title: src/Layers/W1/BaseApp/Projects/Project/WIP/JobWIPTotal.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] object_type: table object_id: 1021 name: Job WIP Total caption: Project WIP Total namespace: Microsoft.Projects.Project.WIP app: Base Application extends: null first_version: "23" last_version: "30" present_in: - "23" - "24" - "25" - "26" - "27" - "28" - "29" - "30" changed_in: - "24" - "28" source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 21 procedures: 1 events: 0 subscribers: 0 relations: out: 6 referenced_by: 4 pages: 1 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 1021 "Job WIP Total" > Table 1021 "Job WIP Total" in Base Application (Microsoft.Projects.Project.WIP). 21 fields, 1 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC28. Base Application · Microsoft.Projects.Project.WIP · captioned "Project WIP Total" · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Projects/Project/WIP/JobWIPTotal.Table.al) · 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. | Code[20] | Project No. caption | TableRelation [Table 167 "Job"](../table/167.md); not editable; NotBlank | | 3 | Job Task No. | 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"](../table/1001.md) ("Job Task"."Job Task No." where("Job No." = field("Job No."))); NotBlank | | 4 | WIP Method | 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"](../table/1006.md) ("Job WIP Method".Code); not editable | | 5 | WIP Posting Date | 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 | 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) | Decimal | Specifies the total of the budgeted costs for the project. via [Page 1028 "Job WIP Totals"](../page/1028.md) | not editable | | 11 | Schedule (Total Price) | Decimal | Specifies the total of the budgeted prices for the project. via [Page 1028 "Job WIP Totals"](../page/1028.md) | not editable | | 12 | Usage (Total Cost) | 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"](../page/1028.md) | not editable | | 13 | Usage (Total Price) | 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"](../page/1028.md) | not editable | | 14 | Contract (Total Cost) | 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"](../page/1028.md) | not editable | | 15 | Contract (Total Price) | 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"](../page/1028.md) | not editable | | 16 | Contract (Invoiced Price) | 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"](../page/1028.md) | not editable | | 17 | Contract (Invoiced Cost) | 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"](../page/1028.md) | not editable | | 20 | Calc. Recog. Sales Amount | Decimal | Specifies the calculated sum of recognized sales amounts in the current WIP calculation. | not editable | | 21 | Calc. Recog. Costs Amount | Decimal | Specifies the calculated sum of recognized costs amounts in the current WIP calculation. | not editable | | 30 | Cost Completion % | Decimal | Specifies the cost completion percentage for project tasks that have been budgeted in the current WIP calculation. | not editable | | 31 | Invoiced % | 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"](../page/1028.md) - lookup page [Page 1028 "Job WIP Totals"](../page/1028.md) - Job Task No.: TableRelation [Table 1001 "Job Task"](../table/1001.md) - WIP Method: TableRelation [Table 1006 "Job WIP Method"](../table/1006.md) - WIP Warnings: CalcFormula [Table 1007 "Job WIP Warning"](../table/1007.md) - Job No.: TableRelation [Table 167 "Job"](../table/167.md) ## Referenced by 4 fields in 4 objects relate to this table (TableRelation or CalcFormula). - [Table 1004 "Job WIP Entry"](../table/1004.md): Job WIP Total Entry No. - [Table 1005 "Job WIP G/L Entry"](../table/1005.md): Job WIP Total Entry No. - [Table 1007 "Job WIP Warning"](../table/1007.md): Job WIP Total Entry No. - [Table 1018 "Job WIP Buffer"](../table/1018.md): Job WIP Total Entry No. ## Pages and codeunits on this table - [Page 1028 "Job WIP Totals"](../page/1028.md) (source table) ## Across versions - Present in: BC23-30 - Changed (declaration) in: BC24, BC28 Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10). ## 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.