Table 307 Inventory Buffer

Base Application, Microsoft.Inventory.Counting.Journal

src/Layers/W1/BaseApp/Inventory/Counting/Journal/InventoryBuffer.Table.al90 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.Counting.Journal;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Warehouse.Structure;table 307 "Inventory Buffer"{    Caption = 'Inventory Buffer';    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(1; "Item No."; Code[20])        {            Caption = 'Item No.';            DataClassification = SystemMetadata;            TableRelation = Item;        }        field(4; "Location Code"; Code[10])        {            Caption = 'Location Code';            DataClassification = SystemMetadata;            TableRelation = Location;        }        field(5; Quantity; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity';            DataClassification = SystemMetadata;            DecimalPlaces = 0 : 5;        }        field(6; "Dimension Entry No."; Integer)        {            Caption = 'Dimension Entry No.';            DataClassification = SystemMetadata;        }        field(5400; "Variant Code"; Code[10])        {            Caption = 'Variant Code';            DataClassification = SystemMetadata;            TableRelation = "Item Variant".Code where("Item No." = field("Item No."));        }        field(5401; "Bin Code"; Code[20])        {            Caption = 'Bin Code';            DataClassification = SystemMetadata;            TableRelation = Bin.Code where("Location Code" = field("Location Code"));        }        field(6500; "Serial No."; Code[50])        {            Caption = 'Serial No.';            DataClassification = SystemMetadata;        }        field(6501; "Lot No."; Code[50])        {            Caption = 'Lot No.';            DataClassification = SystemMetadata;        }        field(6515; "Package No."; Code[50])        {            Caption = 'Package No.';            CaptionClass = '6,1';            DataClassification = SystemMetadata;        }    }    keys    {        key(Key1; "Item No.", "Variant Code", "Dimension Entry No.", "Location Code", "Bin Code", "Lot No.", "Serial No.")        {            Clustered = true;        }        key(Key2; "Location Code", "Variant Code", Quantity)        {            SumIndexFields = Quantity;        }    }    fieldgroups    {    }}