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

Show/hide columns in Job WIP 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 Entry].[Job No_]
       ,[Job].[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].[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 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_]
6WIP Posting 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)
12Job Complete Searchtinyint
13Job WIP Total Entry No_ Searchint
14Reverse Searchtinyint
15WIP Posting Method Used Searchint
16Global Dimension 1 Code Searchnvarchar(40)
17Global Dimension 2 Code Searchnvarchar(40)
18Dimension Set ID Searchint
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Job WIP Entry table

Leave a Reply

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