Inventory Report Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInventory Report Entry

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

Table Type: Company

Table Name: Inventory Report Entry
Database Table Name: CRONUS UK Ltd_$Inventory Report Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5846

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 Inventory Report Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Inventory Report Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[No_]
   ,[Inventory]
   ,[Inventory (Interim)]
   ,[WIP Inventory]
   ,[Direct Cost Applied Actual]
   ,[Overhead Applied Actual]
   ,[Purchase Variance]
   ,[Inventory Adjmt_]
   ,[Invt_ Accrual (Interim)]
   ,[COGS]
   ,[COGS (Interim)]
   ,[Material Variance]
   ,[Capacity Variance]
   ,[Subcontracted Variance]
   ,[Capacity Overhead Variance]
   ,[Mfg_ Overhead Variance]
   ,[Total]
   ,[G_L Total]
   ,[Difference]
   ,[Type]
   ,[Direct Cost Applied WIP]
   ,[Overhead Applied WIP]
   ,[Inventory To WIP]
   ,[WIP To Interim]
   ,[Direct Cost Applied]
   ,[Overhead Applied]
   ,[Description]
   ,[Warning]
   ,[Cost is Posted to G_L Warning]
   ,[Expected Cost Posting Warning]
   ,[Compression Warning]
   ,[Posting Group Warning]
   ,[Direct Postings Warning]
   ,[Posting Date Warning]
   ,[Closing Period Overlap Warning]
   ,[Similar Accounts Warning]
   ,[Deleted G_L Accounts Warning]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Inventory Report Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [Inventory Report Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Inventory Report Entry].[Location Filter] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Report Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Report Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Inventory Report Entry table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
3	No.	No.	Normal	Code	20	No_	nvarchar(40)
5	Location Filter	Location Filter	FlowFilter	Code	10
6	Posting Date Filter	Posting Date Filter	FlowFilter	Date	4
8	Inventory	Inventory	Normal	Decimal	12	Inventory	decimal(38,38)
9	Inventory (Interim)	Inventory (Interim)	Normal	Decimal	12	Inventory (Interim)	decimal(38,38)
10	WIP Inventory	WIP Inventory	Normal	Decimal	12	WIP Inventory	decimal(38,38)
11	Direct Cost Applied Actual	Direct Cost Applied Actual	Normal	Decimal	12	Direct Cost Applied Actual	decimal(38,38)
12	Overhead Applied Actual	Overhead Applied Actual	Normal	Decimal	12	Overhead Applied Actual	decimal(38,38)
13	Purchase Variance	Purchase Variance	Normal	Decimal	12	Purchase Variance	decimal(38,38)
14	Inventory Adjmt.	Inventory Adjmt.	Normal	Decimal	12	Inventory Adjmt_	decimal(38,38)
16	Invt. Accrual (Interim)	Invt. Accrual (Interim)	Normal	Decimal	12	Invt_ Accrual (Interim)	decimal(38,38)
17	COGS	COGS	Normal	Decimal	12	COGS	decimal(38,38)
18	COGS (Interim)	COGS (Interim)	Normal	Decimal	12	COGS (Interim)	decimal(38,38)
19	Material Variance	Material Variance	Normal	Decimal	12	Material Variance	decimal(38,38)
20	Capacity Variance	Capacity Variance	Normal	Decimal	12	Capacity Variance	decimal(38,38)
21	Subcontracted Variance	Subcontracted Variance	Normal	Decimal	12	Subcontracted Variance	decimal(38,38)
22	Capacity Overhead Variance	Capacity Overhead Variance	Normal	Decimal	12	Capacity Overhead Variance	decimal(38,38)
23	Mfg. Overhead Variance	Mfg. Overhead Variance	Normal	Decimal	12	Mfg_ Overhead Variance	decimal(38,38)
28	Total	Total	Normal	Decimal	12	Total	decimal(38,38)
29	G/L Total	G/L Total	Normal	Decimal	12	G_L Total	decimal(38,38)
30	Difference	Difference	Normal	Decimal	12	Difference	decimal(38,38)
31	Type	Type	Normal	Option	4	Type	int
	Available options are: ” “ “G/L Account” “Item”
32	Direct Cost Applied WIP	Direct Cost Applied WIP	Normal	Decimal	12	Direct Cost Applied WIP	decimal(38,38)
33	Overhead Applied WIP	Overhead Applied WIP	Normal	Decimal	12	Overhead Applied WIP	decimal(38,38)
35	Inventory To WIP	Inventory To WIP	Normal	Decimal	12	Inventory To WIP	decimal(38,38)
36	WIP To Interim	WIP To Interim	Normal	Decimal	12	WIP To Interim	decimal(38,38)
37	Direct Cost Applied	Direct Cost Applied	Normal	Decimal	12	Direct Cost Applied	decimal(38,38)
38	Overhead Applied	Overhead Applied	Normal	Decimal	12	Overhead Applied	decimal(38,38)
39	Description	Description	Normal	Text	100	Description	nvarchar(200)
40	Warning	Warning	Normal	Text	50	Warning	nvarchar(100)
61	Cost is Posted to G/L Warning	Cost is Posted to G/L Warning	Normal	Boolean	4	Cost is Posted to G_L Warning	tinyint
62	Expected Cost Posting Warning	Expected Cost Posting Warning	Normal	Boolean	4	Expected Cost Posting Warning	tinyint
63	Compression Warning	Compression Warning	Normal	Boolean	4	Compression Warning	tinyint
64	Posting Group Warning	Posting Group Warning	Normal	Boolean	4	Posting Group Warning	tinyint
65	Direct Postings Warning	Direct Postings Warning	Normal	Boolean	4	Direct Postings Warning	tinyint
66	Posting Date Warning	Posting Date Warning	Normal	Boolean	4	Posting Date Warning	tinyint
67	Closing Period Overlap Warning	Closing Period Overlap Warning	Normal	Boolean	4	Closing Period Overlap Warning	tinyint
68	Similar Accounts Warning	Similar Accounts Warning	Normal	Boolean	4	Similar Accounts Warning	tinyint
69	Deleted G/L Accounts Warning	Deleted G/L Accounts Warning	Normal	Boolean	4	Deleted G_L Accounts Warning	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Inventory Report Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Inventory Report Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Report Entry] LEFT JOIN [User] AS [User] ON [Inventory Report Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Inventory Report Entry].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Inventory Report Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Report Entry] LEFT JOIN [User] AS [User] ON [Inventory Report Entry].[$systemModifiedBy] = [User].[User Security ID]