Pstd_ Phys_ Invt_ Record Line

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

Table Type: Company

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

Table Number: 5882

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_ Record Line can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Order No_]
   ,[Recording No_]
   ,[Line No_]
   ,[Order Line No_]
   ,[Recorded without Order]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Bin Code]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity]
   ,[Quantity (Base)]
   ,[Qty_ per Unit of Measure]
   ,[Recorded]
   ,[Use Item Tracking]
   ,[Shelf No_]
   ,[Date Recorded]
   ,[Time Recorded]
   ,[Person Recorded]
   ,[Serial No_]
   ,[Lot No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Record Line$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_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Record Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Pstd_ Phys_ Invt_ Record Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Pstd_ Phys_ Invt_ Record Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Pstd_ Phys_ Invt_ Record Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Pstd_ Phys_ Invt_ Record Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Order No_ Primary Key Searchnvarchar(40)
3Recording No_ Primary Key Searchint
4Line No_ Primary Key Searchint
5Order Line No_ Searchint
6Recorded without Order Searchtinyint
7Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

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

Show/hide example query

SELECT
       [Pstd_ Phys_ Invt_ Record Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Record Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Pstd_ Phys_ Invt_ Record Line].[Location Code] = [Location].[Code]
10Bin Code Searchnvarchar(40)
11Description Searchnvarchar(200)
12Description 2 Searchnvarchar(100)
13Unit of Measure Searchnvarchar(100)
14Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Pstd_ Phys_ Invt_ Record Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Record Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Pstd_ Phys_ Invt_ Record Line].[Unit of Measure Code] = [Unit of Measure].[Code]
15Quantity Searchdecimal(38,38)
16Quantity (Base) Searchdecimal(38,38)
17Qty_ per Unit of Measure Searchdecimal(38,38)
18Recorded Searchtinyint
19Use Item Tracking Searchtinyint
20Shelf No_ Searchnvarchar(20)
21Date Recorded Searchdatetime
22Time Recorded Searchdatetime
23Person Recorded Searchnvarchar(40)
24Serial No_ Searchnvarchar(100)
25Lot No_ Searchnvarchar(100)
26$systemId Searchuniqueidentifier
27$systemCreatedAt Searchdatetime
28$systemCreatedBy Searchuniqueidentifier
29$systemModifiedAt Searchdatetime
30$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Pstd_ Phys_ Invt_ Record Line table

Leave a Reply

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