Table 847 "Cash Flow Forecast Entry"
Base Application · Microsoft.CashFlow.Forecast
Across versions
- BC23present
- BC24declaration changed
- BC25-26unchanged
- BC272 fields changed
- BC28-30unchanged
Neighbourhood 19 connected objects and pages
Base Application · Microsoft.CashFlow.Forecast · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 850 “Cash Flow Forecast Entries” (1 Learn page), Page 860 “CF Entries Dim. Overview” (1), Page 863 “CF Entries Dim. Matrix” (1).
Properties
| Property | Value |
|---|---|
| Caption | Cash Flow Forecast Entry |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. via Page 850 “Cash Flow Forecast Entries” | |
| 2 | User ID | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. via Page 850 “Cash Flow Forecast Entries” | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 10 | Cash Flow Forecast No. | Code[20] | Specifies a number for the cash flow forecast. via Page 850 “Cash Flow Forecast Entries” | TableRelation Table 840 “Cash Flow Forecast” (Cash Flow Forecast) |
| 11 | Cash Flow Date | Date | Specifies the cash flow date that the entry is posted to. via Page 850 “Cash Flow Forecast Entries” | |
| 12 | Document No. | Code[20] | Specifies the document that represents the forecast entry. via Page 850 “Cash Flow Forecast Entries” | |
| 13 | Cash Flow Account No. | Code[20] | Specifies the number of the cash flow account that the forecast entry is posted to. via Page 850 “Cash Flow Forecast Entries” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 14 | Source Type | Enum “Cash Flow Source Type” | Specifies the source type that applies to the source number that is shown in the Source No. field. via Page 850 “Cash Flow Forecast Entries” | enum Enum 847 “Cash Flow Source Type”; not editable |
| 15 | Description | Text[250] | Specifies a description of the cash flow forecast entry. via Page 850 “Cash Flow Forecast Entries” | |
| 16 | Overdue | Boolean | Specifies if the entry is related to an overdue payment. via Page 850 “Cash Flow Forecast Entries” | not editable |
| 17 | Document Date | Date | — | |
| 21 | Payment Discount Δ BC27 | Decimal | Specifies the possible payment discount for the cash flow forecast. via Page 850 “Cash Flow Forecast Entries” | |
| 22 | Associated Entry No. | Integer | — | |
| 23 | Associated Document No. | Code[20] | — | |
| 24 | Global Dimension 2 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. via Page 850 “Cash Flow Forecast Entries” | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 25 | Global Dimension 1 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. via Page 850 “Cash Flow Forecast Entries” | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 26 | Recurring Method | Option | — | OptionCaption: ,Fixed,Variable |
| 29 | Amount (LCY) Δ BC27 | Decimal | Specifies the amount of the forecast line in LCY. Revenues are entered without a plus or minus sign. Expenses are entered with a minus sign. via Page 850 “Cash Flow Forecast Entries” | |
| 30 | Positive | Boolean | — | not editable |
| 33 | Source No. | Code[20] | Specifies the number of the source document that the entry originates from. via Page 850 “Cash Flow Forecast Entries” | TableRelation Table 15 “G/L Account”, Table 21 “Cust. Ledger Entry”, Table 25 “Vendor Ledger Entry” (if (“Source Type” = const(“Liquid Funds”)) “G/L Account” else if (“Source Type” = const(Receivables)) “Cust. Ledger Entry”.“Document No.” else if (“Source Type” = const(Payables)) “Vendor Ledger Entry”.“Document No.” else if (“Source Type” = const(“Fixed Assets Budget”)) “Fixed Asset” else if (“Sour…) |
| 35 | G/L Budget Name | Code[10] | — | TableRelation Table 95 “G/L Budget Name” (G/L Budget Name) |
| 36 | Source Line No. | Integer | — | |
| 480 | Dimension Set ID | Integer | Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. via Page 850 “Cash Flow Forecast Entries” | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 481 | Shortcut Dimension 3 Code | Code[20] | Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 850 “Cash Flow Forecast Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3))); not editable |
| 482 | Shortcut Dimension 4 Code | Code[20] | Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 850 “Cash Flow Forecast Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4))); not editable |
| 483 | Shortcut Dimension 5 Code | Code[20] | Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 850 “Cash Flow Forecast Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5))); not editable |
| 484 | Shortcut Dimension 6 Code | Code[20] | Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 850 “Cash Flow Forecast Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6))); not editable |
| 485 | Shortcut Dimension 7 Code | Code[20] | Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 850 “Cash Flow Forecast Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7))); not editable |
| 486 | Shortcut Dimension 8 Code | Code[20] | Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 850 “Cash Flow Forecast Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8))); not editable |
Keys
- Key1: Entry No. (clustered)
- Key2: Cash Flow Account No., Cash Flow Date, Cash Flow Forecast No.
- Key3: Cash Flow Forecast No., Cash Flow Account No., Source Type, Cash Flow Date, Positive
- Key4: Cash Flow Account No., Cash Flow Forecast No., Global Dimension 1 Code, Global Dimension 2 Code, Cash Flow Date
- Key5: Cash Flow Forecast No., Cash Flow Date
Procedures
GetLastEntryNo(): IntegerShowDimensions()DrillDownOnEntries(var CashFlowForecast: Record "Cash Flow Forecast")ShowSource(ShowDocument: Boolean)
Relations
- drill-down page Page 850 “Cash Flow Forecast Entries”
- lookup page Page 850 “Cash Flow Forecast Entries”
- Source No.: TableRelation Table 15 “G/L Account” (conditional)
- Source No.: TableRelation Table 21 “Cust. Ledger Entry” (conditional)
- Source No.: TableRelation Table 25 “Vendor Ledger Entry” (conditional)
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Source No.: TableRelation Table 5600 “Fixed Asset” (conditional)
- Cash Flow Forecast No.: TableRelation Table 840 “Cash Flow Forecast”
- Cash Flow Account No.: TableRelation Table 841 “Cash Flow Account”
- G/L Budget Name: TableRelation Table 95 “G/L Budget Name”
Referenced by
2 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 840 “Cash Flow Forecast”: Amount (LCY)
- Table 841 “Cash Flow Account”: Amount
Pages and codeunits on this table
- Page 850 “Cash Flow Forecast Entries” (source table)
- Page 860 “CF Entries Dim. Overview” (source table)
- Page 863 “CF Entries Dim. Matrix” (source table)
Extended by
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 841 “Cash Flow Management” (2 calls:
ShowSource → ShowSource,ShowSource → ShowSourceDocument) - Codeunit 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 703 “Find Record Management” (1 call:
GetLastEntryNo → GetLastEntryIntFieldValue)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Cash Flow Forecast Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.