Table 6529 Record Buffer

Base Application, System.IO

src/Layers/W1/BaseApp/RecordBuffer.Table.al289 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 System.IO;using Microsoft.Inventory.Item;using Microsoft.Inventory.Tracking;using System.Reflection;table 6529 "Record Buffer"{    Caption = 'Record Buffer';    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(1; "Entry No."; Integer)        {            Caption = 'Entry No.';            DataClassification = SystemMetadata;        }        field(3; "Table No."; Integer)        {            Caption = 'Table No.';            DataClassification = SystemMetadata;        }        field(4; "Table Name"; Text[250])        {            Caption = 'Table Name';            DataClassification = SystemMetadata;            Editable = false;        }        field(5; "Record Identifier"; RecordID)        {            Caption = 'Record Identifier';            DataClassification = CustomerContent;            Editable = false;        }        field(6; "Search Record ID"; Code[100])        {            Caption = 'Search Record ID';            DataClassification = SystemMetadata;            Editable = false;        }        field(7; "Primary Key"; Text[250])        {            Caption = 'Primary Key';            DataClassification = SystemMetadata;            Editable = false;        }        field(8; "Primary Key Field 1 No."; Integer)        {            Caption = 'Primary Key Field 1 No.';            DataClassification = SystemMetadata;            TableRelation = Field."No." where(TableNo = field("Table No."));        }        field(9; "Primary Key Field 1 Name"; Text[80])        {            CalcFormula = lookup(Field."Field Caption" where(TableNo = field("Table No."),                                                              "No." = field("Primary Key Field 1 No.")));            Caption = 'Primary Key Field 1 Name';            FieldClass = FlowField;        }        field(10; "Primary Key Field 1 Value"; Text[50])        {            Caption = 'Primary Key Field 1 Value';            DataClassification = SystemMetadata;        }        field(11; "Primary Key Field 2 No."; Integer)        {            Caption = 'Primary Key Field 2 No.';            DataClassification = SystemMetadata;            TableRelation = Field."No." where(TableNo = field("Table No."));        }        field(12; "Primary Key Field 2 Name"; Text[80])        {            CalcFormula = lookup(Field."Field Caption" where(TableNo = field("Table No."),                                                              "No." = field("Primary Key Field 2 No.")));            Caption = 'Primary Key Field 2 Name';            FieldClass = FlowField;        }        field(13; "Primary Key Field 2 Value"; Text[50])        {            Caption = 'Primary Key Field 2 Value';            DataClassification = SystemMetadata;        }        field(14; "Primary Key Field 3 No."; Integer)        {            Caption = 'Primary Key Field 3 No.';            DataClassification = SystemMetadata;            TableRelation = Field."No." where(TableNo = field("Table No."));        }        field(15; "Primary Key Field 3 Name"; Text[80])        {            CalcFormula = lookup(Field."Field Caption" where(TableNo = field("Table No."),                                                              "No." = field("Primary Key Field 3 No.")));            Caption = 'Primary Key Field 3 Name';            FieldClass = FlowField;        }        field(16; "Primary Key Field 3 Value"; Text[50])        {            Caption = 'Primary Key Field 3 Value';            DataClassification = SystemMetadata;        }        field(17; Level; Integer)        {            Caption = 'Level';            DataClassification = SystemMetadata;        }        field(20; "Serial No."; Code[50])        {            Caption = 'Serial No.';            DataClassification = SystemMetadata;            trigger OnLookup()            begin                ItemTrackingMgt.LookupTrackingNoInfo("Item No.", "Variant Code", ItemTrackingType::"Serial No.", "Serial No.");            end;        }        field(21; "Lot No."; Code[50])        {            Caption = 'Lot No.';            DataClassification = SystemMetadata;            trigger OnLookup()            begin                ItemTrackingMgt.LookupTrackingNoInfo("Item No.", "Variant Code", ItemTrackingType::"Lot No.", "Lot No.");            end;        }        field(22; "Item No."; Code[20])        {            Caption = 'Item No.';            DataClassification = SystemMetadata;            TableRelation = Item;        }        field(23; "Variant Code"; Code[10])        {            Caption = 'Variant Code';            DataClassification = SystemMetadata;            TableRelation = "Item Variant".Code where("Item No." = field("Item No."));        }        field(6515; "Package No."; Code[50])        {            Caption = 'Package No.';            DataClassification = SystemMetadata;            trigger OnLookup()            begin                ItemTrackingMgt.LookupTrackingNoInfo("Item No.", "Variant Code", "Item Tracking Type"::"Package No.", "Package No.");            end;        }    }    keys    {        key(Key1; "Entry No.")        {            Clustered = true;        }        key(Key2; "Table No.", "Search Record ID")        {        }        key(Key3; "Search Record ID")        {        }    }    fieldgroups    {    }    var        ItemTrackingMgt: Codeunit "Item Tracking Management";        ItemTrackingType: Enum "Item Tracking Type";    procedure CopyTrackingFromItemTrackingSetup(ItemTrackingSetup: Record "Item Tracking Setup")    begin        "Serial No." := ItemTrackingSetup."Serial No.";        "Lot No." := ItemTrackingSetup."Lot No.";        OnAfterCopyTrackingFromItemTrackingSetup(Rec, ItemTrackingSetup);    end;    procedure SetTrackingFilterFromItemTrackingSetup(ItemTrackingSetup: Record "Item Tracking Setup")    begin        SetRange("Serial No.", ItemTrackingSetup."Serial No.");        SetRange("Lot No.", ItemTrackingSetup."Lot No.");        OnAfterSetTrackingFilterFromItemTrackingSetup(Rec, ItemTrackingSetup);    end;    procedure InsertRecordBuffer(RecRef: RecordRef)    var        KeyFldRef: FieldRef;        KeyRef1: KeyRef;        i: Integer;    begin        SetRange("Record Identifier", RecRef.RecordId);        if not Find('-') then begin            Init();            "Entry No." := "Entry No." + 10;            "Table No." := RecRef.Number;            "Record Identifier" := RecRef.RecordId;            "Search Record ID" :=                CopyStr(Format("Record Identifier"), 1, MaxStrLen("Search Record ID"));            KeyRef1 := RecRef.KeyIndex(1);            for i := 1 to KeyRef1.FieldCount do begin                KeyFldRef := KeyRef1.FieldIndex(i);                if i = 1 then                    "Primary Key" :=                        CopyStr(                            StrSubstNo('%1=%2', KeyFldRef.Caption, FormatValue(KeyFldRef, RecRef.Number)),                            1, MaxStrLen("Primary Key"))                else                    if MaxStrLen("Primary Key") >                       StrLen("Primary Key") +                       StrLen(StrSubstNo(', %1=%2', KeyFldRef.Caption, FormatValue(KeyFldRef, RecRef.Number)))                    then                        "Primary Key" :=                            CopyStr(                                "Primary Key" +                                StrSubstNo(', %1=%2', KeyFldRef.Caption, FormatValue(KeyFldRef, RecRef.Number)),                                1, MaxStrLen("Primary Key"));                case i of                    1:                        begin                            "Primary Key Field 1 No." := KeyFldRef.Number;                            "Primary Key Field 1 Value" :=                                CopyStr(                                    FormatValue(KeyFldRef, RecRef.Number), 1, MaxStrLen("Primary Key Field 1 Value"));                        end;                    2:                        begin                            "Primary Key Field 2 No." := KeyFldRef.Number;                            "Primary Key Field 2 Value" :=                                CopyStr(                                    FormatValue(KeyFldRef, RecRef.Number), 1, MaxStrLen("Primary Key Field 2 Value"));                        end;                    3:                        begin                            "Primary Key Field 3 No." := KeyFldRef.Number;                            "Primary Key Field 3 Value" :=                                CopyStr(                                    FormatValue(KeyFldRef, RecRef.Number), 1, MaxStrLen("Primary Key Field 3 Value"));                        end;                end;            end;            Insert();        end;    end;    procedure FormatValue(var FldRef: FieldRef; TableNumber: Integer): Text    var        "Field": Record System.Reflection.Field;        OptionNo: Integer;        OptionStr: Text;        i: Integer;    begin        Field.Get(TableNumber, FldRef.Number);        if Field.Type = Field.Type::Option then begin            OptionNo := FldRef.Value();            OptionStr := Format(FldRef.OptionCaption);            for i := 1 to OptionNo do                OptionStr := CopyStr(OptionStr, StrPos(OptionStr, ',') + 1);            if StrPos(OptionStr, ',') > 0 then                if StrPos(OptionStr, ',') = 1 then                    OptionStr := ''                else                    OptionStr := CopyStr(OptionStr, 1, StrPos(OptionStr, ',') - 1);            exit(OptionStr);        end;        exit(Format(FldRef.Value));    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCopyTrackingFromItemTrackingSetup(var RecordBuffer: Record "Record Buffer"; ItemTrackingSetup: Record "Item Tracking Setup")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetTrackingFilterFromItemTrackingSetup(var RecordBuffer: Record "Record Buffer"; ItemTrackingSetup: Record "Item Tracking Setup")    begin    end;}