Diagrams


Table

Column Layout Name

DynamicsDocs.comColumn Layout Name«Table 333»Column Layout NameName [PK,NN]DescriptionAnalysis View Name«Table 334»Column LayoutColumn Layout Name [PK]Line No. [PK]Column No.Column HeaderColumn Type; [Formula,Net Change,Balan...Ledger Entry Type; [Entries,Budget Ent...Amount Type; [Net Amount,Debit Amount,...FormulaComparison Date FormulaShow Opposite SignShow; [Always,Never,When Positive,When...Rounding Factor; [None,1,1000,1000000]Comparison Period FormulaBusiness Unit TotalingDimension 1 TotalingDimension 2 TotalingDimension 3 TotalingDimension 4 TotalingCost Center TotalingCost Object Totaling«Table 762»Account Schedules Chart SetupUser ID [PK]Name [PK]DescriptionAccount Schedule NameColumn Layout NameBase X-Axis on; [Period,Acc. Sched. Li...Start DateEnd DatePeriod Length; [Day,Week,Month,Quarter...No. of PeriodsLast ViewedLook Ahead«Table 763»Acc. Sched. Chart Setup LineUser ID [PK]Name [PK]Account Schedule NameAccount Schedule Line No. [PK]Column Layout NameColumn Layout Line No. [PK]Original Measure NameMeasure NameMeasure ValueChart Type; [,Line,StepLine,Column,Sta...«Table 84»Acc. Schedule NameName [PK,NN]DescriptionDefault Column LayoutAnalysis View Name«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<Analysis View Name><Column Layout Name><Column Layout Name><Column Layout Name><Default Column Layout><Column Layout Line No.><Account Schedule Name><User ID><Name><Account Schedule Name><Analysis View Name>

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

Fields

# Name Type
1 Name Code10 NotBlank: Yes
2 Description Text80
4 Analysis View Name Code10

Keys

# Fields
0 Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Analysis View Name Analysis View Code 1..n

Table Relations From Other Tables

From Table From Field
Acc. Sched. Chart Setup Line Column Layout Name 1..n
Acc. Schedule Name Default Column Layout 1..n
Account Schedules Chart Setup Column Layout Name 1..n
Column Layout Column Layout Name 1..n