Avg_ Cost Adjmt_ Entry Point

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

Table Type: Company

Table Name: Avg_ Cost Adjmt_ Entry Point
Database Table Name: CRONUS UK Ltd_$Avg_ Cost Adjmt_ Entry Point$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Avg_ Cost Adjmt_ Entry Point can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Avg_ Cost Adjmt_ Entry Point$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Valuation Date]
   ,[Cost Is Adjusted]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Avg_ Cost Adjmt_ Entry Point$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Avg_ Cost Adjmt_ Entry Point table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Item No_ Primary Key Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Avg_ Cost Adjmt_ Entry Point].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Avg_ Cost Adjmt_ Entry Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Avg_ Cost Adjmt_ Entry Point]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Avg_ Cost Adjmt_ Entry Point].[Item No_] = [Item].[No_]
3Variant Code Primary Key Searchnvarchar(20)
4Location Code Primary Key Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Avg_ Cost Adjmt_ Entry Point].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Avg_ Cost Adjmt_ Entry Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Avg_ Cost Adjmt_ Entry Point]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Avg_ Cost Adjmt_ Entry Point].[Location Code] = [Location].[Code]
5Valuation Date Primary Key Searchdatetime
6Cost Is Adjusted Searchtinyint
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Avg_ Cost Adjmt_ Entry Point table

Leave a Reply

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