Share via


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 G/L 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 G/L entries must have in order to be included in a view. You can also specify whether only G/L entries posted to certain accounts should be included in an analysis view using the Account Filter function. When you update an analysis view, the program compresses G/L 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, G/L account number, and dimension values.

An analysis view entry can therefore be made up of many G/L 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 G/L entry. However, if you have chosen to date compress analysis view entries, all G/L entries within a period with the same combination of posting date, G/L account number, and dimension values will be regarded as a single analysis view entry.

By choosing the Entry No. field, you can view which G/L entries comprise the analysis view entry.

List of Fields in the Table

Field Location
Updated Field, Analysis View Entry Table Spain Local Functionality
Old G/L Account No. Field, Analysis View Entry Table Spain Local Functionality
Account No. Field, Analysis View Entry Table General Ledger
Add.-Curr. Amount Field, Analysis View Entry Table General Ledger
Analysis View Code Field, Analysis View Entry Table General Ledger
Credit Amount Field, Analysis View Entry Table General Ledger
Dimension 2 Value Code Field, Analysis View Entry Table General Ledger
Dimension 1 Value Code Field, Analysis View Entry Table General Ledger
Dimension 3 Value Code Field, Analysis View Entry Table General Ledger
Amount Field, Analysis View Entry Table General Ledger
Posting Date Field, Analysis View Entry Table General Ledger
Business Unit Code Field, Analysis View Entry Table General Ledger
Dimension 4 Value Code Field, Analysis View Entry Table General Ledger
Debit Amount Field, Analysis View Entry Table General Ledger
Add.-Curr. Debit Amount Field, Analysis View Entry Table General Ledger
Account No. Field, Analysis View Entry Table General Ledger
Add.-Curr. Amount Field, Analysis View Entry Table General Ledger
Analysis View Code Field, Analysis View Entry Table General Ledger
Credit Amount Field, Analysis View Entry Table General Ledger
Dimension 2 Value Code Field, Analysis View Entry Table General Ledger
Cash Flow Forecast No. Field, Analysis View Entry Table General Ledger
Account Source Field, Analysis View Entry Table General Ledger
Dimension 1 Value Code Field, Analysis View Entry Table General Ledger
Dimension 3 Value Code Field, Analysis View Entry Table General Ledger
Amount Field, Analysis View Entry Table General Ledger
Entry No. Field, Analysis View Entry Table General Ledger
Add.-Curr. Credit Amount Field, Analysis View Entry Table General Ledger
Posting Date Field, Analysis View Entry Table General Ledger
Business Unit Code Field, Analysis View Entry Table General Ledger
Dimension 4 Value Code Field, Analysis View Entry Table General Ledger
Debit Amount Field, Analysis View Entry Table General Ledger
Add.-Curr. Debit Amount Field, Analysis View Entry Table General Ledger
Account No. Field, Analysis View Entry Table General Ledger
Add.-Curr. Amount Field, Analysis View Entry Table General Ledger
Analysis View Code Field, Analysis View Entry Table General Ledger
Credit Amount Field, Analysis View Entry Table General Ledger
Dimension 2 Value Code Field, Analysis View Entry Table General Ledger
Dimension 1 Value Code Field, Analysis View Entry Table General Ledger
Dimension 3 Value Code Field, Analysis View Entry Table General Ledger
Amount Field, Analysis View Entry Table General Ledger
Entry No. Field, Analysis View Entry Table General Ledger
Add.-Curr. Credit Amount Field, Analysis View Entry Table General Ledger
Posting Date Field, Analysis View Entry Table General Ledger
Business Unit Code Field, Analysis View Entry Table General Ledger
Dimension 4 Value Code Field, Analysis View Entry Table General Ledger
Debit Amount Field, Analysis View Entry Table General Ledger
Add.-Curr. Debit Amount Field, Analysis View Entry Table General Ledger
Entry No. Field, Analysis View Entry Table General Ledger
Add.-Curr. Credit Amount Field, Analysis View Entry Table General Ledger
Add.-Curr. Debit Amount Field, Analysis View Entry Table General Ledger
Account No. Field, Analysis View Entry Table General Ledger
Add.-Curr. Amount Field, Analysis View Entry Table General Ledger
Analysis View Code Field, Analysis View Entry Table General Ledger
Credit Amount Field, Analysis View Entry Table General Ledger
Dimension 2 Value Code Field, Analysis View Entry Table General Ledger
Dimension 1 Value Code Field, Analysis View Entry Table General Ledger
Dimension 3 Value Code Field, Analysis View Entry Table General Ledger
Amount Field, Analysis View Entry Table General Ledger
Entry No. Field, Analysis View Entry Table General Ledger
Add.-Curr. Credit Amount Field, Analysis View Entry Table General Ledger
Posting Date Field, Analysis View Entry Table General Ledger
Business Unit Code Field, Analysis View Entry Table General Ledger
Dimension 4 Value Code Field, Analysis View Entry Table General Ledger
Debit Amount Field, Analysis View Entry Table General Ledger

See Also

Reference

Account Filter
Date Compression
Entry No.
Chart of Accs. (Analysis View)

Other Resources

How to: Set Up Analysis Views