Pstd. Phys. Invt. Record Hdr

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

Table Type: Company

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

Table Number: 5881

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Order No_]
   ,[Recording No_]
   ,[Description]
   ,[Status]
   ,[Person Responsible]
   ,[Allow Recording Without Order]
   ,[Date Recorded]
   ,[Time Recorded]
   ,[Person Recorded]
   ,[Location Code]
   ,[Bin Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Record 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_ Record Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Record Hdr]
LEFT JOIN
   [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
      ON
         [Pstd. Phys. Invt. Record Hdr].[Person Responsible] = [Employee].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
      ON
         [Pstd. Phys. Invt. Record Hdr].[Person Recorded] = [Employee].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Pstd. Phys. Invt. Record Hdr].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Pstd. Phys. Invt. Record Hdr].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Pstd. Phys. Invt. Record Hdr].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Pstd. Phys. Invt. Record Hdr].[SystemModifiedBy] = [User].[User Security ID]

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

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Order No. Primary Key SearchOrder No.NormalCode20Order No_nvarchar(40)
2Recording No. Primary Key SearchRecording No.NormalInteger4Recording No_int
10Description SearchDescriptionNormalText100Descriptionnvarchar(200)
11Status SearchStatusNormalOption4Statusint
Available options are:
  • “Open”
  • “Finished”
30Comment SearchCommentFlowFieldBoolean4
31Person Responsible SearchPerson ResponsibleNormalCode20Person Responsiblenvarchar(40)
Key to join to the Employee table.

Show/hide example query

SELECT
       [Pstd. Phys. Invt. Record Hdr].[Person Responsible]
       ,[Employee].[No_]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Record Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Record Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
              ON
                     [Pstd. Phys. Invt. Record Hdr].[Person Responsible] = [Employee].[No_]
40Allow Recording Without Order SearchAllow Recording Without OrderNormalBoolean4Allow Recording Without Ordertinyint
100Date Recorded SearchDate RecordedNormalDate4Date Recordeddatetime
101Time Recorded SearchTime RecordedNormalTime4Time Recordeddatetime
102Person Recorded SearchPerson RecordedNormalCode20Person Recordednvarchar(40)
Key to join to the Employee table.

Show/hide example query

SELECT
       [Pstd. Phys. Invt. Record Hdr].[Person Recorded]
       ,[Employee].[No_]
FROM
       [CRONUS UK Ltd_$Pstd_ Phys_ Invt_ Record Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Pstd. Phys. Invt. Record Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
              ON
                     [Pstd. Phys. Invt. Record Hdr].[Person Recorded] = [Employee].[No_]
110Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

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

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

Leave a Reply

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