Table 5520 Unplanned Demand
src/Layers/W1/BaseApp/Inventory/Planning/UnplannedDemand.Table.al189 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.Projects.Project.Job;using Microsoft.Sales.Document;using Microsoft.Warehouse.Structure;table 5520 "Unplanned Demand"{ Caption = 'Unplanned Demand'; Permissions = TableData "Sales Header" = r, TableData Job = r; DataClassification = CustomerContent; fields { field(1; "Demand Type"; Enum "Unplanned Demand Type") { Caption = 'Demand Type'; Editable = false; } field(2; "Demand SubType"; Option) { Caption = 'Demand SubType'; Editable = false; OptionCaption = '0,1,2,3,4,5,6,7,8,9'; OptionMembers = "0","1","2","3","4","5","6","7","8","9"; } field(4; "Demand Order No."; Code[20]) { Caption = 'Demand Order No.'; Editable = false; trigger OnValidate() begin "Sell-to Customer No." := ''; Description := ''; if "Demand Order No." = '' then exit; OnValidateDemandOrderNoOnGetSourceFields(Rec); "Demand Line No." := 0; "Demand Ref. No." := 0; end; } field(5; "Demand Line No."; Integer) { Caption = 'Demand Line No.'; } field(6; "Demand Ref. No."; Integer) { Caption = 'Demand Ref. No.'; } field(7; "Sell-to Customer No."; Code[20]) { Caption = 'Sell-to Customer No.'; Editable = false; } field(8; Description; Text[100]) { Caption = 'Description'; Editable = false; } field(9; "Demand Date"; Date) { Caption = 'Demand Date'; Editable = false; } field(10; Status; Option) { Caption = 'Status'; Editable = false; OptionCaption = '0,1,2,3,4,5,6,7,8,9,10'; OptionMembers = "0","1","2","3","4","5","6","7","8","9","10"; } field(13; "Item No."; Code[20]) { Caption = 'Item No.'; } field(14; "Variant Code"; Code[10]) { Caption = 'Variant Code'; } field(15; "Location Code"; Code[10]) { Caption = 'Location Code'; } field(16; "Quantity (Base)"; Decimal) { AutoFormatType = 0; Caption = 'Quantity (Base)'; } field(17; Level; Integer) { Caption = 'Level'; } field(18; "Bin Code"; Code[20]) { Caption = 'Bin Code'; TableRelation = Bin.Code where("Location Code" = field("Location Code"), "Item Filter" = field("Item No."), "Variant Filter" = field("Variant Code")); } field(19; "Qty. per Unit of Measure"; Decimal) { AutoFormatType = 0; Caption = 'Qty. per Unit of Measure'; DecimalPlaces = 0 : 5; Editable = false; InitValue = 1; } field(20; "Unit of Measure Code"; Code[10]) { Caption = 'Unit of Measure Code'; TableRelation = "Item Unit of Measure".Code where("Item No." = field("Item No.")); } field(21; Reserve; Boolean) { Caption = 'Reserve'; } field(22; "Needed Qty. (Base)"; Decimal) { AutoFormatType = 0; Caption = 'Needed Qty. (Base)'; } field(23; "Special Order"; Boolean) { Caption = 'Special Order'; } field(24; "Purchasing Code"; Code[10]) { Caption = 'Purchasing Code'; } field(25; "Drop Shipment"; Boolean) { Caption = 'Drop Shipment'; } } keys { key(Key1; "Demand Type", "Demand SubType", "Demand Order No.", "Demand Line No.", "Demand Ref. No.") { Clustered = true; } key(Key2; "Demand Date", Level) { } key(Key3; "Item No.", "Variant Code", "Location Code", "Demand Date") { IncludedFields = "Quantity (Base)", "Needed Qty. (Base)"; } } fieldgroups { } procedure InitRecord(DemandLineNo: Integer; DemandRefNo: Integer; ItemNo: Code[20]; ItemDescription: Text[100]; VariantCode: Code[10]; LocationCode: Code[10]; BinCode: Code[20]; UoMCode: Code[10]; QtyPerUoM: Decimal; QtyBase: Decimal; DemandDate: Date) begin "Demand Line No." := DemandLineNo; "Demand Ref. No." := DemandRefNo; "Item No." := ItemNo; Description := ItemDescription; "Variant Code" := VariantCode; "Location Code" := LocationCode; "Bin Code" := BinCode; "Unit of Measure Code" := UoMCode; "Qty. per Unit of Measure" := QtyPerUoM; "Quantity (Base)" := QtyBase; "Demand Date" := DemandDate; if "Demand Date" = 0D then "Demand Date" := WorkDate(); Level := 1; end; [IntegrationEvent(false, false)] local procedure OnValidateDemandOrderNoOnGetSourceFields(var UnplannedDemand: Record "Unplanned Demand") begin end;}