Diagrams


Table

Cash Flow Manual Expense

DynamicsDocs.comCash Flow Manual Expense«Table 850»Cash Flow Manual ExpenseCode [PK,NN]Cash Flow Account No.DescriptionStarting DateEnding DateRecurring FrequencyAmountGlobal Dimension 1 CodeGlobal Dimension 2 Code«Table 352»Default DimensionTable ID [PK,NN]No. [PK]Dimension Code [PK,NN]Dimension Value CodeValue Posting; [,Code Mandatory,Same C...Table CaptionMulti Selection Action; [,Change,Delet...«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 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 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 Account No.><Global Dimension 1 Code><Global Dimension 2 Code><No.><Source No.><Dimension Value Code><Cash Flow Account No.><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 1 Filter><Global Dimension 2 Filter>

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

Fields

# Name Type
2 Code (Code) Code10 NotBlank: Yes
3 Cash Flow Account No. (Cash Flow Account No.) Code20
4 Description (Description) Text50
5 Starting Date (Starting Date) Date
6 Ending Date (Ending Date) Date
7 Recurring Frequency (Recurring Frequency) DateFormula
8 Amount (Amount) Decimal
9 Global Dimension 1 Code (Global Dimension 1 Code) Code20
10 Global Dimension 2 Code (Global Dimension 2 Code) Code20

Keys

# Fields
0 Code (Code) Clustered: Yes
1 Starting Date (Starting Date)

Table Relations To Other Tables

Field Related Table Related Field
Cash Flow Account No. (Cash Flow Account No.) Cash Flow Account No. (No.) 1..n
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Cash Flow Forecast Entry Source No. (Source No.) 1..n
Default Dimension No. (No.) 1..n