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
   [timestamp]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Phys Invt Counting Period Code]
   ,[Shelf No_]
   ,[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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Phys_ Invt_ Item Selection].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Phys_ Invt_ Item Selection].[Location Code] = [Location].[Code]

Show/hide columns in Phys_ Invt_ Item Selection table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Item No_ Primary Key Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Phys_ Invt_ Item Selection].[Item No_] = [Item].[No_]
3Variant Code Primary Key Searchnvarchar(20)
4Location Code Primary Key Searchnvarchar(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]
5Phys Invt Counting Period Code Primary Key Searchnvarchar(20)
6Shelf No_ Searchnvarchar(20)
7Last Counting Date Searchdatetime
8Count Frequency per Year Searchint
9Selected Searchtinyint
10Phys Invt Counting Period Type Searchint
11Next Counting Start Date Searchdatetime
12Next Counting End Date Searchdatetime
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Phys_ Invt_ Item Selection table

Leave a Reply

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