BOM Component

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/90

Table Type: Company

Table Name: BOM Component
Database Table Name: CRONUS UK Ltd_$BOM Component$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Parent Item No_]
   ,[Line No_]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Unit of Measure Code]
   ,[Quantity per]
   ,[Position]
   ,[Position 2]
   ,[Position 3]
   ,[Machine No_]
   ,[Lead-Time Offset]
   ,[Resource Usage Type]
   ,[Variant Code]
   ,[Installed in Line No_]
   ,[Installed in Item No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$BOM Component$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$BOM Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Component]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [BOM Component].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in BOM Component table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Parent Item No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Type Searchint
5No_ Searchnvarchar(40)
6Description Searchnvarchar(200)
7Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [BOM Component].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$BOM Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Component]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [BOM Component].[Unit of Measure Code] = [Unit of Measure].[Code]
8Quantity per Searchdecimal(38,38)
9Position Searchnvarchar(20)
10Position 2 Searchnvarchar(20)
11Position 3 Searchnvarchar(20)
12Machine No_ Searchnvarchar(20)
13Lead-Time Offset Searchvarchar(32)
14Resource Usage Type Searchint
15Variant Code Searchnvarchar(20)
16Installed in Line No_ Searchint
17Installed in Item No_ Searchnvarchar(40)
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from BOM Component table

Leave a Reply

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