Table 343 Item Application Entry History
src/Layers/W1/BaseApp/Inventory/Ledger/ItemApplicationEntryHistory.Table.al145 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.NoSeries;using Microsoft.Inventory.Setup;using Microsoft.Utilities;using System.Security.AccessControl;table 343 "Item Application Entry History"{ Caption = 'Item Application Entry History'; DrillDownPageID = "Item Application Entry History"; LookupPageID = "Item Application Entry History"; Permissions = TableData "Item Application Entry History" = ri; DataClassification = CustomerContent; fields { field(1; "Entry No."; Integer) { Caption = 'Entry No.'; ToolTip = 'Specifies the number of the entry, as assigned from the specified number series when the entry was created.'; } field(2; "Item Ledger Entry No."; Integer) { Caption = 'Item Ledger Entry No.'; ToolTip = 'Specifies the entry number of the item ledger entry, for which the item application entry was recorded.'; TableRelation = "Item Ledger Entry"; } field(3; "Inbound Item Entry No."; Integer) { Caption = 'Inbound Item Entry No.'; ToolTip = 'Specifies the number of the item ledger entry corresponding to the inventory increase or positive quantity in inventory for this entry.'; TableRelation = "Item Ledger Entry"; } field(4; "Outbound Item Entry No."; Integer) { Caption = 'Outbound Item Entry No.'; ToolTip = 'Specifies the number of the item ledger entry corresponding to the inventory decrease for this entry.'; TableRelation = "Item Ledger Entry"; } field(9; "Primary Entry No."; Integer) { Caption = 'Primary Entry No.'; ToolTip = 'Specifies a unique identifying number for each item application entry history record.'; } field(11; Quantity; Decimal) { AutoFormatType = 0; Caption = 'Quantity'; ToolTip = 'Specifies the item quantity being applied from the inventory decrease in the Outbound Item Entry No. field, to the inventory increase in the Inbound Item Entry No. field.'; DecimalPlaces = 0 : 5; } field(21; "Posting Date"; Date) { Caption = 'Posting Date'; ToolTip = 'Specifies a date that corresponds to the posting date of the item ledger entry, for which this item application entry was created.'; } field(23; "Transferred-from Entry No."; Integer) { Caption = 'Transferred-from Entry No.'; ToolTip = 'Specifies the item ledger entry number of the inventory increase, if an item application entry originates from an item location transfer.'; TableRelation = "Item Ledger Entry"; } field(25; "Creation Date"; DateTime) { Caption = 'Creation Date'; } field(26; "Created By User"; Code[50]) { Caption = 'Created By User'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; } field(27; "Last Modified Date"; DateTime) { Caption = 'Last Modified Date'; } field(28; "Last Modified By User"; Code[50]) { Caption = 'Last Modified By User'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; } field(29; "Deleted Date"; DateTime) { Caption = 'Deleted Date'; } field(30; "Deleted By User"; Code[50]) { Caption = 'Deleted By User'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; } field(5800; "Cost Application"; Boolean) { Caption = 'Cost Application'; ToolTip = 'Specifies which application entries should have the cost forwarded, or simply included, in an average cost calculation.'; } field(5804; "Output Completely Invd. Date"; Date) { Caption = 'Output Completely Invd. Date'; ToolTip = 'Specifies the outbound item entries have been completely invoiced.'; } } keys { key(Key1; "Primary Entry No.") { Clustered = true; } key(Key2; "Entry No.") { } } fieldgroups { } [InherentPermissions(PermissionObjectType::TableData, Database::"Item Application Entry History", 'r')] procedure GetNextEntryNo(): Integer var InventorySetup: Record "Inventory Setup"; SequenceNoMgt: Codeunit "Sequence No. Mgt."; begin if InventorySetup.UseLegacyPosting() then exit(GetLastEntryNo() + 1); exit(SequenceNoMgt.GetNextSeqNo(DATABASE::"Item Application Entry History")); end; [InherentPermissions(PermissionObjectType::TableData, Database::"Item Application Entry History", 'r')] procedure GetLastEntryNo(): Integer; var FindRecordManagement: Codeunit "Find Record Management"; begin exit(FindRecordManagement.GetLastEntryIntFieldValue(Rec, FieldNo("Primary Entry No."))) end;}