Item Reference

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

Table Type: Company

Table Name: Item Reference
Database Table Name: CRONUS UK Ltd_$Item Reference$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 Item Reference can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Item No_]
   ,[Variant Code]
   ,[Unit of Measure]
   ,[Reference Type]
   ,[Reference Type No_]
   ,[Reference No_]
   ,[Description]
   ,[Discontinue Bar Code]
   ,[Description 2]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Item Reference$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 Reference$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Reference]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Item Reference].[Item No_] = [Item].[No_]

Show/hide columns in Item Reference 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 Reference].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Item Reference$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Reference]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Item Reference].[Item No_] = [Item].[No_]
3Variant Code Primary Key Searchnvarchar(20)
4Unit of Measure Primary Key Searchnvarchar(20)
5Reference Type Primary Key Searchint
6Reference Type No_ Primary Key Searchnvarchar(40)
7Reference No_ Primary Key Searchnvarchar(100)
8Description Searchnvarchar(200)
9Discontinue Bar Code Searchtinyint
10Description 2 Searchnvarchar(100)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Item Reference table

Leave a Reply

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