Table 5615 FA Allocation

Base Application, Microsoft.FixedAssets.FixedAsset

src/Layers/W1/BaseApp/FixedAssets/FixedAsset/FAAllocation.Table.al197 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.FixedAssets.FixedAsset;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;table 5615 "FA Allocation"{    Caption = 'FA Allocation';    DrillDownPageID = "FA Allocations";    LookupPageID = "FA Allocations";    DataClassification = CustomerContent;    fields    {        field(1; "Code"; Code[20])        {            Caption = 'Code';            NotBlank = true;            TableRelation = "FA Posting Group";        }        field(2; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(3; Description; Text[100])        {            Caption = 'Description';        }        field(4; "Account No."; Code[20])        {            Caption = 'Account No.';            ToolTip = 'Specifies the account number to allocate to for the fixed asset allocation type on this line.';            TableRelation = "G/L Account";            trigger OnValidate()            var                IsHandled: Boolean;            begin                if "Account No." = '' then                    exit;                GLAcc.Get("Account No.");                GLAcc.CheckGLAcc();                IsHandled := false;                OnValidateAccountNoOnBeforeTestFieldDirectPosting(Rec, IsHandled);                if not IsHandled then                    if "Allocation Type".AsInteger() < "Allocation Type"::Gain.AsInteger() then                        GLAcc.TestField("Direct Posting");                Description := GLAcc.Name;            end;        }        field(5; "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");            end;        }        field(6; "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");            end;        }        field(7; "Allocation %"; Decimal)        {            AutoFormatType = 0;            Caption = 'Allocation %';            ToolTip = 'Specifies the percentage to use when allocating the amount for the allocation type.';            DecimalPlaces = 1 : 1;            MaxValue = 100;            MinValue = 0;        }        field(8; "Allocation Type"; Enum "FA Allocation Type")        {            Caption = 'Allocation Type';        }        field(9; "Account Name"; Text[100])        {            CalcFormula = lookup("G/L Account".Name where("No." = field("Account No.")));            Caption = 'Account Name';            ToolTip = 'Specifies the name of the account on this allocation line.';            Editable = false;            FieldClass = FlowField;        }        field(480; "Dimension Set ID"; Integer)        {            Caption = 'Dimension Set ID';            Editable = false;            TableRelation = "Dimension Set Entry";            trigger OnLookup()            begin                Rec.ShowDimensions();            end;            trigger OnValidate()            begin                DimMgt.UpdateGlobalDimFromDimSetID("Dimension Set ID", "Global Dimension 1 Code", "Global Dimension 2 Code");            end;        }    }    keys    {        key(Key1; "Code", "Allocation Type", "Line No.")        {            Clustered = true;        }        key(Key2; "Allocation Type", "Code")        {            SumIndexFields = "Allocation %";        }    }    fieldgroups    {    }    trigger OnInsert()    begin        "Dimension Set ID" := 0;        "Global Dimension 1 Code" := '';        "Global Dimension 2 Code" := '';    end;    trigger OnRename()    begin        Error(Text000, TableCaption);    end;    var        GLAcc: Record "G/L Account";        DimMgt: Codeunit DimensionManagement;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'You cannot rename a %1.';#pragma warning restore AA0470#pragma warning restore AA0074    procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin        OnBeforeValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode);        DimMgt.ValidateShortcutDimValues(FieldNumber, ShortcutDimCode, "Dimension Set ID");        OnAfterValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode);    end;    procedure ShowDimensions()    begin        "Dimension Set ID" :=          DimMgt.EditDimensionSet(            Rec, "Dimension Set ID", StrSubstNo('%1 %2 %3', Code, "Allocation Type", "Line No."),            "Global Dimension 1 Code", "Global Dimension 2 Code");        OnAfterShowDimensions(Rec);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterShowDimensions(var FAAllocation: Record "FA Allocation")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterValidateShortcutDimCode(var FAAllocation: Record "FA Allocation"; var xFAAllocation: Record "FA Allocation"; FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateShortcutDimCode(var FAAllocation: Record "FA Allocation"; var xFAAllocation: Record "FA Allocation"; FieldNumber: Integer; var ShortcutDimCode: Code[20])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnValidateAccountNoOnBeforeTestFieldDirectPosting(var FAAllocation: Record "FA Allocation"; var IsHandled: Boolean)    begin    end;}