Diagrams

Table

Account Schedules Chart Setup

DynamicsDocs.comAccount Schedules Chart Setup«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 333»Column Layout NameName [PK,NN]DescriptionAnalysis View Name<Account Schedule Name><Column Layout Name><User ID><Name><Account Schedule Name><Column Layout Name><Default Column Layout>

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

Fields

# Name Type
1 User ID (User ID) Text132 Editable: No
2 Name (Name) Text30
3 Description (Description) Text250
10 Account Schedule Name (Account Schedule Name) Code10
20 Column Layout Name (Column Layout Name) Code10
30 Base X-Axis on (Base X-Axis on) Option
31 Start Date (Start Date) Date
32 End Date (End Date) Date
41 Period Length (Period Length) Option
42 No. of Periods (No. of Periods) Integer
50 Last Viewed (Last Viewed) Boolean Editable: No
51 Look Ahead (Look Ahead) Boolean

Keys

# Fields
0 User ID,Name (User ID,Name) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Account Schedule Name (Account Schedule Name) Acc. Schedule Name Name (Name) 1..n
Column Layout Name (Column Layout Name) Column Layout Name Name (Name) 1..n

Table Relations From Other Tables

From Table From Field
Acc. Sched. Chart Setup Line Name (Name) 1..n