Table 850 Cash Flow Manual Expense

Base Application, Microsoft.CashFlow.Setup

src/Layers/W1/BaseApp/CashFlow/Setup/CashFlowManualExpense.Table.al181 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.Setup;using Microsoft.CashFlow.Account;using Microsoft.Finance.Dimension;table 850 "Cash Flow Manual Expense"{    Caption = 'Cash Flow Manual Expense';    DrillDownPageID = "Cash Flow Manual Expenses";    LookupPageID = "Cash Flow Manual Expenses";    DataClassification = CustomerContent;    fields    {        field(2; "Code"; Code[10])        {            Caption = 'Code';            NotBlank = true;        }        field(3; "Cash Flow Account No."; Code[20])        {            Caption = 'Cash Flow Account No.';            TableRelation = "Cash Flow Account";            trigger OnValidate()            var                CFAccount: Record "Cash Flow Account";            begin                if "Cash Flow Account No." <> '' then begin                    CFAccount.Get("Cash Flow Account No.");                    CFAccount.TestField("Account Type", CFAccount."Account Type"::Entry);                    if "Cash Flow Account No." <> xRec."Cash Flow Account No." then                        Description := CFAccount.Name;                end;            end;        }        field(4; Description; Text[100])        {            Caption = 'Description';        }        field(5; "Starting Date"; Date)        {            Caption = 'Starting Date';        }        field(6; "Ending Date"; Date)        {            Caption = 'Ending Date';        }        field(7; "Recurring Frequency"; DateFormula)        {            Caption = 'Recurring Frequency';        }        field(8; Amount; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Amount';        }        field(9; "Global Dimension 1 Code"; Code[20])        {            CaptionClass = '1,1,1';            Caption = 'Global Dimension 1 Code';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1),                                                          Blocked = const(false));            trigger OnValidate()            begin                Rec.ValidateShortcutDimCode(1, "Global Dimension 1 Code");                Modify();            end;        }        field(10; "Global Dimension 2 Code"; Code[20])        {            CaptionClass = '1,1,2';            Caption = 'Global Dimension 2 Code';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2),                                                          Blocked = const(false));            trigger OnValidate()            begin                Rec.ValidateShortcutDimCode(2, "Global Dimension 2 Code");                Modify();            end;        }    }    keys    {        key(Key1; "Code")        {            Clustered = true;        }        key(Key2; "Starting Date")        {        }    }    fieldgroups    {    }    trigger OnDelete()    begin        DimMgt.DeleteDefaultDim(DATABASE::"Cash Flow Manual Expense", Code);    end;    trigger OnInsert()    var        BlankCashFlowAccount: Record "Cash Flow Account";        ExistingCashFlowManualExpense: Record "Cash Flow Manual Expense";    begin        if Rec.Code = '' then            if ExistingCashFlowManualExpense.Get('') then                Error(CodeIsNotSetErr, BlankCashFlowAccount.TableCaption(), BlankCashFlowAccount.FieldCaption(BlankCashFlowAccount."Source Type"), BlankCashFlowAccount."Source Type"::"Cash Flow Manual Expense");        DimMgt.UpdateDefaultDim(          DATABASE::"Cash Flow Manual Expense", Code,          "Global Dimension 1 Code", "Global Dimension 2 Code");    end;    trigger OnRename()    begin        DimMgt.RenameDefaultDim(DATABASE::"Cash Flow Manual Expense", xRec.Code, Code);    end;    var        DimMgt: Codeunit DimensionManagement;        ExpTxt: Label 'EXP', Comment = 'Abbreviation of Expense, used as prefix for code (e.g. EXP000001)';    procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin        OnBeforeValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode);        DimMgt.ValidateDimValueCode(FieldNumber, ShortcutDimCode);        if not IsTemporary then            DimMgt.SaveDefaultDim(DATABASE::"Cash Flow Manual Expense", Code, FieldNumber, ShortcutDimCode);        OnAfterValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode);    end;    procedure InitNewRecord()    var        CashFlowManualExpense: Record "Cash Flow Manual Expense";        CashFlowAccount: Record "Cash Flow Account";        CashFlowCode: Code[10];    begin        CashFlowManualExpense.SetFilter(Code, '%1', ExpTxt + '0*');        if not CashFlowManualExpense.FindLast() then            CashFlowCode := PadStr(ExpTxt, MaxStrLen(CashFlowManualExpense.Code), '0')        else            CashFlowCode := CashFlowManualExpense.Code;        CashFlowCode := IncStr(CashFlowCode);        CashFlowAccount.SetRange("Source Type", CashFlowAccount."Source Type"::"Cash Flow Manual Expense");        if not CashFlowAccount.FindFirst() then            exit;        Code := CashFlowCode;        "Cash Flow Account No." := CashFlowAccount."No.";        "Starting Date" := WorkDate();        "Ending Date" := 0D;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterValidateShortcutDimCode(var CashFlowManualExpense: Record "Cash Flow Manual Expense"; var xCashFlowManualExpense: Record "Cash Flow Manual Expense"; FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateShortcutDimCode(var CashFlowManualExpense: Record "Cash Flow Manual Expense"; var xCashFlowManualExpense: Record "Cash Flow Manual Expense"; FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin    end;    var        CodeIsNotSetErr: Label 'Cannot insert the line because no code value is set. Please verify that you have set up the %1 with the %2 set to %3.', Comment = '%1 is Cash Flow Account, %2 is Source Type, %3 is Cash Flow Manual Expense';}