Item Register – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IItem 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Integer	4	No_	int
2	From Entry No.	From Entry No.	Normal	Integer	4	From Entry No_	int
3	To Entry No.	To Entry No.	Normal	Integer	4	To Entry No_	int
4	Creation Date	Creation Date	Normal	Date	4	Creation Date	datetime
5	Source Code	Source Code	Normal	Code	10	Source Code	nvarchar(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]
6	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
7	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
9	Creation Time	Creation Time	Normal	Time	4	Creation Time	datetime
10	From Phys. Inventory Entry No.	From Phys. Inventory Entry No.	Normal	Integer	4	From 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_]
11	To Phys. Inventory Entry No.	To Phys. Inventory Entry No.	Normal	Integer	4	To 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_]
5800	From Value Entry No.	From Value Entry No.	Normal	Integer	4	From 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_]
5801	To Value Entry No.	To Value Entry No.	Normal	Integer	4	To 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_]
5831	From Capacity Entry No.	From Capacity Entry No.	Normal	Integer	4	From 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_]
5832	To Capacity Entry No.	To Capacity Entry No.	Normal	Integer	4	To 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	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Item Register].[$systemModifiedBy] ,[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].[$systemModifiedBy] = [User].[User Security ID]

Dynamics 365 BC Table Reference Tables Company Tables IItem Register

Leave a Reply Cancel reply