Diagrams

Table

Analysis Column

DynamicsDocs.comAnalysis Column«Table 7118»Analysis ColumnAnalysis Area; [Sales,Purchase,Invento...Analysis Column Template [PK]Line No. [PK]Column No.Column HeaderColumn Type; [Formula,Net Change,Balan...Ledger Entry Type; [Item Entries,Item...FormulaComparison Date FormulaShow Opposite SignShow; [Always,Never,When Positive,When...Rounding Factor; [None,1,1000,1000000]Comparison Period FormulaAnalysis Type CodeItem Ledger Entry Type FilterValue Entry Type FilterValue Type; [,Quantity,Sales Amount,Co...InvoicedComparison Period Formula LCID«Table 771»Analysis Report Chart LineUser ID [PK]Name [PK]Analysis Line Line No. [PK]Analysis Column Line No. [PK]Analysis Area; [Sales,Purchase,Invento...Analysis Line Template NameAnalysis Column Template NameOriginal Measure NameMeasure NameMeasure ValueChart Type; [,Line,StepLine,Column,Sta...«Table 7116»Analysis Column TemplateAnalysis Area; [Sales,Purchase,Invento...Name [PK,NN]Description«Table 7113»Analysis TypeCode [PK,NN]NameValue Type; [,Quantity,Sales Amount,Co...Item Ledger Entry Type FilterValue Entry Type Filter<Analysis Column Template><Analysis Type Code><Analysis Column Line No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

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
30 Comparison Period Formula LCID (Comparison Period Formula LCID) Integer

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