Table 7313 Warehouse Register
- App
- Base Application
- Namespace
- Microsoft.Warehouse.Ledger
- Versions
- 17-28
Fields, 8Keys, 2Procedures, 6Obsolete, 1
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/Warehouse/Ledger/WarehouseRegister.Table.al137 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.Warehouse.Ledger;
using Microsoft.Foundation.AuditCodes;
using Microsoft.Foundation.NoSeries;
using Microsoft.Inventory.Journal;
using Microsoft.Utilities;
using System.Security.AccessControl;
table 7313 "Warehouse Register"
{
Caption = 'Warehouse Register';
LookupPageID = "Warehouse Registers";
InherentPermissions = r;
Permissions = TableData "Warehouse Register" = i;
DataClassification = CustomerContent;
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 = 'First Entry No.';
ToolTip = 'Specifies the first item entry number in the register.';
TableRelation = "Warehouse Entry";
}
field(3; "To Entry No."; Integer)
{
Caption = 'Last Entry No.';
ToolTip = 'Specifies the last warehouse entry number in the register.';
TableRelation = "Warehouse Entry";
}
field(4; "Creation Date"; Date)
{
Caption = 'Creation Date';
ToolTip = 'Specifies the date on which 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 on which the entries in the register were posted.';
}
}
keys
{
key(Key1; "No.")
{
Clustered = true;
}
key(Key2; "Source Code")
{
}
}
fieldgroups
{
}
#if not CLEAN27
[Obsolete('This function is deprecated. Concurrent warehouse posting is always on.', '27.0')]
procedure InsertRecord(UseLegacyPosting: Boolean)
begin
InsertRecord();
end;
#endif
[InherentPermissions(PermissionObjectType::TableData, Database::"Warehouse Register", 'r')]
procedure InsertRecord()
var
SequenceNoMgt: Codeunit "Sequence No. Mgt.";
begin
if not Rec.Insert() then begin
SequenceNoMgt.RebaseSeqNo(Database::"Warehouse Register");
"No." := SequenceNoMgt.GetNextSeqNo(Database::"Warehouse Register");
Rec.Insert();
end;
end;
procedure GetNextEntryNo(UseLegacyPosting: Boolean): Integer
begin
if not UseLegacyPosting then
exit(GetNextEntryNo());
Rec.LockTable();
exit(GetLastEntryNo() + 1);
end;
[InherentPermissions(PermissionObjectType::TableData, Database::"Warehouse Register", 'r')]
procedure GetNextEntryNo(): Integer
var
SequenceNoMgt: Codeunit "Sequence No. Mgt.";
begin
exit(SequenceNoMgt.GetNextSeqNo(Database::"Warehouse Register"));
end;
[InherentPermissions(PermissionObjectType::TableData, Database::"Warehouse Register", 'r')]
procedure GetLastEntryNo(): Integer;
var
FindRecordManagement: Codeunit "Find Record Management";
begin
exit(FindRecordManagement.GetLastEntryIntFieldValue(Rec, FieldNo("No.")))
end;
procedure Lock()
begin
LockTable();
if FindLast() then;
end;
}