Table 5410 Prod. Order Capacity Need

Base Application, Microsoft.Manufacturing.Document

Source AL, 270 lines

src/Layers/W1/BaseApp/Manufacturing/Document/ProdOrderCapacityNeed.Table.allines 13 to 28 of 270, Copyright (c) Microsoft Corporation. MIT

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])        {

All 270 lines

Fields 28 in 29

1StatusEnum "Production Order Status"17-29
2Prod. Order No.Code[20]17-29
3Routing No.Code[20]17-29
4Line No.Integer17-29
5Operation No.Code[10]17-29
6TypeEnum "Capacity Type"17-29
7No.Code[20]17-29
8Work Center No.Code[20]17-29
9Work Center Group CodeCode[10]17-29

All 28 fields

Public procedures 3 in 29

UpdateDatetime()17-29
GetStartingEndingDateAndTime(var StartingTime: Time; var EndingTime: Time; var CurrDate: Date)17-29
SetCapacityFilters(CapType: Enum "Capacity Type"; CapNo: Code[20])17-29

All 4 procedures in 17-29

Trigger events 10

OnBeforeInsertEvent(var Rec: Record "Prod. Order Capacity Need"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Prod. Order Capacity Need"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Prod. Order Capacity Need"; var xRec: Record "Prod. Order Capacity Need"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Prod. Order Capacity Need"; var xRec: Record "Prod. Order Capacity Need"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Prod. Order Capacity Need"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Prod. Order Capacity Need"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Prod. Order Capacity Need"; var xRec: Record "Prod. Order Capacity Need"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Prod. Order Capacity Need"; var xRec: Record "Prod. Order Capacity Need"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Prod. Order Capacity Need"; var xRec: Record "Prod. Order Capacity Need"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Prod. Order Capacity Need"; var xRec: Record "Prod. Order Capacity Need"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 5 in 22

List17181920212223242526272829
Keys5
Procedures1
key(Key4; "Work Center No.", Date, Active, "Starting Date-Time") { IncludedFields = "Allocated Time", "Needed Time"; }17-29changed in 22
changed, was key(Key4; "Work Center No.", Date, Active, "Starting Date-Time") { IncludedFields = "Allocated Time", "Needed Time"; SumIndexFields = "Allocated Time", "Needed Time"; }
key(Key5; "Work Center Group Code", Date, "Starting Date-Time") { IncludedFields = "Allocated Time"; }17-29changed in 22
changed, was key(Key5; "Work Center Group Code", Date, "Starting Date-Time") { IncludedFields = "Allocated Time"; SumIndexFields = "Allocated Time"; }
key(Key6; Type, "No.", Date, Active) { IncludedFields = "Allocated Time"; }17-29changed in 22
changed, was key(Key6; Type, "No.", Date, Active) { IncludedFields = "Allocated Time"; SumIndexFields = "Allocated Time"; }
key(Key9; "Worksheet Template Name", "Worksheet Batch Name", "Worksheet Line No.", "Operation No.") { IncludedFields = "Allocated Time"; }17-29changed in 22
changed, was key(Key9; "Worksheet Template Name", "Worksheet Batch Name", "Worksheet Line No.", "Operation No.") { IncludedFields = "Allocated Time"; SumIndexFields = "Allocated Time"; }
key(Key13; Status, "Prod. Order No.", Type, "No.", "Work Center No.", Date, "Requested Only") { IncludedFields = "Allocated Time", "Needed Time"; }17-29changed in 22
changed, was key(Key13; Status, "Prod. Order No.", Type, "No.", "Work Center No.", Date, "Requested Only") { IncludedFields = "Allocated Time", "Needed Time"; SumIndexFields = "Allocated Time", "Needed Time"; }

All 6 changes in 17-29