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

   [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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	Type	Type	Normal	Option	4	Type	int
	Available options are: “” “Item” “Machine Center” “Work Center” “Resource”
3	No.	No.	Normal	Code	20	No_	nvarchar(40)
5	Description	Description	Normal	Text	100	Description	nvarchar(200)
6	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
7	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(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]
8	Location Code	Location Code	Normal	Code	10	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	Replenishment System	Normal	Option	4
10	Indentation	Indentation	Normal	Integer	4	Indentation	int
11	Is Leaf	Is Leaf	Normal	Boolean	4	Is Leaf	tinyint
13	Bottleneck	Bottleneck	Normal	Boolean	4	Bottleneck	tinyint
15	Routing No.	Routing No.	Normal	Code	20	Routing 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_]
16	Production BOM No.	Production BOM No.	Normal	Code	20	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_] 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].[Line 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].[Line 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_]
20	Lot Size	Lot Size	Normal	Decimal	12	Lot Size	decimal(38,38)
21	Low-Level Code	Low-Level Code	Normal	Integer	4	Low-Level Code	int
22	Rounding Precision	Rounding Precision	Normal	Decimal	12	Rounding Precision	decimal(38,38)
30	Qty. per Parent	Qty. per Parent	Normal	Decimal	12	Qty_ per Parent	decimal(38,38)
31	Qty. per Top Item	Qty. per Top Item	Normal	Decimal	12	Qty_ per Top Item	decimal(38,38)
32	Able to Make Top Item	Able to Make Top Item	Normal	Decimal	12	Able to Make Top Item	decimal(38,38)
33	Able to Make Parent	Able to Make Parent	Normal	Decimal	12	Able to Make Parent	decimal(38,38)
35	Available Quantity	Available Quantity	Normal	Decimal	12	Available Quantity	decimal(38,38)
36	Gross Requirement	Gross Requirement	Normal	Decimal	12	Gross Requirement	decimal(38,38)
37	Scheduled Receipts	Scheduled Receipts	Normal	Decimal	12	Scheduled Receipts	decimal(38,38)
38	Unused Quantity	Unused Quantity	Normal	Decimal	12	Unused Quantity	decimal(38,38)
40	Lead Time Calculation	Lead Time Calculation	Normal	DateFormula	32	Lead Time Calculation	varchar(32)
41	Lead-Time Offset	Lead-Time Offset	Normal	DateFormula	32	Lead-Time Offset	varchar(32)
42	Rolled-up Lead-Time Offset	Rolled-up Lead-Time Offset	Normal	Integer	4	Rolled-up Lead-Time Offset	int
43	Needed by Date	Needed by Date	Normal	Date	4	Needed by Date	datetime
45	Safety Lead Time	Safety Lead Time	Normal	DateFormula	32	Safety Lead Time	varchar(32)
50	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
52	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
54	Overhead Rate	Overhead Rate	Normal	Decimal	12	Overhead Rate	decimal(38,38)
55	Scrap %	Scrap %	Normal	Decimal	12	Scrap _	decimal(38,38)
56	Scrap Qty. per Parent	Scrap Qty. per Parent	Normal	Decimal	12	Scrap Qty_ per Parent	decimal(38,38)
57	Scrap Qty. per Top Item	Scrap Qty. per Top Item	Normal	Decimal	12	Scrap Qty_ per Top Item	decimal(38,38)
59	Resource Usage Type	Resource Usage Type	Normal	Option	4	Resource Usage Type	int
	Available options are: “Direct” “Fixed”
61	Single-Level Material Cost	Single-Level Material Cost	Normal	Decimal	12	Single-Level Material Cost	decimal(38,38)
62	Single-Level Capacity Cost	Single-Level Capacity Cost	Normal	Decimal	12	Single-Level Capacity Cost	decimal(38,38)
63	Single-Level Subcontrd. Cost	Single-Level Subcontrd. Cost	Normal	Decimal	12	Single-Level Subcontrd_ Cost	decimal(38,38)
64	Single-Level Cap. Ovhd Cost	Single-Level Cap. Ovhd Cost	Normal	Decimal	12	Single-Level Cap_ Ovhd Cost	decimal(38,38)
65	Single-Level Mfg. Ovhd Cost	Single-Level Mfg. Ovhd Cost	Normal	Decimal	12	Single-Level Mfg_ Ovhd Cost	decimal(38,38)
66	Single-Level Scrap Cost	Single-Level Scrap Cost	Normal	Decimal	12	Single-Level Scrap Cost	decimal(38,38)
71	Rolled-up Material Cost	Rolled-up Material Cost	Normal	Decimal	12	Rolled-up Material Cost	decimal(38,38)
72	Rolled-up Capacity Cost	Rolled-up Capacity Cost	Normal	Decimal	12	Rolled-up Capacity Cost	decimal(38,38)
73	Rolled-up Subcontracted Cost	Rolled-up Subcontracted Cost	Normal	Decimal	12	Rolled-up Subcontracted Cost	decimal(38,38)
74	Rolled-up Capacity Ovhd. Cost	Rolled-up Capacity Ovhd. Cost	Normal	Decimal	12	Rolled-up Capacity Ovhd_ Cost	decimal(38,38)
75	Rolled-up Mfg. Ovhd Cost	Rolled-up Mfg. Ovhd Cost	Normal	Decimal	12	Rolled-up Mfg_ Ovhd Cost	decimal(38,38)
76	Rolled-up Scrap Cost	Rolled-up Scrap Cost	Normal	Decimal	12	Rolled-up Scrap Cost	decimal(38,38)
81	Total Cost	Total Cost	Normal	Decimal	12	Total Cost	decimal(38,38)
82	BOM Unit of Measure Code	BOM Unit of Measure Code	Normal	Code	10	BOM Unit of Measure Code	nvarchar(20)
83	Qty. per BOM Line	Qty. per BOM Line	Normal	Decimal	12	Qty_ per BOM Line	decimal(38,38)
84	Inventoriable	Inventoriable	Normal	Boolean	4	Inventoriable	tinyint
85	Calculation Formula	Calculation Formula	Normal	Option	4	Calculation Formula	int
	Available options are: ” “ “Length” “Length * Width” “Length * Width * Depth” “Weight” “Fixed Quantity”
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from BOM Buffer table

Location Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables BBOM Buffer

Leave a Reply Cancel reply