tableAL Developmentofficial - Microsoftderived - from the source, no model text

Table 847 "Cash Flow Forecast Entry"

Base Application · Microsoft.CashFlow.Forecast

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC25-26unchanged
  4. BC272 fields changed
  5. BC28-30unchanged

Neighbourhood 19 connected objects and pages

Table 480 "Dimension Set Entry" (relates to, 7 links)Dimension Set EntryTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 15 "G/L Account" (relates to)G/L AccountTable 21 "Cust. Ledger Entry" (relates to)Cust. Ledger EntryTable 25 "Vendor Ledger Entry" (relates to)Vendor Ledger EntryTable 5600 "Fixed Asset" (relates to)Fixed AssetTable 840 "Cash Flow Forecast" (relates to)Cash Flow ForecastTable 841 "Cash Flow Account" (relates to)Cash Flow AccountTable 95 "G/L Budget Name" (relates to)G/L Budget NamePage 850 "Cash Flow Forecast Entries" (pages and codeunits on it, 3 links)Cash Flow Forecast EntriesPage 860 "CF Entries Dim. Overview" (pages and codeunits on it)CF Entries Dim. OverviewPage 863 "CF Entries Dim. Matrix" (pages and codeunits on it)Table extension 6470 "Serv. Cash Flow Forecast Entry" (extended by)Serv. Cash Flow Forecast EntryCodeunit 841 "Cash Flow Management" (calls, 2 links)Cash Flow ManagementCodeunit 408 "DimensionManagement" (calls)DimensionManagementCodeunit 703 "Find Record Management" (calls)Table 840 "Cash Flow Forecast" (referenced by)Table 841 "Cash Flow Account" (referenced by)Analyze cash flows (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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(): Integer
  • ShowDimensions()
  • DrillDownOnEntries(var CashFlowForecast: Record "Cash Flow Forecast")
  • ShowSource(ShowDocument: Boolean)

Relations

Referenced by

2 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this 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.

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.

Evidence 1 sources