Pstd_ Phys_ Invt_ Tracking

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

Table Type: Company

Table Name: Pstd_ Phys_ Invt_ Tracking
Database Table Name: CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Tracking$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5884

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 Pstd_ Phys_ Invt_ Tracking can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document No_]
   ,[Item Tracking No_]
   ,[Line No_]
   ,[Item No_]
   ,[Description]
   ,[Location Code]
   ,[Quantity]
   ,[Serial No_]
   ,[Positive]
   ,[Warranty Date]
   ,[Expiration Date]
   ,[Lot No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Entry Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Tracking$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Tracking$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Tracking]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Pstd_ Phys_ Invt_ Tracking].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Pstd_ Phys_ Invt_ Tracking].[Location Code] = [Location].[Code]

Show/hide columns in Pstd_ Phys_ Invt_ Tracking table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document No_ Primary Key Searchnvarchar(40)
3Item Tracking No_ Primary Key Searchint
4Line No_ Primary Key Searchint
5Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Pstd_ Phys_ Invt_ Tracking].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Tracking$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Tracking]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Pstd_ Phys_ Invt_ Tracking].[Item No_] = [Item].[No_]
6Description Searchnvarchar(200)
7Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Pstd_ Phys_ Invt_ Tracking].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Tracking$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Tracking]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Pstd_ Phys_ Invt_ Tracking].[Location Code] = [Location].[Code]
8Quantity Searchdecimal(38,38)
9Serial No_ Searchnvarchar(100)
10Positive Searchtinyint
11Warranty Date Searchdatetime
12Expiration Date Searchdatetime
13Lot No_ Searchnvarchar(100)
14Variant Code Searchnvarchar(20)
15Bin Code Searchnvarchar(40)
16Entry Type Searchint
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Pstd_ Phys_ Invt_ Tracking table

Leave a Reply

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