Job WIP G_L Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables JJob 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Job No_	nvarchar(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_]
4	Document No_	nvarchar(40)
5	G_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_]
6	Posting Date	datetime
7	WIP Entry Amount	decimal(38,38)
8	Job Posting Group	nvarchar(40)
9	Type	int
10	G_L Bal_ Account No_	nvarchar(40)
11	WIP Method Used	nvarchar(40)
12	WIP Posting Method Used	int
13	WIP Posting Date	datetime
14	Description	nvarchar(200)
15	G_L Entry No_	int
16	Reversed	tinyint
17	Reverse	tinyint
18	WIP Transaction No_	int
19	Reverse Date	datetime
20	Job Complete	tinyint
21	Job WIP Total Entry No_	int
22	Global Dimension 1 Code	nvarchar(40)
23	Global Dimension 2 Code	nvarchar(40)
24	Dimension Set ID	int
25	$systemId	uniqueidentifier
26	$systemCreatedAt	datetime
27	$systemCreatedBy	uniqueidentifier
28	$systemModifiedAt	datetime
29	$systemModifiedBy	uniqueidentifier