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 CodeIdLast Modified Date Time<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 Code10 NotBlank: Yes
2 Name Text50
3 Account Source Option
4 Last Entry No. Integer
5 Last Budget Entry No. Integer
6 Last Date Updated Date
7 Update on Posting Boolean Editable: No
8 Blocked Boolean
9 Account Filter Code250
10 Business Unit Filter Code250
11 Starting Date Date
12 Date Compression Option
13 Dimension 1 Code Code20
14 Dimension 2 Code Code20
15 Dimension 3 Code Code20
16 Dimension 4 Code Code20
17 Include Budgets Boolean
18 Refresh When Unblocked Boolean

Keys

# Fields
0 Code Clustered: Yes
1 Account Source

Table Relations To Other Tables

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

Table Relations From Other Tables

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