Pstd_ 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
   [timestamp]
   ,[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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Pstd_ Phys_ Invt_ Order Hdr].[Location Code] = [Location].[Code]

Show/hide columns in Pstd_ Phys_ Invt_ Order Hdr table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Description Searchnvarchar(200)
4Status Searchint
5Order Date Searchdatetime
6Posting Date Searchdatetime
7Person Responsible Searchnvarchar(40)
8Reason Code Searchnvarchar(20)
9Gen_ Bus_ Posting Group Searchnvarchar(40)
10Shortcut Dimension 1 Code Searchnvarchar(40)
11Shortcut Dimension 2 Code Searchnvarchar(40)
12Pre-Assigned No_ Series Searchnvarchar(40)
13No_ Series Searchnvarchar(40)
14Pre-Assigned No_ Searchnvarchar(40)
15User ID Searchnvarchar(100)
16Source Code Searchnvarchar(20)
17Location Code Searchnvarchar(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]
18Bin Code Searchnvarchar(40)
19Dimension Set ID Searchint
20$systemId Searchuniqueidentifier
21$systemCreatedAt Searchdatetime
22$systemCreatedBy Searchuniqueidentifier
23$systemModifiedAt Searchdatetime
24$systemModifiedBy Searchuniqueidentifier

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

Leave a Reply

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