Manufacturing 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
   [timestamp]
   ,[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 columns in Manufacturing User Template table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2User ID Primary Key Searchnvarchar(100)
3Create Purchase Order Searchint
4Create Production Order Searchint
5Create Transfer Order Searchint
6Create Assembly Order Searchint
7Purchase Req_ Wksh_ Template Searchnvarchar(20)
8Purchase Wksh_ Name Searchnvarchar(20)
9Prod_ Req_ Wksh_ Template Searchnvarchar(20)
10Prod_ Wksh_ Name Searchnvarchar(20)
11Transfer Req_ Wksh_ Template Searchnvarchar(20)
12Transfer Wksh_ Name Searchnvarchar(20)
13Make Orders Searchint
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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