Pstd. Phys. Invt. Order Hdr

Dynamics 365 BC Table ReferenceTablesCompany TablesPPstd. Phys. Invt. Order Hdr

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

Table Type: Company

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

Table Number: 5879

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[Description]
   ,[Status]
   ,[Order Date]
   ,[Posting Date]
   ,[Person Responsible]
   ,[Reason Code]
   ,[Gen_ Bus_ Posting Group]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Pre-Assigned No_ Series]
   ,[No_ Series]
   ,[Pre-Assigned No_]
   ,[User ID]
   ,[Source Code]
   ,[Location Code]
   ,[Bin Code]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$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 Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
   [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
      ON
         [Pstd. Phys. Invt. Order Hdr].[Person Responsible] = [Employee].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Pstd. Phys. Invt. Order Hdr].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Pstd. Phys. Invt. Order Hdr].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Pstd. Phys. Invt. Order Hdr].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Pstd. Phys. Invt. Order Hdr].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Pstd. Phys. Invt. Order Hdr].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Pstd. Phys. Invt. Order Hdr].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Pstd. Phys. Invt. Order Hdr].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Pstd. Phys. Invt. Order Hdr].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Pstd. Phys. Invt. Order Hdr].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Pstd. Phys. Invt. Order Hdr table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
10Description SearchDescriptionNormalText100Descriptionnvarchar(200)
11Status SearchStatusNormalOption4Statusint
Available options are:
  • “Open”
  • “Finished”
20Order Date SearchOrder DateNormalDate4Order Datedatetime
21Posting Date SearchPosting DateNormalDate4Posting Datedatetime
30Comment SearchCommentFlowFieldBoolean4
31Person Responsible SearchPerson ResponsibleNormalCode20Person Responsiblenvarchar(40)
Key to join to the Employee table.

Show/hide example query

SELECT
       [Pstd. Phys. Invt. Order Hdr].[Person Responsible]
       ,[Employee].[No_]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[Person Responsible] = [Employee].[No_]
40Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Pstd. Phys. Invt. Order Hdr].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[Reason Code] = [Reason Code].[Code]
41Gen. 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
       [Pstd. Phys. Invt. Order Hdr].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
50Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

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

Show/hide example query

SELECT
       [Pstd. Phys. Invt. Order Hdr].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[Shortcut Dimension 2 Code] = [Dimension].[Code]
60Pre-Assigned No. Series SearchPre-Assigned No. SeriesNormalCode20Pre-Assigned No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Pstd. Phys. Invt. Order Hdr].[Pre-Assigned No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[Pre-Assigned No_ Series] = [No. Series].[Code]
61No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Pstd. Phys. Invt. Order Hdr].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[No_ Series] = [No. Series].[Code]
62Pre-Assigned No. SearchPre-Assigned No.NormalCode20Pre-Assigned No_nvarchar(40)
63User ID SearchUser IDNormalCode50User IDnvarchar(100)
66Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Pstd. Phys. Invt. Order Hdr].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[Source Code] = [Source Code].[Code]
71No. Finished Recordings SearchNo. Finished RecordingsFlowFieldInteger4
110Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Pstd. Phys. Invt. Order Hdr].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[Location Code] = [Location].[Code]
111Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

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

Show/hide example query

SELECT
       [Pstd. Phys. Invt. Order Hdr].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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. Order Hdr].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [User] AS [User]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[$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
       [Pstd. Phys. Invt. Order Hdr].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Order Hdr]
LEFT JOIN
       [User] AS [User]
              ON
                     [Pstd. Phys. Invt. Order Hdr].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Pstd. Phys. Invt. Order Hdr table

Location
Dynamics 365 BC Table ReferenceTablesCompany TablesPPstd. Phys. Invt. Order Hdr

Leave a Reply

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