Phys. Invt. Order Line

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

Table Type: Company

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

Table Number: 5876

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Document No_]
   ,[Line No_]
   ,[On Recording Lines]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Bin Code]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Base Unit of Measure Code]
   ,[Qty_ Expected (Base)]
   ,[Qty_ Exp_ Calculated]
   ,[Use Item Tracking]
   ,[Last Item Ledger Entry No_]
   ,[Unit Amount]
   ,[Unit Cost]
   ,[No_ Finished Rec_-Lines]
   ,[Qty_ Recorded (Base)]
   ,[Quantity (Base)]
   ,[Entry Type]
   ,[Pos_ Qty_ (Base)]
   ,[Neg_ Qty_ (Base)]
   ,[Without Difference]
   ,[Recorded Without Order]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Shelf No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Inventory Posting Group]
   ,[Dimension Set ID]
   ,[Item Category Code]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Phys Invt Counting Period Code]
   ,[Phys Invt Counting Period Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Phys_ Invt_ Order 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_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Phys. Invt. Order Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Phys. Invt. Order Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Phys. Invt. Order 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. Order Line].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Phys. Invt. Order Line].[Base Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Invt. Order Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Phys. Invt. Order Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Phys. Invt. Order Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Phys. Invt. Order Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Phys. Invt. Order Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
      ON
         [Phys. Invt. Order Line].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Phys. Invt. Order Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Phys. Invt. Order Line].[SystemModifiedBy] = [User].[User Security ID]

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

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
12On Recording Lines SearchOn Recording LinesNormalBoolean4On Recording Linestinyint
20Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Phys. Invt. Order 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. Order Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Phys. Invt. Order 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. Order Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Phys. Invt. Order 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. Order Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Phys. Invt. Order 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. Order Line].[Unit of Measure]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Phys. Invt. Order Line].[Unit of Measure] = [Unit of Measure].[Code]
40Base Unit of Measure Code SearchBase Unit of Measure CodeNormalCode10Base Unit of Measure Codenvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Base Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Phys. Invt. Order Line].[Base Unit of Measure Code] = [Unit of Measure].[Code]
50Qty. Expected (Base) SearchQty. Expected (Base)NormalDecimal12Qty_ Expected (Base)decimal(38,38)
51Qty. Exp. Calculated SearchQty. Exp. CalculatedNormalBoolean4Qty_ Exp_ Calculatedtinyint
52Qty. Exp. Item Tracking (Base) SearchQty. Exp. Item Tracking (Base)FlowFieldDecimal12
53Use Item Tracking SearchUse Item TrackingNormalBoolean4Use Item Trackingtinyint
55Last Item Ledger Entry No. SearchLast Item Ledger Entry No.NormalInteger4Last Item Ledger Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Last Item Ledger Entry No_]
       ,[Item Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
              ON
                     [Phys. Invt. Order Line].[Last Item Ledger Entry No_] = [Item Ledger Entry].[Entry No_]
60Unit Amount SearchUnit AmountNormalDecimal12Unit Amountdecimal(38,38)
62Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
70No. Finished Rec.-Lines SearchNo. Finished Rec.-LinesNormalInteger4No_ Finished Rec_-Linesint
71Qty. Recorded (Base) SearchQty. Recorded (Base)NormalDecimal12Qty_ Recorded (Base)decimal(38,38)
72Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
73Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • ” “
  • “Positive Adjmt.”
  • “Negative Adjmt.”
74Pos. Qty. (Base) SearchPos. Qty. (Base)NormalDecimal12Pos_ Qty_ (Base)decimal(38,38)
75Neg. Qty. (Base) SearchNeg. Qty. (Base)NormalDecimal12Neg_ Qty_ (Base)decimal(38,38)
76Without Difference SearchWithout DifferenceNormalBoolean4Without Differencetinyint
80Recorded Without Order SearchRecorded Without OrderNormalBoolean4Recorded Without Ordertinyint
90Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Phys. Invt. Order Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
91Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Phys. Invt. Order Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
100Shelf No. SearchShelf No.NormalCode10Shelf No_nvarchar(20)
110Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Phys. Invt. Order Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
111Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Phys. Invt. Order Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
112Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Phys. Invt. Order Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Phys. Invt. Order Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
5704Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Phys. Invt. Order Line].[Item Category Code] = [Item Category].[Code]
5725Item Reference No. SearchItem Reference No.NormalCode50Item Reference No_nvarchar(100)
5726Item Reference Unit of Measure SearchItem Reference 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)
7380Phys Invt Counting Period Code SearchPhys Invt Counting Period CodeNormalCode10Phys Invt Counting Period Codenvarchar(20)
Key to join to the Phys. Invt. Counting Period table.

Show/hide example query

SELECT
       [Phys. Invt. Order Line].[Phys Invt Counting Period Code]
       ,[Phys. Invt. Counting Period].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
              ON
                     [Phys. Invt. Order Line].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
7381Phys Invt Counting Period Type SearchPhys Invt Counting Period TypeNormalOption4Phys Invt Counting Period Typeint
Available options are:
  • ” “
  • “Item”
  • “SKU”
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. Order Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Phys. Invt. Order 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. Order Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Order Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Phys. Invt. Order Line].[$systemModifiedBy] = [User].[User Security ID]

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

Leave a Reply

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