Table extension 99000801 Mfg. Capacity Ledger Entry
src/Layers/W1/BaseApp/Manufacturing/Capacity/MfgCapacityLedgerEntry.TableExt.al151 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.Capacity;using Microsoft.Manufacturing.Document;using Microsoft.Manufacturing.MachineCenter;using Microsoft.Manufacturing.Routing;using Microsoft.Manufacturing.Setup;using Microsoft.Manufacturing.WorkCenter;tableextension 99000801 "Mfg. Capacity Ledger Entry" extends "Capacity Ledger Entry"{ fields { modify("No.") { TableRelation = if (Type = const("Machine Center")) "Machine Center" else if (Type = const("Work Center")) "Work Center"; } field(8; "Operation No."; Code[10]) { Caption = 'Operation No.'; DataClassification = CustomerContent; } field(9; "Work Center No."; Code[20]) { Caption = 'Work Center No.'; DataClassification = CustomerContent; TableRelation = "Work Center"; } field(11; "Setup Time"; Decimal) { AutoFormatType = 0; Caption = 'Setup Time'; DataClassification = CustomerContent; DecimalPlaces = 0 : 5; } field(12; "Run Time"; Decimal) { AutoFormatType = 0; Caption = 'Run Time'; DataClassification = CustomerContent; DecimalPlaces = 0 : 5; } field(13; "Stop Time"; Decimal) { AutoFormatType = 0; Caption = 'Stop Time'; DataClassification = CustomerContent; DecimalPlaces = 0 : 5; } field(16; "Output Quantity"; Decimal) { AutoFormatType = 0; Caption = 'Output Quantity'; DataClassification = CustomerContent; DecimalPlaces = 0 : 5; } field(17; "Scrap Quantity"; Decimal) { AutoFormatType = 0; Caption = 'Scrap Quantity'; DataClassification = CustomerContent; DecimalPlaces = 0 : 5; } field(19; "Concurrent Capacity"; Decimal) { AutoFormatType = 0; Caption = 'Concurrent Capacity'; DataClassification = CustomerContent; } field(39; "Last Output Line"; Boolean) { Caption = 'Last Output Line'; DataClassification = CustomerContent; } field(43; "Starting Time"; Time) { Caption = 'Starting Time'; DataClassification = CustomerContent; } field(44; "Ending Time"; Time) { Caption = 'Ending Time'; DataClassification = CustomerContent; } field(52; "Routing No."; Code[20]) { Caption = 'Routing No.'; DataClassification = CustomerContent; TableRelation = "Routing Header"; } field(53; "Routing Reference No."; Integer) { Caption = 'Routing Reference No.'; DataClassification = CustomerContent; } field(65; "Stop Code"; Code[10]) { Caption = 'Stop Code'; DataClassification = CustomerContent; TableRelation = Stop; } field(66; "Scrap Code"; Code[10]) { Caption = 'Scrap Code'; DataClassification = CustomerContent; TableRelation = Scrap; } field(68; "Work Center Group Code"; Code[10]) { Caption = 'Work Center Group Code'; DataClassification = CustomerContent; TableRelation = "Work Center Group"; } field(69; "Work Shift Code"; Code[10]) { Caption = 'Work Shift Code'; DataClassification = CustomerContent; TableRelation = "Work Shift"; } modify("Order No.") { TableRelation = if ("Order Type" = const(Production)) "Production Order"."No." where(Status = filter(Released ..)); } modify("Order Line No.") { TableRelation = if ("Order Type" = const(Production)) "Prod. Order Line"."Line No." where(Status = filter(Released ..), "Prod. Order No." = field("Order No.")); } } keys { key(Key4; "Work Center No.", "Work Shift Code") { } } procedure SetFilterByProdOrderRoutingLine(ProdOrderNo: Code[20]; ProdOrderLineNo: Integer; ProdOrderRoutingNo: Code[20]; ProdOrderRoutingLineNo: Integer) begin SetRange("Order Type", "Order Type"::Production); SetRange("Order No.", ProdOrderNo); SetRange("Order Line No.", ProdOrderLineNo); SetRange("Routing No.", ProdOrderRoutingNo); SetRange("Routing Reference No.", ProdOrderRoutingLineNo); end;}