Machine Center #99000758

Manufacturing table in Microsoft Dynamics 365 Business Central. 64 fields, 13 records in Cronus demo.

64
Fields
13
Records
1
Primary key
5
FlowFields
19
Relations
Open in Data Explorer →

Primary key

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

All fields (64)

Machine Center — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal
3 Name Text Normal
4 Search Name Code Normal
5 Name 2 Text Normal
6 Address Text Normal
7 Address 2 Text Normal
8 City Text Normal
9 Post Code Code Normal
14 Work Center No. Code Normal → Work Center #99000754
19 Direct Unit Cost Decimal Normal
20 Indirect Cost % Decimal Normal
21 Unit Cost Decimal Normal
22 Queue Time Decimal Normal
23 Queue Time Unit of Meas. Code Code Normal → Capacity Unit of Measure #99000780
26 Last Date Modified Date Normal
27 Comment ⚡ FLOW Boolean FlowField
31 Capacity Decimal Normal
32 Efficiency Decimal Normal
33 Maximum Efficiency Decimal Normal
34 Minimum Efficiency Decimal Normal
38 Blocked Boolean Normal
39 Date Filter Date FlowFilter
40 Work Shift Filter Code FlowFilter → Work Shift #99000750
41 Capacity (Total) ⚡ FLOW Decimal FlowField
42 Capacity (Effective) ⚡ FLOW Decimal FlowField
44 Prod. Order Need (Qty.) ⚡ FLOW Decimal FlowField
45 Prod. Order Need Amount ⚡ FLOW Decimal FlowField
47 Prod. Order Status Filter Option FlowFilter
50 Setup Time Decimal Normal
52 Wait Time Decimal Normal
53 Move Time Decimal Normal
54 Fixed Scrap Quantity Decimal Normal
55 Scrap % Decimal Normal
56 Setup Time Unit of Meas. Code Code Normal → Capacity Unit of Measure #99000780
57 Wait Time Unit of Meas. Code Code Normal → Capacity Unit of Measure #99000780
58 Send-Ahead Quantity Decimal Normal
59 Move Time Unit of Meas. Code Code Normal → Capacity Unit of Measure #99000780
60 Flushing Method Option Normal
62 Minimum Process Time Decimal Normal
63 Maximum Process Time Decimal Normal
64 Concurrent Capacities Decimal Normal
65 Item Filter Code FlowFilter → Item #27
66 Stop Code Filter Code FlowFilter → Stop #99000761
67 Scrap Code Filter Code FlowFilter → Scrap #99000762
80 No. Series Code Normal → No. Series #308
81 Overhead Rate Decimal Normal
82 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
83 County Text Normal
84 Country/Region Code Code Normal → Country/Region #9
6210 Default Sust. Account Code Normal → Sustainability Account #6210
6211 Default CO2 Emission Decimal Normal
6212 Default CH4 Emission Decimal Normal
6213 Default N2O Emission Decimal Normal
6214 CO2e per Unit Decimal Normal
6215 CO2e Last Date Modified Date Normal
7300 Location Code Code Normal → Location #14
7301 Open Shop Floor Bin Code Code Normal → Bin #7354
7302 To-Production Bin Code Code Normal → Bin #7354
7303 From-Production Bin Code Code Normal → Bin #7354
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 (13)

Tables referenced by fields on the Machine Center table through TableRelation properties.

Work Center
#99000754 · Manufacturing · via Work Center No.
Capacity Unit of Measure
#99000780 · Manufacturing · via Queue Time Unit of Meas. Code, Setup Time Unit of Meas. Code, Wait Time Unit of Meas. Code, Move Time Unit of Meas. Code
Work Shift
#99000750 · Manufacturing · via Work Shift Filter
Item
#27 · Inventory · via Item Filter
Stop
#99000761 · Manufacturing · via Stop Code Filter
Scrap
#99000762 · Manufacturing · via Scrap Code Filter
No. Series
#308 · Other · via No. Series
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Country/Region
#9 · General Ledger · via Country/Region Code
Sustainability Account
#6210 · Other · via Default Sust. Account
Location
#14 · General Ledger · via Location Code
Bin
#7354 · Warehouse · via Open Shop Floor Bin Code, To-Production Bin Code, From-Production Bin Code