Diagrams


Table

Analysis Column

Fields

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

Keys

# Fields
0 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 Name 1..n
Analysis Type Code Analysis Type Code 1..n

Table Relations From Other Tables

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