Standard 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
   [timestamp]
   ,[Standard Cost Worksheet Name]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Implemented]
   ,[Replenishment System]
   ,[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 columns in Standard Cost Worksheet table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Standard Cost Worksheet Name Primary Key Searchnvarchar(20)
3Type Primary Key Searchint
4No_ Primary Key Searchnvarchar(40)
5Description Searchnvarchar(200)
6Implemented Searchtinyint
7Replenishment System Searchint
8Standard Cost Searchdecimal(38,38)
9New Standard Cost Searchdecimal(38,38)
10Indirect Cost _ Searchdecimal(38,38)
11New Indirect Cost _ Searchdecimal(38,38)
12Overhead Rate Searchdecimal(38,38)
13New Overhead Rate Searchdecimal(38,38)
14Single-Lvl Material Cost Searchdecimal(38,38)
15New Single-Lvl Material Cost Searchdecimal(38,38)
16Single-Lvl Cap_ Cost Searchdecimal(38,38)
17New Single-Lvl Cap_ Cost Searchdecimal(38,38)
18Single-Lvl Subcontrd Cost Searchdecimal(38,38)
19New Single-Lvl Subcontrd Cost Searchdecimal(38,38)
20Single-Lvl Cap_ Ovhd Cost Searchdecimal(38,38)
21New Single-Lvl Cap_ Ovhd Cost Searchdecimal(38,38)
22Single-Lvl Mfg_ Ovhd Cost Searchdecimal(38,38)
23New Single-Lvl Mfg_ Ovhd Cost Searchdecimal(38,38)
24Rolled-up Material Cost Searchdecimal(38,38)
25New Rolled-up Material Cost Searchdecimal(38,38)
26Rolled-up Cap_ Cost Searchdecimal(38,38)
27New Rolled-up Cap_ Cost Searchdecimal(38,38)
28Rolled-up Subcontrd Cost Searchdecimal(38,38)
29New Rolled-up Subcontrd Cost Searchdecimal(38,38)
30Rolled-up Cap_ Ovhd Cost Searchdecimal(38,38)
31New Rolled-up Cap_ Ovhd Cost Searchdecimal(38,38)
32Rolled-up Mfg_ Ovhd Cost Searchdecimal(38,38)
33New Rolled-up Mfg_ Ovhd Cost Searchdecimal(38,38)
34$systemId Searchuniqueidentifier
35$systemCreatedAt Searchdatetime
36$systemCreatedBy Searchuniqueidentifier
37$systemModifiedAt Searchdatetime
38$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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