Table 5643 Depreciation Table Line, source in 29
Source29
src/Layers/W1/BaseApp/FixedAssets/Depreciation/DepreciationTableLine.Table.al105 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.Depreciation;
table 5643 "Depreciation Table Line"
{
Caption = 'Depreciation Table Line';
DataClassification = CustomerContent;
fields
{
field(1; "Depreciation Table Code"; Code[10])
{
Caption = 'Depreciation Table Code';
NotBlank = true;
TableRelation = "Depreciation Table Header";
}
field(2; "Period No."; Integer)
{
Caption = 'Period No.';
ToolTip = 'Specifies the number of the depreciation period that this line applies to.';
MinValue = 1;
NotBlank = true;
}
field(3; "Period Depreciation %"; Decimal)
{
AutoFormatType = 0;
Caption = 'Period Depreciation %';
ToolTip = 'Specifies the depreciation percentage to apply to the period for this line.';
DecimalPlaces = 2 : 8;
MinValue = 0;
trigger OnValidate()
begin
DeprTableHeader.Get("Depreciation Table Code");
if DeprTableHeader."Total No. of Units" <> 0 then
"No. of Units in Period" :=
Round(DeprTableHeader."Total No. of Units" * "Period Depreciation %" / 100, 0.00001);
end;
}
field(4; "No. of Units in Period"; Decimal)
{
AutoFormatType = 0;
Caption = 'No. of Units in Period';
ToolTip = 'Specifies the units produced by the asset this depreciation table applies to, during the period when this line applies.';
DecimalPlaces = 0 : 5;
MinValue = 0;
trigger OnValidate()
begin
DeprTableHeader.Get("Depreciation Table Code");
if DeprTableHeader."Total No. of Units" <> 0 then
"Period Depreciation %" :=
Round("No. of Units in Period" / DeprTableHeader."Total No. of Units" * 100, 0.00000001);
end;
}
}
keys
{
key(Key1; "Depreciation Table Code", "Period No.")
{
Clustered = true;
}
}
fieldgroups
{
}
trigger OnInsert()
var
DeprTableHeader: Record "Depreciation Table Header";
begin
LockTable();
DeprTableHeader.Get("Depreciation Table Code");
end;
trigger OnRename()
begin
Error(Text000, TableCaption);
end;
var
DeprTableHeader: Record "Depreciation Table Header";
#pragma warning disable AA0074
#pragma warning disable AA0470
Text000: Label 'You cannot rename a %1.';
#pragma warning restore AA0470
#pragma warning restore AA0074
procedure NewRecord()
var
DeprTableLine: Record "Depreciation Table Line";
begin
DeprTableLine.SetRange("Depreciation Table Code", "Depreciation Table Code");
if DeprTableLine.FindLast() then;
"Period No." := DeprTableLine."Period No." + 1;
end;
}