Item Entry Relation – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IItem Entry Relation

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

Table Type: Company

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

Table Number: 6507

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Item Entry No_]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source ID]
   ,[Source Batch Name]
   ,[Source Prod_ Order Line]
   ,[Source Ref_ No_]
   ,[Serial No_]
   ,[Lot No_]
   ,[Order No_]
   ,[Order Line No_]
   ,[Package No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Item Entry Relation table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Item Entry No.	Item Entry No.	Normal	Integer	4	Item Entry No_	int
	Key to join to the Item Ledger Entry table. Show/hide example query SELECT [Item Entry Relation].[Item Entry No_] ,[Item Ledger Entry].[Entry No_] FROM [CRONUS UK Ltd_$Item Entry Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Entry Relation] LEFT JOIN [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry] ON [Item Entry Relation].[Item Entry No_] = [Item Ledger Entry].[Entry No_]
10	Source Type	Source Type	Normal	Integer	4	Source Type	int
11	Source Subtype	Source Subtype	Normal	Option	4	Source Subtype	int
	Available options are: “0” “1” “2” “3” “4” “5” “6” “7” “8” “9” “10”
12	Source ID	Source ID	Normal	Code	20	Source ID	nvarchar(40)
13	Source Batch Name	Source Batch Name	Normal	Code	10	Source Batch Name	nvarchar(20)
14	Source Prod. Order Line	Source Prod. Order Line	Normal	Integer	4	Source Prod_ Order Line	int
15	Source Ref. No.	Source Ref. No.	Normal	Integer	4	Source Ref_ No_	int
20	Serial No.	Serial No.	Normal	Code	50	Serial No_	nvarchar(100)
21	Lot No.	Lot No.	Normal	Code	50	Lot No_	nvarchar(100)
30	Order No.	Order No.	Normal	Code	20	Order No_	nvarchar(40)
31	Order Line No.	Order Line No.	Normal	Integer	4	Order Line No_	int
6515	Package No.	Package No.	Normal	Code	50	Package No_	nvarchar(100)
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 Entry Relation].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Item Entry Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Entry Relation] LEFT JOIN [User] AS [User] ON [Item Entry Relation].[$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 Entry Relation].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Item Entry Relation$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Entry Relation] LEFT JOIN [User] AS [User] ON [Item Entry Relation].[$systemModifiedBy] = [User].[User Security ID]