Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/99000779
Table Type: Company
Table Name: Production BOM Version
Database Table Name: CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 99000779Due 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 Version can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Production BOM No_]
,[Version Code]
,[Description]
,[Starting Date]
,[Unit of Measure Code]
,[Last Date Modified]
,[Status]
,[No_ Series]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Version]
LEFT JOIN
[User] AS [User]
ON
[Production BOM Version].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Production BOM Version].[SystemModifiedBy] = [User].[User Security ID]
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|
1 | Production BOM No. | Production BOM No. | Normal | Code | 20 | Production BOM No_ | nvarchar(40) |
| Key to join to the Production BOM Header table.SELECT
[Production BOM Version].[Production BOM No_]
,[Production BOM Header].[No_]
FROM
[CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Version]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
ON
[Production BOM Version].[Production BOM No_] = [Production BOM Header].[No_] Part of multi-key to join to the Production BOM Line table.SELECT
[Production BOM Version].[Production BOM No_]
,[Production BOM Line].[Line No_]
FROM
[CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Version]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
ON
[Production BOM Version].[Production BOM No_] = [Production BOM Line].[Line No_] Part of multi-key to join to the Production BOM Line table.SELECT
[Production BOM Version].[Production BOM No_]
,[Production BOM Line].[Production BOM No_]
FROM
[CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Version]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
ON
[Production BOM Version].[Production BOM No_] = [Production BOM Line].[Production BOM No_] |
2 | Version Code | Version Code | Normal | Code | 20 | Version Code | nvarchar(40) |
3 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
10 | Starting Date | Starting Date | Normal | Date | 4 | Starting Date | datetime |
21 | Unit of Measure Code | Unit of Measure Code | Normal | Code | 10 | Unit of Measure Code | nvarchar(20) |
22 | Last Date Modified | Last Date Modified | Normal | Date | 4 | Last Date Modified | datetime |
45 | Status | Status | Normal | Option | 4 | Status | int |
| Available options are:
- “New”
- “Certified”
- “Under Development”
- “Closed”
|
50 | No. Series | No. Series | Normal | Code | 20 | No_ Series | nvarchar(40) |
| Key to join to the No. Series table.SELECT
[Production BOM Version].[No_ Series]
,[No. Series].[Code]
FROM
[CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Version]
LEFT JOIN
[CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
ON
[Production BOM Version].[No_ Series] = [No. Series].[Code] |
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.SELECT
[Production BOM Version].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Version]
LEFT JOIN
[User] AS [User]
ON
[Production BOM Version].[$systemCreatedBy] = [User].[User Security ID] |
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |