Table 841 Cash Flow Account

Base Application, Microsoft.CashFlow.Account

src/Layers/W1/BaseApp/CashFlow/Account/CashFlowAccount.Table.al230 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.CashFlow.Account;using Microsoft.CashFlow.Comment;using Microsoft.CashFlow.Forecast;using Microsoft.CashFlow.Setup;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Foundation.Comment;using Microsoft.Utilities;table 841 "Cash Flow Account"{    Caption = 'Cash Flow Account';    DataCaptionFields = "No.", Name;    DrillDownPageID = "Cash Flow Account List";    LookupPageID = "Cash Flow Account List";    DataClassification = CustomerContent;    fields    {        field(1; "No."; Code[20])        {            Caption = 'No.';            NotBlank = true;        }        field(2; Name; Text[50])        {            Caption = 'Name';            trigger OnValidate()            begin                if ("Search Name" = UpperCase(xRec.Name)) or ("Search Name" = '') then                    "Search Name" := Name;            end;        }        field(3; "Search Name"; Code[50])        {            Caption = 'Search Name';        }        field(4; "Account Type"; Enum "Cash Flow Account Type")        {            Caption = 'Account Type';        }        field(5; Comment; Boolean)        {            CalcFormula = exist("Cash Flow Account Comment" where("Table Name" = const("Cash Flow Account"),                                                                   "No." = field("No.")));            Caption = 'Comment';            Editable = false;            FieldClass = FlowField;        }        field(6; Blocked; Boolean)        {            Caption = 'Blocked';        }        field(7; "New Page"; Boolean)        {            Caption = 'New Page';        }        field(8; "No. of Blank Lines"; Integer)        {            Caption = 'No. of Blank Lines';            MinValue = 0;        }        field(9; Indentation; Integer)        {            Caption = 'Indentation';            MinValue = 0;            trigger OnValidate()            begin                if Indentation < 0 then                    Indentation := 0;            end;        }        field(10; "Last Date Modified"; Date)        {            Caption = 'Last Date Modified';            Editable = false;        }        field(11; "Date Filter"; Date)        {            Caption = 'Date Filter';            FieldClass = FlowFilter;        }        field(12; "Cash Flow Forecast Filter"; Code[20])        {            Caption = 'Cash Flow Forecast Filter';            FieldClass = FlowFilter;            TableRelation = "Cash Flow Forecast";        }        field(13; Amount; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            CalcFormula = 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 Filter"),                                                                               "Global Dimension 2 Code" = field("Global Dimension 2 Filter")));            Caption = 'Amount';            FieldClass = FlowField;        }        field(29; "Global Dimension 1 Filter"; Code[20])        {            CaptionClass = '1,3,1';            Caption = 'Global Dimension 1 Filter';            FieldClass = FlowFilter;            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1),                                                          Blocked = const(false));        }        field(30; "Global Dimension 2 Filter"; Code[20])        {            CaptionClass = '1,3,2';            Caption = 'Global Dimension 2 Filter';            FieldClass = FlowFilter;            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2),                                                          Blocked = const(false));        }        field(34; Totaling; Text[250])        {            Caption = 'Totaling';            TableRelation = "Cash Flow Account";            ValidateTableRelation = false;            trigger OnValidate()            begin                if not ("Account Type" in ["Account Type"::Total, "Account Type"::"End-Total"]) then                    FieldError("Account Type");                CalcFields(Amount);            end;        }        field(35; "Source Type"; Enum "Cash Flow Source Type")        {            Caption = 'Source Type';        }        field(36; "G/L Integration"; Option)        {            Caption = 'G/L Integration';            OptionCaption = ' ,Balance,Budget,Both';            OptionMembers = " ",Balance,Budget,Both;        }        field(37; "G/L Account Filter"; Code[250])        {            Caption = 'G/L Account Filter';            TableRelation = "G/L Account";            ValidateTableRelation = false;            trigger OnLookup()            var                GLAccList: Page "G/L Account List";                IsHandled: Boolean;            begin                IsHandled := false;                OnBeforeOnLookup(Rec, IsHandled);                if IsHandled then                    exit;                GLAccList.LookupMode(true);                if GLAccList.RunModal() = ACTION::LookupOK then                    "G/L Account Filter" := CopyStr(GLAccList.GetSelectionFilter(), 1, MaxStrLen("G/L Account Filter"));            end;        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }        key(Key2; "Search Name")        {        }        key(Key3; "Source Type")        {        }    }    fieldgroups    {        fieldgroup(DropDown; "No.", Name, "Account Type", Amount)        {        }    }    trigger OnDelete()    var        CommentLine: Record "Comment Line";    begin        MoveEntries.MoveCashFlowEntries(Rec);        CommentLine.SetRange("Table Name", CommentLine."Table Name"::"G/L Account");        CommentLine.SetRange("No.", "No.");        CommentLine.DeleteAll();    end;    trigger OnInsert()    begin        if Indentation < 0 then            Indentation := 0;    end;    trigger OnModify()    begin        "Last Date Modified" := Today;        if Indentation < 0 then            Indentation := 0;    end;    trigger OnRename()    begin        "Last Date Modified" := Today;    end;    var        MoveEntries: Codeunit MoveEntries;    [IntegrationEvent(false, false)]    local procedure OnBeforeOnLookup(var CashFlowAccount: Record "Cash Flow Account"; var IsHandled: Boolean)    begin    end;}