Manufacturing User Template – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables MManufacturing 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
2	Create Purchase Order	Create Purchase Order	Normal	Option	4	Create Purchase Order	int
	Available options are: ” “ “Make Purch. Orders” “Make Purch. Orders & Print” “Copy to Req. Wksh”
3	Create Production Order	Create Production Order	Normal	Option	4	Create Production Order	int
	Available options are: ” “ “Planned” “Firm Planned” “Firm Planned & Print” “Copy to Req. Wksh”
4	Create Transfer Order	Create Transfer Order	Normal	Option	4	Create Transfer Order	int
	Available options are: ” “ “Make Trans. Orders” “Make Trans. Order & Print” “Copy to Req. Wksh”
5	Create Assembly Order	Create Assembly Order	Normal	Option	4	Create Assembly Order	int
	Available options are: ” “ “Make Assembly Orders” “Make Assembly Orders & Print”
11	Purchase Req. Wksh. Template	Purchase Req. Wksh. Template	Normal	Code	10	Purchase Req_ Wksh_ Template	nvarchar(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]
12	Purchase Wksh. Name	Purchase Wksh. Name	Normal	Code	10	Purchase Wksh_ Name	nvarchar(20)
15	Prod. Req. Wksh. Template	Prod. Req. Wksh. Template	Normal	Code	10	Prod_ Req_ Wksh_ Template	nvarchar(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]
16	Prod. Wksh. Name	Prod. Wksh. Name	Normal	Code	10	Prod_ Wksh_ Name	nvarchar(20)
19	Transfer Req. Wksh. Template	Transfer Req. Wksh. Template	Normal	Code	10	Transfer Req_ Wksh_ Template	nvarchar(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]
20	Transfer Wksh. Name	Transfer Wksh. Name	Normal	Code	10	Transfer Wksh_ Name	nvarchar(20)
21	Make Orders	Make Orders	Normal	Option	4	Make Orders	int
	Available options are: “The Active Line” “The Active Order” “All Lines”
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables MManufacturing User Template

Leave a Reply Cancel reply