Table 1021 Job WIP Total in 26
- App
- Base Application
- Namespace
- Microsoft.Projects.Project.WIP
Fields, 21Keys, 3Procedures, 1
Versions171819202122232425262728latest
Source29
Fields, 21
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Entry No. | Integer | - |
| 2 | Job No. | Code[20] | - |
| 3 | Job Task No. | Code[20] | - |
| 4 | WIP Method | Code[20] | - |
| 5 | WIP Posting Date | Date | - |
| 6 | WIP Posting Date Filter | Text[250] | - |
| 7 | WIP Planning Date Filter | Text[250] | - |
| 8 | WIP Warnings | Boolean | - |
| 9 | Posted to G/L | Boolean | - |
| 10 | Schedule (Total Cost) | Decimal | - |
| 11 | Schedule (Total Price) | Decimal | - |
| 12 | Usage (Total Cost) | Decimal | - |
| 13 | Usage (Total Price) | Decimal | - |
| 14 | Contract (Total Cost) | Decimal | - |
| 15 | Contract (Total Price) | Decimal | - |
| 16 | Contract (Invoiced Price) | Decimal | - |
| 17 | Contract (Invoiced Cost) | Decimal | - |
| 20 | Calc. Recog. Sales Amount | Decimal | - |
| 21 | Calc. Recog. Costs Amount | Decimal | - |
| 30 | Cost Completion % | Decimal | - |
| 31 | Invoiced % | Decimal | - |
Keys, 3
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Entry No. | - |
| Key2 | Job No., Job Task No. | - |
| Key3 | Job No., Posted to G/L | - |
Procedures, 1
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| DeleteEntriesForJobTask | (Record Job Task) | public | - |