Manufacturing User Template

Dynamics 365 BC Table ReferenceTablesCompany TablesMManufacturing User Template

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5525

Table Type: Company

Table Name: Manufacturing User Template
Database Table Name: CRONUS UK Ltd_$Manufacturing User Template$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5525

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 User Template can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Manufacturing User Template$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [User ID]
   ,[Create Purchase Order]
   ,[Create Production Order]
   ,[Create Transfer Order]
   ,[Create Assembly Order]
   ,[Purchase Req_ Wksh_ Template]
   ,[Purchase Wksh_ Name]
   ,[Prod_ Req_ Wksh_ Template]
   ,[Prod_ Wksh_ Name]
   ,[Transfer Req_ Wksh_ Template]
   ,[Transfer Wksh_ Name]
   ,[Make Orders]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Manufacturing User Template$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 User Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing User Template]
LEFT JOIN
   [User] AS [User]
      ON
         [Manufacturing User Template].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Manufacturing User Template].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Manufacturing User Template table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1User ID Primary Key SearchUser IDNormalCode50User IDnvarchar(100)
2Create Purchase Order SearchCreate Purchase OrderNormalOption4Create Purchase Orderint
Available options are:
  • ” “
  • “Make Purch. Orders”
  • “Make Purch. Orders & Print”
  • “Copy to Req. Wksh”
3Create Production Order SearchCreate Production OrderNormalOption4Create Production Orderint
Available options are:
  • ” “
  • “Planned”
  • “Firm Planned”
  • “Firm Planned & Print”
  • “Copy to Req. Wksh”
4Create Transfer Order SearchCreate Transfer OrderNormalOption4Create Transfer Orderint
Available options are:
  • ” “
  • “Make Trans. Orders”
  • “Make Trans. Order & Print”
  • “Copy to Req. Wksh”
5Create Assembly Order SearchCreate Assembly OrderNormalOption4Create Assembly Orderint
Available options are:
  • ” “
  • “Make Assembly Orders”
  • “Make Assembly Orders & Print”
11Purchase Req. Wksh. Template SearchPurchase Req. Wksh. TemplateNormalCode10Purchase Req_ Wksh_ Templatenvarchar(20)
Key to join to the Req. Wksh. Template table.

Show/hide example query

SELECT
       [Manufacturing User Template].[Purchase Req_ Wksh_ Template]
       ,[Req. Wksh. Template].[Name]
FROM
       [CRONUS UK Ltd_$Manufacturing User Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing User Template]
LEFT JOIN
       [CRONUS UK Ltd_$Req_ Wksh_ Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Req. Wksh. Template]
              ON
                     [Manufacturing User Template].[Purchase Req_ Wksh_ Template] = [Req. Wksh. Template].[Name]
12Purchase Wksh. Name SearchPurchase Wksh. NameNormalCode10Purchase Wksh_ Namenvarchar(20)
15Prod. Req. Wksh. Template SearchProd. Req. Wksh. TemplateNormalCode10Prod_ Req_ Wksh_ Templatenvarchar(20)
Key to join to the Req. Wksh. Template table.

Show/hide example query

SELECT
       [Manufacturing User Template].[Prod_ Req_ Wksh_ Template]
       ,[Req. Wksh. Template].[Name]
FROM
       [CRONUS UK Ltd_$Manufacturing User Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing User Template]
LEFT JOIN
       [CRONUS UK Ltd_$Req_ Wksh_ Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Req. Wksh. Template]
              ON
                     [Manufacturing User Template].[Prod_ Req_ Wksh_ Template] = [Req. Wksh. Template].[Name]
16Prod. Wksh. Name SearchProd. Wksh. NameNormalCode10Prod_ Wksh_ Namenvarchar(20)
19Transfer Req. Wksh. Template SearchTransfer Req. Wksh. TemplateNormalCode10Transfer Req_ Wksh_ Templatenvarchar(20)
Key to join to the Req. Wksh. Template table.

Show/hide example query

SELECT
       [Manufacturing User Template].[Transfer Req_ Wksh_ Template]
       ,[Req. Wksh. Template].[Name]
FROM
       [CRONUS UK Ltd_$Manufacturing User Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing User Template]
LEFT JOIN
       [CRONUS UK Ltd_$Req_ Wksh_ Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Req. Wksh. Template]
              ON
                     [Manufacturing User Template].[Transfer Req_ Wksh_ Template] = [Req. Wksh. Template].[Name]
20Transfer Wksh. Name SearchTransfer Wksh. NameNormalCode10Transfer Wksh_ Namenvarchar(20)
21Make Orders SearchMake OrdersNormalOption4Make Ordersint
Available options are:
  • “The Active Line”
  • “The Active Order”
  • “All Lines”
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 User Template].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Manufacturing User Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing User Template]
LEFT JOIN
       [User] AS [User]
              ON
                     [Manufacturing User Template].[$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 User Template].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Manufacturing User Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturing User Template]
LEFT JOIN
       [User] AS [User]
              ON
                     [Manufacturing User Template].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesMManufacturing User Template

Leave a Reply

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