Diagrams


Table

Acc. Schedule Name

DynamicsDocs.comAcc. Schedule Name«Table 84»Acc. Schedule NameName [PK,NN]DescriptionDefault Column LayoutAnalysis View Name«Table 136»Acc. Sched. KPI Web Srv. LineAcc. Schedule Name [PK,NN]Acc. Schedule Description«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 85»Acc. Schedule LineSchedule Name [PK]Line No. [PK]Row No.DescriptionTotalingTotaling Type; [Posting Accounts,Total...New PageDate FilterDimension 1 FilterDimension 2 FilterG/L Budget FilterBusiness Unit FilterShow; [Yes,No,If Any Column Not Zero,W...Dimension 3 FilterDimension 4 FilterDimension 1 TotalingDimension 2 TotalingDimension 3 TotalingDimension 4 TotalingBoldItalicUnderlineShow Opposite SignRow Type; [Net Change,Balance at Date,...Amount Type; [Net Amount,Debit Amount,...Double UnderlineCash Flow Forecast FilterCost Center FilterCost Object FilterCost Center TotalingCost Object Totaling...«Table 333»Column Layout NameName [PK,NN]DescriptionAnalysis 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<Default Column Layout><Analysis View Name><Acc. Schedule Name><Account Schedule Name><Account Schedule Name><Schedule Name><Column Layout Name><User ID><Name><Account Schedule Line No.><Column Layout 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
3 Default Column Layout Code10
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
Default Column Layout Column Layout Name Name 1..n

Table Relations From Other Tables

From Table From Field
Acc. Sched. Chart Setup Line Account Schedule Name 1..n
Acc. Sched. KPI Web Srv. Line Acc. Schedule Name 1..1
Acc. Schedule Line Schedule Name 1..n
Account Schedules Chart Setup Account Schedule Name 1..n