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
   [timestamp]
   ,[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]
   ,[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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Phys_ Invt_ Order Line].[Item No_] = [Item].[No_]
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_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Phys_ Invt_ Order Line].[Item Category Code] = [Item Category].[Code]

Show/hide columns in Phys_ Invt_ Order Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4On Recording Lines Searchtinyint
5Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Phys_ Invt_ Order Line].[Item No_] = [Item].[No_]
6Variant Code Searchnvarchar(20)
7Location Code Searchnvarchar(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]
8Bin Code Searchnvarchar(40)
9Description Searchnvarchar(200)
10Description 2 Searchnvarchar(100)
11Unit of Measure Searchnvarchar(100)
12Base Unit of Measure Code Searchnvarchar(20)
13Qty_ Expected (Base) Searchdecimal(38,38)
14Qty_ Exp_ Calculated Searchtinyint
15Use Item Tracking Searchtinyint
16Last Item Ledger Entry No_ Searchint
17Unit Amount Searchdecimal(38,38)
18Unit Cost Searchdecimal(38,38)
19No_ Finished Rec_-Lines Searchint
20Qty_ Recorded (Base) Searchdecimal(38,38)
21Quantity (Base) Searchdecimal(38,38)
22Entry Type Searchint
23Pos_ Qty_ (Base) Searchdecimal(38,38)
24Neg_ Qty_ (Base) Searchdecimal(38,38)
25Without Difference Searchtinyint
26Recorded Without Order Searchtinyint
27Shortcut Dimension 1 Code Searchnvarchar(40)
28Shortcut Dimension 2 Code Searchnvarchar(40)
29Shelf No_ Searchnvarchar(20)
30Gen_ Bus_ Posting Group Searchnvarchar(40)
31Gen_ Prod_ Posting Group Searchnvarchar(40)
32Inventory Posting Group Searchnvarchar(40)
33Dimension Set ID Searchint
34Item Category Code Searchnvarchar(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]
35Phys Invt Counting Period Code Searchnvarchar(20)
36Phys Invt Counting Period Type Searchint
37$systemId Searchuniqueidentifier
38$systemCreatedAt Searchdatetime
39$systemCreatedBy Searchuniqueidentifier
40$systemModifiedAt Searchdatetime
41$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Phys_ Invt_ Order Line table

Leave a Reply

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