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.OverdueShortcut 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 FilterOverdue CF Dates to Work DateDefault G/L Budget Name«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><Default G/L Budget Name><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. (Line No.) Integer
3 Cash Flow Forecast No. (Cash Flow Forecast No.) Code20
4 Cash Flow Date (Cash Flow Date) Date
5 Document No. (Document No.) Code20
6 Cash Flow Account No. (Cash Flow Account No.) Code20
7 Source Type (Source Type) Option
8 Description (Description) Text250
9 Document Type (Document Type) Option
10 Document Date (Document Date) Date
11 Pmt. Discount Date (Pmt. Discount Date) Date
12 Pmt. Disc. Tolerance Date (Pmt. Disc. Tolerance Date) Date
13 Payment Terms Code (Payment Terms Code) Code10
14 Payment Discount (Payment Discount) Decimal
15 Associated Entry No. (Associated Entry No.) Integer
16 Overdue (Overdue) Boolean Editable: No
17 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
18 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
30 Amount (LCY) (Amount (LCY)) Decimal
34 Source No. (Source No.) Code20
35 G/L Budget Name (G/L Budget Name) Code10
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

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

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
Cash Flow Forecast No. (Cash Flow Forecast No.) Cash Flow Forecast No. (No.) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Dimension Value Code (Code) 1..n
G/L Budget Name (G/L Budget Name) G/L Budget Name Name (Name) 1..n
Payment Terms Code (Payment Terms Code) Payment Terms Code (Code) 1..n

Table Relations From Other Tables

From Table From Field