Phys. Invt. Record Line

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

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

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

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Order No. Primary Key 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. 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
       [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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [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
       [Phys. Invt. Record Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [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
       [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]
23Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Phys. Invt. Record Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [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
       [Phys. Invt. Record Line].[Unit of Measure]
       ,[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] = [Unit of Measure].[Code]
33Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
34Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
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
       [Phys. Invt. Record Line].[Person Recorded]
       ,[Employee].[No_]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Line]
LEFT JOIN
       [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
              ON
                     [Phys. Invt. Record Line].[Person Recorded] = [Employee].[No_]
103Recorded by User ID SearchCreated by UserNormalCode50Recorded by User IDnvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
       [Phys. Invt. Record Line].[Recorded by User ID]
       ,[User].[User Name]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Phys. Invt. Record Line].[Recorded by User ID] = [User].[User Name]
130Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
131Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
5725Item Reference No. SearchItem Reference No.NormalCode50Item Reference No_nvarchar(100)
5726Item Reference Unit of Measure SearchReference Unit of MeasureNormalCode10Item Reference Unit of Measurenvarchar(20)
5727Item Reference Type SearchItem Reference TypeNormalOption4Item Reference Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bar Code”
5728Item Reference Type No. SearchItem Reference Type No.NormalCode30Item Reference Type No_nvarchar(60)
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
       [Phys. Invt. Record Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Phys. Invt. Record Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Phys. Invt. Record Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Record Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Phys. Invt. Record Line].[$systemModifiedBy] = [User].[User Security ID]

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

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

Leave a Reply

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