Production Order #5405

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

61
Fields
0
Records
2
Primary key
10
FlowFields
14
Relations
Open in Data Explorer →

Primary key

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

All fields (61)

Production Order — FIELDS
NO.FIELDTYPECLASSRELATION
1 Status PK Option Normal
2 No. PK Code Normal → Production Order #5405
3 Description Text Normal
4 Search Description Code Normal
5 Description 2 Text Normal
6 Creation Date Date Normal
7 Last Date Modified Date Normal
9 Source Type Option Normal
10 Source No. Code Normal
11 Routing No. Code Normal → Routing Header #99000763
12 Variant Code Code Normal
15 Inventory Posting Group Code Normal → Inventory Posting Group #94
16 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
17 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
19 Comment ⚡ FLOW Boolean FlowField
20 Starting Time Time Normal
21 Starting Date Date Normal
22 Ending Time Time Normal
23 Ending Date Date Normal
24 Due Date Date Normal
25 Finished Date Date Normal
28 Blocked Boolean Normal
30 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
31 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
32 Location Code Code Normal → Location #14
33 Bin Code Code Normal
34 Replan Ref. No. Code Normal
35 Replan Ref. Status Option Normal
38 Low-Level Code Integer Normal
40 Quantity Decimal Normal
41 Unit Cost Decimal Normal
42 Cost Amount Decimal Normal
47 Work Center Filter Code FlowFilter → Work Center #99000754
48 Capacity Type Filter Option FlowFilter
49 Capacity No. Filter Code FlowFilter
50 Date Filter Date FlowFilter
51 Expected Operation Cost Amt. ⚡ FLOW Decimal FlowField
52 Expected Component Cost Amt. ⚡ FLOW Decimal FlowField
55 Actual Time Used ⚡ FLOW Decimal FlowField
56 Allocated Capacity Need ⚡ FLOW Decimal FlowField
57 Expected Capacity Need ⚡ FLOW Decimal FlowField
80 No. Series Code Normal → No. Series #308
82 Planned Order No. Code Normal
83 Firm Planned Order No. Code Normal
85 Simulated Order No. Code Normal
92 Expected Material Ovhd. Cost ⚡ FLOW Decimal FlowField
94 Expected Capacity Ovhd. Cost ⚡ FLOW Decimal FlowField
98 Starting Date-Time DateTime Normal
99 Ending Date-Time DateTime Normal
110 Document Put-away Status Option Normal
200 Reopened Boolean Normal
290 Manual Scheduling Boolean Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
6210 Sustainability Lines Exist ⚡ FLOW Boolean FlowField
7300 Completely Picked ⚡ FLOW Boolean FlowField
9000 Assigned User ID Code Normal → User Setup #91
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 (12)

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

Production Order
#5405 · Other · via No.
Routing Header
#99000763 · Manufacturing · via Routing No.
Inventory Posting Group
#94 · Other · via Inventory Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Location
#14 · General Ledger · via Location Code
Work Center
#99000754 · Manufacturing · via Work Center Filter
No. Series
#308 · Other · via No. Series
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
User Setup
#91 · Other · via Assigned User ID