Diagrams


Table

Analysis View Entry

DynamicsDocs.comAnalysis View Entry«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 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«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 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...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 ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...«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 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<Analysis View Code><Business Unit Code><Account No.><Account No.><Cash Flow Forecast No.><Exch. Rate Losses Acc.><Exch. Rate Gains Acc.><Residual Account><Comp. 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 Acc><Business Unit Filter><Cash Flow Forecast Filter>

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

Fields

# Name Type
1 Analysis View Code Code10 NotBlank: Yes
2 Business Unit Code Code20
3 Account No. Code20
4 Dimension 1 Value Code Code20
5 Dimension 2 Value Code Code20
6 Dimension 3 Value Code Code20
7 Dimension 4 Value Code Code20
8 Posting Date Date
9 Entry No. Integer
10 Amount Decimal
11 Debit Amount Decimal
12 Credit Amount Decimal
13 Add.-Curr. Amount Decimal
14 Add.-Curr. Debit Amount Decimal
15 Add.-Curr. Credit Amount Decimal
16 Account Source Option
17 Cash Flow Forecast No. Code20

Keys

# Fields
0 Analysis View Code,Account No.,Account Source,Dimension 1 Value Code,Dimension 2 Value Code,Dimension 3 Value Code,Dimension 4 Value Code,Business Unit Code,Posting Date,Entry No.,Cash Flow Forecast No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Analysis View Code Analysis View Code 1..n
Business Unit Code Business Unit Code 1..n
Account No. Cash Flow Account No. 1..n
Cash Flow Forecast No. Cash Flow Forecast No. 1..n
Account No. G/L Account No. 1..n

Table Relations From Other Tables

From Table From Field