Table 45 G/L Register

Base Application, Microsoft.Finance.GeneralLedger.Ledger

src/Layers/W1/BaseApp/Finance/GeneralLedger/Ledger/GLRegister.Table.al268 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.Finance.GeneralLedger.Ledger;using Microsoft.Finance.VAT.Ledger;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.NoSeries;using Microsoft.Utilities;using System.Security.AccessControl;/// <summary>/// Stores register information for G/L entry posting batches with audit trail and navigation capabilities./// Provides sequential numbering and date tracking for all G/L entry transactions./// </summary>/// <remarks>/// Key relationships: G/L Entry, VAT Entry, Source Code. Primary key: No./// Extensible via table extensions for additional posting batch tracking requirements./// Used for audit trail, batch navigation, and posting verification./// </remarks>table 45 "G/L Register"{    Caption = 'G/L Register';    LookupPageID = "G/L Registers";    Permissions = TableData "G/L Entry" = m,                  TableData "G/L Register" = rimd;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Sequential register number for G/L entry posting batches.        /// </summary>        field(1; "No."; Integer)        {            Caption = 'No.';            ToolTip = 'Specifies the number of the general ledger register.';        }        /// <summary>        /// First G/L entry number in this posting batch.        /// </summary>        field(2; "From Entry No."; Integer)        {            Caption = 'From Entry No.';            ToolTip = 'Specifies the first general ledger entry number in the register.';            TableRelation = "G/L Entry";        }        /// <summary>        /// Last G/L entry number in this posting batch.        /// </summary>        field(3; "To Entry No."; Integer)        {            Caption = 'To Entry No.';            ToolTip = 'Specifies the last general ledger entry number in the register.';            TableRelation = "G/L Entry";        }        /// <summary>        /// The Creation Date field has been replaced with the SystemCreateAt field but needs to be kept for historical audit purposes.        /// </summary>        field(4; "Creation Date"; Date)        {            Caption = 'Creation Date';            ToolTip = 'Specifies the date when the entries in the register were posted.';        }        /// <summary>        /// Source code indicating the journal or process that created this register.        /// </summary>        field(5; "Source Code"; Code[10])        {            Caption = 'Source Code';            ToolTip = 'Specifies the source code for the entries in the register.';            TableRelation = "Source Code";        }        /// <summary>        /// User ID of the person who posted this register.        /// </summary>        field(6; "User ID"; Code[50])        {            Caption = 'User ID';            ToolTip = 'Specifies the ID of the user who posted the entry, to be used, for example, in the change log.';            DataClassification = EndUserIdentifiableInformation;            TableRelation = User."User Name";        }        /// <summary>        /// Journal batch name from the original journal that created this register.        /// </summary>        field(7; "Journal Batch Name"; Code[10])        {            Caption = 'Journal Batch Name';            ToolTip = 'Specifies the batch name of the general journal that the entries were posted from.';        }        /// <summary>        /// First VAT entry number in this posting batch.        /// </summary>        field(8; "From VAT Entry No."; Integer)        {            Caption = 'From VAT Entry No.';            ToolTip = 'Specifies the first VAT entry number in the register.';            TableRelation = "VAT Entry";        }        /// <summary>        /// Last VAT entry number in this posting batch.        /// </summary>        field(9; "To VAT Entry No."; Integer)        {            Caption = 'To VAT Entry No.';            ToolTip = 'Specifies the last entry number in the register.';            TableRelation = "VAT Entry";        }        /// <summary>        /// Indicates whether this register has been reversed.        /// </summary>        field(10; Reversed; Boolean)        {            Caption = 'Reversed';            ToolTip = 'Specifies if the register has been reversed (undone) from the Reverse Entries window.';        }        /// <summary>        /// The Creation Time field has been replaced with the SystemCreateAt field but needs to be kept for historical audit purposes.        /// </summary>        field(11; "Creation Time"; Time)        {            Caption = 'Creation Time';            ToolTip = 'Specifies the time when the entries in the register were posted.';        }        /// <summary>        /// Journal template name from the original journal that created this register.        /// </summary>        field(12; "Journal Templ. Name"; Code[10])        {            Caption = 'Journal Template Name';        }        /// <summary>        /// Number of G/L transactions in this register.        /// </summary>        field(13; "No. of Transactions"; Integer)        {            CalcFormula = count("G/L Transaction" where("G/L Register No." = field("No.")));            Caption = 'No. of Transactions';            Editable = false;            FieldClass = FlowField;            ToolTip = 'Specifies the number of general ledger transactions in this register.';        }        field(10700; "Posting Date"; Date)        {            Caption = 'Posting Date';            ClosingDates = true;        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }        key(Key2; "Creation Date")        {        }        key(Key3; "Source Code", "Journal Batch Name", "Creation Date")        {        }        key(Key4; "Posting Date")        {        }        key(key6; "From Entry No.", "To Entry No.")        {            IncludedFields = "Creation Date", SystemCreatedAt;        }        key(key7; "Source Code", "Journal Batch Name", SystemCreatedAt)        {        }        key(key8; SystemCreatedAt)        {        }    }    fieldgroups    {        fieldgroup(DropDown; "No.", "From Entry No.", "To Entry No.", SystemCreatedAt, "Source Code")        {        }    }    procedure GetNextRegisterNo(UseLegacyPosting: Boolean): Integer    begin        if not UseLegacyPosting then            exit(GetNextEntryNo());        Rec.LockTable();        exit(GetLastEntryNo() + 1);    end;    [InherentPermissions(PermissionObjectType::TableData, Database::"G/L Register", 'r')]    procedure GetNextEntryNo(): Integer    var        SequenceNoMgt: Codeunit "Sequence No. Mgt.";    begin        exit(SequenceNoMgt.GetNextSeqNo(DATABASE::"G/L Register"));    end;    /// <summary>    /// Retrieves the last (highest) register number from the G/L Register table.    /// </summary>    /// <returns>Integer: The highest register number, or 0 if no registers exist.</returns>    [InherentPermissions(PermissionObjectType::TableData, Database::"G/L Register", 'r')]    procedure GetLastEntryNo(): Integer;    var        FindRecordManagement: Codeunit "Find Record Management";    begin        exit(FindRecordManagement.GetLastEntryIntFieldValue(Rec, FieldNo("No.")))    end;    /// <summary>    /// Initializes a new G/L Register record with the specified parameters.    /// </summary>    /// <param name="NextRegNo">Next sequential register number to assign.</param>    /// <param name="FromEntryNo">Starting G/L entry number for this register.</param>    /// <param name="FromVATEntryNo">Starting VAT entry number for this register.</param>    /// <param name="SourceCode">Source code identifying the posting process.</param>    /// <param name="BatchName">Journal batch name from the posting process.</param>    /// <param name="TemplateName">Journal template name from the posting process.</param>    procedure Initialize(NextRegNo: Integer; FromEntryNo: Integer; FromVATEntryNo: Integer; SourceCode: Code[10]; BatchName: Code[10]; TemplateName: Code[10])    begin        Init();        OnInitializeOnAfterGLRegisterInit(Rec, TemplateName);        "No." := NextRegNo;        "Source Code" := SourceCode;        "User ID" := CopyStr(UserId(), 1, MaxStrLen("User ID"));        "From Entry No." := FromEntryNo;        "From VAT Entry No." := FromVATEntryNo;        "Journal Batch Name" := BatchName;        "Journal Templ. Name" := TemplateName;    end;    procedure UpdateGLEntriesWithRegisterNo()    var        GLEntry: Record "G/L Entry";        GLTransaction: Record "G/L Transaction";    begin        GLEntry.SetLoadFields("Entry No.", "G/L Register No.", "Transaction No.");        GLEntry.SetRange("Entry No.", Rec."From Entry No.", Rec."To Entry No.");        if GLEntry.FindSet(true) then            repeat                if GLEntry."G/L Register No." = 0 then begin                    GLEntry."G/L Register No." := Rec."No.";                    GLEntry.Modify();                    if not GLTransaction.Get(GLEntry."Transaction No.") then begin                        GLTransaction.Init();                        GLTransaction."No." := GLEntry."Transaction No.";                        GLTransaction."G/L Register No." := Rec."No.";                        GLTransaction.Insert();                    end;                end;            until GLEntry.Next() = 0;    end;    /// <summary>    /// Integration event raised after initializing a G/L Register record.    /// </summary>    /// <param name="GLRegister">G/L Register record being initialized.</param>    /// <param name="TemplateName">Journal template name used for initialization.</param>    [IntegrationEvent(false, false)]    local procedure OnInitializeOnAfterGLRegisterInit(var GLRegister: record "G/L Register"; TemplateName: Code[10])    begin    end;}