Phys_ Invt_ Order Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPhys_ 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	No_	nvarchar(40)
3	Description	nvarchar(200)
4	Status	int
5	Order Date	datetime
6	Posting Date	datetime
7	Person Responsible	nvarchar(40)
8	Reason Code	nvarchar(20)
9	Gen_ Bus_ Posting Group	nvarchar(40)
10	Shortcut Dimension 1 Code	nvarchar(40)
11	Shortcut Dimension 2 Code	nvarchar(40)
12	Posting No_ Series	nvarchar(40)
13	No_ Series	nvarchar(40)
14	Posting No_	nvarchar(40)
15	Last Posting No_	nvarchar(40)
16	Location Code	nvarchar(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]
17	Bin Code	nvarchar(40)
18	Dimension Set ID	int
19	$systemId	uniqueidentifier
20	$systemCreatedAt	datetime
21	$systemCreatedBy	uniqueidentifier
22	$systemModifiedAt	datetime
23	$systemModifiedBy	uniqueidentifier