Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/99000776
Table Type: Company
Table Name: Production BOM Comment Line
Database Table Name: CRONUS UK Ltd_$Production BOM Comment Line$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 Production BOM Comment Line can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Production BOM Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Production BOM No_]
,[BOM Line No_]
,[Version Code]
,[Line No_]
,[Date]
,[Comment]
,[Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Production BOM Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Production BOM Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Comment Line]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
ON
[Production BOM Comment Line].[BOM Line No_] = [Production BOM Line].[Line No_]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
ON
[Production BOM Comment Line].[Production BOM No_] = [Production BOM Header].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
ON
[Production BOM Comment Line].[Production BOM No_] = [Production BOM Line].[Production BOM No_]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
ON
[Production BOM Comment Line].[BOM Line No_] = [Production BOM Line].[Line No_]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
ON
[Production BOM Comment Line].[Production BOM No_] = [Production BOM Line].[Production BOM No_]Show/hide columns in Production BOM Comment Line table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Production BOM No_  | nvarchar(40) | ||||
Key to join to the Production BOM Header table.Show/hide example querySELECT
[Production BOM Comment Line].[Production BOM No_]
,[Production BOM Header].[No_]
FROM
[CRONUS UK Ltd_$Production BOM Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Comment Line]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
ON
[Production BOM Comment Line].[Production BOM No_] = [Production BOM Header].[No_]Show/hide example querySELECT
[Production BOM Comment Line].[Production BOM No_]
,[Production BOM Line].[Production BOM No_]
FROM
[CRONUS UK Ltd_$Production BOM Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Comment Line]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
ON
[Production BOM Comment Line].[Production BOM No_] = [Production BOM Line].[Production BOM No_]
AND
[Production BOM Comment Line].[BOM Line No_] = [Production BOM Line].[Line No_] | ||||||
| 3 | BOM Line No_ | int | ||||
Multi-key to join to the Production BOM Line table.Show/hide example querySELECT
[Production BOM Comment Line].[BOM Line No_]
,[Production BOM Line].[Line No_]
FROM
[CRONUS UK Ltd_$Production BOM Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Comment Line]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
ON
[Production BOM Comment Line].[BOM Line No_] = [Production BOM Line].[Line No_]
AND
[Production BOM Comment Line].[Production BOM No_] = [Production BOM Line].[Production BOM No_] | ||||||
| 4 | Version Code | nvarchar(40) | ||||
| 5 | Line No_ | int | ||||
| 6 | Date | datetime | ||||
| 7 | Comment | nvarchar(160) | ||||
| 8 | Code | nvarchar(20) | ||||
| 9 | $systemId | uniqueidentifier | ||||
| 10 | $systemCreatedAt | datetime | ||||
| 11 | $systemCreatedBy | uniqueidentifier | ||||
| 12 | $systemModifiedAt | datetime | ||||
| 13 | $systemModifiedBy | uniqueidentifier | ||||