Diagrams


Table

Analysis Column

Fields

# Name Type
1 Analysis Area (Analysis Area) Option
2 Analysis Column Template (Analysis Column Template) Code10
3 Line No. (Line No.) Integer
4 Column No. (Column No.) Code10
5 Column Header (Column Header) Text50
6 Column Type (Column Type) Option
7 Ledger Entry Type (Ledger Entry Type) Option
8 Formula (Formula) Code80
9 Comparison Date Formula (Comparison Date Formula) DateFormula
10 Show Opposite Sign (Show Opposite Sign) Boolean
11 Show (Show) Option NotBlank: Yes
12 Rounding Factor (Rounding Factor) Option
13 Comparison Period Formula (Comparison Period Formula) Code20
14 Analysis Type Code (Analysis Type Code) Code10
15 Item Ledger Entry Type Filter (Item Ledger Entry Type Filter) Text250
16 Value Entry Type Filter (Value Entry Type Filter) Text250
17 Value Type (Value Type) Option
18 Invoiced (Invoiced) Boolean

Keys

# Fields
0 Analysis Area,Analysis Column Template,Line No. (Analysis Area,Analysis Column Template,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Analysis Column Template (Analysis Column Template) Analysis Column Template Name (Name) 1..n
Analysis Type Code (Analysis Type Code) Analysis Type Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Analysis Report Chart Line Analysis Column Line No. (Analysis Column Line No.) 1..n