Manufacturing table in Microsoft Dynamics 365 Business Central. 60 fields, 5 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Work Center table through TableRelation properties.