Table 99000855 Untracked Planning Element
src/Layers/W1/BaseApp/Inventory/Planning/UntrackedPlanningElement.Table.al118 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.Planning;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Inventory.Requisition;table 99000855 "Untracked Planning Element"{ Caption = 'Untracked Planning Element'; DataClassification = CustomerContent; fields { field(1; "Worksheet Template Name"; Code[10]) { Caption = 'Worksheet Template Name'; Editable = false; TableRelation = "Req. Wksh. Template"; } field(2; "Worksheet Batch Name"; Code[10]) { Caption = 'Worksheet Batch Name'; TableRelation = "Requisition Wksh. Name".Name where("Worksheet Template Name" = field("Worksheet Template Name")); } field(3; "Worksheet Line No."; Integer) { Caption = 'Worksheet Line No.'; TableRelation = "Requisition Line"."Line No." where("Worksheet Template Name" = field("Worksheet Template Name"), "Journal Batch Name" = field("Worksheet Batch Name")); } field(4; "Track Line No."; Integer) { Caption = 'Track Line No.'; } field(11; "Item No."; Code[20]) { Caption = 'Item No.'; ToolTip = 'Specifies the number of the item in the requisition line for which untracked planning surplus exists.'; TableRelation = Item; } field(12; "Variant Code"; Code[10]) { Caption = 'Variant Code'; ToolTip = 'Specifies the variant of the item on the line.'; TableRelation = "Item Variant".Code where("Item No." = field("Item No."), Code = field("Variant Code")); } field(13; "Location Code"; Code[10]) { Caption = 'Location Code'; ToolTip = 'Specifies the location code in the requisition line associated with the untracked planning surplus.'; TableRelation = Location; } field(21; "Source Type"; Integer) { Caption = 'Source Type'; } field(23; "Source ID"; Code[20]) { Caption = 'Source ID'; ToolTip = 'Specifies the identification code for the source of the untracked planning quantity.'; } field(70; "Parameter Value"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Parameter Value'; ToolTip = 'Specifies the value of this planning parameter.'; } field(71; "Untracked Quantity"; Decimal) { AutoFormatType = 0; Caption = 'Untracked Quantity'; ToolTip = 'Specifies how much this planning parameter contributed to the total surplus quantity.'; } field(72; "Track Quantity From"; Decimal) { AutoFormatType = 0; Caption = 'Track Quantity From'; ToolTip = 'Specifies how much the total surplus quantity is, including the quantity from this entry.'; } field(73; "Track Quantity To"; Decimal) { AutoFormatType = 0; Caption = 'Track Quantity To'; ToolTip = 'Specifies what the surplus quantity would be without the quantity from this entry.'; } field(74; Source; Text[200]) { Caption = 'Source'; ToolTip = 'Specifies what the source of this untracked surplus quantity is.'; } field(75; "Warning Level"; Option) { Caption = 'Warning Level'; OptionCaption = ',Emergency,Exception,Attention'; OptionMembers = ,Emergency,Exception,Attention; } } keys { key(Key1; "Worksheet Template Name", "Worksheet Batch Name", "Worksheet Line No.", "Track Line No.") { Clustered = true; } } fieldgroups { }}