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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
      ON
         [Manufacturing Setup].[Current Production Forecast] = [Production Forecast Name].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Manufacturing Setup].[Components at Location] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Capacity Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Unit of Measure]
      ON
         [Manufacturing Setup].[Show Capacity In] = [Capacity Unit of Measure].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Manufacturing Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Manufacturing Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Manufacturing Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
7Normal Starting Time SearchNormal Starting TimeNormalTime4Normal Starting Timedatetime
8Normal Ending Time SearchNormal Ending TimeNormalTime4Normal Ending Timedatetime
9Doc. No. Is Prod. Order No. SearchDoc. No. Is Prod. Order No.NormalBoolean4Doc_ No_ Is Prod_ Order No_tinyint
11Cost Incl. Setup SearchCost Incl. SetupNormalBoolean4Cost Incl_ Setuptinyint
12Dynamic Low-Level Code SearchDynamic Low-Level CodeNormalBoolean4Dynamic Low-Level Codetinyint
18Planning Warning SearchPlanning WarningNormalBoolean4Planning Warningtinyint
20Simulated Order Nos. SearchSimulated Order Nos.NormalCode20Simulated Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Simulated Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Manufacturing Setup].[Simulated Order Nos_] = [No. Series].[Code]
21Planned Order Nos. SearchPlanned Order Nos.NormalCode20Planned Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Planned Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Manufacturing Setup].[Planned Order Nos_] = [No. Series].[Code]
22Firm Planned Order Nos. SearchFirm Planned Order Nos.NormalCode20Firm Planned Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Firm Planned Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Manufacturing Setup].[Firm Planned Order Nos_] = [No. Series].[Code]
23Released Order Nos. SearchReleased Order Nos.NormalCode20Released Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Released Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Manufacturing Setup].[Released Order Nos_] = [No. Series].[Code]
29Work Center Nos. SearchWork Center Nos.NormalCode20Work Center Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Work Center Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Manufacturing Setup].[Work Center Nos_] = [No. Series].[Code]
30Machine Center Nos. SearchMachine Center Nos.NormalCode20Machine Center Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Machine Center Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Manufacturing Setup].[Machine Center Nos_] = [No. Series].[Code]
31Production BOM Nos. SearchProduction BOM Nos.NormalCode20Production BOM Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Production BOM Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Manufacturing Setup].[Production BOM Nos_] = [No. Series].[Code]
32Routing Nos. SearchRouting Nos.NormalCode20Routing Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Routing Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Manufacturing Setup].[Routing Nos_] = [No. Series].[Code]
35Current Production Forecast SearchCurrent Demand ForecastNormalCode10Current Production Forecastnvarchar(20)
Key to join to the Production Forecast Name table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Current Production Forecast]
       ,[Production Forecast Name].[Name]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
              ON
                     [Manufacturing Setup].[Current Production Forecast] = [Production Forecast Name].[Name]
36Use Forecast on Variants SearchUse forecast on variantsNormalBoolean4Use Forecast on Variantstinyint
37Use Forecast on Locations SearchUse forecast on locationsNormalBoolean4Use Forecast on Locationstinyint
38Combined MPS/MRP Calculation SearchCombined MPS/MRP CalculationNormalBoolean4Combined MPS_MRP Calculationtinyint
39Components at Location SearchComponents at LocationNormalCode10Components at Locationnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Components at Location]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Manufacturing Setup].[Components at Location] = [Location].[Code]
40Default Dampener Period SearchDefault Dampener PeriodNormalDateFormula32Default Dampener Periodvarchar(32)
41Default Dampener % SearchDefault Dampener %NormalDecimal12Default Dampener _decimal(38,38)
42Default Safety Lead Time SearchDefault Safety Lead TimeNormalDateFormula32Default Safety Lead Timevarchar(32)
43Blank Overflow Level SearchBlank Overflow LevelNormalOption4Blank Overflow Levelint
Available options are:
  • “Allow Default Calculation”
  • “Use Item/SKU Values Only”
50Show Capacity In SearchShow Capacity InNormalCode10Show Capacity Innvarchar(20)
Key to join to the Capacity Unit of Measure table.

Show/hide example query

SELECT
       [Manufacturing Setup].[Show Capacity In]
       ,[Capacity Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Capacity Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Unit of Measure]
              ON
                     [Manufacturing Setup].[Show Capacity In] = [Capacity Unit of Measure].[Code]
3687Optimize low-level code calc. SearchOptimize low-level code calculationNormalBoolean4Optimize low-level code calc_tinyint
5500Preset Output Quantity SearchPreset Output QuantityNormalOption4Preset Output Quantityint
Available options are:
  • “Expected Quantity”
  • “Zero on All Operations”
  • “Zero on Last Operation”
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Manufacturing Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Manufacturing Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Manufacturing Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Manufacturing Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Manufacturing Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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