Diagrams


Table

Cash Flow Worksheet Line

DynamicsDocs.comCash Flow Worksheet Line«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.Shortcut Dimension 2 CodeShortcut Dimension 1 CodeAmount [LCY]Source No.G/L Budget NameDimension Set ID«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 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 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. Memos«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«Table 95»G/L Budget NameName [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeBudget Dimension 4 Code«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Cash Flow Forecast No.><Cash Flow Account No.><Payment Terms Code><Shortcut Dimension 2 Code><Shortcut Dimension 1 Code><G/L Budget Name><Dimension Set ID><Cash Flow Forecast Filter><Global Dimension 1 Filter><Global Dimension 2 Filter><Dimension Value Code>

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

Fields

# Name Type
2 Line No. Integer
3 Cash Flow Forecast No. Code20
4 Cash Flow Date Date
5 Document No. Code20
6 Cash Flow Account No. Code20
7 Source Type Option
8 Description Text50
9 Document Type Option
10 Document Date Date
11 Pmt. Discount Date Date
12 Pmt. Disc. Tolerance Date Date
13 Payment Terms Code Code10
14 Payment Discount Decimal
15 Associated Entry No. Integer
17 Shortcut Dimension 2 Code Code20
18 Shortcut Dimension 1 Code Code20
30 Amount (LCY) Decimal
34 Source No. Code20
35 G/L Budget Name Code10
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Line No. Clustered: Yes
1 Cash Flow Forecast No.,Document No.

Table Relations To Other Tables

Field Related Table Related Field
Cash Flow Account No. Cash Flow Account No. 1..n
Cash Flow Forecast No. Cash Flow Forecast No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 1 Code Dimension Value Code 1..n
G/L Budget Name G/L Budget Name Name 1..n
Payment Terms Code Payment Terms Code 1..n

Table Relations From Other Tables

From Table From Field