Table 46 Item Register

Base Application, Microsoft.Inventory.Ledger

src/Layers/W1/BaseApp/Inventory/Ledger/ItemRegister.Table.al162 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.Inventory.Ledger;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.NoSeries;using Microsoft.Inventory.Counting.Journal;using Microsoft.Inventory.Journal;using Microsoft.Utilities;using System.Security.AccessControl;table 46 "Item Register"{    Caption = 'Item Register';    LookupPageID = "Item Registers";    DataClassification = CustomerContent;    Permissions = TableData "Item Register" = ri;    fields    {        field(1; "No."; Integer)        {            Caption = 'No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';        }        field(2; "From Entry No."; Integer)        {            Caption = 'From Entry No.';            ToolTip = 'Specifies the first item entry number in the register.';            TableRelation = "Item Ledger Entry";        }        field(3; "To Entry No."; Integer)        {            Caption = 'To Entry No.';            ToolTip = 'Specifies the last item entry number in the register.';            TableRelation = "Item Ledger Entry";        }        field(4; "Creation Date"; Date)        {            Caption = 'Creation Date';            ToolTip = 'Specifies the date when the entries in the register were posted.';        }        field(5; "Source Code"; Code[10])        {            Caption = 'Source Code';            ToolTip = 'Specifies the source code that specifies where the entry was created.';            TableRelation = "Source Code";        }        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";        }        field(7; "Journal Batch Name"; Code[10])        {            Caption = 'Journal Batch Name';            ToolTip = 'Specifies the name of the journal batch, a personalized journal layout, that the entries were posted from.';            TableRelation = "Item Journal Batch".Name;        }        field(9; "Creation Time"; Time)        {            Caption = 'Creation Time';            ToolTip = 'Specifies the time when the entries in the register were posted.';        }        field(10; "From Phys. Inventory Entry No."; Integer)        {            Caption = 'From Phys. Inventory Entry No.';            ToolTip = 'Specifies the first physical inventory ledger entry number in the register.';            TableRelation = "Phys. Inventory Ledger Entry";        }        field(11; "To Phys. Inventory Entry No."; Integer)        {            Caption = 'To Phys. Inventory Entry No.';            ToolTip = 'Specifies the last physical inventory ledger entry number in the register.';            TableRelation = "Phys. Inventory Ledger Entry";        }        field(5800; "From Value Entry No."; Integer)        {            Caption = 'From Value Entry No.';            ToolTip = 'Specifies the first value entry number in the register.';            TableRelation = "Value Entry";        }        field(5801; "To Value Entry No."; Integer)        {            Caption = 'To Value Entry No.';            ToolTip = 'Specifies the last value entry number in this register.';            TableRelation = "Value Entry";        }        field(5831; "From Capacity Entry No."; Integer)        {            Caption = 'From Capacity Entry No.';            ToolTip = 'Specifies the first capacity entry number in the register.';            TableRelation = Microsoft.Manufacturing.Capacity."Capacity Ledger Entry";        }        field(5832; "To Capacity Entry No."; Integer)        {            Caption = 'To Capacity Entry No.';            ToolTip = 'Specifies the last capacity ledger entry number in this register.';            TableRelation = Microsoft.Manufacturing.Capacity."Capacity Ledger Entry";        }        field(5895; "Cost Adjustment Run Guid"; Guid)        {            Caption = 'Cost Adjustment Run Guid';            DataClassification = CustomerContent;        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }        key(Key2; "Creation Date")        {        }        key(Key3; "Source Code", "Journal Batch Name", "Creation Date")        {        }        key(Key4; "Cost Adjustment Run Guid")        {        }    }    fieldgroups    {        fieldgroup(DropDown; "No.", "From Entry No.", "To Entry No.", "Creation Date", "Source Code")        {        }    }    procedure GetNextEntryNo(UseLegacyPosting: Boolean): Integer    begin        if not UseLegacyPosting then            exit(GetNextEntryNo());        Rec.LockTable();        exit(GetLastEntryNo() + 1);    end;    [InherentPermissions(PermissionObjectType::TableData, Database::"Item Register", 'r')]    procedure GetNextEntryNo(): Integer    var        SequenceNoMgt: Codeunit "Sequence No. Mgt.";    begin        exit(SequenceNoMgt.GetNextSeqNo(DATABASE::"Item Register"));    end;    [InherentPermissions(PermissionObjectType::TableData, Database::"Item Register", 'r')]    procedure GetLastEntryNo(): Integer;    var        FindRecordManagement: Codeunit "Find Record Management";    begin        exit(FindRecordManagement.GetLastEntryIntFieldValue(Rec, FieldNo("No.")))    end;}