Phys_ Invt_ Record Line

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

Table Type: Company

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

Table Number: 5878

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$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]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[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_$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_$Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys_ Invt_ Record Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Phys_ Invt_ Record Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [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
         [Phys_ Invt_ Record Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in 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
       [Phys_ Invt_ Record Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys_ Invt_ Record Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [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
       [Phys_ Invt_ Record Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys_ Invt_ Record Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Phys_ Invt_ Record Line].[Location Code] = [Location].[Code]
10Bin Code Searchnvarchar(40)
11Description Searchnvarchar(200)
12Description 2 Searchnvarchar(100)
13Unit of Measure Searchnvarchar(100)
14Qty_ Rounding Precision Searchdecimal(38,38)
15Qty_ Rounding Precision (Base) Searchdecimal(38,38)
16Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

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

Show/hide tables related from Phys_ Invt_ Record Line table

Leave a Reply

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