Diagrams


Table

Inventory Report Entry

Fields

# Name Type
1 Entry No. Integer
3 No. Code20
5 Location Filter Code10 FlowFilter
6 Posting Date Filter Date FlowFilter
8 Inventory Decimal
9 Inventory (Interim) Decimal
10 WIP Inventory Decimal
11 Direct Cost Applied Actual Decimal
12 Overhead Applied Actual Decimal
13 Purchase Variance Decimal
14 Inventory Adjmt. Decimal
16 Invt. Accrual (Interim) Decimal
17 COGS Decimal
18 COGS (Interim) Decimal
19 Material Variance Decimal
20 Capacity Variance Decimal
21 Subcontracted Variance Decimal
22 Capacity Overhead Variance Decimal
23 Mfg. Overhead Variance Decimal
28 Total Decimal
29 G/L Total Decimal
30 Difference Decimal
31 Type Option
32 Direct Cost Applied WIP Decimal
33 Overhead Applied WIP Decimal
35 Inventory To WIP Decimal
36 WIP To Interim Decimal
37 Direct Cost Applied Decimal
38 Overhead Applied Decimal
39 Description Text50
40 Warning Text50
61 Cost is Posted to G/L Warning Boolean
62 Expected Cost Posting Warning Boolean
63 Compression Warning Boolean
64 Posting Group Warning Boolean
65 Direct Postings Warning Boolean
66 Posting Date Warning Boolean
67 Closing Period Overlap Warning Boolean
68 Similar Accounts Warning Boolean
69 Deleted G/L Accounts Warning Boolean

Keys

# Fields
0 Type,Entry No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field