Table 3900 Retention Period
src/System Application/App/Retention Policy/src/Retention Period/RetentionPeriod.Table.al69 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 System.DataAdministration;/// <summary>/// The Retention Periods table is used to define retention periods./// You define a retention period by selecting one of the default values in the Retention Period field, or by selecting the Custom value and providing a date formula./// The date formula must result in a date that is at least two days before the current date./// </summary>table 3900 "Retention Period"{ LookupPageId = "Retention Periods"; Extensible = false; DataCaptionFields = Code, Description; fields { field(1; Code; Code[20]) { DataClassification = CustomerContent; NotBlank = true; } field(2; Description; Text[100]) { DataClassification = CustomerContent; } field(3; "Retention Period"; Enum "Retention Period Enum") { DataClassification = SystemMetadata; trigger OnValidate() var RetentionPeriod: Interface "Retention Period"; begin if Rec."Retention Period" = Rec."Retention Period"::Custom then Clear(Rec."Ret. Period Calculation"); // clear before getting again RetentionPeriod := Rec."Retention Period"; Evaluate(Rec."Ret. Period Calculation", RetentionPeriod.RetentionPeriodDateFormula(Rec)); if Rec."Retention Period" = Rec."Retention Period"::"Never Delete" then Clear(Rec."Ret. Period Calculation"); // clear before validating, don't store as it changes with time Validate(Rec."Ret. Period Calculation"); end; } field(4; "Ret. Period Calculation"; DateFormula) { DataClassification = CustomerContent; trigger OnValidate() var RetentionPeriodImpl: Codeunit "Retention Period Impl."; begin // do not use interface here to avoid overriding of validation RetentionPeriodImpl.ValidateRetentionPeriodDateFormula("Ret. Period Calculation"); end; } } keys { key(PrimaryKey; Code) { Clustered = true; } }}