Jobs table in Microsoft Dynamics 365 Business Central. 10 fields, 0 records in Cronus demo.
The Job Usage Link table (ID 1020) is part of the Jobs area in Microsoft Dynamics 365 Business Central. It contains 10 fields, with a primary key of Project No., Project Task No., Line No., Entry No.. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Project No., Project Task No., Line No., Entry 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 | Line No. PK | Integer | Normal | → Job Planning Line #1003 |
| 4 | Entry No. PK | Integer | Normal | |
| 5 | External Id | GUID | 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 Usage Link table through TableRelation properties.