Jobs table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The Job Difference Buffer table (ID 1019) is part of the Jobs area in Microsoft Dynamics 365 Business Central. It contains 17 fields, with a primary key of Project No., Project Task No., Type, Location Code, Variant Code, Unit of Measure code, Entry type, Work Type Code, 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., Type, Location Code, Variant Code, Unit of Measure code, Entry type, Work Type Code, No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Project No. PK | Code | Normal | |
| 2 | Project Task No. PK | Code | Normal | |
| 3 | Type PK | Option | Normal | |
| 4 | Location Code PK | Code | Normal | |
| 5 | Variant Code PK | Code | Normal | |
| 6 | Unit of Measure code PK | Code | Normal | |
| 7 | Entry type PK | Option | Normal | |
| 8 | Work Type Code PK | Code | Normal | |
| 9 | No. PK | Code | Normal | |
| 10 | Quantity | Decimal | Normal | |
| 11 | Total Cost | Decimal | Normal | |
| 12 | Line Amount | 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 |