Average 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Type Searchint
4Valuation Date Searchdatetime
5Item No_ Searchnvarchar(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_]
6Location Code Searchnvarchar(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]
7Variant Code Searchnvarchar(20)
8Cost is Adjusted Searchtinyint
9Attached to Entry No_ Searchint
10Attached to Valuation Date Searchdatetime
11Level Searchint
12Item Ledger Entry No_ Searchint
13Posting Date Searchdatetime
14Entry Type Searchint
15Document Type Searchint
16Document No_ Searchnvarchar(40)
17Document Line No_ Searchint
18Description Searchnvarchar(200)
19Quantity Searchdecimal(38,38)
20Applied Quantity Searchint
21Cost Amount (Expected) Searchdecimal(38,38)
22Cost Amount (Actual) Searchdecimal(38,38)
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Average Cost Calc_ Overview table

Leave a Reply

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