Table 5635 Insurance Journal Line
src/Layers/W1/BaseApp/FixedAssets/Insurance/InsuranceJournalLine.Table.al364 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.Insurance;using Microsoft.Finance.Dimension;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Journal;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.NoSeries;table 5635 "Insurance Journal Line"{ Caption = 'Insurance Journal Line'; DataClassification = CustomerContent; fields { field(1; "Journal Template Name"; Code[10]) { Caption = 'Journal Template Name'; TableRelation = "Insurance Journal Template"; } field(2; "Journal Batch Name"; Code[10]) { Caption = 'Journal Batch Name'; TableRelation = "Insurance Journal Batch".Name where("Journal Template Name" = field("Journal Template Name")); } field(3; "Line No."; Integer) { Caption = 'Line No.'; } field(4; "Insurance No."; Code[20]) { Caption = 'Insurance No.'; ToolTip = 'Specifies the insurance number to post an insurance coverage entry to.'; TableRelation = Insurance; trigger OnValidate() begin if "Insurance No." = '' then begin CreateDimFromDefaultDim(); exit; end; Insurance.Get("Insurance No."); Insurance.TestField(Blocked, false); Description := Insurance.Description; OnValidateInsuranceNoOnBeforeCreateDim(Rec); CreateDimFromDefaultDim(); end; } field(6; "FA No."; Code[20]) { Caption = 'FA No.'; ToolTip = 'Specifies the number of the related fixed asset.'; TableRelation = "Fixed Asset"; trigger OnValidate() begin if "FA No." = '' then begin CreateDimFromDefaultDim(); "FA Description" := ''; exit; end; FA.Get("FA No."); "FA Description" := FA.Description; FA.TestField(Blocked, false); FA.TestField(Inactive, false); CreateDimFromDefaultDim(); end; } field(7; "FA Description"; Text[100]) { Caption = 'FA Description'; ToolTip = 'Specifies a description of the fixed asset.'; } field(8; "Posting Date"; Date) { Caption = 'Posting Date'; ToolTip = 'Specifies the date to use as the posting date on the insurance coverage ledger entry.'; } field(9; "Document Type"; Enum "FA Journal Line Document Type") { Caption = 'Document Type'; ToolTip = 'Specifies the appropriate document type for the amount you want to post.'; } field(10; "Document Date"; Date) { Caption = 'Document Date'; } field(11; "Document No."; Code[20]) { Caption = 'Document No.'; ToolTip = 'Specifies a document number for the journal line.'; } field(12; "External Document No."; Code[35]) { Caption = 'External Document No.'; } field(13; Amount; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; Caption = 'Amount'; ToolTip = 'Specifies the total amount the journal line consists of. Credit amounts must be entered with a minus sign.'; } field(14; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies the description that is entered in the Insurance No. field.'; } field(15; "Shortcut Dimension 1 Code"; Code[20]) { CaptionClass = '1,2,1'; Caption = 'Shortcut Dimension 1 Code'; ToolTip = 'Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window.'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false)); trigger OnValidate() begin Rec.ValidateShortcutDimCode(1, "Shortcut Dimension 1 Code"); Modify(); end; } field(16; "Shortcut Dimension 2 Code"; Code[20]) { CaptionClass = '1,2,2'; Caption = 'Shortcut Dimension 2 Code'; ToolTip = 'Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window.'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false)); trigger OnValidate() begin Rec.ValidateShortcutDimCode(2, "Shortcut Dimension 2 Code"); Modify(); end; } field(17; "Reason Code"; Code[10]) { Caption = 'Reason Code'; ToolTip = 'Specifies the reason code, a supplementary source code that enables you to trace the entry.'; TableRelation = "Reason Code"; } field(18; "Source Code"; Code[10]) { Caption = 'Source Code'; TableRelation = "Source Code"; } field(20; "Index Entry"; Boolean) { Caption = 'Index Entry'; ToolTip = 'Specifies whether to post an indexation (that is, to index the total value insured).'; } field(21; "Posting No. Series"; Code[20]) { Caption = 'Posting No. Series'; TableRelation = "No. Series"; } 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", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); end; } } keys { key(Key1; "Journal Template Name", "Journal Batch Name", "Line No.") { Clustered = true; } key(Key2; "Journal Template Name", "Journal Batch Name", "Posting Date") { MaintainSQLIndex = false; } } fieldgroups { } trigger OnInsert() begin LockTable(); InsuranceJnlTempl.Get("Journal Template Name"); "Source Code" := InsuranceJnlTempl."Source Code"; InsuranceJnlBatch.Get("Journal Template Name", "Journal Batch Name"); "Reason Code" := InsuranceJnlBatch."Reason Code"; Rec.ValidateShortcutDimCode(1, "Shortcut Dimension 1 Code"); Rec.ValidateShortcutDimCode(2, "Shortcut Dimension 2 Code"); end; var Insurance: Record Insurance; FA: Record "Fixed Asset"; InsuranceJnlTempl: Record "Insurance Journal Template"; InsuranceJnlBatch: Record "Insurance Journal Batch"; InsuranceJnlLine: Record "Insurance Journal Line"; DimMgt: Codeunit DimensionManagement; procedure SetUpNewLine(LastInsuranceJnlLine: Record "Insurance Journal Line") var NoSeries: Codeunit "No. Series"; begin InsuranceJnlTempl.Get("Journal Template Name"); InsuranceJnlBatch.Get("Journal Template Name", "Journal Batch Name"); InsuranceJnlLine.SetRange("Journal Template Name", "Journal Template Name"); InsuranceJnlLine.SetRange("Journal Batch Name", "Journal Batch Name"); if InsuranceJnlLine.FindFirst() then begin "Posting Date" := LastInsuranceJnlLine."Posting Date"; "Document No." := LastInsuranceJnlLine."Document No."; end else begin "Posting Date" := WorkDate(); if InsuranceJnlBatch."No. Series" <> '' then "Document No." := NoSeries.PeekNextNo(InsuranceJnlBatch."No. Series", "Posting Date"); end; "Source Code" := InsuranceJnlTempl."Source Code"; "Reason Code" := InsuranceJnlBatch."Reason Code"; "Posting No. Series" := InsuranceJnlBatch."Posting No. Series"; OnAfterSetUpNewLine(Rec, InsuranceJnlTempl, InsuranceJnlBatch, LastInsuranceJnlLine); end; procedure CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) var IsHandled: Boolean; OldDimSetID: Integer; begin IsHandled := false; OnBeforeCreateDim(Rec, IsHandled); if IsHandled then exit; "Shortcut Dimension 1 Code" := ''; "Shortcut Dimension 2 Code" := ''; OldDimSetID := Rec."Dimension Set ID"; "Dimension Set ID" := DimMgt.GetRecDefaultDimID( Rec, CurrFieldNo, DefaultDimSource, "Source Code", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", 0, 0); OnAfterCreateDim(Rec, CurrFieldNo, xRec, OldDimSetID); end; 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 LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]) begin DimMgt.LookupDimValueCode(FieldNumber, ShortcutDimCode); DimMgt.ValidateShortcutDimValues(FieldNumber, ShortcutDimCode, "Dimension Set ID"); end; procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20]) begin DimMgt.GetShortcutDimensions(Rec."Dimension Set ID", ShortcutDimCode); end; procedure ShowDimensions() begin "Dimension Set ID" := DimMgt.EditDimensionSet( Rec, "Dimension Set ID", StrSubstNo('%1 %2 %3', "Journal Template Name", "Journal Batch Name", "Line No."), "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code"); OnAfterShowDimensions(Rec); end; procedure IsOpenedFromBatch(): Boolean var InsuranceJournalBatch: Record "Insurance Journal Batch"; TemplateFilter: Text; BatchFilter: Text; begin BatchFilter := GetFilter("Journal Batch Name"); if BatchFilter <> '' then begin TemplateFilter := GetFilter("Journal Template Name"); if TemplateFilter <> '' then InsuranceJournalBatch.SetFilter("Journal Template Name", TemplateFilter); InsuranceJournalBatch.SetFilter(Name, BatchFilter); InsuranceJournalBatch.FindFirst(); end; exit((("Journal Batch Name" <> '') and ("Journal Template Name" = '')) or (BatchFilter <> '')); end; procedure CreateDimFromDefaultDim() var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; begin InitDefaultDimensionSources(DefaultDimSource); CreateDim(DefaultDimSource); end; local procedure InitDefaultDimensionSources(var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) begin DimMgt.AddDimSource(DefaultDimSource, Database::Insurance, Rec."Insurance No."); DimMgt.AddDimSource(DefaultDimSource, Database::"Fixed Asset", Rec."FA No."); OnAfterInitDefaultDimensionSources(Rec, DefaultDimSource); end; [IntegrationEvent(false, false)] local procedure OnAfterInitDefaultDimensionSources(var InsuranceJournalLine: Record "Insurance Journal Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCreateDim(var InsuranceJournalLine: Record "Insurance Journal Line"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnAfterCreateDim(var InsuranceJournalLine: Record "Insurance Journal Line"; CurrFieldNo: Integer; xInsuranceJournalLine: Record "Insurance Journal Line"; OldDimSetID: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetUpNewLine(var InsuranceJnlLine: Record "Insurance Journal Line"; InsuranceJnlTempl: Record "Insurance Journal Template"; InsuranceJnlBatch: Record "Insurance Journal Batch"; LastInsuranceJnlLine: Record "Insurance Journal Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterShowDimensions(var InsuranceJournalLine: Record "Insurance Journal Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterValidateShortcutDimCode(var InsuranceJournalLine: Record "Insurance Journal Line"; var xInsuranceJournalLine: Record "Insurance Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateShortcutDimCode(var InsuranceJournalLine: Record "Insurance Journal Line"; var xInsuranceJournalLine: Record "Insurance Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnValidateInsuranceNoOnBeforeCreateDim(var InsuranceJournalLine: Record "Insurance Journal Line") begin end;}