Prod. Order Line #5406

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

79
Fields
0
Records
3
Primary key
9
FlowFields
19
Relations
Open in Data Explorer →

Primary key

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

All fields (79)

Prod. Order Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Status PK Option Normal
2 Prod. Order No. PK Code Normal → Production Order #5405
3 Line No. PK Integer Normal
11 Item No. Code Normal → Item #27
12 Variant Code Code Normal → Item Variant #5401
13 Description Text Normal
14 Description 2 Text Normal
20 Location Code Code Normal → Location #14
21 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
22 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
23 Bin Code Code Normal
35 Standard Task Code Code Normal → Standard Task #99000778
40 Quantity Decimal Normal
41 Finished Quantity Decimal Normal
42 Remaining Quantity Decimal Normal
45 Scrap % Decimal Normal
47 Due Date Date Normal
48 Starting Date Date Normal
49 Starting Time Time Normal
50 Ending Date Date Normal
51 Ending Time Time Normal
52 Planning Level Code Integer Normal
53 Priority Integer Normal
60 Production BOM No. Code Normal → Production BOM Header #99000771
61 Routing No. Code Normal → Routing Header #99000763
62 Inventory Posting Group Code Normal → Inventory Posting Group #94
63 Routing Reference No. Integer Normal
65 Unit Cost Decimal Normal
66 Put-away Status Option Normal
67 Cost Amount Decimal Normal
68 Reserved Quantity ⚡ FLOW Decimal FlowField
70 Capacity Type Filter Option FlowFilter
71 Capacity No. Filter Code FlowFilter
72 Date Filter Date FlowFilter
73 Qty. Rounding Precision Decimal Normal
74 Qty. Rounding Precision (Base) Decimal Normal
75 Manual Scheduling Boolean Normal
80 Unit of Measure Code Code Normal → Item Unit of Measure #5404
81 Quantity (Base) Decimal Normal
82 Finished Qty. (Base) Decimal Normal
83 Remaining Qty. (Base) Decimal Normal
84 Reserved Qty. (Base) ⚡ FLOW Decimal FlowField
90 Expected Operation Cost Amt. ⚡ FLOW Decimal FlowField
91 Total Exp. Oper. Output (Qty.) ⚡ FLOW Decimal FlowField
94 Expected Component Cost Amt. ⚡ FLOW Decimal FlowField
198 Starting Date-Time DateTime Normal
199 Ending Date-Time DateTime Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
5831 Cost Amount (ACY) Decimal Normal
5832 Unit Cost (ACY) Decimal Normal
5850 Qty. Put Away Decimal Normal
5851 Qty. Put Away (Base) Decimal Normal
5852 Put-away Qty. ⚡ FLOW Decimal FlowField
5853 Put-away Qty. (Base) ⚡ FLOW Decimal FlowField
5854 Lot No. Filter Code FlowFilter
5855 Serial No. Filter Code FlowFilter
5856 Package No. Filter Code FlowFilter
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
6217 Expected Operation Total CO2e ⚡ FLOW Decimal FlowField
6218 Expected Component Total CO2e ⚡ FLOW Decimal FlowField
99000750 Production BOM Version Code Code Normal → Production BOM Version #99000779
99000751 Routing Version Code Code Normal → Routing Version #99000786
99000752 Routing Type Option Normal
99000753 Qty. per Unit of Measure Decimal Normal
99000754 MPS Order Boolean Normal
99000755 Planning Flexibility Option Normal
99000764 Indirect Cost % Decimal Normal
99000765 Overhead Rate 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 (17)

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

Production Order
#5405 · Other · via Prod. Order No.
Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code
Location
#14 · General Ledger · via Location Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Standard Task
#99000778 · Manufacturing · via Standard Task Code
Production BOM Header
#99000771 · Manufacturing · via Production BOM No.
Routing Header
#99000763 · Manufacturing · via Routing No.
Inventory Posting Group
#94 · Other · via Inventory Posting Group
Item Unit of Measure
#5404 · Other · via Unit of Measure Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
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
Production BOM Version
#99000779 · Manufacturing · via Production BOM Version Code
Routing Version
#99000786 · Manufacturing · via Routing Version Code