Table 841 "Cash Flow Account"
Base Application · Microsoft.CashFlow.Account
Across versions
- BC23present
- BC241 fields changed
- BC25-26unchanged
- BC271 fields changed
- BC28-30unchanged
Neighbourhood 23 connected objects and pages
Base Application · Microsoft.CashFlow.Account · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 851 “Chart of Cash Flow Accounts” (2 Learn pages), Page 862 “Cash Flow Account Card” (2), Page 855 “Cash Flow Account List” (1).
Properties
| Property | Value |
|---|---|
| Caption | Cash Flow Account |
| 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 | No. | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. via Page 862 “Cash Flow Account Card” | NotBlank |
| 2 | Name | Text[50] | Specifies the name of the cash flow account. via Page 862 “Cash Flow Account Card” | |
| 3 | Search Name | Code[50] | Specifies an alternate name that you can use to search for the record in question when you cannot remember the value in the Name field. via Page 862 “Cash Flow Account Card” | |
| 4 | Account Type | Enum “Cash Flow Account Type” | Specifies the purpose of the cash flow account. Newly created cash flow accounts are automatically assigned the Entry account type, but you can change this. via Page 862 “Cash Flow Account Card” | enum Enum 841 “Cash Flow Account Type” |
| 5 | Comment | Boolean | Specifies the comment for the record. via Page 855 “Cash Flow Account List” | FlowField: exist(“Cash Flow Account Comment” where(“Table Name” = const(“Cash Flow Account”), “No.” = field(“No.”))); not editable |
| 6 | Blocked | Boolean | Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine. via Page 862 “Cash Flow Account Card” | |
| 7 | New Page | Boolean | Specifies if you want a new page to start immediately after this cash flow account when you print the chart of cash flow accounts. via Page 862 “Cash Flow Account Card” | |
| 8 | No. of Blank Lines | Integer | Specifies the number of blank lines that you want to be inserted before this cash flow account in the chart of cash flow accounts. via Page 862 “Cash Flow Account Card” | |
| 9 | Indentation | Integer | — | |
| 10 | Last Date Modified | Date | — | not editable |
| 11 | Date Filter | Date | — | FlowFilter |
| 12 | Cash Flow Forecast Filter | Code[20] | — | TableRelation Table 840 “Cash Flow Forecast” (Cash Flow Forecast); FlowFilter |
| 13 | Amount Δ BC24 Δ BC27 | Decimal | Specifies the cash flow amount. via Page 851 “Chart of Cash Flow Accounts” | FlowField: sum(“Cash Flow Forecast Entry”.“Amount (LCY)” where(“Cash Flow Account No.” = field(“No.”), “Cash Flow Account No.” = field(filter(Totaling)), “Cash Flow Forecast No.” = field(“Cash Flow Forecast Filter”), “Cash Flow Date” = field(“Date Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1… |
| 29 | Global Dimension 1 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))); FlowFilter |
| 30 | Global Dimension 2 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))); FlowFilter |
| 34 | Totaling | Text[250] | Specifies an account interval or a list of account numbers. The entries of the account will be totaled to give a total balance. How entries are totaled depends on the value in the Account Type field. via Page 862 “Cash Flow Account Card” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 35 | 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 862 “Cash Flow Account Card” | enum Enum 847 “Cash Flow Source Type” |
| 36 | G/L Integration | Option | Specifies if the cash flow account has integration with the general ledger. When a cash flow account has integration with the general ledger, either the balances of the general ledger accounts or their budgeted values are used in the cash flow forecast. via Page 862 “Cash Flow Account Card” | OptionCaption: ,Balance,Budget,Both |
| 37 | G/L Account Filter | Code[250] | Specifies that only the cash flow entries that are registered to the filtered general ledger accounts are included in the cash flow forecast. via Page 862 “Cash Flow Account Card” | TableRelation Table 15 “G/L Account” (G/L Account) |
Keys
- Key1: No. (clustered)
- Key2: Search Name
- Key3: Source Type
Events published
OnBeforeOnLookup(var CashFlowAccount: Record "Cash Flow Account"; var IsHandled: Boolean)(integration)
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- drill-down page Page 855 “Cash Flow Account List”
- lookup page Page 855 “Cash Flow Account List”
- G/L Account Filter: TableRelation Table 15 “G/L Account”
- Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
- Cash Flow Forecast Filter: TableRelation Table 840 “Cash Flow Forecast”
- Totaling: TableRelation Table 841 “Cash Flow Account”
- Comment: CalcFormula Table 842 “Cash Flow Account Comment”
- Amount: CalcFormula Table 847 “Cash Flow Forecast Entry”
Referenced by
21 fields in 13 objects relate to this table (TableRelation or CalcFormula).
- Table 843 “Cash Flow Setup”: FA Budget CF Account No., FA Disposal CF Account No., Job CF Account No., Payables CF Account No., Purch. Order CF Account No., Receivables CF Account No., Sales Order CF Account No., Tax CF Account No.
- Table 376 “G/L Account (Analysis View)”: No., Totaling
- Table 363 “Analysis View”: Account Filter
- Table 365 “Analysis View Entry”: Account No.
- Table 368 “Dimension Selection Buffer”: Dimension Value Filter
- Table 841 “Cash Flow Account”: Totaling
- Table 842 “Cash Flow Account Comment”: No.
- Table 846 “Cash Flow Worksheet Line”: Cash Flow Account No.
- Table 847 “Cash Flow Forecast Entry”: Cash Flow Account No.
- Table 849 “Cash Flow Manual Revenue”: Cash Flow Account No.
- Table 85 “Acc. Schedule Line”: Totaling
- Table 850 “Cash Flow Manual Expense”: Cash Flow Account No.
- Table extension 6471 “Serv. Cash Flow Setup”: Service CF Account No.
Pages and codeunits on this table
- Page 851 “Chart of Cash Flow Accounts” (source table)
- Page 855 “Cash Flow Account List” (source table)
- Page 862 “Cash Flow Account Card” (source table)
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 361 “MoveEntries” (1 call:
OnDelete → MoveCashFlowEntries)
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 Account"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.