Job WIP Warning

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

Table Type: Company

Table Name: Job WIP Warning
Database Table Name: CRONUS UK Ltd_$Job WIP Warning$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1007

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 Job WIP Warning can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Job WIP Warning$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Entry No_]
   ,[Job No_]
   ,[Job Task No_]
   ,[Job WIP Total Entry No_]
   ,[Warning Message]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job WIP Warning$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Job WIP Warning table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Job WIP Warning].[Job No_]
       ,[Job].[No_]
FROM
       [CRONUS UK Ltd_$Job WIP Warning$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Warning]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Job WIP Warning].[Job No_] = [Job].[No_]
3Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
4Job WIP Total Entry No. SearchJob WIP Total Entry No.NormalInteger4Job WIP Total Entry No_int
Key to join to the Job WIP Total table.

Show/hide example query

SELECT
       [Job WIP Warning].[Job WIP Total Entry No_]
       ,[Job WIP Total].[Entry No_]
FROM
       [CRONUS UK Ltd_$Job WIP Warning$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Warning]
LEFT JOIN
       [CRONUS UK Ltd_$Job WIP Total$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Total]
              ON
                     [Job WIP Warning].[Job WIP Total Entry No_] = [Job WIP Total].[Entry No_]
5Warning Message SearchWarning MessageNormalText250Warning Messagenvarchar(500)
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
       [Job WIP Warning].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job WIP Warning$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Warning]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job WIP Warning].[$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
       [Job WIP Warning].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job WIP Warning$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Warning]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job WIP Warning].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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