Table 5644 FA Posting Type
- App
- Base Application
- Namespace
- Microsoft.FixedAssets.Posting
- Versions
- 17-28
Fields, 5Keys, 2Procedures, 2Events, 1
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/FixedAssets/FixedAsset/FAPostingType.Table.al186 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.Posting;
using Microsoft.FixedAssets.Depreciation;
table 5644 "FA Posting Type"
{
Caption = 'FA Posting Type';
LookupPageID = "FA Posting Types";
DataClassification = CustomerContent;
fields
{
field(1; "FA Posting Type No."; Integer)
{
Caption = 'FA Posting Type No.';
}
field(2; "FA Posting Type Name"; Text[50])
{
Caption = 'FA Posting Type Name';
ToolTip = 'Specifies the name of the fixed asset posting type.';
}
field(3; "FA Entry"; Boolean)
{
Caption = 'FA Entry';
}
field(4; "G/L Entry"; Boolean)
{
Caption = 'G/L Entry';
}
field(5; "Entry No."; Integer)
{
Caption = 'Entry No.';
}
}
keys
{
key(Key1; "FA Posting Type No.", "FA Posting Type Name")
{
Clustered = true;
}
key(Key2; "Entry No.")
{
}
}
fieldgroups
{
}
procedure CreateTypes()
var
FADepreciationBook: Record "FA Depreciation Book";
begin
LockTable();
if not Find('-') then begin
"FA Entry" := true;
"G/L Entry" := true;
InsertRec(1, FADepreciationBook.FieldNo("Acquisition Cost"), FADepreciationBook.FieldCaption("Acquisition Cost"));
InsertRec(2, FADepreciationBook.FieldNo(Depreciation), FADepreciationBook.FieldCaption(Depreciation));
InsertRec(3, FADepreciationBook.FieldNo("Write-Down"), FADepreciationBook.FieldCaption("Write-Down"));
InsertRec(4, FADepreciationBook.FieldNo(Appreciation), FADepreciationBook.FieldCaption(Appreciation));
InsertRec(5, FADepreciationBook.FieldNo("Custom 1"), FADepreciationBook.FieldCaption("Custom 1"));
InsertRec(6, FADepreciationBook.FieldNo("Custom 2"), FADepreciationBook.FieldCaption("Custom 2"));
InsertRec(7, FADepreciationBook.FieldNo("Proceeds on Disposal"), FADepreciationBook.FieldCaption("Proceeds on Disposal"));
InsertRec(8, FADepreciationBook.FieldNo("Gain/Loss"), FADepreciationBook.FieldCaption("Gain/Loss"));
"FA Entry" := true;
"G/L Entry" := false;
InsertRec(9, FADepreciationBook.FieldNo("Book Value"), FADepreciationBook.FieldCaption("Book Value"));
InsertRec(10, FADepreciationBook.FieldNo("Depreciable Basis"), FADepreciationBook.FieldCaption("Depreciable Basis"));
InsertRec(11, FADepreciationBook.FieldNo("Salvage Value"), FADepreciationBook.FieldCaption("Salvage Value"));
"FA Entry" := false;
"G/L Entry" := true;
InsertRec(12, FADepreciationBook.FieldNo("Book Value on Disposal"), FADepreciationBook.FieldCaption("Book Value on Disposal"));
end else begin
SetCurrentKey("Entry No.");
Find('-');
repeat
if "Entry No." = 1 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo("Acquisition Cost")) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption("Acquisition Cost"))
then begin
Delete();
InsertRec(1, FADepreciationBook.FieldNo("Acquisition Cost"), FADepreciationBook.FieldCaption("Acquisition Cost"));
end;
if "Entry No." = 2 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo(Depreciation)) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption(Depreciation))
then begin
Delete();
InsertRec(2, FADepreciationBook.FieldNo(Depreciation), FADepreciationBook.FieldCaption(Depreciation));
end;
if "Entry No." = 3 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo("Write-Down")) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption("Write-Down"))
then begin
Delete();
InsertRec(3, FADepreciationBook.FieldNo("Write-Down"), FADepreciationBook.FieldCaption("Write-Down"));
end;
if "Entry No." = 4 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo(Appreciation)) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption(Appreciation))
then begin
Delete();
InsertRec(4, FADepreciationBook.FieldNo(Appreciation), FADepreciationBook.FieldCaption(Appreciation));
end;
if "Entry No." = 5 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo("Custom 1")) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption("Custom 1"))
then begin
Delete();
InsertRec(5, FADepreciationBook.FieldNo("Custom 1"), FADepreciationBook.FieldCaption("Custom 1"));
end;
if "Entry No." = 6 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo("Custom 2")) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption("Custom 2"))
then begin
Delete();
InsertRec(6, FADepreciationBook.FieldNo("Custom 2"), FADepreciationBook.FieldCaption("Custom 2"));
end;
if "Entry No." = 7 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo("Proceeds on Disposal")) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption("Proceeds on Disposal"))
then begin
Delete();
InsertRec(7, FADepreciationBook.FieldNo("Proceeds on Disposal"), FADepreciationBook.FieldCaption("Proceeds on Disposal"));
end;
if "Entry No." = 8 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo("Gain/Loss")) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption("Gain/Loss"))
then begin
Delete();
InsertRec(8, FADepreciationBook.FieldNo("Gain/Loss"), FADepreciationBook.FieldCaption("Gain/Loss"));
end;
if "Entry No." = 9 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo("Book Value")) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption("Book Value"))
then begin
Delete();
InsertRec(9, FADepreciationBook.FieldNo("Book Value"), FADepreciationBook.FieldCaption("Book Value"));
end;
if "Entry No." = 10 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo("Depreciable Basis")) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption("Depreciable Basis"))
then begin
Delete();
InsertRec(10, FADepreciationBook.FieldNo("Depreciable Basis"), FADepreciationBook.FieldCaption("Depreciable Basis"));
end;
if "Entry No." = 11 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo("Salvage Value")) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption("Salvage Value"))
then begin
Delete();
InsertRec(11, FADepreciationBook.FieldNo("Salvage Value"), FADepreciationBook.FieldCaption("Salvage Value"));
end;
if "Entry No." = 12 then
if ("FA Posting Type No." <> FADepreciationBook.FieldNo("Book Value on Disposal")) or
("FA Posting Type Name" <> FADepreciationBook.FieldCaption("Book Value on Disposal"))
then begin
Delete();
InsertRec(12, FADepreciationBook.FieldNo("Book Value on Disposal"), FADepreciationBook.FieldCaption("Book Value on Disposal"));
end;
until Next() = 0;
end;
OnAfterCreateTypes(Rec);
end;
procedure InsertRec(EntryNo: Integer; FAPostingTypeNo: Integer; FAPostingTypeName: Text)
begin
"Entry No." := EntryNo;
"FA Posting Type No." := FAPostingTypeNo;
"FA Posting Type Name" := CopyStr(FAPostingTypeName, 1, MaxStrLen("FA Posting Type Name"));
Insert();
end;
[IntegrationEvent(false, false)]
local procedure OnAfterCreateTypes(var FAPostingType: Record "FA Posting Type")
begin
end;
}