Pstd. Phys. Invt. Record Line

Dynamics 365 BC Table ReferenceTablesCompany TablesPPstd. 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

   [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 Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Pstd. Phys. Invt. Record Line].[Variant Code] = [Item Variant].[Code]
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_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Pstd. Phys. Invt. Record Line].[Bin Code] = [Bin].[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] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
      ON
         [Pstd. Phys. Invt. Record Line].[Person Recorded] = [Employee].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Pstd. Phys. Invt. Record Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Pstd. Phys. Invt. Record Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Pstd. Phys. Invt. Record Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
2Recording No. Primary Key SearchRecording No.NormalInteger4Recording No_int
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
16Order Line No. Primary Key SearchOrder Line No.NormalInteger4Order Line No_int
17Recorded without Order SearchRecorded without OrderNormalBoolean4Recorded without Ordertinyint
20Item No. SearchItem No.NormalCode20Item No_nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Pstd. Phys. Invt. Record Line].[Item No_] = [Item].[No_]
21Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
	       [Pstd. Phys. Invt. Record Line].[Variant Code]
	       ,[Item Variant].[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_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Pstd. Phys. Invt. Record Line].[Variant Code] = [Item Variant].[Code]
22Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
23Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
	       [Pstd. Phys. Invt. Record Line].[Bin Code]
	       ,[Bin].[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_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
	              ON
	                     [Pstd. Phys. Invt. Record Line].[Bin Code] = [Bin].[Code]
30Description SearchDescriptionNormalText100Descriptionnvarchar(200)
31Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
32Unit of Measure SearchUnit of MeasureNormalText50Unit of Measurenvarchar(100)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
	       [Pstd. Phys. Invt. Record Line].[Unit of Measure]
	       ,[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] = [Unit of Measure].[Code]
40Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
41Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
42Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
43Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
45Recorded SearchRecordedNormalBoolean4Recordedtinyint
53Use Item Tracking SearchUse Item TrackingNormalBoolean4Use Item Trackingtinyint
99Shelf No. SearchShelf No.NormalCode10Shelf No_nvarchar(20)
100Date Recorded SearchDate RecordedNormalDate4Date Recordeddatetime
101Time Recorded SearchTime RecordedNormalTime4Time Recordeddatetime
102Person Recorded SearchPerson RecordedNormalCode20Person Recordednvarchar(40)
Key to join to the Employee table.

Show/hide example query

SELECT
	       [Pstd. Phys. Invt. Record Line].[Person Recorded]
	       ,[Employee].[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_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
	              ON
	                     [Pstd. Phys. Invt. Record Line].[Person Recorded] = [Employee].[No_]
130Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
131Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
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
	       [Pstd. Phys. Invt. Record Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Record Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Pstd. Phys. Invt. Record Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Pstd. Phys. Invt. Record Line table

LocationUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesPPstd. Phys. Invt. Record Line

Leave a Reply

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