Diagrams


Table

Analysis Report Chart Line

DynamicsDocs.comAnalysis Report Chart Line«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 770»Analysis Report Chart SetupUser ID [PK]Name [PK]Analysis Area; [Sales,Purchase,Invento...Analysis Report NameAnalysis Line Template NameAnalysis Column Template NameBase X-Axis on; [Period,Line,Column]Start DateEnd DatePeriod Length; [Day,Week,Month,Quarter...No. of PeriodsLast Viewed«Table 7114»Analysis LineAnalysis Area; [Sales,Purchase,Invento...Analysis Line Template Name [PK]Line No. [PK]Row Ref. No.DescriptionType; [Item,Item Group,Customer,Custom...RangeNew PageShow; [Yes,No,If Any Column Not Zero]BoldItalicUnderlineShow Opposite SignSource Type Filter; [,Customer,Vendor,...Date FilterItem Budget FilterLocation FilterDimension 1 FilterDimension 2 FilterDimension 3 FilterDimension 1 TotalingDimension 2 TotalingDimension 3 TotalingSource No. FilterGroup Dimension CodeIndentation«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...Invoiced<User ID><Name><Analysis Area><Analysis Line Template Name><Analysis Column Template Name><Analysis Line Line No.><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 User ID (User ID) Text132 Editable: No
2 Name (Name) Text30 Editable: No
3 Analysis Line Line No. (Analysis Line Line No.) Integer Editable: No
4 Analysis Column Line No. (Analysis Column Line No.) Integer Editable: No
6 Analysis Area (Analysis Area) Option Editable: No
7 Analysis Line Template Name (Analysis Line Template Name) Code10 Editable: No
8 Analysis Column Template Name (Analysis Column Template Name) Code10 Editable: No
10 Original Measure Name (Original Measure Name) Text111 Editable: No
15 Measure Name (Measure Name) Text111
20 Measure Value (Measure Value) Text30 Editable: No
40 Chart Type (Chart Type) Option

Keys

# Fields
0 User ID,Analysis Area,Name,Analysis Line Line No.,Analysis Column Line No. (User ID,Analysis Area,Name,Analysis Line Line No.,Analysis Column Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Analysis Column Line No. (Analysis Column Line No.) Analysis Column Line No. (Line No.) 1..n
Analysis Line Line No. (Analysis Line Line No.) Analysis Line Line No. (Line No.) 1..n
Analysis Column Template Name (Analysis Column Template Name) Analysis Report Chart Setup Analysis Column Template Name (Analysis Column Template Name) 1..n

Table Relations From Other Tables

From Table From Field