Job WIP Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesJJob WIP Entry

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

Table Type: Company

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

Table Number: 1004

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Job No_]
   ,[Document No_]
   ,[G_L Account No_]
   ,[WIP Posting Date]
   ,[WIP Entry Amount]
   ,[Job Posting Group]
   ,[Type]
   ,[G_L Bal_ Account No_]
   ,[WIP Method Used]
   ,[Job Complete]
   ,[Job WIP Total Entry No_]
   ,[Reverse]
   ,[WIP Posting Method Used]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Job WIP Entry$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 Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
      ON
         [Job WIP Entry].[WIP Method Used] = [Job WIP Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Job WIP Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Job WIP Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job WIP Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Job WIP Entry 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 Entry].[Job No_]
       ,[Job].[No_]
FROM
       [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Job WIP Entry].[Job No_] = [Job].[No_]
3Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
4G/L Account No. SearchG/L Account No.NormalCode20G_L Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Job WIP Entry].[G_L Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Job WIP Entry].[G_L Account No_] = [G/L Account].[No_]
5WIP Posting Date SearchWIP Posting DateNormalDate4WIP Posting Datedatetime
6WIP Entry Amount SearchWIP Entry AmountNormalDecimal12WIP Entry Amountdecimal(38,38)
7Job Posting Group SearchJob Posting GroupNormalCode20Job Posting Groupnvarchar(40)
8Type SearchTypeNormalOption4Typeint
Available options are:
  • “Applied Costs”
  • “Applied Sales”
  • “Recognized Costs”
  • “Recognized Sales”
  • “Accrued Costs”
  • “Accrued Sales”
9G/L Bal. Account No. SearchG/L Bal. Account No.NormalCode20G_L Bal_ Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Job WIP Entry].[G_L Bal_ Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Job WIP Entry].[G_L Bal_ Account No_] = [G/L Account].[No_]
10WIP Method Used SearchWIP Method UsedNormalCode20WIP Method Usednvarchar(40)
Key to join to the Job WIP Method table.

Show/hide example query

SELECT
       [Job WIP Entry].[WIP Method Used]
       ,[Job WIP Method].[Code]
FROM
       [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
              ON
                     [Job WIP Entry].[WIP Method Used] = [Job WIP Method].[Code]
11Job Complete SearchJob CompleteNormalBoolean4Job Completetinyint
12Job 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 Entry].[Job WIP Total Entry No_]
       ,[Job WIP Total].[Entry No_]
FROM
       [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job WIP Total$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Total]
              ON
                     [Job WIP Entry].[Job WIP Total Entry No_] = [Job WIP Total].[Entry No_]
13Reverse SearchReverseNormalBoolean4Reversetinyint
14WIP Posting Method Used SearchWIP Posting Method UsedNormalOption4WIP Posting Method Usedint
Available options are:
  • “Per Job”
  • “Per Job Ledger Entry”
60Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Job WIP Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Job WIP Entry].[Global Dimension 1 Code] = [Dimension].[Code]
61Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Job WIP Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Job WIP Entry].[Global Dimension 2 Code] = [Dimension].[Code]
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Job WIP Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Job WIP Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
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 Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job WIP Entry].[$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 Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job WIP Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job WIP Entry].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesJJob WIP Entry

Leave a Reply

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