tableManufacturingofficial - Microsoftderived - from the source, no model text

Table 5409 "Prod. Order Routing Line"

Base Application · Microsoft.Manufacturing.Document

Across versions

  1. BC23present
  2. BC243 events added
  3. BC252 events added, 2 events removed
  4. BC265 procedures added, 4 fields added
  5. BC272 events added, 1 procedures added
  6. BC2853 fields changed, 3 events added
  7. BC29unchanged
  8. BC301 procedures added, 1 events added

Neighbourhood 53 connected objects and pages

Table 5832 "Capacity Ledger Entry" (relates to, 4 links)Capacity Ledger EntryTable 99000780 "Capacity Unit of Measure" (relates to, 4 links)Capacity Unit of MeasureTable 99000754 "Work Center" (relates to, 2 links)Table 5405 "Production Order" (relates to)Table 99000756 "Work Center Group" (relates to)Work Center GroupTable 99000758 "Machine Center" (relates to)Table 99000763 "Routing Header" (relates to)Table 99000777 "Routing Link" (relates to)Table 99000778 "Standard Task" (relates to)Page 99000817 "Prod. Order Routing" (pages and codeunits on it, 3 links)Prod. Order RoutingPage 20502 "Subc. Routing Info Factbox" (pages and codeunits on it)Page 5408 "Prod. Order Routing Lines" (pages and codeunits on it)Page 99000915 "Work Center Task List" (pages and codeunits on it)Page 99000916 "Machine Center Task List" (pages and codeunits on it)Table extension 20506 "Subc. ProdOrderRtngLine Ext." (extended by)Table extension 6247 "Sust. Prod. Order Routing Line" (extended by)Codeunit 20520 "Subc. Prod. Order Rtng. Ext." (event subscribers, 11 links)Subc. Prod. Order Rtng. Ext.Codeunit 6254 "Sust. Manufacturing Subscriber" (event subscribers, 3 links)Codeunit 99000788 "Mfg. Experience Tier" (event subscribers)Codeunit 99000773 "Calculate Prod. Order" (calls, 6 links)Calculate Prod. OrderCodeunit 99000772 "Prod. Order Route Management" (calls, 4 links)Prod. Order Route ManagementCodeunit 99000849 "Mfg. ReservCheckDateConfl" (calls, 2 links)Codeunit 27 "Confirm Management" (calls)Table 20560 "Subcontractor WIP Ledger Entry" (referenced by, 2 links)Subcontractor WIP Ledger EntryTable 20574 "Subc. Prod. Rtng. Comment" (referenced by, 2 links)Subc. Prod. Rtng. CommentTable 5405 "Production Order" (referenced by, 2 links)Production OrderTable 5411 "Prod. Order Routing Tool" (referenced by, 2 links)Prod. Order Routing ToolTable 5412 "Prod. Order Routing Personnel" (referenced by, 2 links)Table 5413 "Prod. Order Rtng Qlty Meas." (referenced by, 2 links)Prod. Order Rtng Qlty Meas.Table 5415 "Prod. Order Rtng Comment Line" (referenced by, 2 links)Table 9056 "Manufacturing Cue" (referenced by, 2 links)Manufacturing CueTable extension 20517 "Subc. Transfer Line" (referenced by, 2 links)Subc. Transfer LineTable 5406 "Prod. Order Line" (referenced by)Table 99000754 "Work Center" (referenced by)Table 99000758 "Machine Center" (referenced by)Table extension 20512 "Subc. Purchase Line" (referenced by)Table extension 20513 "Subc. Purch. Rcpt. Line" (referenced by)Table extension 20514 "Subc. Purch. Inv. Line" (referenced by)Create routings (Learn pages)Sustainability value chain in production (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Manufacturing.Document · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 99000817 “Prod. Order Routing” (2 Learn pages), Page 99000915 “Work Center Task List” (1), Page 99000916 “Machine Center Task List” (1).

Properties

Property Value
Caption Prod. Order Routing Line
DataClassification CustomerContent
Permissions TableData “Prod. Order Capacity Need” = rimd

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 Routing No. Δ BC28 Code[20] Specifies the routing number. TableRelation Table 99000763 “Routing Header” (Routing Header)
3 Routing Reference No. Δ BC28 Integer Specifies that the routing reference number. not editable
4 Operation No. Δ BC28 Code[10] Specifies the operation number. NotBlank
5 Next Operation No. Δ BC28 Code[30] Specifies the next operation number.
6 Previous Operation No. Δ BC28 Code[30] Specifies the previous operation number.
7 Type Δ BC28 Enum “Capacity Type” Specifies the type of operation. enum Enum 5871 “Capacity Type”
8 No. Δ BC28 Code[20] Specifies the number of the involved entry or record, according to the specified number series. TableRelation Table 99000754 “Work Center”, Table 99000758 “Machine Center” (if (Type = const(“Work Center”)) “Work Center” else if (Type = const(“Machine Center”)) “Machine Center”)
9 Work Center No. Code[20] — TableRelation Table 99000754 “Work Center” (Work Center); not editable
10 Work Center Group Code Code[10] — TableRelation Table 99000756 “Work Center Group” (Work Center Group); not editable
11 Description Δ BC28 Text[100] Specifies the description of the operation.
12 Setup Time Δ BC28 Decimal Specifies the setup time of the operation.
13 Run Time Δ BC28 Decimal Specifies the run time of the operation.
14 Wait Time Δ BC28 Decimal Specifies the wait time after processing.
15 Move Time Δ BC28 Decimal Specifies the move time.
16 Fixed Scrap Quantity Δ BC28 Decimal Specifies the fixed scrap quantity.
17 Lot Size Δ BC28 Decimal Specifies the lot size.
18 Scrap Factor % Δ BC28 Decimal Specifies the scrap factor in percent.
19 Setup Time Unit of Meas. Code Δ BC28 Code[10] Specifies the setup time unit of measure. TableRelation Table 99000780 “Capacity Unit of Measure” (Capacity Unit of Measure)
20 Run Time Unit of Meas. Code Δ BC28 Code[10] Specifies the run time unit of measure. TableRelation Table 99000780 “Capacity Unit of Measure” (Capacity Unit of Measure)
21 Wait Time Unit of Meas. Code Δ BC28 Code[10] Specifies the unit of measure code that applies to the wait time. TableRelation Table 99000780 “Capacity Unit of Measure” (Capacity Unit of Measure)
22 Move Time Unit of Meas. Code Δ BC28 Code[10] Specifies the unit of measure code that applies to the move time. TableRelation Table 99000780 “Capacity Unit of Measure” (Capacity Unit of Measure)
23 Description 2 + BC28 Text[50] Specifies additional description text.
27 Minimum Process Time Δ BC28 Decimal —
28 Maximum Process Time Δ BC28 Decimal —
30 Concurrent Capacities Δ BC28 Decimal Specifies the concurrent capacity of the operation.
31 Send-Ahead Quantity Δ BC28 Decimal Specifies the send-ahead quantity of the operation.
34 Routing Link Code Δ BC26 Δ BC28 Code[10] Specifies a routing link code. TableRelation Table 99000777 “Routing Link” (Routing Link)
35 Standard Task Code Δ BC28 Code[10] Specifies the standard task code that applies to the operation. TableRelation Table 99000778 “Standard Task” (Standard Task)
40 Unit Cost per Δ BC28 Decimal Specifies the unit cost for this operation if it is different than the unit cost on the work center card.
41 Recalculate Boolean —
50 Sequence No. (Forward) Integer — not editable
51 Sequence No. (Backward) Integer — not editable
52 Fixed Scrap Qty. (Accum.) Δ BC28 Decimal — not editable
53 Scrap Factor % (Accumulated) Δ BC28 Decimal — not editable
55 Sequence No. (Actual) Integer — not editable
56 Direct Unit Cost Δ BC28 Decimal —
57 Indirect Cost % Δ BC28 Decimal —
58 Overhead Rate Δ BC28 Decimal —
70 Starting Time Δ BC28 Time Specifies the starting time of the routing line (operation).
71 Starting Date Δ BC28 Date Specifies the starting date of the routing line (operation).
72 Ending Time Δ BC28 Time Specifies the ending time of the routing line (operation).
73 Ending Date Δ BC28 Date Specifies the ending date of the routing line (operation).
74 Status Δ BC28 Enum “Production Order Status” Specifies the status of the routing line. enum Enum 5405 “Production Order Status”
75 Prod. Order No. Δ BC28 Code[20] Specifies the number of the related production order. TableRelation Table 5405 “Production Order” (“Production Order”.“No.” where(Status = field(Status))); not editable; NotBlank
76 Unit Cost Calculation Enum “Unit Cost Calculation Type” — enum Enum 5409 “Unit Cost Calculation Type”
77 Input Quantity Δ BC28 Decimal —
78 Critical Path Boolean — not editable
79 Routing Status Δ BC28 Enum “Prod. Order Routing Status” Specifies the status of the routing line, such as Planned, In Progress, or Finished. enum Enum 99000765 “Prod. Order Routing Status”
81 Flushing Method Δ BC26 Enum “Flushing Method Routing” Specifies the method to use to calculate and handle output at the work or machine center. Manual: Output must be posted manually by using the output journal. Forward: Output is automatically calculated and posted when you change the status of a simulated, planned (or firm planned) production order t… enum Enum 5428 “Flushing Method Routing”
90 Expected Operation Cost Amt. Δ BC28 Decimal Specifies the total cost of operations. It is automatically calculated from the capacity need, when a production order is refreshed or replanned. not editable
91 Expected Capacity Need Δ BC28 Decimal — not editable
96 Expected Capacity Ovhd. Cost Δ BC28 Decimal Specifies the capacity overhead. It is automatically calculated from the capacity need, when a production order is refreshed or replanned. not editable
98 Starting Date-Time Δ BC28 DateTime Specifies the starting date and the starting time, which are combined in a format called “starting date-time”.
99 Ending Date-Time Δ BC28 DateTime Specifies the ending date and the ending time, which are combined in a format called “ending date-time”.
100 Schedule Manually Δ BC28 Boolean Specifies that the underlying capacity need is recalculated each time a change is made in the schedule of the routing.
101 Location Code Δ BC28 Code[10] Specifies the location where the machine or work center on the production order routing line operates. not editable
7301 Open Shop Floor Bin Code Δ BC28 Code[20] Specifies the corresponding bin at the machine or work center, if the location code matches the setup of that machine or work center. not editable
7302 To-Production Bin Code Δ BC28 Code[20] Specifies the bin that holds components with a flushing method, that involves a warehouse activity to bring the items to the bin. not editable
7303 From-Production Bin Code Δ BC28 Code[20] Specifies the corresponding bin at the machine or work center if the location code matches the setup of that machine or work center. not editable
7304 Posted Output Quantity + BC26 Δ BC28 Decimal Specifies the total output quantity that has been posted to the capacity ledger. Value expressed in base unit of measure. FlowField: sum(“Capacity Ledger Entry”.“Output Quantity” where(“Routing No.” = field(“Routing No.”), “Order No.” = field(“Prod. Order No.”), “Operation No.” = field(“Operation No.”), “Order Type” = const(Production), “Routing Reference No.” = field(“Routing Reference No.”))); not editable
7305 Posted Scrap Quantity + BC26 Δ BC28 Decimal Specifies the total scrap quantity that has been posted to the capacity ledger. Value expressed in base unit of measure. FlowField: sum(“Capacity Ledger Entry”.“Scrap Quantity” where(“Routing No.” = field(“Routing No.”), “Order No.” = field(“Prod. Order No.”), “Operation No.” = field(“Operation No.”), “Order Type” = const(Production), “Routing Reference No.” = field(“Routing Reference No.”))); not editable
7306 Posted Run Time + BC26 Δ BC28 Decimal Specifies the total run time that has been posted to the capacity ledger. FlowField: sum(“Capacity Ledger Entry”.“Run Time” where(“Routing No.” = field(“Routing No.”), “Order No.” = field(“Prod. Order No.”), “Operation No.” = field(“Operation No.”), “Order Type” = const(Production), “Routing Reference No.” = field(“Routing Reference No.”))); not editable
7307 Posted Setup Time + BC26 Δ BC28 Decimal Specifies the total set up time that has been posted to the capacity ledger. FlowField: sum(“Capacity Ledger Entry”.“Setup Time” where(“Routing No.” = field(“Routing No.”), “Order No.” = field(“Prod. Order No.”), “Operation No.” = field(“Operation No.”), “Order Type” = const(Production), “Routing Reference No.” = field(“Routing Reference No.”))); not editable

Keys

  • Key1: Status, Prod. Order No., Routing Reference No., Routing No., Operation No. (clustered)
  • Key2: Prod. Order No., Routing Reference No., Status, Routing No., Operation No.
  • Key3: Status, Prod. Order No., Routing Reference No., Routing No., Sequence No. (Forward)
  • Key4: Status, Prod. Order No., Routing Reference No., Routing No., Sequence No. (Backward)
  • Key5: Status, Prod. Order No., Routing Reference No., Routing No., Sequence No. (Actual)
  • Key6: Work Center No.
  • Key7: Type, No., Starting Date
  • Key8: Status, Work Center No.
  • Key9: Prod. Order No., Status, Flushing Method
  • Key10: Starting Date, Starting Time, Routing Status
  • Key11: Ending Date, Ending Time, Routing Status
  • Key12: Type, No., Status

Events published

  • OnAfterCalcStartingEndingDates(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var xProdOrderRoutingLine: Record "Prod. Order Routing Line"; var ProdOrderLine: Record "Prod. Order Line"; CallingFieldNo: Integer) (integration)
  • OnAfterCopyFromRoutingLine(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; RoutingLine: Record "Routing Line") (integration)
  • OnAfterDeleteRelations(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; SkipUpdateOfCompBinCodes: Boolean) (integration)
  • OnAfterFillDefaultLocationAndBins(var ProdOrderRoutingLine: Record "Prod. Order Routing Line") (integration)
  • OnAfterWorkCenterTransferFields(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; WorkCenter: Record "Work Center") (integration)
  • OnAfterMachineCtrTransferFields(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; WorkCenter: Record "Work Center"; MachineCenter: Record "Machine Center") (integration)
  • OnAfterSetRecalcStatus(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var ProdOrderLine: Record "Prod. Order Line") (integration)
  • OnAfterTransferFromStdTaskTool(var ProdOrderRoutingTool: Record "Prod. Order Routing Tool"; StandardTaskTool: Record "Standard Task Tool") (integration)
  • OnAfterTransferFromStdTaskPersonnel(var ProdOrderRoutingPersonnel: Record "Prod. Order Routing Personnel"; StandardTaskPersonnel: Record "Standard Task Personnel") (integration)
  • OnAfterTransferFromStdTaskQltyMeasure(var ProdOrderRtngQltyMeas: Record "Prod. Order Rtng Qlty Meas."; StandardTaskQualityMeasure: Record "Standard Task Quality Measure") (integration)
  • OnAfterTransferFromStdTaskComment(var ProdOrderRtngCommentLine: Record "Prod. Order Rtng Comment Line"; StandardTaskDescription: Record "Standard Task Description") (integration)
  • OnAfterUpdateDateTime(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var xProdOrderRoutingLine: Record "Prod. Order Routing Line"; CallingFieldNo: Integer) (integration)
  • OnAfterValidateNo(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var xProdOrderRoutingLine: Record "Prod. Order Routing Line"; var ProdOrderLine: Record "Prod. Order Line") (integration)
  • OnBeforeAdjustComponents(var ProdOrderComp: Record "Prod. Order Component") (integration)
  • OnBeforeCalcStartingEndingDates(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var Direction: Option Forward,Backward; var IsHandled: Boolean) (integration)
  • OnBeforeCheckRoutingNoNotBlank(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var IsHandled: Boolean) (integration)
  • OnBeforeCheckIfSubcontractingPurchOrderExist(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; xProdOrderRoutingLine: Record "Prod. Order Routing Line"; var IsHandled: Boolean) (integration)
  • OnBeforeDeleteRelations(var ProdOrderRoutingLine: Record "Prod. Order Routing Line") (integration)
  • OnBeforeFillDefaultLocationAndBins(var ProdOrderRoutingLine: Record "Prod. Order Routing Line") (integration)
  • OnBeforeSetNextOperations(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var IsHandled: Boolean) (integration)
  • OnBeforeTerminationProcessesErr(var IsHandled: Boolean; var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; xProdOrderRoutingLine: Record "Prod. Order Routing Line") (integration)
  • OnCalcStartingEndingDatesOnBeforeCalculateRouting(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var IsHandled: Boolean) (integration)
  • OnCheckPreviousAndNextOnAfterProdOrderRoutingPageRunModal(var TempRemainingProdOrderRoutingLine: Record "Prod. Order Routing Line" temporary) (integration)
  • OnValidateRoutingStatusOnBeforeConfirm(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var IsHandled: Boolean) (integration)
  • OnValidateNoOnBeforeModifyCapNeedEntries(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; xProdOrderRoutingLine: Record "Prod. Order Routing Line") + BC28 (integration)
  • OnAfterCopyFromPlanningRoutingLine(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; PlanningRoutingLine: Record "Planning Routing Line") (integration)
  • OnValidateStandardTaskCodeOnBeforeProdOrderRtngCommentLineInsert(var ProdOrderRtngCommentLine: Record "Prod. Order Rtng Comment Line"; StdTaskComment: Record "Standard Task Description") (integration)
  • OnAfterUpdateComponentsBin(var TempProdOrderRoutingLine: Record "Prod. Order Routing Line"; FromTrigger: Option) (integration)
  • OnAfterUpdateOfComponentsBinRequired(ProdOrderRoutingLine: Record "Prod. Order Routing Line"; FromTrigger: Option; var Result: Boolean) (integration)
  • OnCalculateRoutingBackOnAfterCalculateProdOrderDates(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var ProdOrderLine: Record "Prod. Order Line") (integration)
  • OnCalculateRoutingBackOnBeforeCalculateProdOrderDates(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var ProdOrderLine: Record "Prod. Order Line") + BC28 (integration)
  • OnCalculateRoutingForwardOnAfterCalculateProdOrderDates(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var ProdOrderLine: Record "Prod. Order Line") (integration)
  • OnCalculateRoutingForwardOnBeforeCalculateProdOrderDates(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var ProdOrderLine: Record "Prod. Order Line") + BC28 (integration)
  • OnBeforeRunTimePer(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var IsHandled: Boolean; var Result: Decimal) + BC24 (integration)
  • OnMachineCtrTransferFieldsOnAfterWorkCenterTransferFields(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; WorkCenter: Record "Work Center"; MachineCenter: Record "Machine Center"; var SkipUpdateDescription: Boolean; xProdOrderRoutingLine: Record "Prod. Order Routing Line"; var IsHandled: Boolean) + BC24 + BC25 − BC25 (integration)
  • OnBeforeWorkCenterTransferFields(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; WorkCenter: Record "Work Center"; var SkipUpdateDescription: Boolean; xProdOrderRoutingLine: Record "Prod. Order Routing Line"; var IsHandled: Boolean) + BC24 + BC25 − BC25 (integration)
  • OnBeforeShowMessage(var ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var MessageText: Text; var IsHandled: Boolean) + BC26 (integration)
  • OnBeforeNextOperationExist(var ProdOrderRoutingLine: Record "Prod. Order Routing Line") + BC27 (integration)
  • OnCheckPreviousAndNextOnBeforeInsertTempRemainingProdOrderRtngLine(ProdOrderRoutingLine: Record "Prod. Order Routing Line"; var ProdOrderRoutingLineFiltered: Record "Prod. Order Routing Line"; var TempDeletedProdOrderRoutingLine: Record "Prod. Order Routing Line" temporary; var ErrorOnNext: Boolean; var ErrorOnPrevious: Boolean) + BC27 (integration)

Trigger event subscribers

Procedures

  • Caption(): Text
  • CopyFromPlanningRoutingLine(PlanningRoutingLine: Record "Planning Routing Line")
  • CopyFromRoutingLine(RoutingLine: Record "Routing Line")
  • FillDefaultLocationAndBins()
  • CalcStartingEndingDates(PlanningDirection: Option Forward,Backward)
  • SetRecalcStatus()
  • RunTimePer(): Decimal
  • UpdateDatetime()
  • CheckPreviousAndNext()
  • SetNextOperations(var RtngLine: Record "Prod. Order Routing Line")
  • SubcontractingPurchOrderExist(): Boolean
  • UpdateComponentsBin(FromTrigger: Option Insert,Modify,Delete)
  • SetSkipUpdateOfCompBinCodes(Setting: Boolean)
  • SetHideValidationDialog(NewHideValidationDialog: Boolean)
  • IsSerial(): Boolean
  • GetStartingEndingDateAndTime(var StartingTime: Time; var StartingDate: Date; var EndingTime: Time; var EndingDate: Date)
  • NextOperationExist(): Boolean + BC27

Plus 21 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

Referenced by

36 fields in 27 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Extended by

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Recent changes

Countries that replace it

IT

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Prod. Order Routing Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources