Production BOM Version

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: 99000779

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 Version can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[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]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
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].[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 Version].[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 Version].[Production BOM No_] = [Production BOM Line].[Production BOM No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Production BOM Version].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Production BOM Version table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Production BOM No_ Primary Key Searchnvarchar(40)
Key to join to the Production BOM Header table.

Show/hide example query

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_]
Multi-key to join to the Production BOM Line table.

Show/hide example query

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_]
              AND
                     [Production BOM Version].[BOM Line No_] = [Production BOM Line].[Line No_]
3Version Code Primary Key Searchnvarchar(40)
4Description Searchnvarchar(200)
5Starting Date Searchdatetime
6Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Production BOM Version].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Production BOM Version$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Version]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Production BOM Version].[Unit of Measure Code] = [Unit of Measure].[Code]
7Last Date Modified Searchdatetime
8Status Searchint
9No_ Series Searchnvarchar(40)
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Production BOM Version table

Leave a Reply

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