Table 307 Inventory Buffer, source in 29
Source29
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
{
}
}