Diagrams


Table

Cash Flow Account

DynamicsDocs.comCash Flow Account«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 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 842»Cash Flow Account CommentTable Name; [Cash Flow Forecast,Cash F...No. [PK]Line No. [PK]DateCodeComment«Table 843»Cash Flow SetupPrimary Key [PK]Cash Flow Forecast No. SeriesReceivables CF Account No.Payables CF Account No.Sales Order CF Account No.Purch. Order CF Account No.FA Budget CF Account No.FA Disposal CF Account No.Service CF Account No.CF No. on Chart in Role CenterJob CF Account No.Automatic Update Frequency; [Never,Dai...Tax CF Account No.Taxable Period; [Monthly,Quarterly,Acc...Tax Payment WindowTax Bal. Account Type; [,Vendor,G/L Ac...Tax Bal. Account No.API KeyAPI URLVariance %Historical PeriodsHorizonPeriod Type; [Day,Week,Month,Quarter,Y...TimeOutService Pass API Key IDCortana Intelligence EnabledShow Cortana Notification«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...DescriptionOverduePayment 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 849»Cash Flow Manual RevenueCode [PK,NN]Cash Flow Account No.DescriptionStarting DateEnding DateRecurring FrequencyAmountGlobal Dimension 1 CodeGlobal Dimension 2 Code«Table 850»Cash Flow Manual ExpenseCode [PK,NN]Cash Flow Account No.DescriptionStarting DateEnding DateRecurring FrequencyAmountGlobal Dimension 1 CodeGlobal Dimension 2 Code«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 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID<Cash Flow Forecast Filter><Global Dimension 1 Filter><Global Dimension 2 Filter><Account No.><No.><No.><Receivables CF Account No.><Payables CF Account No.><Sales Order CF Account No.><Purch. Order CF Account No.><FA Budget CF Account No.><FA Disposal CF Account No.><Service CF Account No.><Job CF Account No.><Tax CF Account No.><Cash Flow Account No.><Cash Flow Account No.><Cash Flow Account No.><Cash Flow Account No.><Cash Flow Forecast No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Cash Flow Forecast Filter><No.><Cash Flow Forecast No.><Shortcut Dimension 2 Code><Shortcut Dimension 1 Code><Cash Flow Forecast No.><Global Dimension 2 Code><Global Dimension 1 Code><Source No.><Source No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code>

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

Fields

# Name Type
1 No. Code20 NotBlank: Yes
2 Name Text50
3 Search Name Code50
4 Account Type Option
5 Comment Boolean Editable: No
FlowField
6 Blocked Boolean
7 New Page Boolean
8 No. of Blank Lines Integer
9 Indentation Integer
10 Last Date Modified Date Editable: No
11 Date Filter Date FlowFilter
12 Cash Flow Forecast Filter Code20 FlowFilter
13 Amount Decimal FlowField
29 Global Dimension 1 Filter Code20 FlowFilter
30 Global Dimension 2 Filter Code20 FlowFilter
34 Totaling Text250
35 Source Type Option
36 G/L Integration Option
37 G/L Account Filter Code250

Keys

# Fields
0 No. Clustered: Yes
1 Search Name
2 Source Type

Table Relations To Other Tables

Field Related Table Related Field
Cash Flow Forecast Filter Cash Flow Forecast No. 1..n
Global Dimension 2 Filter Dimension Value Code 1..n

Table Relations From Other Tables

From Table From Field
Analysis View Entry Account No. 1..n
Cash Flow Account Comment No. 1..n
Cash Flow Forecast Entry Cash Flow Account No. 1..n
Cash Flow Manual Expense Cash Flow Account No. 1..n
Cash Flow Manual Revenue Cash Flow Account No. 1..n
Cash Flow Setup Tax CF Account No. 1..n
Cash Flow Worksheet Line Cash Flow Account No. 1..n
G/L Account (Analysis View) No. 1..n