Phys_ Invt_ Order Header

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

Table Type: Company

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

Table Number: 5875

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Phys_ Invt_ Order Header$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]
   ,[Posting No_ Series]
   ,[No_ Series]
   ,[Posting No_]
   ,[Last Posting No_]
   ,[Location Code]
   ,[Bin Code]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Phys_ Invt_ Order Header$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 Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys_ Invt_ Order Header]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Phys_ Invt_ Order Header].[Location Code] = [Location].[Code]

Show/hide columns in Phys_ Invt_ Order Header 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)
12Posting No_ Series Searchnvarchar(40)
13No_ Series Searchnvarchar(40)
14Posting No_ Searchnvarchar(40)
15Last Posting No_ Searchnvarchar(40)
16Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Phys_ Invt_ Order Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Phys_ Invt_ Order Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys_ Invt_ Order Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Phys_ Invt_ Order Header].[Location Code] = [Location].[Code]
17Bin Code Searchnvarchar(40)
18Dimension Set ID Searchint
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Phys_ Invt_ Order Header table

Leave a Reply

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