Diagrams

Table

Analysis View

DynamicsDocs.comAnalysis View«Table 363»Analysis ViewCode [PK,NN]NameAccount Source; [G/L Account,Cash Flow...Last Entry No.Last Budget Entry No.Last Date UpdatedUpdate on PostingBlockedAccount FilterBusiness Unit FilterStarting DateDate Compression; [None,Day,Week,Month...Dimension 1 CodeDimension 2 CodeDimension 3 CodeDimension 4 CodeInclude BudgetsRefresh When Unblocked«Table 333»Column Layout NameName [PK,NN]DescriptionAnalysis View Name«Table 364»Analysis View FilterAnalysis View Code [PK,NN]Dimension Code [PK,NN]Dimension Value Filter«Table 365»Analysis View EntryAnalysis View Code [PK,NN]Business Unit Code [PK]Account No. [PK]Dimension 1 Value Code [PK]Dimension 2 Value Code [PK]Dimension 3 Value Code [PK]Dimension 4 Value Code [PK]Posting Date [PK]Entry No. [PK]AmountDebit AmountCredit AmountAdd.-Curr. AmountAdd.-Curr. Debit AmountAdd.-Curr. Credit AmountAccount Source; [G/L Account,Cash Flow...Cash Flow Forecast No. [PK]«Table 366»Analysis View Budget EntryAnalysis View Code [PK,NN]Budget Name [PK]Business Unit Code [PK]G/L Account No. [PK]Dimension 1 Value Code [PK]Dimension 2 Value Code [PK]Dimension 3 Value Code [PK]Dimension 4 Value Code [PK]Posting Date [PK]Entry No. [PK]Amount«Table 369»Selected DimensionUser ID [PK]Object Type [PK]Object ID [PK]Dimension Code [PK]New Dimension Value CodeDimension Value FilterLevel; [,Level 1,Level 2,Level 3,Level...Analysis View Code [PK]«Table 376»G/L Account (Analysis View)No. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Account Source; [G/L Account,Cash Flow...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedCash Flow Forecast FilterDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudgeted at DateConsol. Debit Acc.Consol. Credit Acc....«Table 84»Acc. Schedule NameName [PK,NN]DescriptionDefault Column LayoutAnalysis View Name«Table 348»DimensionCode [PK,NN]NameCode CaptionFilter CaptionDescriptionBlockedConsolidation CodeMap-to IC Dimension Code<Dimension 1 Code><Dimension 2 Code><Dimension 3 Code><Dimension 4 Code><Analysis View Name><Analysis View Code><Analysis View Code><Analysis View Code><Analysis View Code><Analysis View Filter><Analysis View Name><Default Column Layout><Dimension Code>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Name (Name) Text50
3 Account Source (Account Source) Option
4 Last Entry No. (Last Entry No.) Integer
5 Last Budget Entry No. (Last Budget Entry No.) Integer
6 Last Date Updated (Last Date Updated) Date
7 Update on Posting (Update on Posting) Boolean Editable: No
8 Blocked (Blocked) Boolean
9 Account Filter (Account Filter) Code250
10 Business Unit Filter (Business Unit Filter) Code250
11 Starting Date (Starting Date) Date
12 Date Compression (Date Compression) Option
13 Dimension 1 Code (Dimension 1 Code) Code20
14 Dimension 2 Code (Dimension 2 Code) Code20
15 Dimension 3 Code (Dimension 3 Code) Code20
16 Dimension 4 Code (Dimension 4 Code) Code20
17 Include Budgets (Include Budgets) Boolean
18 Refresh When Unblocked (Refresh When Unblocked) Boolean

Keys

# Fields
0 Code (Code) Clustered: Yes
1 Account Source (Account Source)

Table Relations To Other Tables

Field Related Table Related Field
Dimension 4 Code (Dimension 4 Code) Dimension Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Acc. Schedule Name Analysis View Name (Analysis View Name) 1..n
Analysis View Budget Entry Analysis View Code (Analysis View Code) 1..n
Analysis View Entry Analysis View Code (Analysis View Code) 1..n
Analysis View Filter Analysis View Code (Analysis View Code) 1..n
Column Layout Name Analysis View Name (Analysis View Name) 1..n
G/L Account (Analysis View) Analysis View Filter (Analysis View Filter) 1..n
Selected Dimension Analysis View Code (Analysis View Code) 1..n