Job Posting Group

Dynamics 365 BC Table ReferenceTablesCompany TablesJJob Posting Group

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

Table Type: Company

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

Table Number: 208

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[WIP Costs Account]
   ,[WIP Accrued Costs Account]
   ,[Job Costs Applied Account]
   ,[Job Costs Adjustment Account]
   ,[G_L Expense Acc_ (Contract)]
   ,[Job Sales Adjustment Account]
   ,[WIP Accrued Sales Account]
   ,[WIP Invoiced Sales Account]
   ,[Job Sales Applied Account]
   ,[Recognized Costs Account]
   ,[Recognized Sales Account]
   ,[Item Costs Applied Account]
   ,[Resource Costs Applied Account]
   ,[G_L Costs Applied Account]
   ,[Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Job Posting Group$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 Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[WIP Costs Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[WIP Accrued Costs Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[Job Costs Applied Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[Job Costs Adjustment Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[Job Sales Adjustment Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[WIP Accrued Sales Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[WIP Invoiced Sales Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[Job Sales Applied Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[Recognized Costs Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[Recognized Sales Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[Item Costs Applied Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Job Posting Group].[Resource Costs Applied Account] = [G/L Account].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Job Posting Group].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job Posting Group].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Job Posting Group table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode20Codenvarchar(40)
2WIP Costs Account Primary Key SearchWIP Costs AccountNormalCode20WIP Costs Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[WIP Costs Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[WIP Costs Account] = [G/L Account].[No_]
3WIP Accrued Costs Account SearchWIP Accrued Costs AccountNormalCode20WIP Accrued Costs Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[WIP Accrued Costs Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[WIP Accrued Costs Account] = [G/L Account].[No_]
4Job Costs Applied Account SearchJob Costs Applied AccountNormalCode20Job Costs Applied Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[Job Costs Applied Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[Job Costs Applied Account] = [G/L Account].[No_]
5Job Costs Adjustment Account SearchJob Costs Adjustment AccountNormalCode20Job Costs Adjustment Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[Job Costs Adjustment Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[Job Costs Adjustment Account] = [G/L Account].[No_]
6G/L Expense Acc. (Contract) SearchG/L Expense Acc. (Contract)NormalCode20G_L Expense Acc_ (Contract)nvarchar(40)
7Job Sales Adjustment Account SearchJob Sales Adjustment AccountNormalCode20Job Sales Adjustment Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[Job Sales Adjustment Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[Job Sales Adjustment Account] = [G/L Account].[No_]
8WIP Accrued Sales Account SearchWIP Accrued Sales AccountNormalCode20WIP Accrued Sales Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[WIP Accrued Sales Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[WIP Accrued Sales Account] = [G/L Account].[No_]
9WIP Invoiced Sales Account SearchWIP Invoiced Sales AccountNormalCode20WIP Invoiced Sales Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[WIP Invoiced Sales Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[WIP Invoiced Sales Account] = [G/L Account].[No_]
10Job Sales Applied Account SearchJob Sales Applied AccountNormalCode20Job Sales Applied Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[Job Sales Applied Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[Job Sales Applied Account] = [G/L Account].[No_]
11Recognized Costs Account SearchRecognized Costs AccountNormalCode20Recognized Costs Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[Recognized Costs Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[Recognized Costs Account] = [G/L Account].[No_]
12Recognized Sales Account SearchRecognized Sales AccountNormalCode20Recognized Sales Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[Recognized Sales Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[Recognized Sales Account] = [G/L Account].[No_]
13Item Costs Applied Account SearchItem Costs Applied AccountNormalCode20Item Costs Applied Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[Item Costs Applied Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[Item Costs Applied Account] = [G/L Account].[No_]
14Resource Costs Applied Account SearchResource Costs Applied AccountNormalCode20Resource Costs Applied Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Job Posting Group].[Resource Costs Applied Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Job Posting Group].[Resource Costs Applied Account] = [G/L Account].[No_]
15G/L Costs Applied Account SearchG/L Costs Applied AccountNormalCode20G_L Costs Applied Accountnvarchar(40)
20Description SearchDescriptionNormalText100Descriptionnvarchar(200)
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 Posting Group].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Job Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Posting Group]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Job Posting Group].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesJJob Posting Group

Leave a Reply

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