Work Center #99000754

Manufacturing table in Microsoft Dynamics 365 Business Central. 60 fields, 5 records in Cronus demo.

60
Fields
5
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 (60)

Work 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
12 Alternate Work Center Code Normal → Work Center #99000754
14 Work Center Group Code Code Normal → Work Center Group #99000756
16 Global Dimension 1 Code Code Normal → Dimension Value #349
17 Global Dimension 2 Code Code Normal → Dimension Value #349
18 Subcontractor No. Code Normal → Vendor #23
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
30 Unit of Measure Code Code Normal → Capacity Unit of Measure #99000780
31 Capacity Decimal Normal
32 Efficiency Decimal Normal
33 Maximum Efficiency Decimal Normal
34 Minimum Efficiency Decimal Normal
35 Calendar Rounding Precision Decimal Normal
36 Simulation Type Option Normal
37 Shop Calendar Code Code Normal → Shop Calendar #99000751
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 Unit Cost Calculation Option Normal
51 Specific Unit Cost Boolean Normal
52 Consolidated Calendar Boolean Normal
53 Flushing Method Option Normal
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 (14)

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

Work Center
#99000754 · Manufacturing · via Alternate Work Center
Work Center Group
#99000756 · Manufacturing · via Work Center Group Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Vendor
#23 · Purchasing · via Subcontractor No.
Capacity Unit of Measure
#99000780 · Manufacturing · via Queue Time Unit of Meas. Code, Unit of Measure Code
Shop Calendar
#99000751 · Manufacturing · via Shop Calendar Code
Work Shift
#99000750 · Manufacturing · via Work Shift 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