Diagrams


Table

Cash Flow Forecast

DynamicsDocs.comCash Flow Forecast«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 FilterOverdue CF Dates to Work DateDefault G/L Budget Name«Table 365»Analysis View EntryAnalysis View Code [PK,NN]Business Unit Code [PK]Account No. [PK]Dimension 1 Value Code [PK]Dimension 2 Value Code [PK]Dimension 3 Value Code [PK]Dimension 4 Value Code [PK]Posting Date [PK]Entry No. [PK]AmountDebit AmountCredit AmountAdd.-Curr. AmountAdd.-Curr. Debit AmountAdd.-Curr. Credit AmountAccount Source; [G/L Account,Cash Flow...Cash Flow Forecast No. [PK]«Table 376»G/L Account (Analysis View)No. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Account Source; [G/L Account,Cash Flow...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedCash Flow Forecast FilterDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudgeted at DateConsol. Debit Acc.Consol. Credit Acc....«Table 841»Cash Flow AccountNo. [PK,NN]NameSearch NameAccount Type; [Entry,Heading,Total,Beg...CommentBlockedNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterCash Flow Forecast FilterAmountGlobal Dimension 1 FilterGlobal Dimension 2 FilterTotalingSource Type; [,Receivables,Payables,Li...G/L Integration; [,Balance,Budget,Both...G/L Account Filter«Table 842»Cash Flow Account CommentTable Name; [Cash Flow Forecast,Cash F...No. [PK]Line No. [PK]DateCodeComment«Table 846»Cash Flow Worksheet LineLine No. [PK]Cash Flow Forecast No.Cash Flow DateDocument No.Cash Flow Account No.Source Type; [,Receivables,Payables,Li...DescriptionDocument Type; [,Payment,Invoice,Credi...Document DatePmt. Discount DatePmt. Disc. Tolerance DatePayment Terms CodePayment DiscountAssociated Entry No.OverdueShortcut Dimension 2 CodeShortcut Dimension 1 CodeAmount [LCY]Source No.G/L Budget NameDimension Set ID«Table 847»Cash Flow Forecast EntryEntry No. [PK]User IDCash Flow Forecast No.Cash Flow DateDocument No.Cash Flow Account No.Source Type; [,Receivables,Payables,Li...DescriptionOverdueDocument DatePayment DiscountAssociated Entry No.Associated Document No.Global Dimension 2 CodeGlobal Dimension 1 CodeRecurring Method; [,Fixed,Variable]Amount [LCY]PositiveSource No.G/L Budget NameDimension Set ID«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 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 95»G/L Budget NameName [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeBudget Dimension 4 Code<No. Series><Default G/L Budget Name><Cash Flow Forecast No.><Cash Flow Forecast Filter><Cash Flow Forecast Filter><No.><Cash Flow Forecast No.><Cash Flow Forecast No.><Cash Flow Forecast Filter><Account No.><No.><Budget Filter><No.><Cash Flow Account No.><Cash Flow Account No.><G/L Budget Name><G/L Budget Name><G/L Budget Filter>

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

Fields

# Name Type
1 No. Code20
2 Search Name Code50
3 Description Text50
4 Description 2 Text50
5 Consider Discount Boolean
6 Creation Date Date
7 Created By Code50
8 Manual Payments To Date
9 Comment Boolean FlowField
10 No. Series Code20 Editable: No
11 Manual Payments From Date
12 G/L Budget From Date
13 G/L Budget To Date
14 Consider CF Payment Terms Boolean
15 Consider Pmt. Disc. Tol. Date Boolean
16 Consider Pmt. Tol. Amount Boolean
17 Account No. Filter Code20 FlowFilter
18 Source Type Filter Option FlowFilter
19 Cash Flow Date Filter Date FlowFilter
20 Amount (LCY) Decimal FlowField
21 Positive Filter Boolean FlowFilter
22 Overdue CF Dates to Work Date Boolean
23 Default G/L Budget Name Code10

Keys

# Fields
0 No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Default G/L Budget Name G/L Budget Name Name 1..n
No. Series No. Series Code 1..n

Table Relations From Other Tables

From Table From Field
Acc. Schedule Line Cash Flow Forecast Filter 1..n
Analysis View Entry Cash Flow Forecast No. 1..n
Cash Flow Account Cash Flow Forecast Filter 1..n
Cash Flow Account Comment No. 1..n
Cash Flow Forecast Entry Cash Flow Forecast No. 1..n
Cash Flow Worksheet Line Cash Flow Forecast No. 1..n
G/L Account (Analysis View) Cash Flow Forecast Filter 1..n