Standard Cost Worksheet

Dynamics 365 BC Table ReferenceTablesCompany TablesSStandard 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2Standard Cost Worksheet Name SearchStandard Cost Worksheet NameNormalCode10Standard Cost Worksheet Namenvarchar(20)
3Type Primary Key SearchTypeNormalOption4Typeint
Available options are:
  • “Item”
  • “Work Center”
  • “Machine Center”
  • “Resource”
4No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
5Description Primary Key SearchDescriptionNormalText100Descriptionnvarchar(200)
6Implemented SearchImplementedNormalBoolean4Implementedtinyint
7Replenishment System SearchReplenishment SystemNormalOption4
11Standard Cost SearchStandard CostNormalDecimal12Standard Costdecimal(38,38)
12New Standard Cost SearchNew Standard CostNormalDecimal12New Standard Costdecimal(38,38)
13Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
14New Indirect Cost % SearchNew Indirect Cost %NormalDecimal12New Indirect Cost _decimal(38,38)
15Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
16New Overhead Rate SearchNew Overhead RateNormalDecimal12New Overhead Ratedecimal(38,38)
21Single-Lvl Material Cost SearchSingle-Lvl Material CostNormalDecimal12Single-Lvl Material Costdecimal(38,38)
22New Single-Lvl Material Cost SearchNew Single-Lvl Material CostNormalDecimal12New Single-Lvl Material Costdecimal(38,38)
23Single-Lvl Cap. Cost SearchSingle-Lvl Cap. CostNormalDecimal12Single-Lvl Cap_ Costdecimal(38,38)
24New Single-Lvl Cap. Cost SearchNew Single-Lvl Cap. CostNormalDecimal12New Single-Lvl Cap_ Costdecimal(38,38)
25Single-Lvl Subcontrd Cost SearchSingle-Lvl Subcontrd CostNormalDecimal12Single-Lvl Subcontrd Costdecimal(38,38)
26New Single-Lvl Subcontrd Cost SearchNew Single-Lvl Subcontrd CostNormalDecimal12New Single-Lvl Subcontrd Costdecimal(38,38)
27Single-Lvl Cap. Ovhd Cost SearchSingle-Lvl Cap. Ovhd CostNormalDecimal12Single-Lvl Cap_ Ovhd Costdecimal(38,38)
28New Single-Lvl Cap. Ovhd Cost SearchNew Single-Lvl Cap. Ovhd CostNormalDecimal12New Single-Lvl Cap_ Ovhd Costdecimal(38,38)
29Single-Lvl Mfg. Ovhd Cost SearchSingle-Lvl Mfg. Ovhd CostNormalDecimal12Single-Lvl Mfg_ Ovhd Costdecimal(38,38)
30New Single-Lvl Mfg. Ovhd Cost SearchNew Single-Lvl Mfg. Ovhd CostNormalDecimal12New Single-Lvl Mfg_ Ovhd Costdecimal(38,38)
41Rolled-up Material Cost SearchRolled-up Material CostNormalDecimal12Rolled-up Material Costdecimal(38,38)
42New Rolled-up Material Cost SearchNew Rolled-up Material CostNormalDecimal12New Rolled-up Material Costdecimal(38,38)
43Rolled-up Cap. Cost SearchRolled-up Cap. CostNormalDecimal12Rolled-up Cap_ Costdecimal(38,38)
44New Rolled-up Cap. Cost SearchNew Rolled-up Cap. CostNormalDecimal12New Rolled-up Cap_ Costdecimal(38,38)
45Rolled-up Subcontrd Cost SearchRolled-up Subcontrd CostNormalDecimal12Rolled-up Subcontrd Costdecimal(38,38)
46New Rolled-up Subcontrd Cost SearchNew Rolled-up Subcontrd CostNormalDecimal12New Rolled-up Subcontrd Costdecimal(38,38)
47Rolled-up Cap. Ovhd Cost SearchRolled-up Cap. Ovhd CostNormalDecimal12Rolled-up Cap_ Ovhd Costdecimal(38,38)
48New Rolled-up Cap. Ovhd Cost SearchNew Rolled-up Cap. Ovhd CostNormalDecimal12New Rolled-up Cap_ Ovhd Costdecimal(38,38)
49Rolled-up Mfg. Ovhd Cost SearchRolled-up Mfg. Ovhd CostNormalDecimal12Rolled-up Mfg_ Ovhd Costdecimal(38,38)
50New Rolled-up Mfg. Ovhd Cost SearchNew Rolled-up Mfg. Ovhd CostNormalDecimal12New Rolled-up Mfg_ Ovhd Costdecimal(38,38)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesSStandard Cost Worksheet

Leave a Reply

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