BOM Buffer

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

Table Type: Company

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

Table Number: 5870

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Entry No_]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Unit of Measure Code]
   ,[Variant Code]
   ,[Location Code]
   ,[Indentation]
   ,[Is Leaf]
   ,[Bottleneck]
   ,[Routing No_]
   ,[Production BOM No_]
   ,[Lot Size]
   ,[Low-Level Code]
   ,[Rounding Precision]
   ,[Qty_ per Parent]
   ,[Qty_ per Top Item]
   ,[Able to Make Top Item]
   ,[Able to Make Parent]
   ,[Available Quantity]
   ,[Gross Requirement]
   ,[Scheduled Receipts]
   ,[Unused Quantity]
   ,[Lead Time Calculation]
   ,[Lead-Time Offset]
   ,[Rolled-up Lead-Time Offset]
   ,[Needed by Date]
   ,[Safety Lead Time]
   ,[Unit Cost]
   ,[Indirect Cost _]
   ,[Overhead Rate]
   ,[Scrap _]
   ,[Scrap Qty_ per Parent]
   ,[Scrap Qty_ per Top Item]
   ,[Resource Usage Type]
   ,[Single-Level Material Cost]
   ,[Single-Level Capacity Cost]
   ,[Single-Level Subcontrd_ Cost]
   ,[Single-Level Cap_ Ovhd Cost]
   ,[Single-Level Mfg_ Ovhd Cost]
   ,[Single-Level Scrap Cost]
   ,[Rolled-up Material Cost]
   ,[Rolled-up Capacity Cost]
   ,[Rolled-up Subcontracted Cost]
   ,[Rolled-up Capacity Ovhd_ Cost]
   ,[Rolled-up Mfg_ Ovhd Cost]
   ,[Rolled-up Scrap Cost]
   ,[Total Cost]
   ,[BOM Unit of Measure Code]
   ,[Qty_ per BOM Line]
   ,[Inventoriable]
   ,[Calculation Formula]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$BOM Buffer$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 Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [BOM Buffer].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [BOM Buffer].[Location Code] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [BOM Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [BOM Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in BOM Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Type SearchTypeNormalOption4Typeint
Available options are:
  • “”
  • “Item”
  • “Machine Center”
  • “Work Center”
  • “Resource”
3No. SearchNo.NormalCode20No_nvarchar(40)
5Description SearchDescriptionNormalText100Descriptionnvarchar(200)
6Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
7Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [BOM Buffer].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$BOM Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [BOM Buffer].[Variant Code] = [Item Variant].[Code]
8Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [BOM Buffer].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$BOM Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [BOM Buffer].[Location Code] = [Location].[Code]
9Replenishment System SearchReplenishment SystemNormalOption4
10Indentation SearchIndentationNormalInteger4Indentationint
11Is Leaf SearchIs LeafNormalBoolean4Is Leaftinyint
13Bottleneck SearchBottleneckNormalBoolean4Bottlenecktinyint
15Routing No. SearchRouting No.NormalCode20Routing No_nvarchar(40)
Key to join to the Routing Header table.

Show/hide example query

SELECT
       [BOM Buffer].[Routing No_]
       ,[Routing Header].[No_]
FROM
       [CRONUS UK Ltd_$BOM Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header]
              ON
                     [BOM Buffer].[Routing No_] = [Routing Header].[No_]
16Production BOM No. SearchProduction BOM No.NormalCode20Production BOM No_nvarchar(40)
Key to join to the Production BOM Header table.

Show/hide example query

SELECT
       [BOM Buffer].[Production BOM No_]
       ,[Production BOM Header].[No_]
FROM
       [CRONUS UK Ltd_$BOM Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
              ON
                     [BOM Buffer].[Production BOM No_] = [Production BOM Header].[No_]
Part of multi-key to join to the Production BOM Line table.

Show/hide example query

SELECT
       [BOM Buffer].[Production BOM No_]
       ,[Production BOM Line].[Production BOM No_]
FROM
       [CRONUS UK Ltd_$BOM Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
              ON
                     [BOM Buffer].[Production BOM No_] = [Production BOM Line].[Production BOM No_]
              AND
                     [BOM Buffer].[BOM Line No_] = [Production BOM Line].[Line No_]
20Lot Size SearchLot SizeNormalDecimal12Lot Sizedecimal(38,38)
21Low-Level Code SearchLow-Level CodeNormalInteger4Low-Level Codeint
22Rounding Precision SearchRounding PrecisionNormalDecimal12Rounding Precisiondecimal(38,38)
30Qty. per Parent SearchQty. per ParentNormalDecimal12Qty_ per Parentdecimal(38,38)
31Qty. per Top Item SearchQty. per Top ItemNormalDecimal12Qty_ per Top Itemdecimal(38,38)
32Able to Make Top Item SearchAble to Make Top ItemNormalDecimal12Able to Make Top Itemdecimal(38,38)
33Able to Make Parent SearchAble to Make ParentNormalDecimal12Able to Make Parentdecimal(38,38)
35Available Quantity SearchAvailable QuantityNormalDecimal12Available Quantitydecimal(38,38)
36Gross Requirement SearchGross RequirementNormalDecimal12Gross Requirementdecimal(38,38)
37Scheduled Receipts SearchScheduled ReceiptsNormalDecimal12Scheduled Receiptsdecimal(38,38)
38Unused Quantity SearchUnused QuantityNormalDecimal12Unused Quantitydecimal(38,38)
40Lead Time Calculation SearchLead Time CalculationNormalDateFormula32Lead Time Calculationvarchar(32)
41Lead-Time Offset SearchLead-Time OffsetNormalDateFormula32Lead-Time Offsetvarchar(32)
42Rolled-up Lead-Time Offset SearchRolled-up Lead-Time OffsetNormalInteger4Rolled-up Lead-Time Offsetint
43Needed by Date SearchNeeded by DateNormalDate4Needed by Datedatetime
45Safety Lead Time SearchSafety Lead TimeNormalDateFormula32Safety Lead Timevarchar(32)
50Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
52Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
54Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
55Scrap % SearchScrap %NormalDecimal12Scrap _decimal(38,38)
56Scrap Qty. per Parent SearchScrap Qty. per ParentNormalDecimal12Scrap Qty_ per Parentdecimal(38,38)
57Scrap Qty. per Top Item SearchScrap Qty. per Top ItemNormalDecimal12Scrap Qty_ per Top Itemdecimal(38,38)
59Resource Usage Type SearchResource Usage TypeNormalOption4Resource Usage Typeint
Available options are:
  • “Direct”
  • “Fixed”
61Single-Level Material Cost SearchSingle-Level Material CostNormalDecimal12Single-Level Material Costdecimal(38,38)
62Single-Level Capacity Cost SearchSingle-Level Capacity CostNormalDecimal12Single-Level Capacity Costdecimal(38,38)
63Single-Level Subcontrd. Cost SearchSingle-Level Subcontrd. CostNormalDecimal12Single-Level Subcontrd_ Costdecimal(38,38)
64Single-Level Cap. Ovhd Cost SearchSingle-Level Cap. Ovhd CostNormalDecimal12Single-Level Cap_ Ovhd Costdecimal(38,38)
65Single-Level Mfg. Ovhd Cost SearchSingle-Level Mfg. Ovhd CostNormalDecimal12Single-Level Mfg_ Ovhd Costdecimal(38,38)
66Single-Level Scrap Cost SearchSingle-Level Scrap CostNormalDecimal12Single-Level Scrap Costdecimal(38,38)
71Rolled-up Material Cost SearchRolled-up Material CostNormalDecimal12Rolled-up Material Costdecimal(38,38)
72Rolled-up Capacity Cost SearchRolled-up Capacity CostNormalDecimal12Rolled-up Capacity Costdecimal(38,38)
73Rolled-up Subcontracted Cost SearchRolled-up Subcontracted CostNormalDecimal12Rolled-up Subcontracted Costdecimal(38,38)
74Rolled-up Capacity Ovhd. Cost SearchRolled-up Capacity Ovhd. CostNormalDecimal12Rolled-up Capacity Ovhd_ Costdecimal(38,38)
75Rolled-up Mfg. Ovhd Cost SearchRolled-up Mfg. Ovhd CostNormalDecimal12Rolled-up Mfg_ Ovhd Costdecimal(38,38)
76Rolled-up Scrap Cost SearchRolled-up Scrap CostNormalDecimal12Rolled-up Scrap Costdecimal(38,38)
81Total Cost SearchTotal CostNormalDecimal12Total Costdecimal(38,38)
82BOM Unit of Measure Code SearchBOM Unit of Measure CodeNormalCode10BOM Unit of Measure Codenvarchar(20)
83Qty. per BOM Line SearchQty. per BOM LineNormalDecimal12Qty_ per BOM Linedecimal(38,38)
84Inventoriable SearchInventoriableNormalBoolean4Inventoriabletinyint
85Calculation Formula SearchCalculation FormulaNormalOption4Calculation Formulaint
Available options are:
  • ” “
  • “Length”
  • “Length * Width”
  • “Length * Width * Depth”
  • “Weight”
  • “Fixed Quantity”
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
       [BOM Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$BOM Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [BOM Buffer].[$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
       [BOM Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$BOM Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [BOM Buffer].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from BOM Buffer table

Leave a Reply

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