Item 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
   [timestamp]
   ,[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 columns in Item Entry Relation table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Item Entry No_ Primary Key Searchint
3Source Type Searchint
4Source Subtype Searchint
5Source ID Searchnvarchar(40)
6Source Batch Name Searchnvarchar(20)
7Source Prod_ Order Line Searchint
8Source Ref_ No_ Searchint
9Serial No_ Searchnvarchar(100)
10Lot No_ Searchnvarchar(100)
11Order No_ Searchnvarchar(40)
12Order Line No_ Searchint
13Package No_ Searchnvarchar(100)
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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