Diagrams

Table

Analysis Line Template

DynamicsDocs.comAnalysis Line Template«Table 7112»Analysis Line TemplateAnalysis Area; [Sales,Purchase,Invento...Name [PK,NN]DescriptionDefault Column Template NameItem Analysis View Code«Table 7111»Analysis Report NameAnalysis Area; [Sales,Purchase,Invento...Name [PK,NN]DescriptionAnalysis Line Template NameAnalysis Column Template Name«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 7116»Analysis Column TemplateAnalysis Area; [Sales,Purchase,Invento...Name [PK,NN]Description«Table 7152»Item Analysis ViewAnalysis Area; [Sales,Purchase,Invento...Code [PK,NN]NameLast Entry No.Last Budget Entry No.Last Date UpdatedUpdate on PostingBlockedItem FilterLocation FilterStarting DateDate Compression; [None,Day,Week,Month...Dimension 1 CodeDimension 2 CodeDimension 3 CodeInclude BudgetsRefresh When Unblocked<Default Column Template Name><Item Analysis View Code><Analysis Line Template Name><Analysis Line Template Name><Analysis Column Template Name>

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 Name (Name) Code10 NotBlank: Yes
3 Description (Description) Text80
4 Default Column Template Name (Default Column Template Name) Code10
5 Item Analysis View Code (Item Analysis View Code) Code10

Keys

# Fields
0 Analysis Area,Name (Analysis Area,Name) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Default Column Template Name (Default Column Template Name) Analysis Column Template Name (Name) 1..n
Item Analysis View Code (Item Analysis View Code) Item Analysis View Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Analysis Line Analysis Line Template Name (Analysis Line Template Name) 1..n
Analysis Report Name Analysis Line Template Name (Analysis Line Template Name) 1..n