Average Cost Calc_ Overview – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAverage Cost Calc_ Overview

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

Table Type: Company

Table Name: Average Cost Calc_ Overview
Database Table Name: CRONUS UK Ltd_$Average Cost Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5847

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 Average Cost Calc_ Overview can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Average Cost Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Entry No_]
   ,[Type]
   ,[Valuation Date]
   ,[Item No_]
   ,[Location Code]
   ,[Variant Code]
   ,[Cost is Adjusted]
   ,[Attached to Entry No_]
   ,[Attached to Valuation Date]
   ,[Level]
   ,[Item Ledger Entry No_]
   ,[Posting Date]
   ,[Entry Type]
   ,[Document Type]
   ,[Document No_]
   ,[Document Line No_]
   ,[Description]
   ,[Quantity]
   ,[Applied Quantity]
   ,[Cost Amount (Expected)]
   ,[Cost Amount (Actual)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Average Cost Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Average Cost Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Average Cost Calc_ Overview]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Average Cost Calc_ Overview].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Average Cost Calc_ Overview].[Location Code] = [Location].[Code]

Show/hide columns in Average Cost Calc_ Overview table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Type	int
4	Valuation Date	datetime
5	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Average Cost Calc_ Overview].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Average Cost Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Average Cost Calc_ Overview] LEFT JOIN [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Average Cost Calc_ Overview].[Item No_] = [Item].[No_]
6	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Average Cost Calc_ Overview].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Average Cost Calc_ Overview$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Average Cost Calc_ Overview] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Average Cost Calc_ Overview].[Location Code] = [Location].[Code]
7	Variant Code	nvarchar(20)
8	Cost is Adjusted	tinyint
9	Attached to Entry No_	int
10	Attached to Valuation Date	datetime
11	Level	int
12	Item Ledger Entry No_	int
13	Posting Date	datetime
14	Entry Type	int
15	Document Type	int
16	Document No_	nvarchar(40)
17	Document Line No_	int
18	Description	nvarchar(200)
19	Quantity	decimal(38,38)
20	Applied Quantity	int
21	Cost Amount (Expected)	decimal(38,38)
22	Cost Amount (Actual)	decimal(38,38)
23	$systemId	uniqueidentifier
24	$systemCreatedAt	datetime
25	$systemCreatedBy	uniqueidentifier
26	$systemModifiedAt	datetime
27	$systemModifiedBy	uniqueidentifier