Compartir a través de


Item Analysis View Entry Table

Specifies the analysis view entries that are created when you update an analysis view. An analysis view entry is based on one or more item entries that fulfill a number of criteria concerning posting date, account number, and dimension information that you have specified for an analysis view.

When you define an analysis view, you can define what information should be shown in that view. For example, you can specify which dimensions and dimension values item entries must have in order to be included in a view. You can also specify whether only item entries posted to certain accounts should be included in an analysis view using the Item Filter field. When you update an analysis view, the program compresses item entries that fit the criteria that you set for the analysis view and creates analysis view entries. Each analysis view entry represents a unique combination of posting date, item number, and dimension values.

An analysis view entry can therefore be made up of many item ledger entries, depending on what date compression you have set for the analysis view. If you have chosen not to date compress analysis view entries, each analysis view entry will be equal to one item ledger entry. However, if you have chosen to date compress analysis view entries, all item ledger entries within a period with the same combination of posting date, item number, and dimension values will be regarded as a single analysis view entry.

List of Fields in the Table

Field Location
Source No. Field, Item Analysis View Entry Table Inventory
Dimension 2 Value Code Field, Item Analysis View Entry Table Inventory
Posting Date Field, Item Analysis View Entry Table Inventory
Quantity Field, Item Analysis View Entry Table Inventory
Cost Amount (Non-Invtbl.) Field, Item Analysis View Entry Table Inventory
Dimension 3 Value Code Field, Item Analysis View Entry Table Inventory
Location Code Field, Item Analysis View Entry Table Inventory
Entry Type Field, Item Analysis View Entry Table Inventory
Sales Amount (Actual) Field, Item Analysis View Entry Table Inventory
Cost Amount (Expected) Field, Item Analysis View Entry Table Inventory
Invoiced Quantity Field, Item Analysis View Entry Table Inventory
Sales Amount (Expected) Field, Item Analysis View Entry Table Inventory
Cost Amount (Actual) Field, Item Analysis View Entry Table Inventory
Source Type Field, Item Analysis View Entry Table Inventory
Dimension 1 Value Code Field, Item Analysis View Entry Table Inventory
Analysis Area Field, Item Analysis View Entry Table Inventory
Item Ledger Entry Type Field, Item Analysis View Entry Table Inventory
Analysis View Code Field, Item Analysis View Entry Table Inventory
Entry No. Field, Item Analysis View Entry Table Inventory
Item No. Field, Item Analysis View Entry Table Inventory

See Also

Reference

Item Analysis View