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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | User ID  | nvarchar(100) |
| 3 | Create Purchase Order | int |
| 4 | Create Production Order | int |
| 5 | Create Transfer Order | int |
| 6 | Create Assembly Order | int |
| 7 | Purchase Req_ Wksh_ Template | nvarchar(20) |
| 8 | Purchase Wksh_ Name | nvarchar(20) |
| 9 | Prod_ Req_ Wksh_ Template | nvarchar(20) |
| 10 | Prod_ Wksh_ Name | nvarchar(20) |
| 11 | Transfer Req_ Wksh_ Template | nvarchar(20) |
| 12 | Transfer Wksh_ Name | nvarchar(20) |
| 13 | Make Orders | int |
| 14 | $systemId | uniqueidentifier |
| 15 | $systemCreatedAt | datetime |
| 16 | $systemCreatedBy | uniqueidentifier |
| 17 | $systemModifiedAt | datetime |
| 18 | $systemModifiedBy | uniqueidentifier |