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 PageIndentationDate 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 Totaling...«Table 98»General Ledger SetupPrimary Key [PK]Allow Posting FromAllow Posting ToRegister TimePmt. Disc. Excl. VATDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterCust. Balances DueVendor Balances DueUnrealized VATAdjust for Payment Disc.Mark Cr. Memos as CorrectionsLocal Address Format; [Post Code+City,...Inv. Rounding Precision [LCY]Inv. Rounding Type [LCY]; [Nearest,Up,...Local Cont. Addr. Format; [First,After...Bank Account Nos.Summarize G/L EntriesAmount Decimal PlacesUnit-Amount Decimal PlacesAdditional Reporting CurrencyVAT Tolerance %EMU CurrencyLCY CodeVAT Exchange Rate Adjustment; [No Adju...Amount Rounding PrecisionUnit-Amount Rounding PrecisionAppln. Rounding PrecisionGlobal Dimension 1 CodeGlobal Dimension 2 Code...«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><Acc. Sched. for Balance Sheet><Acc. Sched. for Income Stmt.><Acc. Sched. for Cash Flow Stmt><Acc. Sched. for Retained Earn.><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
General Ledger Setup Acc. Sched. for Retained Earn. 1..n