Manufacturing Setup

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

Table Number: 99000765

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 IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Normal Starting Time Searchdatetime
4Normal Ending Time Searchdatetime
5Doc_ No_ Is Prod_ Order No_ Searchtinyint
6Cost Incl_ Setup Searchtinyint
7Dynamic Low-Level Code Searchtinyint
8Planning Warning Searchtinyint
9Simulated Order Nos_ Searchnvarchar(40)
10Planned Order Nos_ Searchnvarchar(40)
11Firm Planned Order Nos_ Searchnvarchar(40)
12Released Order Nos_ Searchnvarchar(40)
13Work Center Nos_ Searchnvarchar(40)
14Machine Center Nos_ Searchnvarchar(40)
15Production BOM Nos_ Searchnvarchar(40)
16Routing Nos_ Searchnvarchar(40)
17Current Production Forecast Searchnvarchar(20)
18Use Forecast on Variants Searchtinyint
19Use Forecast on Locations Searchtinyint
20Combined MPS_MRP Calculation Searchtinyint
21Components at Location Searchnvarchar(20)
22Default Dampener Period Searchvarchar(32)
23Default Dampener _ Searchdecimal(38,38)
24Default Safety Lead Time Searchvarchar(32)
25Blank Overflow Level Searchint
26Show Capacity In Searchnvarchar(20)
27Optimize low-level code calc_ Searchtinyint
28Preset Output Quantity Searchint
29$systemId Searchuniqueidentifier
30$systemCreatedAt Searchdatetime
31$systemCreatedBy Searchuniqueidentifier
32$systemModifiedAt Searchdatetime
33$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *