Table 307 Inventory Buffer
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 { }}