Cost Share Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables CCost Share Buffer

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

Table Type: Company

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

Table Number: 5848

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Cost Share Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Item Ledger Entry No_]
   ,[Capacity Ledger Entry No_]
   ,[Item No_]
   ,[Location Code]
   ,[Variant Code]
   ,[Entry Type]
   ,[Document No_]
   ,[Description]
   ,[Quantity]
   ,[Direct Cost]
   ,[Indirect Cost]
   ,[Revaluation]
   ,[Rounding]
   ,[Variance]
   ,[Purchase Variance]
   ,[Material Variance]
   ,[Capacity Variance]
   ,[Capacity Overhead Variance]
   ,[Mfg_ Overhead Variance]
   ,[Subcontracted Variance]
   ,[Material]
   ,[Capacity]
   ,[Capacity Overhead]
   ,[Material Overhead]
   ,[Subcontracted]
   ,[New Quantity]
   ,[New Direct Cost]
   ,[New Indirect Cost]
   ,[New Revaluation]
   ,[New Rounding]
   ,[New Variance]
   ,[New Purchase Variance]
   ,[New Material Variance]
   ,[New Capacity Variance]
   ,[New Capacity Overhead Variance]
   ,[New Mfg_ Overhead Variance]
   ,[New Subcontracted Variance]
   ,[Share of Cost in Period]
   ,[New Material]
   ,[New Capacity]
   ,[New Capacity Overhead]
   ,[New Material Overhead]
   ,[New Subcontracted]
   ,[Posting Date]
   ,[Order Type]
   ,[Order No_]
   ,[Order Line No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Cost Share 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_$Cost Share Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Share Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Cost Share Buffer].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Cost Share Buffer].[Location Code] = [Location].[Code]

Show/hide columns in Cost Share Buffer table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Item Ledger Entry No_	int
3	Capacity Ledger Entry No_	int
4	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Cost Share Buffer].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Cost Share Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Share Buffer] LEFT JOIN [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Cost Share Buffer].[Item No_] = [Item].[No_]
5	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Cost Share Buffer].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Cost Share Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cost Share Buffer] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Cost Share Buffer].[Location Code] = [Location].[Code]
6	Variant Code	nvarchar(20)
7	Entry Type	int
8	Document No_	nvarchar(40)
9	Description	nvarchar(200)
10	Quantity	decimal(38,38)
11	Direct Cost	decimal(38,38)
12	Indirect Cost	decimal(38,38)
13	Revaluation	decimal(38,38)
14	Rounding	decimal(38,38)
15	Variance	decimal(38,38)
16	Purchase Variance	decimal(38,38)
17	Material Variance	decimal(38,38)
18	Capacity Variance	decimal(38,38)
19	Capacity Overhead Variance	decimal(38,38)
20	Mfg_ Overhead Variance	decimal(38,38)
21	Subcontracted Variance	decimal(38,38)
22	Material	decimal(38,38)
23	Capacity	decimal(38,38)
24	Capacity Overhead	decimal(38,38)
25	Material Overhead	decimal(38,38)
26	Subcontracted	decimal(38,38)
27	New Quantity	decimal(38,38)
28	New Direct Cost	decimal(38,38)
29	New Indirect Cost	decimal(38,38)
30	New Revaluation	decimal(38,38)
31	New Rounding	decimal(38,38)
32	New Variance	decimal(38,38)
33	New Purchase Variance	decimal(38,38)
34	New Material Variance	decimal(38,38)
35	New Capacity Variance	decimal(38,38)
36	New Capacity Overhead Variance	decimal(38,38)
37	New Mfg_ Overhead Variance	decimal(38,38)
38	New Subcontracted Variance	decimal(38,38)
39	Share of Cost in Period	decimal(38,38)
40	New Material	decimal(38,38)
41	New Capacity	decimal(38,38)
42	New Capacity Overhead	decimal(38,38)
43	New Material Overhead	decimal(38,38)
44	New Subcontracted	decimal(38,38)
45	Posting Date	datetime
46	Order Type	int
47	Order No_	nvarchar(40)
48	Order Line No_	int
49	$systemId	uniqueidentifier
50	$systemCreatedAt	datetime
51	$systemCreatedBy	uniqueidentifier
52	$systemModifiedAt	datetime
53	$systemModifiedBy	uniqueidentifier