Table extension 99000801 Mfg. Capacity Ledger Entry

Base Application, Microsoft.Manufacturing.Capacity

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;}