Table 5410 Prod. Order Capacity Need
src/Layers/W1/BaseApp/Manufacturing/Document/ProdOrderCapacityNeed.Table.al270 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.Manufacturing.Document;using Microsoft.Inventory.Requisition;using Microsoft.Manufacturing.Capacity;using Microsoft.Manufacturing.MachineCenter;using Microsoft.Manufacturing.Routing;using Microsoft.Manufacturing.WorkCenter;table 5410 "Prod. Order Capacity Need"{ Caption = 'Prod. Order Capacity Need'; DrillDownPageID = "Prod. Order Capacity Need"; LookupPageID = "Prod. Order Capacity Need"; DataClassification = CustomerContent; fields { field(1; Status; Enum "Production Order Status") { Caption = 'Status'; ToolTip = 'Specifies the status of the production order.'; } field(2; "Prod. Order No."; Code[20]) { Caption = 'Prod. Order No.'; ToolTip = 'Specifies the number of the related production order.'; TableRelation = "Production Order"."No." where(Status = field(Status)); ValidateTableRelation = false; } field(3; "Routing No."; Code[20]) { Caption = 'Routing No.'; ToolTip = 'Specifies the routing number.'; TableRelation = "Routing Header"; } field(4; "Line No."; Integer) { Caption = 'Line No.'; } field(5; "Operation No."; Code[10]) { Caption = 'Operation No.'; ToolTip = 'Specifies the operation number.'; } field(6; Type; Enum "Capacity Type") { Caption = 'Type'; ToolTip = 'Specifies the type of capacity need. Here you can see whether this capacity need is for a machine center or a work center.'; } field(7; "No."; Code[20]) { Caption = 'No.'; ToolTip = 'Specifies the Number of the machine center or work center depending on the entry in the Type field.'; TableRelation = if (Type = const("Work Center")) "Work Center" else if (Type = const("Machine Center")) "Machine Center"; } field(8; "Work Center No."; Code[20]) { Caption = 'Work Center No.'; ToolTip = 'Specifies the work center number of the capacity need. If this capacity need occurs at a machine center that is assigned to a work center, that work center number will be shown here. If the capacity need is for a work center, the No. field and this field will show the same number.'; Editable = false; TableRelation = "Work Center"; } field(9; "Work Center Group Code"; Code[10]) { Caption = 'Work Center Group Code'; Editable = false; TableRelation = "Work Center Group"; } field(10; "Routing Reference No."; Integer) { Caption = 'Routing Reference No.'; } field(11; Date; Date) { Caption = 'Date'; } field(12; "Starting Time"; Time) { Caption = 'Starting Time'; } field(13; "Ending Time"; Time) { Caption = 'Ending Time'; } field(14; "Allocated Time"; Decimal) { AutoFormatType = 0; Caption = 'Allocated Time'; ToolTip = 'Specifies the capacity need of planned operations.'; DecimalPlaces = 0 : 5; MinValue = 0; } field(16; "Send-Ahead Type"; Option) { Caption = 'Send-Ahead Type'; ToolTip = 'Specifies if the send-ahead quantity is of type Input, Output, or Both.'; OptionCaption = ' ,Input,Output,Both'; OptionMembers = " ",Input,Output,Both; }#pragma warning disable AS0070 // Time type changed from Setup to "Setup Time" due to implementation of enum field(17; "Time Type"; Enum "Routing Time Type") { Caption = 'Time Type'; ToolTip = 'Specifies the time type of the capacity need. Two options are available: Setup Time and Run Time.'; }#pragma warning restore AS0070 field(18; "Needed Time"; Decimal) { AutoFormatType = 0; Caption = 'Needed Time'; ToolTip = 'Specifies how much time is required to meet the needs resulting from the specified capacity.'; DecimalPlaces = 0 : 5; } field(19; "Needed Time (ms)"; Decimal) { AutoFormatType = 0; Caption = 'Needed Time (ms)'; Editable = false; } field(21; "Lot Size"; Decimal) { AutoFormatType = 0; Caption = 'Lot Size'; DecimalPlaces = 1 : 1; } field(22; "Concurrent Capacities"; Decimal) { AutoFormatType = 0; Caption = 'Concurrent Capacities'; ToolTip = 'Specifies the concurrent capacity of the operation.'; DecimalPlaces = 0 : 5; } field(23; Efficiency; Decimal) { AutoFormatType = 0; Caption = 'Efficiency'; ToolTip = 'Specifies the efficiency of the production order capacity need.'; DecimalPlaces = 0 : 5; } field(26; "Starting Date-Time"; DateTime) { Caption = 'Starting Date-Time'; ToolTip = 'Specifies the date and the starting time, which are combined in a format called "starting date-time".'; Editable = false; } field(27; "Ending Date-Time"; DateTime) { Caption = 'Ending Date-Time'; ToolTip = 'Specifies the date and the ending time, which are combined in a format called "ending date-time".'; Editable = false; } field(31; "Worksheet Template Name"; Code[10]) { Caption = 'Worksheet Template Name'; TableRelation = "Req. Wksh. Template"; } field(32; "Worksheet Batch Name"; Code[10]) { Caption = 'Worksheet Batch Name'; TableRelation = "Requisition Wksh. Name".Name where("Worksheet Template Name" = field("Worksheet Template Name")); } field(33; "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(41; Active; Boolean) { Caption = 'Active'; Editable = false; } field(42; "Requested Only"; Boolean) { Caption = 'Requested Only'; } } keys { key(Key1; Status, "Prod. Order No.", "Requested Only", "Routing No.", "Routing Reference No.", "Operation No.", "Line No.") { Clustered = true; } key(Key2; "Prod. Order No.", "Routing No.", "Routing Reference No.", "Operation No.", Status, "Line No.", "Requested Only") { } key(Key3; Status, "Prod. Order No.", Active, "Requested Only", "Routing No.") { } key(Key4; "Work Center No.", Date, Active, "Starting Date-Time") { IncludedFields = "Allocated Time", "Needed Time"; } key(Key5; "Work Center Group Code", Date, "Starting Date-Time") { IncludedFields = "Allocated Time"; } key(Key6; Type, "No.", Date, Active) { IncludedFields = "Allocated Time"; } key(Key7; Type, "No.", "Starting Date-Time", "Ending Date-Time", Active) { } key(Key8; Type, "No.", "Ending Date-Time", "Starting Date-Time", Active) { } key(Key9; "Worksheet Template Name", "Worksheet Batch Name", "Worksheet Line No.", "Operation No.") { IncludedFields = "Allocated Time"; } key(Key10; Status, "Prod. Order No.", "Routing Reference No.", "Operation No.", Date, "Starting Time") { } key(Key11; "Worksheet Template Name", "Worksheet Batch Name", "Worksheet Line No.", "Operation No.", Date, "Starting Time") { MaintainSQLIndex = false; } key(Key12; "Worksheet Line No.", "Operation No.") { } key(Key13; Status, "Prod. Order No.", Type, "No.", "Work Center No.", Date, "Requested Only") { IncludedFields = "Allocated Time", "Needed Time"; } } fieldgroups { } procedure UpdateDatetime() begin if (Date <> 0D) and ("Starting Time" <> 0T) then "Starting Date-Time" := CreateDateTime(Date, "Starting Time") else "Starting Date-Time" := 0DT; if (Date <> 0D) and ("Ending Time" <> 0T) then "Ending Date-Time" := CreateDateTime(Date, "Ending Time") else "Ending Date-Time" := 0DT; end; [Scope('OnPrem')] procedure GetStartingEndingDateAndTime(var StartingTime: Time; var EndingTime: Time; var CurrDate: Date) begin StartingTime := DT2Time("Starting Date-Time"); EndingTime := DT2Time("Ending Date-Time"); CurrDate := DT2Date("Ending Date-Time"); end; procedure SetCapacityFilters(CapType: Enum "Capacity Type"; CapNo: Code[20]) begin SetCurrentKey(Type, "No.", "Ending Date-Time", "Starting Date-Time"); SetRange(Type, CapType); SetRange("No.", CapNo); SetFilter(Status, '<> %1', Status::Simulated); SetFilter("Allocated Time", '> 0'); end;}