Prod. Order Routing Line #5409

Other table in Microsoft Dynamics 365 Business Central. 74 fields, 0 records in Cronus demo.

74
Fields
0
Records
5
Primary key
4
FlowFields
15
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Routing No., Routing Reference No., Operation No., Status, Prod. Order No..

All fields (74)

Prod. Order Routing Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Routing No. PK Code Normal → Routing Header #99000763
3 Routing Reference No. PK Integer Normal
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
70 Starting Time Time Normal
71 Starting Date Date Normal
72 Ending Time Time Normal
73 Ending Date Date Normal
74 Status PK Option Normal
75 Prod. Order No. PK Code Normal → Production Order #5405
76 Unit Cost Calculation Option Normal
77 Input Quantity Decimal Normal
78 Critical Path Boolean Normal
79 Routing Status Option Normal
81 Flushing Method Option Normal
90 Expected Operation Cost Amt. Decimal Normal
91 Expected Capacity Need Decimal Normal
96 Expected Capacity Ovhd. Cost Decimal Normal
98 Starting Date-Time DateTime Normal
99 Ending Date-Time DateTime Normal
100 Schedule Manually Boolean Normal
101 Location Code Code Normal
6210 Sustainability Account No. Code Normal → Sustainability Account #6210
6211 Sustainability Account Name Text Normal
6212 Sustainability Account Category Code Normal → Sustain. Account Category #6211
6213 Sustainability Account Subcategory Code Normal → Sustain. Account Subcategory #6212
6214 CO2e per Unit Decimal Normal
6215 Total CO2e Decimal Normal
6216 Posted Total CO2e Decimal Normal
7301 Open Shop Floor Bin Code Code Normal
7302 To-Production Bin Code Code Normal
7303 From-Production Bin Code Code Normal
7304 Posted Output Quantity ⚡ FLOW Decimal FlowField
7305 Posted Scrap Quantity ⚡ FLOW Decimal FlowField
7306 Posted Run Time ⚡ FLOW Decimal FlowField
7307 Posted Setup Time ⚡ 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

Related tables (11)

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

Routing Header
#99000763 · Manufacturing · via Routing 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
Production Order
#5405 · Other · via Prod. Order No.
Sustainability Account
#6210 · Other · via Sustainability Account No.
Sustain. Account Category
#6211 · Other · via Sustainability Account Category
Sustain. Account Subcategory
#6212 · Other · via Sustainability Account Subcategory