Table 8613 Config. Package Table

Base Application, System.IO

src/Layers/W1/BaseApp/System/RapidStart/ConfigPackageTable.Table.al846 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.IO;using Microsoft.Finance.Dimension;using System.Environment;using System.Reflection;using System.Security.AccessControl;table 8613 "Config. Package Table"{    Caption = 'Config. Package Table';    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(1; "Package Code"; Code[20])        {            Caption = 'Package Code';            TableRelation = "Config. Package";        }        field(2; "Table ID"; Integer)        {            Caption = 'Table ID';            NotBlank = true;            TableRelation = AllObj."Object ID" where("Object Type" = const(Table));            trigger OnLookup()            begin                ConfigValidateMgt.LookupTable("Table ID");                if "Table ID" <> 0 then                    Validate("Table ID");            end;            trigger OnValidate()            begin                if ConfigMgt.IsSystemTable("Table ID") then                    Error(SystemTableNotAllowedErr, "Table ID");                if "Table ID" <> xRec."Table ID" then                    "Page ID" := ConfigMgt.FindPage("Table ID");            end;        }        field(3; "Table Name"; Text[250])        {            CalcFormula = lookup(AllObjWithCaption."Object Name" where("Object Type" = const(Table),                                                                        "Object ID" = field("Table ID")));            Caption = 'Table Name';            Editable = false;            FieldClass = FlowField;        }        field(4; "No. of Package Records"; Integer)        {            CalcFormula = count("Config. Package Record" where("Package Code" = field("Package Code"),                                                                "Table ID" = field("Table ID")));            Caption = 'No. of Package Records';            Editable = false;            FieldClass = FlowField;        }        field(5; "No. of Package Errors"; Integer)        {            CalcFormula = count("Config. Package Error" where("Package Code" = field("Package Code"),                                                               "Table ID" = field("Table ID")));            Caption = 'No. of Package Errors';            Editable = false;            FieldClass = FlowField;        }        field(7; "Imported Date and Time"; DateTime)        {            Caption = 'Imported Date and Time';            Editable = false;        }        field(8; "Exported Date and Time"; DateTime)        {            Caption = 'Exported Date and Time';            Editable = false;        }        field(9; Comments; Text[250])        {            Caption = 'Comments';        }        field(10; "Created Date and Time"; DateTime)        {            Caption = 'Created Date and Time';        }        field(11; "Company Filter (Source Table)"; Text[30])        {            Caption = 'Company Filter (Source Table)';            FieldClass = FlowFilter;            TableRelation = Company;        }        field(12; "Table Caption"; Text[250])        {            CalcFormula = lookup(AllObjWithCaption."Object Caption" where("Object Type" = const(Table),                                                                           "Object ID" = field("Table ID")));            Caption = 'Table Caption';            Editable = false;            FieldClass = FlowField;        }        field(13; "Data Template"; Code[10])        {            Caption = 'Data Template';            TableRelation = "Config. Template Header";        }        field(14; "Package Processing Order"; Integer)        {            Caption = 'Package Processing Order';            Editable = false;        }        field(15; "Page ID"; Integer)        {            Caption = 'Page ID';            TableRelation = AllObjWithCaption."Object ID" where("Object Type" = const(Page));            trigger OnLookup()            begin                ConfigValidateMgt.LookupPage("Page ID");                Validate("Page ID");            end;        }        field(16; "Processing Order"; Integer)        {            Caption = 'Processing Order';        }        field(17; "No. of Fields Included"; Integer)        {            CalcFormula = count("Config. Package Field" where("Package Code" = field("Package Code"),                                                               "Table ID" = field("Table ID"),                                                               "Include Field" = const(true)));            Caption = 'No. of Fields Included';            Editable = false;            FieldClass = FlowField;        }        field(18; "No. of Fields Available"; Integer)        {            CalcFormula = count("Config. Package Field" where("Package Code" = field("Package Code"),                                                               "Table ID" = field("Table ID")));            Caption = 'No. of Fields Available';            Editable = false;            FieldClass = FlowField;        }        field(19; "No. of Fields to Validate"; Integer)        {            CalcFormula = count("Config. Package Field" where("Package Code" = field("Package Code"),                                                               "Table ID" = field("Table ID"),                                                               "Validate Field" = const(true)));            Caption = 'No. of Fields to Validate';            Editable = false;            FieldClass = FlowField;        }        field(20; "Package Caption"; Text[50])        {            CalcFormula = lookup("Config. Package"."Package Name" where(Code = field("Package Code")));            Caption = 'Package Caption';            Editable = false;            FieldClass = FlowField;        }        field(21; "Imported by User ID"; Code[50])        {            Caption = 'Imported by User ID';            DataClassification = EndUserIdentifiableInformation;            Editable = false;            TableRelation = User."User Name";        }        field(22; "Created by User ID"; Code[50])        {            Caption = 'Created by User ID';            DataClassification = EndUserIdentifiableInformation;            Editable = false;            TableRelation = User."User Name";        }        field(24; "Dimensions as Columns"; Boolean)        {            Caption = 'Dimensions as Columns';            trigger OnValidate()            begin                if "Dimensions as Columns" then begin                    InitDimensionFields();                    UpdateDimensionsPackageData();                end else                    DeleteDimensionFields();            end;        }        field(25; Filtered; Boolean)        {            CalcFormula = exist("Config. Package Filter" where("Package Code" = field("Package Code"),                                                                "Table ID" = field("Table ID")));            Caption = 'Filtered';            Editable = false;            FieldClass = FlowField;        }        field(26; "Skip Table Triggers"; Boolean)        {            Caption = 'Skip Table Triggers';        }        field(27; "Delete Recs Before Processing"; Boolean)        {            Caption = 'Delete Recs Before Processing';        }        field(28; "Processing Report ID"; Integer)        {            Caption = 'Processing Report ID';            TableRelation = AllObjWithCaption."Object ID" where("Object Type" = const(Report));        }        field(29; "Parent Table ID"; Integer)        {            Caption = 'Parent Table ID';            TableRelation = "Config. Package Table"."Table ID" where("Package Code" = field("Package Code"));            trigger OnValidate()            var                Levels: Integer;            begin                if "Table ID" = "Parent Table ID" then                    Error(CannotBeItsOwnParentErr);                Levels := CheckchildrenTables(Rec);                Levels += CheckParentTables(Rec);                // There should be no more than 2 level of parents, children or both for any table.                if Levels > 2 then                    Error(CannotAddParentErr);            end;        }        field(30; Validated; Boolean)        {            Caption = 'Validated';        }        field(31; "Delayed Insert"; Boolean)        {            Caption = 'Delayed Insert';        }        field(32; "Cross-Column Filter"; Boolean)        {            Caption = 'Cross-Column Filter';        }    }    keys    {        key(Key1; "Package Code", "Table ID")        {            Clustered = true;        }        key(Key2; "Package Processing Order", "Processing Order")        {        }    }    fieldgroups    {    }    trigger OnDelete()    begin        DeletePackageDataForPackage("Package Code", "Table ID");        DeleteRelatedTables("Package Code", "Table ID");    end;    trigger OnInsert()    begin        InitPackageFields();    end;    trigger OnRename()    begin        Error(CannotRenamePackageTableErr);    end;    var        ConfigValidateMgt: Codeunit "Config. Validate Management";        ConfigMgt: Codeunit "Config. Management";        ConfigPackageMgt: Codeunit "Config. Package Management";        i: Integer;#pragma warning disable AA0470        SystemTableNotAllowedErr: Label 'You cannot use system table %1 in the package.';        DimensionsAsColumnsNotAllowedErr: Label 'You cannot use the Dimensions as Columns function for table %1.';        MissingTablesAddQst: Label 'The Default Dimension and Dimension Value tables must be included in the package %1 to enable this option. The missing tables will be added to the package. Do you want to continue?';#pragma warning restore AA0470        CannotRenamePackageTableErr: Label 'You cannot rename the configuration package table.';        DimensionsSetupCanceledMsg: Label 'The setup of Dimensions as Columns was canceled.';#pragma warning disable AA0470        DefineDrillDownPageMsg: Label 'Define the drill-down page in the %1 field.';#pragma warning restore AA0470        CannotAddParentErr: Label 'Cannot add a parent table. This table is already included in a three-level hierarchy, which is the maximum.';        CannotBeItsOwnParentErr: Label 'Cannot add the parent table. A table cannot be its own parent or child.';        CircularDependencyErr: Label 'Cannot add the parent table. The table is already the child of the selected tab.';        ParentTableNotFoundErr: Label 'Cannot find table %1.', Comment = '%1 - Table number';    protected var        HideValidationDialog: Boolean;    [Scope('OnPrem')]    procedure DeleteRelatedTables(PackageCode: Code[20]; TableID: Integer)    var        ConfigLine: Record "Config. Line";        ConfigPackageField: Record "Config. Package Field";        ConfigFieldMap: Record "Config. Field Map";        ConfigPackageFilter: Record "Config. Package Filter";        ConfigTableProcessingRule: Record "Config. Table Processing Rule";    begin        ConfigFieldMap.SetRange("Package Code", PackageCode);        if TableID <> 0 then            ConfigFieldMap.SetRange("Table ID", "Table ID");        ConfigFieldMap.DeleteAll();        ConfigPackageField.SetRange("Package Code", PackageCode);        if TableID <> 0 then            ConfigPackageField.SetRange("Table ID", "Table ID");        ConfigPackageField.DeleteAll();        ConfigPackageFilter.SetRange("Package Code", PackageCode);        if TableID <> 0 then            ConfigPackageFilter.SetRange("Table ID", "Table ID");        ConfigPackageFilter.DeleteAll();        ConfigTableProcessingRule.SetRange("Package Code", PackageCode);        if TableID <> 0 then            ConfigTableProcessingRule.SetRange("Table ID", "Table ID");        ConfigTableProcessingRule.DeleteAll();        ConfigLine.SetRange("Package Code", PackageCode);        if TableID <> 0 then            ConfigLine.SetRange("Table ID", "Table ID");        ConfigLine.SetRange("Dimensions as Columns", true);        ConfigLine.ModifyAll("Dimensions as Columns", false);        ConfigLine.SetRange("Dimensions as Columns");        OnDeleteRelatedTablesOnBeforeModifyAllConfigLineWithEmptyPackageCode(ConfigLine, PackageCode, TableID);        ConfigLine.ModifyAll("Package Code", '');    end;    local procedure InitPackageFields(): Boolean    var        ConfigPackageField: Record "Config. Package Field";        ConfigLine: Record "Config. Line";        "Field": Record "Field";        ConfigPackage: Record "Config. Package";        ProcessingOrder: Integer;        OldGlobalLanguageId: Integer;        FieldsAdded: Boolean;        ShouldAddField: Boolean;    begin        FieldsAdded := false;        ConfigPackageMgt.SetFieldFilter(Field, "Table ID", 0);        ConfigPackage.Get("Package Code");        if ConfigPackage."Language ID" <> 0 then begin            OldGlobalLanguageId := GlobalLanguage;            GlobalLanguage(ConfigPackage."Language ID");        end;        if Field.FindSet() then            repeat                ShouldAddField := not ConfigPackageField.Get("Package Code", "Table ID", Field."No.") and                   not ConfigPackageMgt.IsDimSetIDField("Table ID", Field."No.");                OnInitPackageFieldsOnAfterCalcShouldAddField(Rec, Field, ShouldAddField);                if ShouldAddField then begin                    ConfigPackageMgt.InsertPackageField(                      ConfigPackageField, "Package Code", "Table ID", Field."No.", Field.FieldName, Field."Field Caption",                      true, true, false, false);                    ConfigPackageField.SetRange("Package Code", "Package Code");                    ConfigPackageField.SetRange("Table ID", "Table ID");                    ConfigPackageField.SetRange("Field ID", Field."No.");                    ConfigPackageMgt.SelectAllPackageFields(ConfigPackageField, true);                    OnInitPackageFieldsOnAfterSelectAllPackageFields(ConfigPackageField);                    FieldsAdded := true;                end;            until Field.Next() = 0;        if ConfigPackage."Language ID" <> 0 then            GlobalLanguage(OldGlobalLanguageId);        if FieldsAdded then begin            ProcessingOrder := 0;            SetProcessingOrderPrimaryKey("Package Code", "Table ID", ProcessingOrder);            ConfigPackageField.Reset();            ConfigPackageField.SetRange("Package Code", "Package Code");            ConfigPackageField.SetRange("Table ID", "Table ID");            ConfigPackageField.SetRange("Primary Key", false);            if "Table ID" <> Database::"Config. Line" then                SetProcessingOrderFields(ConfigPackageField, ProcessingOrder)            else begin                ConfigPackageField.SetRange("Field ID", ConfigLine.FieldNo("Line Type"), ConfigLine.FieldNo("Table ID"));                SetProcessingOrderFields(ConfigPackageField, ProcessingOrder);                // package code must be processed just after table ID!                ConfigPackageField.SetRange("Field ID", ConfigLine.FieldNo("Package Code"));                SetProcessingOrderFields(ConfigPackageField, ProcessingOrder);                ConfigPackageField.SetRange("Field ID", ConfigLine.FieldNo(Name), ConfigLine.FieldNo("Package Code") - 1);                SetProcessingOrderFields(ConfigPackageField, ProcessingOrder);                ConfigPackageField.SetFilter("Field ID", '%1..', ConfigLine.FieldNo("Package Code") + 1);                SetProcessingOrderFields(ConfigPackageField, ProcessingOrder);            end;        end;        exit(FieldsAdded);    end;    local procedure SetProcessingOrderPrimaryKey(PackageCode: Code[20]; TableID: Integer; var ProcessingOrder: Integer)    var        ConfigPackageField: Record "Config. Package Field";        RecRef: RecordRef;        FieldRef: FieldRef;        KeyRef: KeyRef;        KeyFieldCount: Integer;    begin        RecRef.Open(TableID);        KeyRef := RecRef.KeyIndex(1);        for KeyFieldCount := 1 to KeyRef.FieldCount do begin            FieldRef := KeyRef.FieldIndex(KeyFieldCount);            ConfigPackageField.Get(PackageCode, TableID, FieldRef.Number);            ProcessingOrder += 1;            ConfigPackageField."Processing Order" := ProcessingOrder;            ConfigPackageField.Modify();        end;    end;    local procedure SetProcessingOrderFields(var ConfigPackageField: Record "Config. Package Field"; var ProcessingOrder: Integer)    begin        if ConfigPackageField.FindSet() then            repeat                ProcessingOrder += 1;                ConfigPackageField."Processing Order" := ProcessingOrder;                ConfigPackageField.Modify();            until ConfigPackageField.Next() = 0;    end;    procedure InitDimensionFields()    var        Dimension: Record Dimension;        ConfigPackageField: Record "Config. Package Field";        ConfigPackageTable: Record "Config. Package Table";        Confirmed: Boolean;    begin        if not (ConfigMgt.IsDimSetIDTable("Table ID") or ConfigMgt.IsDefaultDimTable("Table ID")) then            Error(DimensionsAsColumnsNotAllowedErr, "Table ID");        if ConfigMgt.IsDefaultDimTable("Table ID") then begin            Confirmed :=              (ConfigPackageTable.Get("Package Code", Database::"Dimension Value") and               ConfigPackageTable.Get("Package Code", Database::"Default Dimension")) or              (HideValidationDialog or not GuiAllowed);            if not Confirmed then                Confirmed := Confirm(MissingTablesAddQst, true, "Package Code");            if Confirmed then begin                ConfigPackageMgt.InsertPackageTable(ConfigPackageTable, "Package Code", Database::"Dimension Value");                ConfigPackageMgt.InsertPackageTable(ConfigPackageTable, "Package Code", Database::"Default Dimension");            end else                Error(DimensionsSetupCanceledMsg);        end;        i := 0;        if Dimension.FindSet() then            repeat                i := i + 1;                ConfigPackageMgt.InsertPackageField(                  ConfigPackageField, "Package Code", "Table ID", ConfigMgt.DimensionFieldID() + i,                  Dimension.Code, Dimension."Code Caption", true, false, false, true);            until Dimension.Next() = 0;    end;    procedure DeletePackageData()    begin        DeletePackageDataForPackage("Package Code", "Table ID");    end;    procedure DeletePackageDataForPackage(PackageCode: Code[20]; TableId: Integer)    var        ConfigPackageRecord: Record "Config. Package Record";        ConfigPackageData: Record "Config. Package Data";        ConfigPackageError: Record "Config. Package Error";    begin        ConfigPackageRecord.SetRange("Package Code", PackageCode);        if TableId <> 0 then            ConfigPackageRecord.SetRange("Table ID", TableId);        ConfigPackageRecord.DeleteAll();        ConfigPackageData.SetRange("Package Code", PackageCode);        if TableId <> 0 then            ConfigPackageData.SetRange("Table ID", TableId);        ConfigPackageData.DeleteAll();        ConfigPackageError.SetRange("Package Code", PackageCode);        if TableId <> 0 then            ConfigPackageError.SetRange("Table ID", TableId);        ConfigPackageError.DeleteAll();    end;    local procedure DeleteDimensionFields()    var        ConfigPackageField: Record "Config. Package Field";        ConfigPackageData: Record "Config. Package Data";    begin        ConfigPackageData.SetRange("Package Code", "Package Code");        ConfigPackageData.SetRange("Table ID", "Table ID");        ConfigPackageData.SetRange("Field ID", ConfigMgt.DimensionFieldID(), ConfigMgt.DimensionFieldID() + 999);        ConfigPackageData.DeleteAll();        ConfigPackageField.SetRange("Package Code", "Package Code");        ConfigPackageField.SetRange("Table ID", "Table ID");        ConfigPackageField.SetRange(Dimension, true);        ConfigPackageField.DeleteAll();    end;    procedure DimensionFieldsCount(): Integer    var        ConfigPackageField: Record "Config. Package Field";    begin        ConfigPackageField.SetRange("Package Code", "Package Code");        ConfigPackageField.SetRange("Table ID", "Table ID");        ConfigPackageField.SetRange(Dimension, true);        exit(ConfigPackageField.Count);    end;    procedure DimensionPackageDataExist(): Boolean    var        ConfigPackageData: Record "Config. Package Data";    begin        ConfigPackageData.SetRange("Package Code", "Package Code");        ConfigPackageData.SetRange("Table ID", "Table ID");        ConfigPackageData.SetRange("Field ID", ConfigMgt.DimensionFieldID(), ConfigMgt.DimensionFieldID() + 999);        exit(not ConfigPackageData.IsEmpty);    end;    procedure ShowPackageRecords(Show: Option Records,Errors,All; ShowDim: Boolean)    var        ConfigPackageField: Record "Config. Package Field";        ConfigPackageRecord: Record "Config. Package Record";        ConfigPackageRecords: Page "Config. Package Records";        MatrixColumnCaptions: array[1000] of Text[100];        IsHandled: Boolean;    begin        ConfigPackageField.SetRange("Package Code", "Package Code");        ConfigPackageField.SetRange("Table ID", "Table ID");        ConfigPackageField.SetRange("Include Field", true);        if not ShowDim then            ConfigPackageField.SetRange(Dimension, false);        FillMatrixColumnCaptions(MatrixColumnCaptions, ConfigPackageField);        CalcFields("Table Caption");        Clear(ConfigPackageRecords);        ConfigPackageRecord.SetRange("Package Code", "Package Code");        ConfigPackageRecord.SetRange("Table ID", "Table ID");        case Show of            Show::Records:                ConfigPackageRecord.SetRange(Invalid, false);            Show::Errors:                ConfigPackageRecord.SetRange(Invalid, true);        end;        ConfigPackageRecords.SetTableView(ConfigPackageRecord);        ConfigPackageRecords.LookupMode(true);        ConfigPackageRecords.Load(MatrixColumnCaptions, "Table Caption", "Package Code", "Table ID", ShowDim);        IsHandled := false;        OnShowPackageRecordsOnBeforeShowRecords(ConfigPackageRecords, IsHandled);        if not IsHandled then            ConfigPackageRecords.RunModal();    end;    local procedure FillMatrixColumnCaptions(var MatrixColumnCaptions: array[1000] of Text[100]; var ConfigPackageField: Record "Config. Package Field")    var        IsHandled: Boolean;    begin        isHandled := false;        OnBeforeFillMatrixColumnCaptions(MatrixColumnCaptions, ConfigPackageField, IsHandled);        if IsHandled then            exit;        i := 1;        Clear(MatrixColumnCaptions);        if ConfigPackageField.FindSet() then            repeat                MatrixColumnCaptions[i] := ConfigPackageField."Field Name";                i := i + 1;            until ConfigPackageField.Next() = 0;    end;    procedure ShowDatabaseRecords()    var        ConfigLine: Record "Config. Line";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeShowDatabaseRecords(Rec, IsHandled);        if IsHandled then            exit;        if "Page ID" <> 0 then            PAGE.Run("Page ID")        else begin            ConfigLine.SetRange("Package Code", "Package Code");            ConfigLine.SetRange("Table ID", "Table ID");            if ConfigLine.FindFirst() and (ConfigLine."Page ID" > 0) then                PAGE.Run(ConfigLine."Page ID")            else                Error(DefineDrillDownPageMsg, FieldCaption("Page ID"));        end;    end;    procedure ShowPackageFields()    begin        ShowFilteredPackageFields('');    end;    procedure ShowFilteredPackageFields(FilterValue: Text)    begin        if InitPackageFields() then            Commit();        if "Dimensions as Columns" then            if not DimensionPackageDataExist() then                if DimensionFieldsNotExist() then begin                    if DimensionFieldsCount() > 0 then                        DeleteDimensionFields();                    InitDimensionFields();                    Commit();                end;        SetFiltersAndRunConfigPackageFields(FilterValue);    end;    local procedure SetFiltersAndRunConfigPackageFields(FilterValue: Text)    var        ConfigPackageField: Record "Config. Package Field";        ConfigPackageFields: Page "Config. Package Fields";    begin        OnBeforeSetFiltersAndRunConfigPackageFields(Rec);        ConfigPackageField.FilterGroup(2);        ConfigPackageField.SetRange("Package Code", "Package Code");        ConfigPackageField.SetRange("Table ID", "Table ID");        if FilterValue <> '' then            ConfigPackageField.SetFilter("Field ID", FilterValue);        ConfigPackageField.FilterGroup(0);        ConfigPackageFields.SetTableView(ConfigPackageField);        ConfigPackageFields.RunModal();        Clear(ConfigPackageFields);    end;    procedure ShowPackageCard(PackageCode: Code[20])    var        ConfigPackage: Record "Config. Package";        ConfigPackageCard: Page "Config. Package Card";    begin        ConfigPackage.FilterGroup(2);        ConfigPackage.SetRange(Code, PackageCode);        ConfigPackage.FilterGroup(0);        ConfigPackageCard.SetTableView(ConfigPackage);        ConfigPackageCard.RunModal();        Clear(ConfigPackageCard);    end;    procedure SetFieldStyle(FieldNumber: Integer): Text    begin        case FieldNumber of            FieldNo("No. of Package Records"):                begin                    CalcFields("No. of Package Records");                    if "No. of Package Records" > 0 then                        exit('Strong');                end;            FieldNo("No. of Package Errors"):                begin                    CalcFields("No. of Package Errors");                    if "No. of Package Errors" > 0 then                        exit('Unfavorable');                end;        end;        exit('');    end;    procedure ShowFilters()    var        ConfigPackageFilter: Record "Config. Package Filter";        ConfigPackageFilters: Page "Config. Package Filters";    begin        ConfigPackageFilter.FilterGroup(2);        ConfigPackageFilter.SetRange("Package Code", "Package Code");        ConfigPackageFilter.SetRange("Table ID", "Table ID");        ConfigPackageFilter.SetRange("Processing Rule No.", 0);        ConfigPackageFilter.FilterGroup(0);        ConfigPackageFilters.SetTableView(ConfigPackageFilter);        ConfigPackageFilters.RunModal();        Clear(ConfigPackageFilters);    end;    procedure ShowProcessingRules()    var        ConfigTableProcessingRule: Record "Config. Table Processing Rule";        ConfigTableProcessingRules: Page "Config. Table Processing Rules";    begin        ConfigTableProcessingRule.FilterGroup(2);        ConfigTableProcessingRule.SetRange("Package Code", "Package Code");        ConfigTableProcessingRule.SetRange("Table ID", "Table ID");        ConfigTableProcessingRule.FilterGroup(0);        ConfigTableProcessingRules.SetTableView(ConfigTableProcessingRule);        ConfigTableProcessingRules.RunModal();        Clear(ConfigTableProcessingRules);    end;    local procedure UpdateDimensionsPackageData()    var        ConfigPackageField: Record "Config. Package Field";        ConfigPackageRecord: Record "Config. Package Record";        ConfigPackageData: Record "Config. Package Data";    begin        ConfigPackageRecord.SetRange("Package Code", "Package Code");        ConfigPackageRecord.SetRange("Table ID", "Table ID");        if ConfigPackageRecord.FindSet() then            repeat                ConfigPackageField.SetRange("Package Code", "Package Code");                ConfigPackageField.SetRange("Table ID", "Table ID");                ConfigPackageField.SetRange(Dimension, true);                if ConfigPackageField.FindSet() then                    repeat                        ConfigPackageMgt.InsertPackageData(                          ConfigPackageData, "Package Code", "Table ID", ConfigPackageRecord."No.",                          ConfigPackageField."Field ID", '', ConfigPackageRecord.Invalid);                    until ConfigPackageField.Next() = 0;            until ConfigPackageRecord.Next() = 0;    end;    procedure SetHideValidationDialog(NewHideValidationDialog: Boolean)    begin        HideValidationDialog := NewHideValidationDialog;    end;    procedure GetNoOfDatabaseRecords(): Integer    var        ConfigXMLExchange: Codeunit "Config. XML Exchange";        RecRef: RecordRef;    begin        if "Table ID" = 0 then            exit(0);        if not ConfigXMLExchange.TableObjectExists("Table ID") then            exit(0);        RecRef.Open("Table ID", false, "Company Filter (Source Table)");        if not RecRef.ReadPermission() then            exit(0);        exit(RecRef.Count());    end;    procedure GetNoOfDatabaseRecordsText(): Text    var        ConfigXMLExchange: Codeunit "Config. XML Exchange";        RecRef: RecordRef;    begin        if "Table ID" = 0 then            exit;        if not ConfigXMLExchange.TableObjectExists("Table ID") then            exit;        RecRef.Open("Table ID", false, "Company Filter (Source Table)");        if not RecRef.ReadPermission() then            exit;        exit(Format(RecRef.Count()));    end;    local procedure CheckParentTables(ConfigPackageTable: Record "Config. Package Table"): Integer    var        ParentsFound: Integer;    begin        if ConfigPackageTable."Parent Table ID" <> 0 then            repeat                if not ConfigPackageTable.Get(ConfigPackageTable."Package Code", ConfigPackageTable."Parent Table ID") then                    Error(ParentTableNotFoundErr, ConfigPackageTable."Parent Table ID");                // Check there is no circular dependency                if ConfigPackageTable."Parent Table ID" = "Table ID" then                    Error(CircularDependencyErr);                ParentsFound += 1;                if ParentsFound > 2 then                    exit(ParentsFound);            until ConfigPackageTable."Parent Table ID" = 0;        exit(ParentsFound);    end;    local procedure CheckchildrenTables(ConfigPackageTable: Record "Config. Package Table"): Integer    var        childrenFound: Integer;        TempCounter: Integer;    begin        ConfigPackageTable.SetRange("Package Code", ConfigPackageTable."Package Code");        ConfigPackageTable.SetRange("Parent Table ID", ConfigPackageTable."Table ID");        childrenFound := 0;        if ConfigPackageTable.FindSet() then begin            repeat                // Check there is no circular dependency                if ConfigPackageTable."Table ID" = "Parent Table ID" then                    Error(CircularDependencyErr);                TempCounter := CheckchildrenTables(ConfigPackageTable);                if childrenFound < TempCounter then                    childrenFound := TempCounter;                if childrenFound > 2 then                    exit(childrenFound)            until ConfigPackageTable.Next() = 0;            childrenFound += 1;        end;        exit(childrenFound);    end;    local procedure DimensionFieldsNotExist(): Boolean    var        ConfigPackageField: Record "Config. Package Field";    begin        ConfigPackageField.SetRange("Package Code", "Package Code");        ConfigPackageField.SetRange("Table ID", "Table ID");        ConfigPackageField.SetRange("Processing Order", ConfigMgt.DimensionFieldID(), ConfigMgt.DimensionFieldID() + 999);        exit(ConfigPackageField.IsEmpty);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFillMatrixColumnCaptions(var MatrixColumnCaptions: array[1000] of Text[100]; var ConfigPackageField: Record "Config. Package Field"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSetFiltersAndRunConfigPackageFields(var ConfigPackageTable: Record "Config. Package Table")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeShowDatabaseRecords(var ConfigPackageTable: Record "Config. Package Table"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteRelatedTablesOnBeforeModifyAllConfigLineWithEmptyPackageCode(var ConfigLine: Record "Config. Line"; PackageCode: Code[20]; TableID: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInitPackageFieldsOnAfterCalcShouldAddField(var ConfigPackageTable: Record "Config. Package Table"; "Field": Record "Field"; var ShouldAddField: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnShowPackageRecordsOnBeforeShowRecords(var ConfigPackageRecords: Page "Config. Package Records"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInitPackageFieldsOnAfterSelectAllPackageFields(var ConfigPackageField: Record "Config. Package Field")    begin    end;}