Item Cross Reference

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

Table Type: Company

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

Table Number: 5717

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 Cross Reference can be queried.

Show/hide an example select of all columns

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

Show/hide columns in Item Cross 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 Cross Reference].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Item Cross Reference$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Cross Reference]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Item Cross Reference].[Item No_] = [Item].[No_]
3Variant Code Primary Key Searchnvarchar(20)
4Unit of Measure Primary Key Searchnvarchar(20)
5Cross-Reference Type Primary Key Searchint
6Cross-Reference Type No_ Primary Key Searchnvarchar(60)
7Cross-Reference No_ Primary Key Searchnvarchar(40)
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 Cross Reference table

Leave a Reply

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