Planning Routing Line #99000830

Manufacturing table in Microsoft Dynamics 365 Business Central. 56 fields, 0 records in Cronus demo.

The Planning Routing Line table (ID 99000830) is part of the Manufacturing area in Microsoft Dynamics 365 Business Central. It contains 56 fields, with a primary key of Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Operation No.. Use the reference below to explore every field, data type, and table relation.

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: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Operation No..

All fields (56)

Planning Routing Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Worksheet Template Name PK	Code	Normal	→ Req. Wksh. Template #244
2	Worksheet Batch Name PK	Code	Normal
3	Worksheet Line No. PK	Integer	Normal	→ Requisition Line #246
4	Operation No. PK	Code	Normal
5	Next Operation No.	Code	Normal
6	Previous Operation No.	Code	Normal
7	Type	Option	Normal
8	No.	Code	Normal
9	Work Center No.	Code	Normal	→ Work Center #99000754
10	Work Center Group Code	Code	Normal	→ Work Center Group #99000756
11	Description	Text	Normal
12	Setup Time	Decimal	Normal
13	Run Time	Decimal	Normal
14	Wait Time	Decimal	Normal
15	Move Time	Decimal	Normal
16	Fixed Scrap Quantity	Decimal	Normal
17	Lot Size	Decimal	Normal
18	Scrap Factor %	Decimal	Normal
19	Setup Time Unit of Meas. Code	Code	Normal	→ Capacity Unit of Measure #99000780
20	Run Time Unit of Meas. Code	Code	Normal	→ Capacity Unit of Measure #99000780
21	Wait Time Unit of Meas. Code	Code	Normal	→ Capacity Unit of Measure #99000780
22	Move Time Unit of Meas. Code	Code	Normal	→ Capacity Unit of Measure #99000780
27	Minimum Process Time	Decimal	Normal
28	Maximum Process Time	Decimal	Normal
30	Concurrent Capacities	Decimal	Normal
31	Send-Ahead Quantity	Decimal	Normal
34	Routing Link Code	Code	Normal	→ Routing Link #99000777
35	Standard Task Code	Code	Normal	→ Standard Task #99000778
40	Unit Cost per	Decimal	Normal
41	Recalculate	Boolean	Normal
50	Sequence No.(Forward)	Integer	Normal
51	Sequence No.(Backward)	Integer	Normal
52	Fixed Scrap Qty. (Accum.)	Decimal	Normal
53	Scrap Factor % (Accumulated)	Decimal	Normal
55	Sequence No. (Actual)	Integer	Normal
56	Direct Unit Cost	Decimal	Normal
57	Indirect Cost %	Decimal	Normal
58	Overhead Rate	Decimal	Normal
61	Output Quantity	Decimal	Normal
70	Starting Time	Time	Normal
71	Starting Date	Date	Normal
72	Ending Time	Time	Normal
73	Ending Date	Date	Normal
76	Unit Cost Calculation	Option	Normal
77	Input Quantity	Decimal	Normal
78	Critical Path	Boolean	Normal
98	Starting Date-Time	DateTime	Normal
99	Ending Date-Time	DateTime	Normal
99000909	Expected Operation Cost Amt.	Decimal	Normal
99000910	Expected Capacity Ovhd. Cost	Decimal	Normal
99000911	Expected Capacity Need	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

Related tables (8)

Tables referenced by fields on the Planning Routing Line table through TableRelation properties.

Req. Wksh. Template

#244 · Setup · via Worksheet Template Name

Requisition Line

#246 · Other · via Worksheet Line No.

Work Center

#99000754 · Manufacturing · via Work Center No.

Work Center Group

#99000756 · Manufacturing · via Work Center Group Code

Capacity Unit of Measure

#99000780 · Manufacturing · via Setup Time Unit of Meas. Code, Run Time Unit of Meas. Code, Wait Time Unit of Meas. Code, Move Time Unit of Meas. Code

Routing Link

#99000777 · Manufacturing · via Routing Link Code

Standard Task

#99000778 · Manufacturing · via Standard Task Code