Job WIP G/L Entry

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

Table Type: Company

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

Table Number: 1005

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Job WIP G_L 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_]
   ,[Posting Date]
   ,[WIP Entry Amount]
   ,[Job Posting Group]
   ,[Type]
   ,[G_L Bal_ Account No_]
   ,[WIP Method Used]
   ,[WIP Posting Method Used]
   ,[WIP Posting Date]
   ,[Description]
   ,[G_L Entry No_]
   ,[Reversed]
   ,[Reverse]
   ,[WIP Transaction No_]
   ,[Reverse Date]
   ,[Job Complete]
   ,[Job WIP Total Entry No_]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Job WIP G_L 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 G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
      ON
         [Job WIP G/L Entry].[WIP Method Used] = [Job WIP Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP G/L Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP G/L 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 G/L 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 G/L Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP G/L Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP G/L Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP G/L Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP G/L Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Job WIP G/L Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Job WIP G/L Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job WIP G/L Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Job WIP G/L 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 G/L Entry].[Job No_]
       ,[Job].[No_]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Job WIP G/L 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 G/L Entry].[G_L Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Job WIP G/L Entry].[G_L Account No_] = [G/L Account].[No_]
5Posting Date SearchPosting DateNormalDate4Posting 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 G/L Entry].[G_L Bal_ Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Job WIP G/L 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 G/L Entry].[WIP Method Used]
       ,[Job WIP Method].[Code]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
              ON
                     [Job WIP G/L Entry].[WIP Method Used] = [Job WIP Method].[Code]
11WIP Posting Method Used SearchWIP Posting Method UsedNormalOption4WIP Posting Method Usedint
Available options are:
  • “Per Job”
  • “Per Job Ledger Entry”
12WIP Posting Date SearchWIP Posting DateNormalDate4WIP Posting Datedatetime
13Description SearchDescriptionNormalText100Descriptionnvarchar(200)
14G/L Entry No. SearchG/L Entry No.NormalInteger4G_L Entry No_int
Key to join to the G/L Entry table.

Show/hide example query

SELECT
       [Job WIP G/L Entry].[G_L Entry No_]
       ,[G/L Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
              ON
                     [Job WIP G/L Entry].[G_L Entry No_] = [G/L Entry].[Entry No_]
15Reversed SearchReversedNormalBoolean4Reversedtinyint
16Reverse SearchReverseNormalBoolean4Reversetinyint
17WIP Transaction No. SearchWIP Transaction No.NormalInteger4WIP Transaction No_int
18Reverse Date SearchReverse DateNormalDate4Reverse Datedatetime
19Job Complete SearchJob CompleteNormalBoolean4Job Completetinyint
20Job 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 G/L Entry].[Job WIP Total Entry No_]
       ,[Job WIP Total].[Entry No_]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Job WIP Total$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Total]
              ON
                     [Job WIP G/L Entry].[Job WIP Total Entry No_] = [Job WIP Total].[Entry No_]
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 G/L Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Job WIP G/L 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 G/L Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Job WIP G/L 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 G/L Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Job WIP G/L 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 G/L Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job WIP G/L 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 G/L Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Job WIP G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP G/L Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Job WIP G/L Entry].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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