Diagrams


Table

Acc. Sched. Chart Setup Line

DynamicsDocs.comAcc. Sched. Chart Setup Line«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 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 84»Acc. Schedule NameName [PK,NN]DescriptionDefault Column LayoutAnalysis View Name«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 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<User ID><Name><Account Schedule Name><Account Schedule Line No.><Column Layout Name><Column Layout Line No.><Account Schedule Name><Column Layout Name><Default Column Layout><Schedule Name><Column Layout Name>

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

Fields

# Name Type
1 User ID Text132 Editable: No
2 Name Text30 Editable: No
3 Account Schedule Name Code10 Editable: No
4 Account Schedule Line No. Integer Editable: No
5 Column Layout Name Code10 Editable: No
6 Column Layout Line No. Integer Editable: No
10 Original Measure Name Text111 Editable: No
15 Measure Name Text111
20 Measure Value Text30 Editable: No
40 Chart Type Option

Keys

# Fields
0 User ID,Name,Account Schedule Line No.,Column Layout Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Account Schedule Line No. Acc. Schedule Line Line No. 1..n
Account Schedule Name Acc. Schedule Name Name 1..n
Name Account Schedules Chart Setup Name 1..n
Column Layout Line No. Column Layout Line No. 1..n
Column Layout Name Column Layout Name Name 1..n

Table Relations From Other Tables

From Table From Field