BOM Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables BBOM 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Type	int
4	No_	nvarchar(40)
5	Description	nvarchar(200)
6	Unit of Measure Code	nvarchar(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]
7	Variant Code	nvarchar(20)
8	Location Code	nvarchar(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]
9	Replenishment System	int
10	Indentation	int
11	Is Leaf	tinyint
12	Bottleneck	tinyint
13	Routing No_	nvarchar(40)
14	Production 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_] 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_]
15	Lot Size	decimal(38,38)
16	Low-Level Code	int
17	Rounding Precision	decimal(38,38)
18	Qty_ per Parent	decimal(38,38)
19	Qty_ per Top Item	decimal(38,38)
20	Able to Make Top Item	decimal(38,38)
21	Able to Make Parent	decimal(38,38)
22	Available Quantity	decimal(38,38)
23	Gross Requirement	decimal(38,38)
24	Scheduled Receipts	decimal(38,38)
25	Unused Quantity	decimal(38,38)
26	Lead Time Calculation	varchar(32)
27	Lead-Time Offset	varchar(32)
28	Rolled-up Lead-Time Offset	int
29	Needed by Date	datetime
30	Safety Lead Time	varchar(32)
31	Unit Cost	decimal(38,38)
32	Indirect Cost _	decimal(38,38)
33	Overhead Rate	decimal(38,38)
34	Scrap _	decimal(38,38)
35	Scrap Qty_ per Parent	decimal(38,38)
36	Scrap Qty_ per Top Item	decimal(38,38)
37	Resource Usage Type	int
38	Single-Level Material Cost	decimal(38,38)
39	Single-Level Capacity Cost	decimal(38,38)
40	Single-Level Subcontrd_ Cost	decimal(38,38)
41	Single-Level Cap_ Ovhd Cost	decimal(38,38)
42	Single-Level Mfg_ Ovhd Cost	decimal(38,38)
43	Single-Level Scrap Cost	decimal(38,38)
44	Rolled-up Material Cost	decimal(38,38)
45	Rolled-up Capacity Cost	decimal(38,38)
46	Rolled-up Subcontracted Cost	decimal(38,38)
47	Rolled-up Capacity Ovhd_ Cost	decimal(38,38)
48	Rolled-up Mfg_ Ovhd Cost	decimal(38,38)
49	Rolled-up Scrap Cost	decimal(38,38)
50	Total Cost	decimal(38,38)
51	BOM Unit of Measure Code	nvarchar(20)
52	Qty_ per BOM Line	decimal(38,38)
53	Inventoriable	tinyint
54	Calculation Formula	int
55	$systemId	uniqueidentifier
56	$systemCreatedAt	datetime
57	$systemCreatedBy	uniqueidentifier
58	$systemModifiedAt	datetime
59	$systemModifiedBy	uniqueidentifier

Show/hide tables related from BOM Buffer table

Location Production BOM Header Production BOM Line Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables BBOM Buffer

Leave a Reply Cancel reply