Inventory 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
   [timestamp]
   ,[Type]
   ,[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]
   ,[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 columns in Inventory Report Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Type Primary Key Searchint
3Entry No_ Primary Key Searchint
4No_ Searchnvarchar(40)
5Inventory Searchdecimal(38,38)
6Inventory (Interim) Searchdecimal(38,38)
7WIP Inventory Searchdecimal(38,38)
8Direct Cost Applied Actual Searchdecimal(38,38)
9Overhead Applied Actual Searchdecimal(38,38)
10Purchase Variance Searchdecimal(38,38)
11Inventory Adjmt_ Searchdecimal(38,38)
12Invt_ Accrual (Interim) Searchdecimal(38,38)
13COGS Searchdecimal(38,38)
14COGS (Interim) Searchdecimal(38,38)
15Material Variance Searchdecimal(38,38)
16Capacity Variance Searchdecimal(38,38)
17Subcontracted Variance Searchdecimal(38,38)
18Capacity Overhead Variance Searchdecimal(38,38)
19Mfg_ Overhead Variance Searchdecimal(38,38)
20Total Searchdecimal(38,38)
21G_L Total Searchdecimal(38,38)
22Difference Searchdecimal(38,38)
23Direct Cost Applied WIP Searchdecimal(38,38)
24Overhead Applied WIP Searchdecimal(38,38)
25Inventory To WIP Searchdecimal(38,38)
26WIP To Interim Searchdecimal(38,38)
27Direct Cost Applied Searchdecimal(38,38)
28Overhead Applied Searchdecimal(38,38)
29Description Searchnvarchar(200)
30Warning Searchnvarchar(100)
31Cost is Posted to G_L Warning Searchtinyint
32Expected Cost Posting Warning Searchtinyint
33Compression Warning Searchtinyint
34Posting Group Warning Searchtinyint
35Direct Postings Warning Searchtinyint
36Posting Date Warning Searchtinyint
37Closing Period Overlap Warning Searchtinyint
38Similar Accounts Warning Searchtinyint
39Deleted G_L Accounts Warning Searchtinyint
40$systemId Searchuniqueidentifier
41$systemCreatedAt Searchdatetime
42$systemCreatedBy Searchuniqueidentifier
43$systemModifiedAt Searchdatetime
44$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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