Table 846 "Cash Flow Worksheet Line"
Base Application · Microsoft.CashFlow.Worksheet
Across versions
- BC23present
- BC24declaration changed
- BC251 procedures changed, 1 events added
- BC261 procedures changed, 1 events changed
- BC272 fields changed
- BC28unchanged
- BC291 procedures removed, 1 events removed
- BC30unchanged
Neighbourhood 20 connected objects and pages
Base Application · Microsoft.CashFlow.Worksheet · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 841 “Cash Flow Worksheet” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Cash Flow Worksheet Line |
| 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 |
|---|---|---|---|---|
| 2 | Line No. | Integer | — | |
| 3 | Cash Flow Forecast No. | Code[20] | Specifies a number for the cash flow forecast. via Page 841 “Cash Flow Worksheet” | TableRelation Table 840 “Cash Flow Forecast” (Cash Flow Forecast) |
| 4 | Cash Flow Date | Date | Specifies the cash flow date that the entry is posted to. via Page 841 “Cash Flow Worksheet” | |
| 5 | Document No. | Code[20] | Specifies the document that represents the forecast entry. via Page 841 “Cash Flow Worksheet” | |
| 6 | Cash Flow Account No. | Code[20] | Specifies the number of the cash flow account. via Page 841 “Cash Flow Worksheet” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 7 | 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 841 “Cash Flow Worksheet” | enum Enum 847 “Cash Flow Source Type” |
| 8 | Description | Text[250] | Specifies a description of the worksheet. via Page 841 “Cash Flow Worksheet” | |
| 9 | Document Type | Enum “Gen. Journal Document Type” | — | enum Enum 6 “Gen. Journal Document Type” |
| 10 | Document Date | Date | — | |
| 11 | Pmt. Discount Date | Date | — | |
| 12 | Pmt. Disc. Tolerance Date | Date | — | |
| 13 | Payment Terms Code | Code[10] | — | TableRelation Table 3 “Payment Terms” (Payment Terms) |
| 14 | Payment Discount Δ BC27 | Decimal | — | |
| 15 | Associated Entry No. | Integer | — | |
| 16 | Overdue | Boolean | Specifies if the entry is related to an overdue payment. via Page 841 “Cash Flow Worksheet” | not editable |
| 17 | Shortcut Dimension 2 Code | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. via Page 841 “Cash Flow Worksheet” | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 18 | Shortcut Dimension 1 Code | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. via Page 841 “Cash Flow Worksheet” | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 30 | Amount (LCY) Δ BC27 | Decimal | Specifies the amount of the worksheet line in LCY. Revenues are entered without a plus or minus sign. Expenses are entered with a minus sign. via Page 841 “Cash Flow Worksheet” | |
| 34 | Source No. | Code[20] | Specifies the number of the source document that the entry originates from. via Page 841 “Cash Flow Worksheet” | 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 | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
Keys
- Key1: Line No. (clustered)
- Key2: Cash Flow Forecast No., Document No.
Events published
OnAfterMoveDefualtDimToJnlLineDim(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; var DimensionSetID: Integer; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])(integration)OnAfterValidateShortcutDimCode(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; var xCashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnBeforeValidateShortcutDimCode(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; var xCashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnCalculateCFAmountAndCFDateOnAfterAssignApplyCFPaymentTerm(CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; var ApplyCFPaymentTerm: Boolean; var CheckCrMemo: Boolean; var IsHandled: Boolean)(integration)- subscribers: Codeunit 6493 “Serv. CashFlow Subscribers” OnCalculateCFAmountAndCFDateOnAfterAssignApplyCFPaymentTerm
OnCalculateCFAmountAndCFDateOnBeforeCalcPaymentDiscount(CFDiscountDate: Date; PaymentTerms: record "Payment Terms"; var IsHandled: boolean)(integration)OnBeforeOnValidateCashFlowAccountNo(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; var xCashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; var IsHandled: Boolean)+ BC25 (integration)
Procedures
EmptyLine(): BooleanValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])ShowDimensions()MoveDefualtDimToJnlLineDim(TableID: Integer; No: Code[20]; var DimensionSetID: Integer)CalculateCFAmountAndCFDate()ShowSource()Δ BC25
Triggers
OnInsert
Relations
- 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)
- Payment Terms Code: TableRelation Table 3 “Payment Terms”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- 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”
Pages and codeunits on this table
- Page 841 “Cash Flow Worksheet” (source table)
- Codeunit 843 “Cash Flow Wksh. - Register” (codeunit runs on it)
- Codeunit 844 “Cash Flow Wksh.-Register Batch” (codeunit runs on it)
- Codeunit 846 “Cash Flow Wksh. -Register Line” (codeunit runs on it)
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 408 “DimensionManagement” (7 calls:
LookupShortcutDimCode → LookupDimValueCode,LookupShortcutDimCode → ValidateShortcutDimValues,MoveDefualtDimToJnlLineDim → AddDimSource, …) - Codeunit 841 “Cash Flow Management” (1 call:
ShowSource → ShowSource)
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
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 Worksheet Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.