Job WIP Buffer

Dynamics 365 BC Table ReferenceTablesCompany TablesJJob WIP Buffer

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

Table Type: Company

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

Table Number: 1018

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Posting Group]
   ,[Type]
   ,[WIP Entry Amount]
   ,[G_L Account No_]
   ,[Bal_ G_L Account No_]
   ,[WIP Method]
   ,[Job No_]
   ,[Job Complete]
   ,[Job WIP Total Entry No_]
   ,[Reverse]
   ,[WIP Posting Method Used]
   ,[Dim Combination ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Job WIP Buffer$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 Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Job WIP Buffer].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
      ON
         [Job WIP Buffer].[WIP Method] = [Job WIP Method].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Job WIP Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Job WIP Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Job WIP Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Posting Group SearchPosting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
	       [Job WIP Buffer].[Posting Group]
	       ,[Customer Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Job WIP Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
	              ON
	                     [Job WIP Buffer].[Posting Group] = [Customer Posting Group].[Code]
2Type Primary Key SearchTypeNormalOption4Typeint
Available options are:
  • “Applied Costs”
  • “Applied Sales”
  • “Recognized Costs”
  • “Recognized Sales”
  • “Accrued Costs”
  • “Accrued Sales”
3WIP Entry Amount Primary Key SearchWIP Entry AmountNormalDecimal12WIP Entry Amountdecimal(38,38)
4G/L Account No. SearchG/L Account No.NormalCode20G_L Account No_nvarchar(40)
5Bal. G/L Account No. Primary Key SearchBal. G/L Account No.NormalCode20Bal_ G_L Account No_nvarchar(40)
6WIP Method SearchWIP MethodNormalCode20WIP Methodnvarchar(40)
Key to join to the Job WIP Method table.

Show/hide example query

SELECT
	       [Job WIP Buffer].[WIP Method]
	       ,[Job WIP Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Job WIP Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Job WIP Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Method]
	              ON
	                     [Job WIP Buffer].[WIP Method] = [Job WIP Method].[Code]
7Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
	       [Job WIP Buffer].[Job No_]
	       ,[Job].[No_]
	FROM
	       [CRONUS UK Ltd_$Job WIP Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
	              ON
	                     [Job WIP Buffer].[Job No_] = [Job].[No_]
8Job Complete Primary Key SearchJob CompleteNormalBoolean4Job Completetinyint
9Job 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 Buffer].[Job WIP Total Entry No_]
	       ,[Job WIP Total].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Job WIP Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Job WIP Total$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Total]
	              ON
	                     [Job WIP Buffer].[Job WIP Total Entry No_] = [Job WIP Total].[Entry No_]
22Reverse Primary Key SearchReverseNormalBoolean4Reversetinyint
23WIP Posting Method Used Primary Key SearchWIP Posting Method UsedNormalOption4WIP Posting Method Usedint
Available options are:
  • “Per Job”
  • “Per Job Ledger Entry”
71Dim Combination ID SearchDim Combination IDNormalInteger4Dim Combination IDint
2000000000$systemId Primary Key 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 Buffer].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Job WIP Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job WIP Buffer]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Job WIP Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesJJob WIP Buffer

Leave a Reply

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