Table 5615 FA Allocation
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;}