Jobs table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Project No., Project Task No., Project Planning Line No., Document Type, Document No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Project No. PK | Code | Normal | → Job #167 |
| 2 | Project Task No. PK | Code | Normal | → Job Task #1001 |
| 3 | Project Planning Line No. PK | Integer | Normal | → Job Planning Line #1003 |
| 4 | Document Type PK | Option | Normal | |
| 5 | Document No. PK | Code | Normal | |
| 6 | Line No. PK | Integer | Normal | |
| 7 | Quantity Transferred | Decimal | Normal | |
| 8 | Transferred Date | Date | Normal | |
| 9 | Invoiced Date | Date | Normal | |
| 10 | Invoiced Amount (LCY) | Decimal | Normal | |
| 11 | Invoiced Cost Amount (LCY) | Decimal | Normal | |
| 12 | Project Ledger Entry No. | Integer | Normal | → Job Ledger Entry #169 |
| 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 Planning Line Invoice table through TableRelation properties.