Table 5600 Fixed Asset
src/Layers/W1/BaseApp/FixedAssets/FixedAsset/FixedAsset.Table.al707 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.FixedAssets.Depreciation;using Microsoft.FixedAssets.Insurance;using Microsoft.FixedAssets.Ledger;using Microsoft.FixedAssets.Maintenance;using Microsoft.FixedAssets.Setup;using Microsoft.Foundation.Comment;using Microsoft.Foundation.NoSeries;using Microsoft.HumanResources.Employee;using Microsoft.Inventory.Location;using Microsoft.Purchases.Document;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Document;using System.Environment.Configuration;using System.Telemetry;table 5600 "Fixed Asset"{ Caption = 'Fixed Asset'; DataCaptionFields = "No.", Description; DrillDownPageID = "Fixed Asset List"; LookupPageID = "Fixed Asset List"; Permissions = TableData "Ins. Coverage Ledger Entry" = r, TableData Employee = r; DataClassification = CustomerContent; fields { field(1; "No."; Code[20]) { Caption = 'No.'; ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.'; OptimizeForTextSearch = true; trigger OnValidate() begin if "No." <> xRec."No." then begin FASetup.Get(); NoSeries.TestManual(FASetup."Fixed Asset Nos."); "No. Series" := ''; end; end; } field(2; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies a description of the fixed asset.'; OptimizeForTextSearch = true; trigger OnValidate() var FADeprBook: Record "FA Depreciation Book"; begin if ("Search Description" = UpperCase(xRec.Description)) or ("Search Description" = '') then "Search Description" := Description; if Description <> xRec.Description then begin FADeprBook.SetCurrentKey("FA No."); FADeprBook.SetRange("FA No.", "No."); FADeprBook.ModifyAll(Description, Description); end; end; } field(3; "Search Description"; Code[100]) { Caption = 'Search Description'; ToolTip = 'Specifies a search description for the fixed asset.'; OptimizeForTextSearch = true; } field(4; "Description 2"; Text[50]) { Caption = 'Description 2'; OptimizeForTextSearch = true; } field(5; "FA Class Code"; Code[10]) { Caption = 'FA Class Code'; ToolTip = 'Specifies the class that the fixed asset belongs to.'; TableRelation = "FA Class"; trigger OnValidate() var FASubclass: Record "FA Subclass"; IsHandled: Boolean; begin IsHandled := false; OnBeforeOnValidateFAClassCode(Rec, xRec, IsHandled); if IsHandled then exit; if "FA Subclass Code" = '' then exit; FASubclass.Get("FA Subclass Code"); if not (FASubclass."FA Class Code" in ['', "FA Class Code"]) then "FA Subclass Code" := ''; end; } field(6; "FA Subclass Code"; Code[10]) { Caption = 'FA Subclass Code'; ToolTip = 'Specifies the subclass of the class that the fixed asset belongs to.'; TableRelation = "FA Subclass"; trigger OnValidate() var FASubclass: Record "FA Subclass"; IsHandled: Boolean; begin IsHandled := false; OnBeforeOnValidateFASubclassCode(Rec, xRec, IsHandled); if IsHandled then exit; if "FA Subclass Code" = '' then begin Validate("FA Posting Group", ''); exit; end; FASubclass.Get("FA Subclass Code"); if "FA Class Code" <> '' then begin if not (FASubclass."FA Class Code" in ['', "FA Class Code"]) then Error(UnexpctedSubclassErr); end else Validate("FA Class Code", FASubclass."FA Class Code"); if "FA Posting Group" = '' then Validate("FA Posting Group", FASubclass."Default FA Posting Group"); end; } field(7; "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(8; "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(9; "Location Code"; Code[10]) { Caption = 'Location Code'; TableRelation = Location where("Use As In-Transit" = const(false)); } field(10; "FA Location Code"; Code[10]) { Caption = 'FA Location Code'; ToolTip = 'Specifies the location, such as a building, where the fixed asset is located.'; TableRelation = "FA Location"; trigger OnValidate() begin UpdateFALocationId(); end; } field(11; "Vendor No."; Code[20]) { Caption = 'Vendor No.'; ToolTip = 'Specifies the number of the vendor from which you purchased this fixed asset.'; TableRelation = Vendor; } field(12; "Main Asset/Component"; Enum "FA Component Type") { Caption = 'Main Asset/Component'; ToolTip = 'Specifies if the fixed asset is a main fixed asset or a component of a fixed asset.'; Editable = false; } field(13; "Component of Main Asset"; Code[20]) { Caption = 'Component of Main Asset'; ToolTip = 'Specifies the number of the main fixed asset.'; Editable = false; TableRelation = "Fixed Asset"; } field(14; "Budgeted Asset"; Boolean) { Caption = 'Budgeted Asset'; ToolTip = 'Specifies if the asset is for budgeting purposes.'; trigger OnValidate() begin FAMoveEntries.ChangeBudget(Rec); end; } field(15; "Warranty Date"; Date) { Caption = 'Warranty Date'; ToolTip = 'Specifies the warranty expiration date of the fixed asset.'; } field(16; "Responsible Employee"; Code[20]) { Caption = 'Responsible Employee'; ToolTip = 'Specifies which employee is responsible for the fixed asset.'; TableRelation = Employee; trigger OnValidate() begin UpdateResponsibleEmployeeId(); end; } field(17; "Serial No."; Text[50]) { Caption = 'Serial No.'; ToolTip = 'Specifies the fixed asset''s serial number.'; OptimizeForTextSearch = true; } field(18; "Last Date Modified"; Date) { Caption = 'Last Date Modified'; ToolTip = 'Specifies when the fixed asset card was last modified.'; Editable = false; } field(19; Insured; Boolean) { CalcFormula = exist("Ins. Coverage Ledger Entry" where("FA No." = field("No."), "Disposed FA" = const(false))); Caption = 'Insured'; ToolTip = 'Specifies that the fixed asset is linked to an insurance policy.'; Editable = false; FieldClass = FlowField; } field(20; Comment; Boolean) { CalcFormula = exist("Comment Line" where("Table Name" = const("Fixed Asset"), "No." = field("No."))); Caption = 'Comment'; Editable = false; FieldClass = FlowField; } field(21; Blocked; Boolean) { Caption = 'Blocked'; ToolTip = 'Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine.'; } field(23; "Maintenance Vendor No."; Code[20]) { Caption = 'Maintenance Vendor No.'; ToolTip = 'Specifies the number of the vendor who performs repairs and maintenance on the fixed asset.'; TableRelation = Vendor; } field(24; "Under Maintenance"; Boolean) { Caption = 'Under Maintenance'; ToolTip = 'Specifies if the fixed asset is currently being repaired.'; } field(25; "Next Service Date"; Date) { Caption = 'Next Service Date'; ToolTip = 'Specifies the next scheduled service date for the fixed asset. This is used as a filter in the Maintenance - Next Service report.'; } field(26; Inactive; Boolean) { Caption = 'Inactive'; ToolTip = 'Specifies that the fixed asset is inactive (for example, if the asset is not in service or is obsolete).'; } field(27; "FA Posting Date Filter"; Date) { Caption = 'FA Posting Date Filter'; FieldClass = FlowFilter; } field(28; "No. Series"; Code[20]) { Caption = 'No. Series'; Editable = false; TableRelation = "No. Series"; } field(29; "FA Posting Group"; Code[20]) { Caption = 'FA Posting Group'; TableRelation = "FA Posting Group"; trigger OnValidate() var FALedgerEntry: Record "FA Ledger Entry"; IsHandled: Boolean; begin IsHandled := false; OnBeforeValidateFAPostingGroup(Rec, xRec, IsHandled); if IsHandled then exit; if "FA Posting Group" <> xRec."FA Posting Group" then begin FALedgerEntry.SetRange("FA No.", "No."); if not FALedgerEntry.IsEmpty() then Error(FoundFALedgerEntriesErr); end; end; } field(30; Acquired; Boolean) { CalcFormula = exist("FA Depreciation Book" where("FA No." = field("No."), "Acquisition Date" = filter(<> 0D))); Caption = 'Acquired'; ToolTip = 'Specifies if the fixed asset has been acquired.'; FieldClass = FlowField; } field(140; Image; Media) { Caption = 'Image'; ToolTip = 'Specifies the picture that has been inserted for the fixed asset.'; } field(9001; "FA Location Id"; Guid) { Caption = 'FA Location Id'; DataClassification = SystemMetadata; TableRelation = "FA Location".SystemId; trigger OnValidate() begin UpdateFALocationCode(); end; } field(9002; "Responsible Employee Id"; Guid) { Caption = 'Responsible Employee Id'; DataClassification = SystemMetadata; TableRelation = Employee.SystemId; trigger OnValidate() begin UpdateResponsibleEmployeeCode(); end; } } keys { key(Key1; "No.") { Clustered = true; } key(Key2; "Search Description") { } key(Key3; "FA Class Code") { } key(Key4; "FA Subclass Code") { } key(Key5; "Component of Main Asset", "Main Asset/Component") { } key(Key6; "FA Location Code") { } key(Key7; "Global Dimension 1 Code") { } key(Key8; "Global Dimension 2 Code") { } key(Key9; "FA Posting Group") { } key(Key10; Description) { } } fieldgroups { fieldgroup(DropDown; "No.", Description, "FA Class Code") { } fieldgroup(Brick; "No.", Description, "FA Class Code", Image) { } } trigger OnDelete() var FADeprBook: Record "FA Depreciation Book"; IsHandled: Boolean; begin IsHandled := false; OnBeforeOnDelete(Rec, IsHandled); if IsHandled then exit; LockTable(); MainAssetComp.LockTable(); InsCoverageLedgEntry.LockTable(); if "Main Asset/Component" = "Main Asset/Component"::"Main Asset" then Error(Text000); FAMoveEntries.MoveFAInsuranceEntries("No."); FADeprBook.SetRange("FA No.", "No."); FADeprBook.DeleteAll(true); if not FADeprBook.IsEmpty() then Error(Text001, TableCaption(), "No."); MainAssetComp.SetCurrentKey("FA No."); MainAssetComp.SetRange("FA No.", "No."); MainAssetComp.DeleteAll(); if "Main Asset/Component" = "Main Asset/Component"::Component then begin MainAssetComp.Reset(); MainAssetComp.SetRange("Main Asset No.", "Component of Main Asset"); MainAssetComp.SetRange("FA No.", ''); MainAssetComp.DeleteAll(); MainAssetComp.SetRange("FA No."); if not MainAssetComp.FindFirst() then begin FA.Get("Component of Main Asset"); FA."Main Asset/Component" := FA."Main Asset/Component"::" "; FA."Component of Main Asset" := ''; FA.Modify(); end; end; MaintenanceRegistration.SetRange("FA No.", "No."); MaintenanceRegistration.DeleteAll(); CommentLine.SetRange("Table Name", CommentLine."Table Name"::"Fixed Asset"); CommentLine.SetRange("No.", "No."); CommentLine.DeleteAll(); DimMgt.DeleteDefaultDim(DATABASE::"Fixed Asset", "No."); end; trigger OnInsert() var FeatureTelemetry: Codeunit "Feature Telemetry"; begin FeatureTelemetry.LogUptake('0000H4G', 'Fixed Asset', Enum::"Feature Uptake Status"::"Set up"); InitFANo(); "Main Asset/Component" := "Main Asset/Component"::" "; "Component of Main Asset" := ''; DimMgt.UpdateDefaultDim( DATABASE::"Fixed Asset", "No.", "Global Dimension 1 Code", "Global Dimension 2 Code"); UpdateFALocationId(); UpdateResponsibleEmployeeId(); end; trigger OnModify() begin "Last Date Modified" := Today; end; trigger OnRename() var SalesLine: Record "Sales Line"; PurchaseLine: Record "Purchase Line"; begin SalesLine.RenameNo(SalesLine.Type::"Fixed Asset", xRec."No.", "No."); PurchaseLine.RenameNo(PurchaseLine.Type::"Fixed Asset", xRec."No.", "No."); DimMgt.RenameDefaultDim(DATABASE::"Fixed Asset", xRec."No.", "No."); CommentLine.RenameCommentLine(CommentLine."Table Name"::"Fixed Asset", xRec."No.", "No."); "Last Date Modified" := Today; end; var CommentLine: Record "Comment Line"; FA: Record "Fixed Asset"; FASetup: Record "FA Setup"; MaintenanceRegistration: Record "Maintenance Registration"; MainAssetComp: Record "Main Asset Component"; InsCoverageLedgEntry: Record "Ins. Coverage Ledger Entry"; FAMoveEntries: Codeunit "FA MoveEntries"; NoSeries: Codeunit "No. Series"; DimMgt: Codeunit DimensionManagement;#pragma warning disable AA0074 Text000: Label 'A main asset cannot be deleted.';#pragma warning disable AA0470 Text001: Label 'You cannot delete %1 %2 because it has associated depreciation books.';#pragma warning restore AA0470#pragma warning restore AA0074 UnexpctedSubclassErr: Label 'This fixed asset subclass belongs to a different fixed asset class.'; DontAskAgainActionTxt: Label 'Don''t ask again'; NotificationNameTxt: Label 'Fixed Asset Acquisition Wizard'; NotificationDescriptionTxt: Label 'Notify when ready to acquire the fixed asset.'; ReadyToAcquireMsg: Label 'You are ready to acquire the fixed asset.'; AcquireActionTxt: Label 'Acquire'; FoundFALedgerEntriesErr: Label 'You cannot change the FA posting group because posted FA ledger entries use the existing posting group.'; procedure AssistEdit(OldFA: Record "Fixed Asset") Result: Boolean var IsHandled: Boolean; begin IsHandled := false; OnBeforeAssistEdit(FASetup, FA, Rec, Result, IsHandled, OldFA); if IsHandled then exit(Result); FA := Rec; FASetup.Get(); FASetup.TestField("Fixed Asset Nos."); if NoSeries.LookupRelatedNoSeries(FASetup."Fixed Asset Nos.", OldFA."No. Series", FA."No. Series") then begin FA."No." := NoSeries.GetNextNo(FA."No. Series"); Rec := FA; exit(true); end; end; local procedure InitFANo() var FixedAsset: Record "Fixed Asset"; IsHandled: Boolean; begin IsHandled := false; OnBeforeInitFANo(Rec, xRec, IsHandled); if IsHandled then exit; if "No." = '' then begin FASetup.Get(); FASetup.TestField("Fixed Asset Nos."); if NoSeries.AreRelated(FASetup."Fixed Asset Nos.", xRec."No. Series") then "No. Series" := xRec."No. Series" else "No. Series" := FASetup."Fixed Asset Nos."; "No." := NoSeries.GetNextNo("No. Series"); FixedAsset.ReadIsolation(IsolationLevel::ReadUncommitted); FixedAsset.SetLoadFields("No."); while FixedAsset.Get("No.") do "No." := NoSeries.GetNextNo("No. Series"); end; end; procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]) var IsHandled: Boolean; begin IsHandled := false; OnBeforeValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode, IsHandled); if not IsHandled then begin DimMgt.ValidateDimValueCode(FieldNumber, ShortcutDimCode); if not IsTemporary then begin DimMgt.SaveDefaultDim(DATABASE::"Fixed Asset", "No.", FieldNumber, ShortcutDimCode); Modify(true); end; end; OnAfterValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode); end; procedure FieldsForAcquitionInGeneralGroupAreCompleted(): Boolean begin exit(("No." <> '') and (Description <> '') and ("FA Subclass Code" <> '')); end; procedure ShowAcquireWizardNotification() var NotificationLifecycleMgt: Codeunit "Notification Lifecycle Mgt."; FixedAssetAcquisitionWizard: Codeunit "Fixed Asset Acquisition Wizard"; FAAcquireWizardNotification: Notification; begin if IsNotificationEnabledForCurrentUser() then begin FAAcquireWizardNotification.Id(GetNotificationID()); FAAcquireWizardNotification.Message(ReadyToAcquireMsg); FAAcquireWizardNotification.Scope(NOTIFICATIONSCOPE::LocalScope); FAAcquireWizardNotification.AddAction( AcquireActionTxt, CODEUNIT::"Fixed Asset Acquisition Wizard", 'RunAcquisitionWizardFromNotification'); FAAcquireWizardNotification.AddAction( DontAskAgainActionTxt, CODEUNIT::"Fixed Asset Acquisition Wizard", 'HideNotificationForCurrentUser'); FAAcquireWizardNotification.SetData(FixedAssetAcquisitionWizard.GetNotificationFANoDataItemID(), "No."); NotificationLifecycleMgt.SendNotification(FAAcquireWizardNotification, RecordId); end end; local procedure UpdateFALocationId() var FALocation: Record "FA Location"; begin if "FA Location Code" = '' then begin Clear("FA Location Id"); exit; end; if not FALocation.Get("FA Location Code") then exit; "FA Location Id" := FALocation.SystemId; end; local procedure UpdateFALocationCode() var FALocation: Record "FA Location"; begin if not IsNullGuid("FA Location Id") then FALocation.GetBySystemId("FA Location Id"); "FA Location Code" := FALocation.Code; end; local procedure UpdateResponsibleEmployeeId() var Employee: Record Employee; begin if "Responsible Employee" = '' then begin Clear("Responsible Employee Id"); exit; end; if not Employee.Get("Responsible Employee") then exit; "Responsible Employee Id" := Employee.SystemId; end; local procedure UpdateResponsibleEmployeeCode() var Employee: Record Employee; begin if not IsNullGuid("Responsible Employee Id") then Employee.GetBySystemId("Responsible Employee Id"); "Responsible Employee" := Employee."No."; end; procedure GetNotificationID(): Guid begin exit('3d5c2f86-cfb9-4407-97c3-9df74c7696c9'); end; procedure SetNotificationDefaultState() var MyNotifications: Record "My Notifications"; begin MyNotifications.InsertDefault(GetNotificationID(), NotificationNameTxt, NotificationDescriptionTxt, true); end; local procedure IsNotificationEnabledForCurrentUser(): Boolean var MyNotifications: Record "My Notifications"; begin exit(MyNotifications.IsEnabled(GetNotificationID())); end; procedure DontNotifyCurrentUserAgain() var MyNotifications: Record "My Notifications"; begin if not MyNotifications.Disable(GetNotificationID()) then MyNotifications.InsertDefault(GetNotificationID(), NotificationNameTxt, NotificationDescriptionTxt, false); end; procedure RecallNotificationForCurrentUser() var NotificationLifecycleMgt: Codeunit "Notification Lifecycle Mgt."; begin NotificationLifecycleMgt.RecallNotificationsForRecord(RecordId, false); end; [IntegrationEvent(false, false)] local procedure OnAfterValidateShortcutDimCode(var FixedAsset: Record "Fixed Asset"; var xFixedAsset: Record "Fixed Asset"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeAssistEdit(var FASetup: Record "FA Setup"; var FixedAsset: Record "Fixed Asset"; var Rec: Record "Fixed Asset"; var Result: Boolean; var IsHandled: Boolean; OldFixedAsset: Record "Fixed Asset") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInitFANo(var FixedAsset: Record "Fixed Asset"; xFixedAsset: Record "Fixed Asset"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOnDelete(var FixedAsset: Record "Fixed Asset"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateShortcutDimCode(var FixedAsset: Record "Fixed Asset"; var xFixedAsset: Record "Fixed Asset"; FieldNumber: Integer; var ShortcutDimCode: Code[20]; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOnValidateFASubclassCode(var FixedAsset: Record "Fixed Asset"; var xFixedAsset: Record "Fixed Asset"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOnValidateFAClassCode(var FixedAsset: Record "Fixed Asset"; var xFixedAsset: Record "Fixed Asset"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateFAPostingGroup(var FixedAsset: Record "Fixed Asset"; var xFixedAsset: Record "Fixed Asset"; var IsHandled: Boolean) begin end;}