Job Item Price #1013

Jobs table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Project No., Project Task No., Item No., Unit of Measure Code, Currency Code, Variant Code.

All fields (17)

Job Item Price — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Project No. PK	Code	Normal	→ Job #167
2	Project Task No. PK	Code	Normal	→ Job Task #1001
3	Item No. PK	Code	Normal	→ Item #27
4	Unit of Measure Code PK	Code	Normal	→ Item Unit of Measure #5404
5	Unit Price	Decimal	Normal
6	Currency Code PK	Code	Normal	→ Currency #4
7	Unit Cost Factor	Decimal	Normal
8	Line Discount %	Decimal	Normal
9	Description ⚡ FLOW	Text	FlowField
10	Variant Code PK	Code	Normal	→ Item Variant #5401
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

Related tables (7)

Tables referenced by fields on the Job Item Price table through TableRelation properties.

Job

#167 · Other · via Project No.

Job Task

#1001 · Jobs · via Project Task No.

Item

#27 · Inventory · via Item No.

Item Unit of Measure

#5404 · Other · via Unit of Measure Code

Currency

#4 · General Ledger · via Currency Code

Item Variant

#5401 · Other · via Variant Code