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: 5879Due 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.
SELECT
*
FROM
[CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Order Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972]
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]
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]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | No.  | No. | Normal | Code | 20 | No_ | nvarchar(40) |
| 10 | Description  | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 11 | Status | Status | Normal | Option | 4 | Status | int |
| Available options are:
|
| 20 | Order Date | Order Date | Normal | Date | 4 | Order Date | datetime |
| 21 | Posting Date | Posting Date | Normal | Date | 4 | Posting Date | datetime |
| 30 | Comment | Comment | FlowField | Boolean | 4 | | |
| 31 | Person Responsible | Person Responsible | Normal | Code | 20 | Person Responsible | nvarchar(40) |
| Key to join to the Employee table.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_] |
| 40 | Reason Code | Reason Code | Normal | Code | 10 | Reason Code | nvarchar(20) |
| Key to join to the Reason Code table.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] |
| 41 | Gen. Bus. Posting Group | Gen. Bus. Posting Group | Normal | Code | 20 | Gen_ Bus_ Posting Group | nvarchar(40) |
| Key to join to the Gen. Business Posting Group table.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] |
| 50 | Shortcut Dimension 1 Code | Shortcut Dimension 1 Code | Normal | Code | 20 | Shortcut Dimension 1 Code | nvarchar(40) |
| Key to join to the Dimension table.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] |
| 51 | Shortcut Dimension 2 Code | Shortcut Dimension 2 Code | Normal | Code | 20 | Shortcut Dimension 2 Code | nvarchar(40) |
| Key to join to the Dimension table.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] |
| 60 | Pre-Assigned No. Series | Pre-Assigned No. Series | Normal | Code | 20 | Pre-Assigned No_ Series | nvarchar(40) |
| Key to join to the No. Series table.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] |
| 61 | No. Series | No. Series | Normal | Code | 20 | No_ Series | nvarchar(40) |
| Key to join to the No. Series table.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] |
| 62 | Pre-Assigned No. | Pre-Assigned No. | Normal | Code | 20 | Pre-Assigned No_ | nvarchar(40) |
| 63 | User ID | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
| 66 | Source Code | Source Code | Normal | Code | 10 | Source Code | nvarchar(20) |
| Key to join to the Source Code table.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] |
| 71 | No. Finished Recordings | No. Finished Recordings | FlowField | Integer | 4 | | |
| 110 | Location Code | Location Code | Normal | Code | 10 | Location Code | nvarchar(20) |
| Key to join to the Location table.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] |
| 111 | Bin Code | Bin Code | Normal | Code | 20 | Bin Code | nvarchar(40) |
| Key to join to the Bin table.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] |
| 480 | Dimension Set ID | Dimension Set ID | Normal | Integer | 4 | Dimension Set ID | int |
| Key to join to the Dimension Set Entry table.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 | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
| Key to join to the User table.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] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
