Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/7156
Table Type: Company
Table Name: Item Analysis View Budg_ Entry
Database Table Name: CRONUS UK Ltd_$Item Analysis View Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972
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 Item Analysis View Budg_ Entry can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Item Analysis View Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Analysis Area]
,[Analysis View Code]
,[Budget Name]
,[Item No_]
,[Source Type]
,[Source No_]
,[Dimension 1 Value Code]
,[Dimension 2 Value Code]
,[Dimension 3 Value Code]
,[Location Code]
,[Posting Date]
,[Entry No_]
,[Quantity]
,[Sales Amount]
,[Cost Amount]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Item Analysis View Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Item Analysis View Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View Budg_ Entry]
LEFT JOIN
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Budget Name]
ON
[Item Analysis View Budg_ Entry].[Budget Name] = [G_L Budget Name].[Budget Name]
LEFT JOIN
[CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
ON
[Item Analysis View Budg_ Entry].[Item No_] = [Item].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Item Analysis View Budg_ Entry].[Location Code] = [Location].[Code]Show/hide columns in Item Analysis View Budg_ Entry table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Analysis Area  | int | ||||
| 3 | Analysis View Code | nvarchar(20) | ||||
| 4 | Budget Name | nvarchar(20) | ||||
Key to join to the G_L Budget Name table.Show/hide example querySELECT
[Item Analysis View Budg_ Entry].[Budget Name]
,[G_L Budget Name].[Budget Name]
FROM
[CRONUS UK Ltd_$Item Analysis View Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View Budg_ Entry]
LEFT JOIN
[CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Budget Name]
ON
[Item Analysis View Budg_ Entry].[Budget Name] = [G_L Budget Name].[Budget Name] | ||||||
| 5 | Item No_ | nvarchar(40) | ||||
Key to join to the Item table.Show/hide example querySELECT
[Item Analysis View Budg_ Entry].[Item No_]
,[Item].[No_]
FROM
[CRONUS UK Ltd_$Item Analysis View Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View Budg_ Entry]
LEFT JOIN
[CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
ON
[Item Analysis View Budg_ Entry].[Item No_] = [Item].[No_] | ||||||
| 6 | Source Type | int | ||||
| 7 | Source No_ | nvarchar(40) | ||||
| 8 | Dimension 1 Value Code | nvarchar(40) | ||||
| 9 | Dimension 2 Value Code | nvarchar(40) | ||||
| 10 | Dimension 3 Value Code | nvarchar(40) | ||||
| 11 | Location Code | nvarchar(20) | ||||
Key to join to the Location table.Show/hide example querySELECT
[Item Analysis View Budg_ Entry].[Location Code]
,[Location].[Code]
FROM
[CRONUS UK Ltd_$Item Analysis View Budg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Analysis View Budg_ Entry]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Item Analysis View Budg_ Entry].[Location Code] = [Location].[Code] | ||||||
| 12 | Posting Date | datetime | ||||
| 13 | Entry No_ | int | ||||
| 14 | Quantity | decimal(38,38) | ||||
| 15 | Sales Amount | decimal(38,38) | ||||
| 16 | Cost Amount | decimal(38,38) | ||||
| 17 | $systemId | uniqueidentifier | ||||
| 18 | $systemCreatedAt | datetime | ||||
| 19 | $systemCreatedBy | uniqueidentifier | ||||
| 20 | $systemModifiedAt | datetime | ||||
| 21 | $systemModifiedBy | uniqueidentifier | ||||