Pstd_ Phys_ Invt_ Order Line

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

Table Type: Company

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

Table Number: 5880

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Pstd_ 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]
   ,[Intern Item Track_ Pos_ Qut_]
   ,[Intern Item Track_ Neg_ Qut_]
   ,[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_$Pstd_ 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_$Pstd_ Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Order Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Pstd_ Phys_ Invt_ Order Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Pstd_ Phys_ Invt_ Order Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Pstd_ Phys_ Invt_ Order Line].[Item Category Code] = [Item Category].[Code]

Show/hide columns in Pstd_ 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
       [Pstd_ Phys_ Invt_ Order Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Pstd_ 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
       [Pstd_ Phys_ Invt_ Order Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Pstd_ 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)
33Intern Item Track_ Pos_ Qut_ Searchint
34Intern Item Track_ Neg_ Qut_ Searchint
35Dimension Set ID Searchint
36Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Pstd_ Phys_ Invt_ Order Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd_ Phys_ Invt_ Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Pstd_ Phys_ Invt_ Order Line].[Item Category Code] = [Item Category].[Code]
37Phys Invt Counting Period Code Searchnvarchar(20)
38Phys Invt Counting Period Type Searchint
39$systemId Searchuniqueidentifier
40$systemCreatedAt Searchdatetime
41$systemCreatedBy Searchuniqueidentifier
42$systemModifiedAt Searchdatetime
43$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Pstd_ Phys_ Invt_ Order Line table

Leave a Reply

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