Item Register

Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Register

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

Table Type: Company

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

Table Number: 46

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Item Register$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[From Entry No_]
   ,[To Entry No_]
   ,[Creation Date]
   ,[Source Code]
   ,[User ID]
   ,[Journal Batch Name]
   ,[Creation Time]
   ,[From Phys_ Inventory Entry No_]
   ,[To Phys_ Inventory Entry No_]
   ,[From Value Entry No_]
   ,[To Value Entry No_]
   ,[From Capacity Entry No_]
   ,[To Capacity Entry No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Item Register$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 Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Register]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Item Register].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Register].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Register].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Item Register table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalInteger4No_int
2From Entry No. Primary Key SearchFrom Entry No.NormalInteger4From Entry No_int
3To Entry No. SearchTo Entry No.NormalInteger4To Entry No_int
4Creation Date SearchCreation DateNormalDate4Creation Datedatetime
5Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
	       [Item Register].[Source Code]
	       ,[Source Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Item Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Register]
	LEFT JOIN
	       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
	              ON
	                     [Item Register].[Source Code] = [Source Code].[Code]
6User ID SearchUser IDNormalCode50User IDnvarchar(100)
7Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
9Creation Time SearchCreation TimeNormalTime4Creation Timedatetime
10From Phys. Inventory Entry No. SearchFrom Phys. Inventory Entry No.NormalInteger4From Phys_ Inventory Entry No_int
Key to join to the Phys. Inventory Ledger Entry table.

Show/hide example query

SELECT
	       [Item Register].[From Phys_ Inventory Entry No_]
	       ,[Phys. Inventory Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Item Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Register]
	LEFT JOIN
	       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
	              ON
	                     [Item Register].[From Phys_ Inventory Entry No_] = [Phys. Inventory Ledger Entry].[Entry No_]
11To Phys. Inventory Entry No. SearchTo Phys. Inventory Entry No.NormalInteger4To Phys_ Inventory Entry No_int
Key to join to the Phys. Inventory Ledger Entry table.

Show/hide example query

SELECT
	       [Item Register].[To Phys_ Inventory Entry No_]
	       ,[Phys. Inventory Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Item Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Register]
	LEFT JOIN
	       [CRONUS UK Ltd_$Phys_ Inventory Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Inventory Ledger Entry]
	              ON
	                     [Item Register].[To Phys_ Inventory Entry No_] = [Phys. Inventory Ledger Entry].[Entry No_]
5800From Value Entry No. SearchFrom Value Entry No.NormalInteger4From Value Entry No_int
Key to join to the Value Entry table.

Show/hide example query

SELECT
	       [Item Register].[From Value Entry No_]
	       ,[Value Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Item Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Register]
	LEFT JOIN
	       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
	              ON
	                     [Item Register].[From Value Entry No_] = [Value Entry].[Entry No_]
5801To Value Entry No. SearchTo Value Entry No.NormalInteger4To Value Entry No_int
Key to join to the Value Entry table.

Show/hide example query

SELECT
	       [Item Register].[To Value Entry No_]
	       ,[Value Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Item Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Register]
	LEFT JOIN
	       [CRONUS UK Ltd_$Value Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Value Entry]
	              ON
	                     [Item Register].[To Value Entry No_] = [Value Entry].[Entry No_]
5831From Capacity Entry No. SearchFrom Capacity Entry No.NormalInteger4From Capacity Entry No_int
Key to join to the Capacity Ledger Entry table.

Show/hide example query

SELECT
	       [Item Register].[From Capacity Entry No_]
	       ,[Capacity Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Item Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Register]
	LEFT JOIN
	       [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry]
	              ON
	                     [Item Register].[From Capacity Entry No_] = [Capacity Ledger Entry].[Entry No_]
5832To Capacity Entry No. SearchTo Capacity Entry No.NormalInteger4To Capacity Entry No_int
Key to join to the Capacity Ledger Entry table.

Show/hide example query

SELECT
	       [Item Register].[To Capacity Entry No_]
	       ,[Capacity Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Item Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Register]
	LEFT JOIN
	       [CRONUS UK Ltd_$Capacity Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Ledger Entry]
	              ON
	                     [Item Register].[To Capacity Entry No_] = [Capacity Ledger Entry].[Entry No_]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [Item Register].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Item Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Register]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Item Register].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Register

Leave a Reply

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