Jobs table in Microsoft Dynamics 365 Business Central. 26 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Entry No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Entry No. PK | Integer | Normal | |
| 2 | Project No. | Code | Normal | → Job #167 |
| 3 | Project Task No. | Code | Normal | → Job Task #1001 |
| 4 | WIP Method | Code | Normal | → Job WIP Method #1006 |
| 5 | WIP Posting Date | Date | Normal | |
| 6 | WIP Posting Date Filter | Text | Normal | |
| 7 | WIP Planning Date Filter | Text | Normal | |
| 8 | WIP Warnings ⚡ FLOW | Boolean | FlowField | |
| 9 | Posted to G/L | Boolean | Normal | |
| 10 | Budget (Total Cost) | Decimal | Normal | |
| 11 | Budget (Total Price) | Decimal | Normal | |
| 12 | Usage (Total Cost) | Decimal | Normal | |
| 13 | Usage (Total Price) | Decimal | Normal | |
| 14 | Billable (Total Cost) | Decimal | Normal | |
| 15 | Billable (Total Price) | Decimal | Normal | |
| 16 | Billable (Invoiced Price) | Decimal | Normal | |
| 17 | Billable (Invoiced Cost) | Decimal | Normal | |
| 20 | Calc. Recog. Sales Amount | Decimal | Normal | |
| 21 | Calc. Recog. Costs Amount | Decimal | Normal | |
| 30 | Cost Completion % | Decimal | Normal | |
| 31 | Invoiced % | Decimal | Normal | |
| 2000000000 | System ID | GUID | Normal | |
| 2000000001 | Created At | DateTime | Normal | |
| 2000000002 | Created By | GUID | Normal | |
| 2000000003 | Modified At | DateTime | Normal | |
| 2000000004 | Modified By | GUID | Normal |
Tables referenced by fields on the Job WIP Total table through TableRelation properties.