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
   [timestamp]
   ,[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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Job WIP G_L Entry].[Job No_] = [Job].[Job No_]
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_]

Show/hide columns in Job WIP G_L Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Job WIP G_L Entry].[Job No_]
       ,[Job].[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].[Job No_]
4Document No_ Searchnvarchar(40)
5G_L Account No_ Searchnvarchar(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_]
6Posting Date Searchdatetime
7WIP Entry Amount Searchdecimal(38,38)
8Job Posting Group Searchnvarchar(40)
9Type Searchint
10G_L Bal_ Account No_ Searchnvarchar(40)
11WIP Method Used Searchnvarchar(40)
12WIP Posting Method Used Searchint
13WIP Posting Date Searchdatetime
14Description Searchnvarchar(200)
15G_L Entry No_ Searchint
16Reversed Searchtinyint
17Reverse Searchtinyint
18WIP Transaction No_ Searchint
19Reverse Date Searchdatetime
20Job Complete Searchtinyint
21Job WIP Total Entry No_ Searchint
22Global Dimension 1 Code Searchnvarchar(40)
23Global Dimension 2 Code Searchnvarchar(40)
24Dimension Set ID Searchint
25$systemId Searchuniqueidentifier
26$systemCreatedAt Searchdatetime
27$systemCreatedBy Searchuniqueidentifier
28$systemModifiedAt Searchdatetime
29$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Job WIP G_L Entry table

Leave a Reply

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