Job Planning Line #1003

Jobs table in Microsoft Dynamics 365 Business Central. 107 fields, 14 records in Cronus demo.

The Job Planning Line table (ID 1003) is part of the Jobs area in Microsoft Dynamics 365 Business Central. It contains 107 fields, with a primary key of Line No., Project No., Project Task No., and includes 9 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.

107

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: Line No., Project No., Project Task No..

All fields (107)

Job Planning Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Line No. PK	Integer	Normal
2	Project No. PK	Code	Normal	→ Job #167
3	Planning Date	Date	Normal
4	Document No.	Code	Normal
5	Type	Option	Normal
7	No.	Code	Normal
8	Description	Text	Normal
9	Quantity	Decimal	Normal
11	Direct Unit Cost (LCY)	Decimal	Normal
12	Unit Cost (LCY)	Decimal	Normal
13	Total Cost (LCY)	Decimal	Normal
14	Unit Price (LCY)	Decimal	Normal
15	Total Price (LCY)	Decimal	Normal
16	Resource Group No.	Code	Normal	→ Resource Group #152
17	Unit of Measure Code	Code	Normal
18	Qty. Rounding Precision	Decimal	Normal
19	Qty. Rounding Precision (Base)	Decimal	Normal
20	Location Code	Code	Normal	→ Location #14
29	Last Date Modified	Date	Normal
30	User ID	Code	Normal
32	Work Type Code	Code	Normal	→ Work Type #200
33	Customer Price Group	Code	Normal	→ Customer Price Group #6
79	Country/Region Code	Code	Normal	→ Country/Region #9
80	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
81	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
83	Document Date	Date	Normal
84	Planning Due Date	Date	Normal
900	Qty. to Assemble	Decimal	Normal
901	Qty. to Assemble (Base)	Decimal	Normal
902	Assemble to Order	Boolean	Normal
903	BOM Item No.	Code	Normal	→ Item #27
904	Attached to Line No.	Integer	Normal	→ Job Planning Line #1003
1000	Project Task No. PK	Code	Normal	→ Job Task #1001
1001	Line Amount (LCY)	Decimal	Normal
1002	Unit Cost	Decimal	Normal
1003	Total Cost	Decimal	Normal
1004	Unit Price	Decimal	Normal
1005	Total Price	Decimal	Normal
1006	Line Amount	Decimal	Normal
1007	Line Discount Amount	Decimal	Normal
1008	Line Discount Amount (LCY)	Decimal	Normal
1015	Cost Factor	Decimal	Normal
1019	Serial No.	Code	Normal
1020	Lot No.	Code	Normal
1021	Line Discount %	Decimal	Normal
1022	Line Type	Option	Normal
1023	Currency Code	Code	Normal	→ Currency #4
1024	Currency Date	Date	Normal
1025	Currency Factor	Decimal	Normal
1026	Budget Line	Boolean	Normal
1027	Billable Line	Boolean	Normal
1030	Project Contract Entry No.	Integer	Normal
1035	Invoiced Amount (LCY) ⚡ FLOW	Decimal	FlowField
1036	Invoiced Cost Amount (LCY) ⚡ FLOW	Decimal	FlowField
1037	VAT Unit Price	Decimal	Normal
1038	VAT Line Discount Amount	Decimal	Normal
1039	VAT Line Amount	Decimal	Normal
1041	VAT %	Decimal	Normal
1042	Description 2	Text	Normal
1043	Project Ledger Entry No.	Integer	Normal	→ Job Ledger Entry #169
1048	Status	Option	Normal
1050	Ledger Entry Type	Option	Normal
1051	Ledger Entry No.	Integer	Normal
1052	System-Created Entry	Boolean	Normal
1053	Usage Link	Boolean	Normal
1060	Remaining Qty.	Decimal	Normal
1061	Remaining Qty. (Base)	Decimal	Normal
1062	Remaining Total Cost	Decimal	Normal
1063	Remaining Total Cost (LCY)	Decimal	Normal
1064	Remaining Line Amount	Decimal	Normal
1065	Remaining Line Amount (LCY)	Decimal	Normal
1070	Qty. Posted	Decimal	Normal
1071	Qty. to Transfer to Journal	Decimal	Normal
1072	Posted Total Cost	Decimal	Normal
1073	Posted Total Cost (LCY)	Decimal	Normal
1074	Posted Line Amount	Decimal	Normal
1075	Posted Line Amount (LCY)	Decimal	Normal
1080	Qty. Transferred to Invoice ⚡ FLOW	Decimal	FlowField
1081	Qty. to Transfer to Invoice	Decimal	Normal
1090	Qty. Invoiced ⚡ FLOW	Decimal	FlowField
1091	Qty. to Invoice	Decimal	Normal
1100	Reserved Quantity ⚡ FLOW	Decimal	FlowField
1101	Reserved Qty. (Base) ⚡ FLOW	Decimal	FlowField
1102	Reserve	Option	Normal
1103	Planned	Boolean	Normal
5402	Variant Code	Code	Normal
5403	Bin Code	Code	Normal	→ Bin #7354
5404	Qty. per Unit of Measure	Decimal	Normal
5410	Quantity (Base)	Decimal	Normal
5790	Requested Delivery Date	Date	Normal
5791	Promised Delivery Date	Date	Normal
5794	Planned Delivery Date	Date	Normal
5900	Service Order No.	Code	Normal
6515	Package No.	Code	Normal
7000	Price Calculation Method	Option	Normal
7001	Cost Calculation Method	Option	Normal
7300	Pick Qty. ⚡ FLOW	Decimal	FlowField
7301	Qty. Picked	Decimal	Normal
7302	Qty. Picked (Base)	Decimal	Normal
7303	Completely Picked	Boolean	Normal
7304	Pick Qty. (Base) ⚡ FLOW	Decimal	FlowField
7305	Qty. on Journal ⚡ FLOW	Decimal	FlowField
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