Share via

Analysis Column Table

Specifies the columns for your analysis report - both the visible columns that will appear in the report and the intermediary columns that are used for calculation only. An analysis report consists of a column template and several columns. You can set up several column templates in the Analysis Column Template table.

In the Analysis Report window, you can view analysis reports using the various templates that you have set up for the lines and columns.

List of Fields in the Table

The following table lists the fields in this table.

Field Location
Analysis Type Code Field, Analysis Column Table Inventory
Ledger Entry Type Field, Analysis Column Table Inventory
Show Field, Analysis Column Table Inventory
Item Ledger Entry Type Filter Field, Analysis Column Table Inventory
Column No. Field, Analysis Column Table Inventory
Show Opposite Sign Field, Analysis Column Table Inventory
Keep Comparison Period Scope Field, Analysis Column Table United Kingdom Local Functionality
Invoiced Field, Analysis Column Table Inventory
Column Type Field, Analysis Column Table Inventory
Rounding Factor Field, Analysis Column Table Inventory
Analysis Column Template Field, Analysis Column Table Inventory
Analysis Area Field, Analysis Column Table Inventory
Column Header Field, Analysis Column Table Inventory
Comparison Period Formula Field, Analysis Column Table Inventory
Comparison Date Formula Field, Analysis Column Table Inventory
Value Type Field, Analysis Column Table Inventory
Value Entry Type Filter Field, Analysis Column Table Inventory
Formula Field, Analysis Column Table Inventory
Line No. Field, Analysis Column Table Inventory
Analysis Type Code Field, Analysis Column Table Inventory
Ledger Entry Type Field, Analysis Column Table Inventory
Column Type Field, Analysis Column Table Inventory
Show Field, Analysis Column Table Inventory
Item Ledger Entry Type Filter Field, Analysis Column Table Inventory
Column No. Field, Analysis Column Table Inventory
Show Opposite Sign Field, Analysis Column Table Inventory
Invoiced Field, Analysis Column Table Inventory
Rounding Factor Field, Analysis Column Table Inventory
Analysis Column Template Field, Analysis Column Table Inventory
Analysis Area Field, Analysis Column Table Inventory
Column Header Field, Analysis Column Table Inventory
Comparison Period Formula Field, Analysis Column Table Inventory
Comparison Date Formula Field, Analysis Column Table Inventory
Value Type Field, Analysis Column Table Inventory
Value Entry Type Filter Field, Analysis Column Table Inventory
Formula Field, Analysis Column Table Inventory
Line No. Field, Analysis Column Table Inventory
Keep Comparison Period Scope Field, Analysis Column Table United Kingdom Local Functionality

See Also

Reference

Analysis Columns
Analysis Column Template

Other Resources

Analysis Report
How to: Set Up Analysis Column Templates