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
   [timestamp]
   ,[Entry No_]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Unit of Measure Code]
   ,[Variant Code]
   ,[Location Code]
   ,[Replenishment System]
   ,[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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [BOM Buffer].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [BOM Buffer].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
      ON
         [BOM Buffer].[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
         [BOM Buffer].[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
         [BOM Buffer].[Production BOM No_] = [Production BOM Line].[Production BOM No_]

Show/hide columns in BOM Buffer table

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

Show/hide example query

SELECT
       [BOM Buffer].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$BOM Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [BOM Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [BOM Buffer].[Unit of Measure Code] = [Unit of Measure].[Code]
7Variant Code Searchnvarchar(20)
8Location Code Searchnvarchar(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 Searchint
10Indentation Searchint
11Is Leaf Searchtinyint
12Bottleneck Searchtinyint
13Routing No_ Searchnvarchar(40)
14Production BOM No_ Searchnvarchar(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_]
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_]
15Lot Size Searchdecimal(38,38)
16Low-Level Code Searchint
17Rounding Precision Searchdecimal(38,38)
18Qty_ per Parent Searchdecimal(38,38)
19Qty_ per Top Item Searchdecimal(38,38)
20Able to Make Top Item Searchdecimal(38,38)
21Able to Make Parent Searchdecimal(38,38)
22Available Quantity Searchdecimal(38,38)
23Gross Requirement Searchdecimal(38,38)
24Scheduled Receipts Searchdecimal(38,38)
25Unused Quantity Searchdecimal(38,38)
26Lead Time Calculation Searchvarchar(32)
27Lead-Time Offset Searchvarchar(32)
28Rolled-up Lead-Time Offset Searchint
29Needed by Date Searchdatetime
30Safety Lead Time Searchvarchar(32)
31Unit Cost Searchdecimal(38,38)
32Indirect Cost _ Searchdecimal(38,38)
33Overhead Rate Searchdecimal(38,38)
34Scrap _ Searchdecimal(38,38)
35Scrap Qty_ per Parent Searchdecimal(38,38)
36Scrap Qty_ per Top Item Searchdecimal(38,38)
37Resource Usage Type Searchint
38Single-Level Material Cost Searchdecimal(38,38)
39Single-Level Capacity Cost Searchdecimal(38,38)
40Single-Level Subcontrd_ Cost Searchdecimal(38,38)
41Single-Level Cap_ Ovhd Cost Searchdecimal(38,38)
42Single-Level Mfg_ Ovhd Cost Searchdecimal(38,38)
43Single-Level Scrap Cost Searchdecimal(38,38)
44Rolled-up Material Cost Searchdecimal(38,38)
45Rolled-up Capacity Cost Searchdecimal(38,38)
46Rolled-up Subcontracted Cost Searchdecimal(38,38)
47Rolled-up Capacity Ovhd_ Cost Searchdecimal(38,38)
48Rolled-up Mfg_ Ovhd Cost Searchdecimal(38,38)
49Rolled-up Scrap Cost Searchdecimal(38,38)
50Total Cost Searchdecimal(38,38)
51BOM Unit of Measure Code Searchnvarchar(20)
52Qty_ per BOM Line Searchdecimal(38,38)
53Inventoriable Searchtinyint
54Calculation Formula Searchint
55$systemId Searchuniqueidentifier
56$systemCreatedAt Searchdatetime
57$systemCreatedBy Searchuniqueidentifier
58$systemModifiedAt Searchdatetime
59$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from BOM Buffer table

Leave a Reply

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