Table 99000756 Work Center Group

Base Application, Microsoft.Manufacturing.WorkCenter

src/Layers/W1/BaseApp/Manufacturing/WorkCenter/WorkCenterGroup.Table.al100 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.WorkCenter;using Microsoft.Manufacturing.Capacity;using Microsoft.Manufacturing.Document;using Microsoft.Manufacturing.Setup;table 99000756 "Work Center Group"{    Caption = 'Work Center Group';    DataCaptionFields = "Code", Name;    DrillDownPageID = "Work Center Groups";    LookupPageID = "Work Center Groups";    Permissions = TableData "Prod. Order Capacity Need" = r;    DataClassification = CustomerContent;    fields    {        field(1; "Code"; Code[10])        {            Caption = 'Code';            ToolTip = 'Specifies the code for the work center group.';            NotBlank = true;        }        field(2; Name; Text[50])        {            Caption = 'Name';            ToolTip = 'Specifies a name for the work center group.';        }        field(20; "Date Filter"; Date)        {            Caption = 'Date Filter';            FieldClass = FlowFilter;        }        field(21; "Work Shift Filter"; Code[10])        {            Caption = 'Work Shift Filter';            FieldClass = FlowFilter;            TableRelation = "Work Shift";        }        field(22; "Capacity (Total)"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Calendar Entry"."Capacity (Total)" where("Capacity Type" = const("Work Center"),                                                                         "Work Center Group Code" = field(Code),                                                                         "Work Shift Code" = field("Work Shift Filter"),                                                                         Date = field("Date Filter")));            Caption = 'Capacity (Total)';            DecimalPlaces = 0 : 5;            Editable = false;            FieldClass = FlowField;        }        field(23; "Capacity (Effective)"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Calendar Entry"."Capacity (Effective)" where("Capacity Type" = const("Work Center"),                                                                             "Work Center Group Code" = field(Code),                                                                             "Work Shift Code" = field("Work Shift Filter"),                                                                             Date = field("Date Filter")));            Caption = 'Capacity (Effective)';            DecimalPlaces = 0 : 5;            Editable = false;            FieldClass = FlowField;        }        field(24; "Prod. Order Need (Qty.)"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Prod. Order Capacity Need"."Allocated Time" where(Status = field("Prod. Order Status Filter"),                                                                                  "Work Center Group Code" = field(Code),                                                                                  Date = field("Date Filter"),                                                                                  "Requested Only" = const(false)));            Caption = 'Prod. Order Need (Qty.)';            DecimalPlaces = 0 : 5;            Editable = false;            FieldClass = FlowField;        }        field(47; "Prod. Order Status Filter"; Enum "Production Order Status")        {            Caption = 'Prod. Order Status Filter';            FieldClass = FlowFilter;        }    }    keys    {        key(Key1; "Code")        {            Clustered = true;        }    }    fieldgroups    {    }}