Diagrams


Table

Acc. Schedule Line

DynamicsDocs.comAcc. Schedule Line«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 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 95»G/L Budget NameName [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeBudget Dimension 4 Code«Table 220»Business UnitCode [PK,NN]ConsolidateConsolidation %Starting DateEnding DateIncome Currency FactorBalance Currency FactorExch. Rate Losses Acc.Exch. Rate Gains Acc.Residual AccountLast Balance Currency FactorNameCompany NameCurrency CodeComp. Exch. Rate Gains Acc.Comp. Exch. Rate Losses Acc.Equity Exch. Rate Gains Acc.Equity Exch. Rate Losses Acc.Minority Exch. Rate Gains Acc.Minority Exch. Rate Losses AccCurrency Exchange Rate Table; [Local,B...Data Source; [Local Curr. <LCY>,Add. R...File Format; [Version 4.00 or Later <....«Table 840»Cash Flow ForecastNo. [PK]Search NameDescriptionDescription 2Consider DiscountCreation DateCreated ByManual Payments ToCommentNo. SeriesManual Payments FromG/L Budget FromG/L Budget ToConsider CF Payment TermsConsider Pmt. Disc. Tol. DateConsider Pmt. Tol. AmountAccount No. FilterSource Type Filter; [,Receivables,Paya...Cash Flow Date FilterAmount [LCY]Positive Filter«Table 1112»Cost CenterCode [PK,NN]NameCost Subtype; [,Service Cost Center,Au...Cost Type FilterDate FilterNet ChangeBalance at DateBalance to AllocateResponsible PersonSorting OrderCommentLine Type; [Cost Center,Heading,Total,...BlockedNew PageBlank LineIndentationTotaling«Table 1113»Cost ObjectCode [PK,NN]NameCost Type FilterDate FilterNet ChangeBalance at DateSorting OrderCommentLine Type; [Cost Object,Heading,Total,...BlockedNew PageBlank LineIndentationTotaling«Table 1110»Cost Budget NameName [PK,NN]Description<Schedule Name><G/L Budget Filter><Business Unit Filter><Cash Flow Forecast Filter><Cost Center Filter><Cost Object Filter><Cost Budget Filter><Account Schedule Line No.><Account Schedule Name>

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

Fields

# Name Type
1 Schedule Name Code10
2 Line No. Integer
3 Row No. Code10
4 Description Text80
5 Totaling Text250
6 Totaling Type Option
7 New Page Boolean
11 Date Filter Date FlowFilter
12 Dimension 1 Filter Code20 FlowFilter
13 Dimension 2 Filter Code20 FlowFilter
14 G/L Budget Filter Code10 FlowFilter
15 Business Unit Filter Code20 FlowFilter
16 Show Option
17 Dimension 3 Filter Code20 FlowFilter
18 Dimension 4 Filter Code20 FlowFilter
19 Dimension 1 Totaling Text250
20 Dimension 2 Totaling Text250
21 Dimension 3 Totaling Text250
22 Dimension 4 Totaling Text250
23 Bold Boolean
24 Italic Boolean
25 Underline Boolean
26 Show Opposite Sign Boolean
27 Row Type Option
28 Amount Type Option
30 Double Underline Boolean
840 Cash Flow Forecast Filter Code20 FlowFilter
1100 Cost Center Filter Code20 FlowFilter
1101 Cost Object Filter Code20 FlowFilter
1102 Cost Center Totaling Text80
1103 Cost Object Totaling Text80
1104 Cost Budget Filter Code10 FlowFilter

Keys

# Fields
0 Schedule Name,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Schedule Name Acc. Schedule Name Name 1..n
Business Unit Filter Business Unit Code 1..n
Cash Flow Forecast Filter Cash Flow Forecast No. 1..n
Cost Budget Filter Cost Budget Name Name 1..n
Cost Center Filter Cost Center Code 1..n
Cost Object Filter Cost Object Code 1..n
G/L Budget Filter G/L Budget Name Name 1..n

Table Relations From Other Tables

From Table From Field
Acc. Sched. Chart Setup Line Account Schedule Line No. 1..n