Service Status Priority Setup

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

Table Type: Company

Table Name: Service Status Priority Setup
Database Table Name: CRONUS UK Ltd_$Service Status Priority Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5928

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 Service Status Priority Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Status Priority Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Service Order Status]
   ,[Priority]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Status Priority Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Status Priority Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Status Priority Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Status Priority Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Status Priority Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Status Priority Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Service Order Status Primary Key SearchService Order StatusNormalOption4Service Order Statusint
Available options are:
  • “Pending”
  • “In Process”
  • “Finished”
  • “On Hold”
2Priority SearchPriorityNormalOption4Priorityint
Available options are:
  • “High”
  • “Medium High”
  • “Medium Low”
  • “Low”
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
       [Service Status Priority Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Status Priority Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Status Priority Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Status Priority Setup].[$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
       [Service Status Priority Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Status Priority Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Status Priority Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Status Priority Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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