Production BOM Line

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

Table Type: Company

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

Table Number: 99000772

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Production BOM No_]
   ,[Line No_]
   ,[Version Code]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Unit of Measure Code]
   ,[Quantity]
   ,[Position]
   ,[Position 2]
   ,[Position 3]
   ,[Lead-Time Offset]
   ,[Routing Link Code]
   ,[Scrap _]
   ,[Variant Code]
   ,[Starting Date]
   ,[Ending Date]
   ,[Length]
   ,[Width]
   ,[Weight]
   ,[Depth]
   ,[Calculation Formula]
   ,[Quantity per]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Production BOM 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 Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
LEFT JOIN
   [CRONUS UK Ltd_$Routing Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Link]
      ON
         [Production BOM Line].[Routing Link Code] = [Routing Link].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Production BOM Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Production BOM Line].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [User] AS [User]
      ON
         [Production BOM Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Production BOM Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Production BOM Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Production BOM No. Primary Key SearchProduction BOM No.NormalCode20Production BOM No_nvarchar(40)
Key to join to the Production BOM Header table.

Show/hide example query

SELECT
       [Production BOM Line].[Production BOM No_]
       ,[Production BOM Header].[No_]
FROM
       [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
LEFT JOIN
       [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
              ON
                     [Production BOM Line].[Production BOM No_] = [Production BOM Header].[No_]
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Version Code Primary Key SearchVersion CodeNormalCode20Version Codenvarchar(40)
10Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Item”
  • “Production BOM”
11No. SearchNo.NormalCode20No_nvarchar(40)
12Description SearchDescriptionNormalText100Descriptionnvarchar(200)
13Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
14Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
15Position SearchPositionNormalCode10Positionnvarchar(20)
16Position 2 SearchPosition 2NormalCode10Position 2nvarchar(20)
17Position 3 SearchPosition 3NormalCode10Position 3nvarchar(20)
18Lead-Time Offset SearchLead-Time OffsetNormalDateFormula32Lead-Time Offsetvarchar(32)
19Routing Link Code SearchRouting Link CodeNormalCode10Routing Link Codenvarchar(20)
Key to join to the Routing Link table.

Show/hide example query

SELECT
       [Production BOM Line].[Routing Link Code]
       ,[Routing Link].[Code]
FROM
       [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
LEFT JOIN
       [CRONUS UK Ltd_$Routing Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Link]
              ON
                     [Production BOM Line].[Routing Link Code] = [Routing Link].[Code]
20Scrap % SearchScrap %NormalDecimal12Scrap _decimal(38,38)
21Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Production BOM Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Production BOM Line].[Variant Code] = [Item Variant].[Code]
22Comment SearchCommentFlowFieldBoolean4
28Starting Date SearchStarting DateNormalDate4Starting Datedatetime
29Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [Production BOM Line].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Production BOM Line].[Ending Date] = [Inventory Period].[Ending Date]
40Length SearchLengthNormalDecimal12Lengthdecimal(38,38)
41Width SearchWidthNormalDecimal12Widthdecimal(38,38)
42Weight SearchWeightNormalDecimal12Weightdecimal(38,38)
43Depth SearchDepthNormalDecimal12Depthdecimal(38,38)
44Calculation Formula SearchCalculation FormulaNormalOption4Calculation Formulaint
Available options are:
  • ” “
  • “Length”
  • “Length * Width”
  • “Length * Width * Depth”
  • “Weight”
  • “Fixed Quantity”
45Quantity per SearchQuantity perNormalDecimal12Quantity perdecimal(38,38)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Production BOM Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Production BOM Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Production BOM Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Production BOM Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Production BOM Line table

Leave a Reply

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