Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/99000765
Table Type: Company
Table Name: Manufacturing Setup
Database Table Name: CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Manufacturing Setup can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Primary Key]
,[Normal Starting Time]
,[Normal Ending Time]
,[Doc_ No_ Is Prod_ Order No_]
,[Cost Incl_ Setup]
,[Dynamic Low-Level Code]
,[Planning Warning]
,[Simulated Order Nos_]
,[Planned Order Nos_]
,[Firm Planned Order Nos_]
,[Released Order Nos_]
,[Work Center Nos_]
,[Machine Center Nos_]
,[Production BOM Nos_]
,[Routing Nos_]
,[Current Production Forecast]
,[Use Forecast on Variants]
,[Use Forecast on Locations]
,[Combined MPS_MRP Calculation]
,[Components at Location]
,[Default Dampener Period]
,[Default Dampener _]
,[Default Safety Lead Time]
,[Blank Overflow Level]
,[Show Capacity In]
,[Optimize low-level code calc_]
,[Preset Output Quantity]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Manufacturing Setup table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Primary Key  | nvarchar(20) |
| 3 | Normal Starting Time | datetime |
| 4 | Normal Ending Time | datetime |
| 5 | Doc_ No_ Is Prod_ Order No_ | tinyint |
| 6 | Cost Incl_ Setup | tinyint |
| 7 | Dynamic Low-Level Code | tinyint |
| 8 | Planning Warning | tinyint |
| 9 | Simulated Order Nos_ | nvarchar(40) |
| 10 | Planned Order Nos_ | nvarchar(40) |
| 11 | Firm Planned Order Nos_ | nvarchar(40) |
| 12 | Released Order Nos_ | nvarchar(40) |
| 13 | Work Center Nos_ | nvarchar(40) |
| 14 | Machine Center Nos_ | nvarchar(40) |
| 15 | Production BOM Nos_ | nvarchar(40) |
| 16 | Routing Nos_ | nvarchar(40) |
| 17 | Current Production Forecast | nvarchar(20) |
| 18 | Use Forecast on Variants | tinyint |
| 19 | Use Forecast on Locations | tinyint |
| 20 | Combined MPS_MRP Calculation | tinyint |
| 21 | Components at Location | nvarchar(20) |
| 22 | Default Dampener Period | varchar(32) |
| 23 | Default Dampener _ | decimal(38,38) |
| 24 | Default Safety Lead Time | varchar(32) |
| 25 | Blank Overflow Level | int |
| 26 | Show Capacity In | nvarchar(20) |
| 27 | Optimize low-level code calc_ | tinyint |
| 28 | Preset Output Quantity | int |
| 29 | $systemId | uniqueidentifier |
| 30 | $systemCreatedAt | datetime |
| 31 | $systemCreatedBy | uniqueidentifier |
| 32 | $systemModifiedAt | datetime |
| 33 | $systemModifiedBy | uniqueidentifier |