Standard Cost Worksheet – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SStandard Cost Worksheet

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

Table Type: Company

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

Table Number: 5841

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 Standard Cost Worksheet can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Standard Cost Worksheet Name]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Implemented]
   ,[Standard Cost]
   ,[New Standard Cost]
   ,[Indirect Cost _]
   ,[New Indirect Cost _]
   ,[Overhead Rate]
   ,[New Overhead Rate]
   ,[Single-Lvl Material Cost]
   ,[New Single-Lvl Material Cost]
   ,[Single-Lvl Cap_ Cost]
   ,[New Single-Lvl Cap_ Cost]
   ,[Single-Lvl Subcontrd Cost]
   ,[New Single-Lvl Subcontrd Cost]
   ,[Single-Lvl Cap_ Ovhd Cost]
   ,[New Single-Lvl Cap_ Ovhd Cost]
   ,[Single-Lvl Mfg_ Ovhd Cost]
   ,[New Single-Lvl Mfg_ Ovhd Cost]
   ,[Rolled-up Material Cost]
   ,[New Rolled-up Material Cost]
   ,[Rolled-up Cap_ Cost]
   ,[New Rolled-up Cap_ Cost]
   ,[Rolled-up Subcontrd Cost]
   ,[New Rolled-up Subcontrd Cost]
   ,[Rolled-up Cap_ Ovhd Cost]
   ,[New Rolled-up Cap_ Ovhd Cost]
   ,[Rolled-up Mfg_ Ovhd Cost]
   ,[New Rolled-up Mfg_ Ovhd Cost]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Standard Cost Worksheet$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Cost Worksheet]
LEFT JOIN
   [User] AS [User]
      ON
         [Standard Cost Worksheet].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Standard Cost Worksheet].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Standard Cost Worksheet table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
2	Standard Cost Worksheet Name	Standard Cost Worksheet Name	Normal	Code	10	Standard Cost Worksheet Name	nvarchar(20)
3	Type	Type	Normal	Option	4	Type	int
	Available options are: “Item” “Work Center” “Machine Center” “Resource”
4	No.	No.	Normal	Code	20	No_	nvarchar(40)
5	Description	Description	Normal	Text	100	Description	nvarchar(200)
6	Implemented	Implemented	Normal	Boolean	4	Implemented	tinyint
7	Replenishment System	Replenishment System	Normal	Option	4
11	Standard Cost	Standard Cost	Normal	Decimal	12	Standard Cost	decimal(38,38)
12	New Standard Cost	New Standard Cost	Normal	Decimal	12	New Standard Cost	decimal(38,38)
13	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
14	New Indirect Cost %	New Indirect Cost %	Normal	Decimal	12	New Indirect Cost _	decimal(38,38)
15	Overhead Rate	Overhead Rate	Normal	Decimal	12	Overhead Rate	decimal(38,38)
16	New Overhead Rate	New Overhead Rate	Normal	Decimal	12	New Overhead Rate	decimal(38,38)
21	Single-Lvl Material Cost	Single-Lvl Material Cost	Normal	Decimal	12	Single-Lvl Material Cost	decimal(38,38)
22	New Single-Lvl Material Cost	New Single-Lvl Material Cost	Normal	Decimal	12	New Single-Lvl Material Cost	decimal(38,38)
23	Single-Lvl Cap. Cost	Single-Lvl Cap. Cost	Normal	Decimal	12	Single-Lvl Cap_ Cost	decimal(38,38)
24	New Single-Lvl Cap. Cost	New Single-Lvl Cap. Cost	Normal	Decimal	12	New Single-Lvl Cap_ Cost	decimal(38,38)
25	Single-Lvl Subcontrd Cost	Single-Lvl Subcontrd Cost	Normal	Decimal	12	Single-Lvl Subcontrd Cost	decimal(38,38)
26	New Single-Lvl Subcontrd Cost	New Single-Lvl Subcontrd Cost	Normal	Decimal	12	New Single-Lvl Subcontrd Cost	decimal(38,38)
27	Single-Lvl Cap. Ovhd Cost	Single-Lvl Cap. Ovhd Cost	Normal	Decimal	12	Single-Lvl Cap_ Ovhd Cost	decimal(38,38)
28	New Single-Lvl Cap. Ovhd Cost	New Single-Lvl Cap. Ovhd Cost	Normal	Decimal	12	New Single-Lvl Cap_ Ovhd Cost	decimal(38,38)
29	Single-Lvl Mfg. Ovhd Cost	Single-Lvl Mfg. Ovhd Cost	Normal	Decimal	12	Single-Lvl Mfg_ Ovhd Cost	decimal(38,38)
30	New Single-Lvl Mfg. Ovhd Cost	New Single-Lvl Mfg. Ovhd Cost	Normal	Decimal	12	New Single-Lvl Mfg_ Ovhd Cost	decimal(38,38)
41	Rolled-up Material Cost	Rolled-up Material Cost	Normal	Decimal	12	Rolled-up Material Cost	decimal(38,38)
42	New Rolled-up Material Cost	New Rolled-up Material Cost	Normal	Decimal	12	New Rolled-up Material Cost	decimal(38,38)
43	Rolled-up Cap. Cost	Rolled-up Cap. Cost	Normal	Decimal	12	Rolled-up Cap_ Cost	decimal(38,38)
44	New Rolled-up Cap. Cost	New Rolled-up Cap. Cost	Normal	Decimal	12	New Rolled-up Cap_ Cost	decimal(38,38)
45	Rolled-up Subcontrd Cost	Rolled-up Subcontrd Cost	Normal	Decimal	12	Rolled-up Subcontrd Cost	decimal(38,38)
46	New Rolled-up Subcontrd Cost	New Rolled-up Subcontrd Cost	Normal	Decimal	12	New Rolled-up Subcontrd Cost	decimal(38,38)
47	Rolled-up Cap. Ovhd Cost	Rolled-up Cap. Ovhd Cost	Normal	Decimal	12	Rolled-up Cap_ Ovhd Cost	decimal(38,38)
48	New Rolled-up Cap. Ovhd Cost	New Rolled-up Cap. Ovhd Cost	Normal	Decimal	12	New Rolled-up Cap_ Ovhd Cost	decimal(38,38)
49	Rolled-up Mfg. Ovhd Cost	Rolled-up Mfg. Ovhd Cost	Normal	Decimal	12	Rolled-up Mfg_ Ovhd Cost	decimal(38,38)
50	New Rolled-up Mfg. Ovhd Cost	New Rolled-up Mfg. Ovhd Cost	Normal	Decimal	12	New Rolled-up Mfg_ Ovhd Cost	decimal(38,38)
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 [Standard Cost Worksheet].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Standard Cost Worksheet$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Cost Worksheet] LEFT JOIN [User] AS [User] ON [Standard Cost Worksheet].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Standard Cost Worksheet].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Standard Cost Worksheet$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Cost Worksheet] LEFT JOIN [User] AS [User] ON [Standard Cost Worksheet].[$systemModifiedBy] = [User].[User Security ID]