Table 5803 Item Journal Buffer, source in 29
Source29
src/Layers/W1/BaseApp/Inventory/Journal/ItemJournalBuffer.Table.al77 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.Journal;
using Microsoft.Inventory.Item;
using Microsoft.Inventory.Location;
table 5803 "Item Journal Buffer"
{
Caption = 'Item Journal Buffer';
ReplicateData = false;
DataClassification = CustomerContent;
fields
{
field(2; "Line No."; Integer)
{
Caption = 'Line No.';
DataClassification = SystemMetadata;
}
field(3; "Item No."; Code[20])
{
Caption = 'Item No.';
DataClassification = SystemMetadata;
TableRelation = Item;
}
field(8; "Location Code"; Code[10])
{
Caption = 'Location Code';
DataClassification = SystemMetadata;
TableRelation = Location;
}
field(12; Quantity; Decimal)
{
AutoFormatType = 0;
Caption = 'Quantity';
DataClassification = SystemMetadata;
DecimalPlaces = 0 : 5;
}
field(5402; "Variant Code"; Code[10])
{
Caption = 'Variant Code';
DataClassification = SystemMetadata;
TableRelation = "Item Variant".Code where("Item No." = field("Item No."));
}
field(5802; "Inventory Value (Calculated)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Inventory Value (Calculated)';
DataClassification = SystemMetadata;
Editable = false;
}
}
keys
{
key(Key1; "Line No.")
{
Clustered = true;
}
key(Key2; "Item No.", "Location Code", "Variant Code")
{
}
key(Key3; "Item No.", "Variant Code")
{
}
}
fieldgroups
{
}
}