Table 1265 Data Exch. Field Mapping Buf.

Base Application, System.IO

src/Layers/W1/BaseApp/System/DataExchange/DataExchFieldMappingBuf.Table.al352 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.IO;using System.Reflection;table 1265 "Data Exch. Field Mapping Buf."{    Caption = 'Data Exch. Field Mapping Buf.';    DataClassification = CustomerContent;    fields    {        field(1; "Data Exchange Def Code"; Code[20])        {            Caption = 'Data Exchange Def Code';            DataClassification = SystemMetadata;        }        field(2; "Data Exchange Line Def Code"; Code[20])        {            Caption = 'Data Exchange Line Def Code';            DataClassification = SystemMetadata;        }        field(3; "Table ID"; Integer)        {            Caption = 'Table ID';            DataClassification = SystemMetadata;        }        field(4; "Column No."; Integer)        {            Caption = 'Column No.';            DataClassification = SystemMetadata;        }        field(5; Type; Option)        {            Caption = 'Type';            DataClassification = SystemMetadata;            OptionCaption = 'Field,Table';            OptionMembers = "Field","Table";        }        field(10; "Field ID"; Integer)        {            Caption = 'Field ID';            DataClassification = SystemMetadata;        }        field(11; "Default Value"; Text[250])        {            Caption = 'Default Value';            DataClassification = SystemMetadata;            trigger OnValidate()            var                DataExchFieldMapping: Record "Data Exch. Field Mapping";            begin                TestField(Type, Type::Field);                DataExchFieldMapping.Get("Data Exchange Def Code", "Data Exchange Line Def Code", "Table ID", "Column No.", "Field ID");                DataExchFieldMapping.Validate("Default Value", "Default Value");                DataExchFieldMapping.Modify(true);            end;        }        field(13; Source; Text[250])        {            Caption = 'Source';            DataClassification = SystemMetadata;            trigger OnValidate()            var                DataExchColumnDef: Record "Data Exch. Column Def";                DataExchLineDef: Record "Data Exch. Line Def";            begin                case Type of                    Type::Field:                        if not DataExchColumnDef.Get("Data Exchange Def Code", "Data Exchange Line Def Code", "Column No.") then                            CreateDataExchColumnDef()                        else begin                            DataExchColumnDef.Validate(Path, Source);                            DataExchColumnDef.Modify(true);                        end;                    Type::Table:                        begin                            DataExchLineDef.Get("Data Exchange Def Code", "Data Exchange Line Def Code");                            DataExchLineDef.Validate("Data Line Tag", Source);                            DataExchLineDef.Modify(true);                        end;                end;            end;        }        field(20; Caption; Text[250])        {            Caption = 'Caption';            DataClassification = SystemMetadata;            Editable = false;        }        field(22; Depth; Integer)        {            Caption = 'Depth';            DataClassification = SystemMetadata;        }        field(23; "Transformation Rule"; Code[20])        {            Caption = 'Transformation Rule';            DataClassification = SystemMetadata;            TableRelation = "Transformation Rule";            trigger OnValidate()            var                DataExchFieldMapping: Record "Data Exch. Field Mapping";            begin                TestField(Type, Type::Field);                DataExchFieldMapping.Get("Data Exchange Def Code", "Data Exchange Line Def Code", "Table ID", "Column No.", "Field ID");                DataExchFieldMapping.Validate("Transformation Rule", "Transformation Rule");                DataExchFieldMapping.Modify(true);            end;        }    }    keys    {        key(Key1; "Data Exchange Def Code", "Data Exchange Line Def Code", "Field ID", "Table ID")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        DataExchColumnDef: Record "Data Exch. Column Def";        DataExchFieldMapping: Record "Data Exch. Field Mapping";    begin        TestField(Type, Type::Field);        if DataExchFieldMapping.Get("Data Exchange Def Code", "Data Exchange Line Def Code", "Table ID", "Column No.", "Field ID") then            DataExchFieldMapping.Delete(true);        if DataExchColumnDef.Get("Data Exchange Def Code", "Data Exchange Line Def Code", "Column No.") then            DataExchColumnDef.Delete(true);    end;    trigger OnInsert()    var        DataExchFieldMapping: Record "Data Exch. Field Mapping";    begin        TestField(Type, Type::Field);        if "Column No." = 0 then            CreateDataExchColumnDef();        if not DataExchFieldMapping.Get("Data Exchange Def Code", "Data Exchange Line Def Code", "Table ID", "Column No.", "Field ID") then            CreateFieldMapping();    end;    trigger OnRename()    begin        // TODO: Test and implement    end;    procedure InsertFromDataExchDefinition(var TempDataExchFieldMappingBuf: Record "Data Exch. Field Mapping Buf." temporary; DataExchDef: Record "Data Exch. Def"; var TempSuggestedField: Record "Field" temporary)    var        DataExchLineDef: Record "Data Exch. Line Def";    begin        DataExchLineDef.SetRange("Data Exch. Def Code", DataExchDef.Code);        DataExchLineDef.SetRange("Parent Code", '');        if DataExchLineDef.FindSet() then            repeat                InsertFromDataExchDefinitionLine(TempDataExchFieldMappingBuf, DataExchLineDef, TempSuggestedField, 0);            until DataExchLineDef.Next() = 0;    end;    procedure InsertFromDataExchDefinitionLine(var TempDataExchFieldMappingBuf: Record "Data Exch. Field Mapping Buf." temporary; DataExchLineDef: Record "Data Exch. Line Def"; var TempSuggestedField: Record "Field" temporary; NewDepth: Integer)    var        DataExchMapping: Record "Data Exch. Mapping";        ChildDataExchLineDef: Record "Data Exch. Line Def";    begin        DataExchMapping.SetRange("Data Exch. Def Code", DataExchLineDef."Data Exch. Def Code");        DataExchMapping.SetRange("Data Exch. Line Def Code", DataExchLineDef.Code);        if DataExchMapping.FindSet() then            repeat                InsertDataExchLineDefMappingLine(TempDataExchFieldMappingBuf, DataExchMapping, NewDepth);                InsertFieldMappingDefinition(TempDataExchFieldMappingBuf, DataExchMapping, NewDepth + 1);                InsertSuggestedFields(TempDataExchFieldMappingBuf, DataExchMapping, TempSuggestedField, NewDepth + 1);            until DataExchMapping.Next() = 0;        ChildDataExchLineDef.SetRange("Data Exch. Def Code", DataExchLineDef."Data Exch. Def Code");        ChildDataExchLineDef.SetRange("Parent Code", DataExchLineDef.Code);        if ChildDataExchLineDef.FindSet() then            repeat                InsertFromDataExchDefinitionLine(TempDataExchFieldMappingBuf, ChildDataExchLineDef, TempSuggestedField, NewDepth + 1);            until ChildDataExchLineDef.Next() = 0;    end;    procedure InsertFieldMappingDefinition(var TempDataExchFieldMappingBuf: Record "Data Exch. Field Mapping Buf." temporary; DataExchMapping: Record "Data Exch. Mapping"; Indentation: Integer)    var        DataExchFieldMapping: Record "Data Exch. Field Mapping";    begin        DataExchFieldMapping.SetRange("Data Exch. Def Code", DataExchMapping."Data Exch. Def Code");        DataExchFieldMapping.SetRange("Data Exch. Line Def Code", DataExchMapping."Data Exch. Line Def Code");        DataExchFieldMapping.SetRange("Table ID", DataExchMapping."Table ID");        if not DataExchFieldMapping.FindSet() then            exit;        repeat            InsertFieldMappingLineDefinition(TempDataExchFieldMappingBuf, DataExchMapping, DataExchFieldMapping, Indentation);        until DataExchFieldMapping.Next() = 0;    end;    procedure InsertSuggestedFields(var TempDataExchFieldMappingBuf: Record "Data Exch. Field Mapping Buf." temporary; DataExchMapping: Record "Data Exch. Mapping"; var TempSuggestedField: Record "Field" temporary; Indentation: Integer)    var        DataExchFieldMapping: Record "Data Exch. Field Mapping";    begin        TempSuggestedField.SetRange(TableNo, DataExchMapping."Table ID");        if not TempSuggestedField.FindSet() then            exit;        repeat            DataExchFieldMapping.SetRange("Data Exch. Def Code", DataExchMapping."Data Exch. Def Code");            DataExchFieldMapping.SetRange("Data Exch. Line Def Code", DataExchMapping."Data Exch. Line Def Code");            DataExchFieldMapping.SetRange("Table ID", DataExchMapping."Table ID");            DataExchFieldMapping.SetRange("Field ID", TempSuggestedField."No.");            if not DataExchFieldMapping.FindFirst() then begin                InitializeDataExchangeSetupLine(                  TempDataExchFieldMappingBuf, DataExchMapping, TempSuggestedField."No.", Indentation, TempSuggestedField."Field Caption");                TempDataExchFieldMappingBuf.Insert(true);            end;        until TempSuggestedField.Next() = 0;    end;    procedure InsertFieldMappingLineDefinition(var TempDataExchFieldMappingBuf: Record "Data Exch. Field Mapping Buf." temporary; DataExchMapping: Record "Data Exch. Mapping"; DataExchFieldMapping: Record "Data Exch. Field Mapping"; Indentation: Integer)    var        DataExchColumnDef: Record "Data Exch. Column Def";    begin        InitializeDataExchangeSetupLine(          TempDataExchFieldMappingBuf, DataExchMapping, DataExchFieldMapping."Field ID", Indentation, DataExchFieldMapping.GetFieldCaption());        TempDataExchFieldMappingBuf."Column No." := DataExchFieldMapping."Column No.";        TempDataExchFieldMappingBuf."Default Value" := DataExchFieldMapping."Default Value";        TempDataExchFieldMappingBuf."Transformation Rule" := DataExchFieldMapping."Transformation Rule";        DataExchColumnDef.Get(          DataExchFieldMapping."Data Exch. Def Code", DataExchFieldMapping."Data Exch. Line Def Code",          DataExchFieldMapping."Column No.");        TempDataExchFieldMappingBuf.Source := DataExchColumnDef.Path;        TempDataExchFieldMappingBuf.Insert(true);    end;    local procedure InsertDataExchLineDefMappingLine(var TempDataExchFieldMappingBuf: Record "Data Exch. Field Mapping Buf." temporary; DataExchMapping: Record "Data Exch. Mapping"; Indentation: Integer)    var        DataExchDef: Record "Data Exch. Def";        DataExchLineDef: Record "Data Exch. Line Def";    begin        DataExchDef.Get(DataExchMapping."Data Exch. Def Code");        DataExchLineDef.Get(DataExchMapping."Data Exch. Def Code", DataExchMapping."Data Exch. Line Def Code");        Clear(TempDataExchFieldMappingBuf);        TempDataExchFieldMappingBuf.Init();        TempDataExchFieldMappingBuf."Data Exchange Def Code" := DataExchMapping."Data Exch. Def Code";        TempDataExchFieldMappingBuf."Data Exchange Line Def Code" := DataExchMapping."Data Exch. Line Def Code";        TempDataExchFieldMappingBuf.Type := TempDataExchFieldMappingBuf.Type::Table;        TempDataExchFieldMappingBuf."Table ID" := DataExchMapping."Table ID";        TempDataExchFieldMappingBuf.Caption := DataExchLineDef.Name;        TempDataExchFieldMappingBuf.Depth := Indentation;        TempDataExchFieldMappingBuf.Source := DataExchLineDef."Data Line Tag";        TempDataExchFieldMappingBuf.Insert();    end;    local procedure InitializeDataExchangeSetupLine(var TempDataExchFieldMappingBuf: Record "Data Exch. Field Mapping Buf." temporary; DataExchMapping: Record "Data Exch. Mapping"; FieldID: Integer; Indentation: Integer; NewCaption: Text)    var        DataExchDef: Record "Data Exch. Def";    begin        DataExchDef.Get(DataExchMapping."Data Exch. Def Code");        Clear(TempDataExchFieldMappingBuf);        TempDataExchFieldMappingBuf.Init();        TempDataExchFieldMappingBuf."Data Exchange Def Code" := DataExchMapping."Data Exch. Def Code";        TempDataExchFieldMappingBuf."Data Exchange Line Def Code" := DataExchMapping."Data Exch. Line Def Code";        TempDataExchFieldMappingBuf.Type := TempDataExchFieldMappingBuf.Type::Field;        TempDataExchFieldMappingBuf."Table ID" := DataExchMapping."Table ID";        TempDataExchFieldMappingBuf."Field ID" := FieldID;        TempDataExchFieldMappingBuf.Caption := CopyStr(NewCaption, 1, MaxStrLen(TempDataExchFieldMappingBuf.Caption));        TempDataExchFieldMappingBuf.Depth := Indentation;    end;    procedure SourceAssistEdit(var XMLBuffer: Record "XML Buffer")    begin        if PAGE.RunModal(PAGE::"Select Source", XMLBuffer) = ACTION::LookupOK then            Validate(Source, XMLBuffer.Path);    end;    procedure CaptionAssistEdit()    var        "Field": Record "Field";        FieldSelection: Codeunit "Field Selection";    begin        Field.SetRange(TableNo, "Table ID");        if FieldSelection.Open(Field) then begin            Validate("Field ID", Field."No.");            Validate(Caption, Field."Field Caption");        end;    end;    local procedure GetLastColumnNo(): Integer    var        DataExchColumnDef: Record "Data Exch. Column Def";    begin        DataExchColumnDef.SetRange("Data Exch. Def Code", "Data Exchange Def Code");        DataExchColumnDef.SetRange("Data Exch. Line Def Code", "Data Exchange Line Def Code");        if DataExchColumnDef.FindLast() then            exit(DataExchColumnDef."Column No.");        exit(GetIncrement());    end;    local procedure GetIncrement(): Integer    begin        exit(10000);    end;    local procedure CreateDataExchColumnDef()    var        DataExchColumnDef: Record "Data Exch. Column Def";    begin        if "Data Exchange Def Code" <> '' then begin            "Column No." := GetLastColumnNo() + GetIncrement();            DataExchColumnDef.Init();            DataExchColumnDef."Data Exch. Def Code" := "Data Exchange Def Code";            DataExchColumnDef."Data Exch. Line Def Code" := "Data Exchange Line Def Code";            DataExchColumnDef."Column No." := "Column No.";            DataExchColumnDef.Path := Source;            DataExchColumnDef.Insert(true);        end;    end;    local procedure CreateFieldMapping()    var        DataExchFieldMapping: Record "Data Exch. Field Mapping";    begin        if "Data Exchange Def Code" <> '' then begin            DataExchFieldMapping.Init();            DataExchFieldMapping.Validate("Data Exch. Def Code", "Data Exchange Def Code");            DataExchFieldMapping.Validate("Data Exch. Line Def Code", "Data Exchange Line Def Code");            DataExchFieldMapping.Validate("Table ID", "Table ID");            DataExchFieldMapping.Validate("Column No.", "Column No.");            DataExchFieldMapping.Validate("Field ID", "Field ID");            DataExchFieldMapping.Validate("Default Value", "Default Value");            DataExchFieldMapping.Validate("Transformation Rule", "Transformation Rule");            DataExchFieldMapping.Insert(true);        end;    end;}