Cost 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Item Ledger Entry No_ Primary Key Searchint
3Capacity Ledger Entry No_ Primary Key Searchint
4Item No_ Searchnvarchar(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_]
5Location Code Searchnvarchar(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]
6Variant Code Searchnvarchar(20)
7Entry Type Searchint
8Document No_ Searchnvarchar(40)
9Description Searchnvarchar(200)
10Quantity Searchdecimal(38,38)
11Direct Cost Searchdecimal(38,38)
12Indirect Cost Searchdecimal(38,38)
13Revaluation Searchdecimal(38,38)
14Rounding Searchdecimal(38,38)
15Variance Searchdecimal(38,38)
16Purchase Variance Searchdecimal(38,38)
17Material Variance Searchdecimal(38,38)
18Capacity Variance Searchdecimal(38,38)
19Capacity Overhead Variance Searchdecimal(38,38)
20Mfg_ Overhead Variance Searchdecimal(38,38)
21Subcontracted Variance Searchdecimal(38,38)
22Material Searchdecimal(38,38)
23Capacity Searchdecimal(38,38)
24Capacity Overhead Searchdecimal(38,38)
25Material Overhead Searchdecimal(38,38)
26Subcontracted Searchdecimal(38,38)
27New Quantity Searchdecimal(38,38)
28New Direct Cost Searchdecimal(38,38)
29New Indirect Cost Searchdecimal(38,38)
30New Revaluation Searchdecimal(38,38)
31New Rounding Searchdecimal(38,38)
32New Variance Searchdecimal(38,38)
33New Purchase Variance Searchdecimal(38,38)
34New Material Variance Searchdecimal(38,38)
35New Capacity Variance Searchdecimal(38,38)
36New Capacity Overhead Variance Searchdecimal(38,38)
37New Mfg_ Overhead Variance Searchdecimal(38,38)
38New Subcontracted Variance Searchdecimal(38,38)
39Share of Cost in Period Searchdecimal(38,38)
40New Material Searchdecimal(38,38)
41New Capacity Searchdecimal(38,38)
42New Capacity Overhead Searchdecimal(38,38)
43New Material Overhead Searchdecimal(38,38)
44New Subcontracted Searchdecimal(38,38)
45Posting Date Searchdatetime
46Order Type Searchint
47Order No_ Searchnvarchar(40)
48Order Line No_ Searchint
49$systemId Searchuniqueidentifier
50$systemCreatedAt Searchdatetime
51$systemCreatedBy Searchuniqueidentifier
52$systemModifiedAt Searchdatetime
53$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Cost Share Buffer table

Leave a Reply

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