Jobs table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The Job Resource Price table (ID 1012) 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, Code, Work Type Code, Currency Code. 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, Code, Work Type Code, Currency Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Project No. PK | Code | Normal | → Job #167 |
| 2 | Project Task No. PK | Code | Normal | → Job Task #1001 |
| 3 | Type PK | Option | Normal | |
| 4 | Code PK | Code | Normal | |
| 5 | Work Type Code PK | Code | Normal | → Work Type #200 |
| 6 | Unit Price | Decimal | Normal | |
| 7 | Currency Code PK | Code | Normal | → Currency #4 |
| 8 | Unit Cost Factor | Decimal | Normal | |
| 9 | Line Discount % | Decimal | Normal | |
| 10 | Description | Text | Normal | |
| 11 | Apply Project Price | Boolean | Normal | |
| 12 | Apply Project Discount | Boolean | 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 Resource Price table through TableRelation properties.