Phys. Invt. Item Selection

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

Table Type: Company

Table Name: Phys. Invt. Item Selection
Database Table Name: CRONUS UK Ltd_$Phys_ Invt_ Item Selection$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7380

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 Phys. Invt. Item Selection can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Phys_ Invt_ Item Selection$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Shelf No_]
   ,[Phys Invt Counting Period Code]
   ,[Last Counting Date]
   ,[Count Frequency per Year]
   ,[Selected]
   ,[Phys Invt Counting Period Type]
   ,[Next Counting Start Date]
   ,[Next Counting End Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Phys_ Invt_ Item Selection$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Phys_ Invt_ Item Selection$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Item Selection]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Phys. Invt. Item Selection].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Phys. Invt. Item Selection].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
      ON
         [Phys. Invt. Item Selection].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Phys. Invt. Item Selection].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Phys. Invt. Item Selection].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Phys. Invt. Item Selection table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Item No. Primary Key SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Phys. Invt. Item Selection].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Item Selection$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Item Selection]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Phys. Invt. Item Selection].[Item No_] = [Item].[No_]
2Variant Code Primary Key SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Phys. Invt. Item Selection].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Item Selection$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Item Selection]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Phys. Invt. Item Selection].[Variant Code] = [Item Variant].[Code]
3Location Code Primary Key SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Phys. Invt. Item Selection].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Item Selection$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Item Selection]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Phys. Invt. Item Selection].[Location Code] = [Location].[Code]
4Description SearchDescriptionFlowFieldText100
5Shelf No. SearchShelf No.NormalCode10Shelf No_nvarchar(20)
6Phys Invt Counting Period Code Primary Key SearchPhys Invt Counting Period CodeNormalCode10Phys Invt Counting Period Codenvarchar(20)
Key to join to the Phys. Invt. Counting Period table.

Show/hide example query

SELECT
       [Phys. Invt. Item Selection].[Phys Invt Counting Period Code]
       ,[Phys. Invt. Counting Period].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Item Selection$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Item Selection]
LEFT JOIN
       [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
              ON
                     [Phys. Invt. Item Selection].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
7Last Counting Date SearchLast Counting DateNormalDate4Last Counting Datedatetime
9Count Frequency per Year SearchCount Frequency per YearNormalInteger4Count Frequency per Yearint
10Selected SearchSelectedNormalBoolean4Selectedtinyint
11Phys Invt Counting Period Type SearchPhys Invt Counting Period TypeNormalOption4Phys Invt Counting Period Typeint
Available options are:
  • ” “
  • “Item”
  • “SKU”
12Next Counting Start Date SearchNext Counting Start DateNormalDate4Next Counting Start Datedatetime
13Next Counting End Date SearchNext Counting End DateNormalDate4Next Counting End Datedatetime
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
       [Phys. Invt. Item Selection].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Item Selection$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Item Selection]
LEFT JOIN
       [User] AS [User]
              ON
                     [Phys. Invt. Item Selection].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Phys. Invt. Item Selection].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Item Selection$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Item Selection]
LEFT JOIN
       [User] AS [User]
              ON
                     [Phys. Invt. Item Selection].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Phys. Invt. Item Selection table

Leave a Reply

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