Item Budget Buffer

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

Table Type: Company

Table Name: Item Budget Buffer
Database Table Name: CRONUS UK Ltd_$Item Budget Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7136

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 Budget Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item Budget Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Item No_]
   ,[Source Type]
   ,[Source No_]
   ,[Location Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Budget Dimension 1 Code]
   ,[Budget Dimension 2 Code]
   ,[Budget Dimension 3 Code]
   ,[Date]
   ,[Quantity]
   ,[Sales Amount]
   ,[Cost Amount]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Item Budget Buffer$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 Budget Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Budget Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Item Budget Buffer].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Item Budget Buffer].[Location Code] = [Location].[Code]

Show/hide columns in Item Budget Buffer 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
       [Item Budget Buffer].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Item Budget Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Budget Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Item Budget Buffer].[Item No_] = [Item].[No_]
3Source Type Primary Key Searchint
4Source No_ Primary Key Searchnvarchar(40)
5Location Code Primary Key Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Item Budget Buffer].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Item Budget Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Budget Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Item Budget Buffer].[Location Code] = [Location].[Code]
6Global Dimension 1 Code Primary Key Searchnvarchar(40)
7Global Dimension 2 Code Primary Key Searchnvarchar(40)
8Budget Dimension 1 Code Primary Key Searchnvarchar(40)
9Budget Dimension 2 Code Primary Key Searchnvarchar(40)
10Budget Dimension 3 Code Primary Key Searchnvarchar(40)
11Date Primary Key Searchdatetime
12Quantity Searchdecimal(38,38)
13Sales Amount Searchdecimal(38,38)
14Cost Amount Searchdecimal(38,38)
15Dimension Set ID Searchint
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Item Budget Buffer table

Leave a Reply

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