Jobs table in Microsoft Dynamics 365 Business Central. 34 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 | Document No. | Code | Normal | |
| 4 | G/L Account No. | Code | Normal | → G/L Account #15 |
| 5 | Posting Date | Date | Normal | |
| 6 | WIP Entry Amount | Decimal | Normal | |
| 7 | Project Posting Group | Code | Normal | → Job Posting Group #208 |
| 8 | Type | Option | Normal | |
| 9 | G/L Bal. Account No. | Code | Normal | → G/L Account #15 |
| 10 | WIP Method Used | Code | Normal | → Job WIP Method #1006 |
| 11 | WIP Posting Method Used | Option | Normal | |
| 12 | WIP Posting Date | Date | Normal | |
| 13 | Description | Text | Normal | |
| 14 | G/L Entry No. | Integer | Normal | → G/L Entry #17 |
| 15 | Reversed | Boolean | Normal | |
| 16 | Reverse | Boolean | Normal | |
| 17 | WIP Transaction No. | Integer | Normal | |
| 18 | Reverse Date | Date | Normal | |
| 19 | Project Complete | Boolean | Normal | |
| 20 | Project WIP Total Entry No. | Integer | Normal | → Job WIP Total #1021 |
| 60 | Global Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 61 | Global Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 481 | Shortcut Dimension 3 Code ⚡ FLOW | Code | FlowField | |
| 482 | Shortcut Dimension 4 Code ⚡ FLOW | Code | FlowField | |
| 483 | Shortcut Dimension 5 Code ⚡ FLOW | Code | FlowField | |
| 484 | Shortcut Dimension 6 Code ⚡ FLOW | Code | FlowField | |
| 485 | Shortcut Dimension 7 Code ⚡ FLOW | Code | FlowField | |
| 486 | Shortcut Dimension 8 Code ⚡ FLOW | Code | FlowField | |
| 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 G/L Entry table through TableRelation properties.