Table 99000830 "Planning Routing Line"
Base Application · Microsoft.Manufacturing.Routing
- 52fields
- 28procedures
- 9events
- 1Learn pages
- 1countries replace it
- 1fields reference it
- 1event subscribers
- 2objects it calls
Across versions
- BC23present
- BC24declaration changed
- BC252 events added
- BC26-27unchanged
- BC2834 fields changed, 1 fields added
- BC29-30unchanged
Neighbourhood 16 connected objects and pages
Base Application · Microsoft.Manufacturing.Routing · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 99000863 “Planning Routing” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Planning Routing Line |
| DataClassification | CustomerContent |
| Permissions | TableData “Prod. Order Capacity Need” = rmd |
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 | Worksheet Template Name | Code[10] | — | TableRelation Table 244 “Req. Wksh. Template” (Req. Wksh. Template); not editable |
| 2 | Worksheet Batch Name | Code[10] | — | TableRelation Table 245 “Requisition Wksh. Name” (if (“Worksheet Template Name” = filter(<> ‘’)) “Requisition Wksh. Name”.Name where(“Worksheet Template Name” = field(“Worksheet Template Name”))) |
| 3 | Worksheet Line No. | Integer | — | TableRelation Table 246 “Requisition Line” (“Requisition Line”.“Line No.” where(“Worksheet Template Name” = field(“Worksheet Template Name”), “Journal Batch Name” = field(“Worksheet Batch Name”))) |
| 4 | Operation No. Δ BC28 | Code[10] | Specifies the operation number for this planning routing line. | NotBlank |
| 5 | Next Operation No. Δ BC28 | Code[30] | Specifies the next operation number if you use parallel routings. | |
| 6 | Previous Operation No. Δ BC28 | Code[30] | Specifies the previous operation number and shows the operation that is run directly before the operation. | |
| 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 a description of the task related to this routing line. | |
| 12 | Setup Time Δ BC28 | Decimal | Specifies the setup time using the unit of measure from the Setup Time Unit of Measure field on the work or machine center card. | |
| 13 | Run Time Δ BC28 | Decimal | Specifies the run time of the operation. | |
| 14 | Wait Time Δ BC28 | Decimal | Specifies the wait time. | |
| 15 | Move Time Δ BC28 | Decimal | Specifies the move time using the unit of measure in the Move Time Unit of Measure field on the machine or work center card. | |
| 16 | Fixed Scrap Quantity Δ BC28 | Decimal | Specifies a fixed scrap quantity for this routing line. | |
| 17 | Lot Size Δ BC28 | Decimal | Specifies the number of items that are included in the same operation at the same time. The run time on routing lines is reduced proportionally to the lot size. For example, if the lot size is two pieces, the run time will be reduced by half. | |
| 18 | Scrap Factor % Δ BC28 | Decimal | Specifies the scrap factor as a percentage. | |
| 19 | Setup Time Unit of Meas. Code | Code[10] | — | TableRelation Table 99000780 “Capacity Unit of Measure” (Capacity Unit of Measure) |
| 20 | Run Time Unit of Meas. Code | Code[10] | — | TableRelation Table 99000780 “Capacity Unit of Measure” (Capacity Unit of Measure) |
| 21 | Wait Time Unit of Meas. Code | Code[10] | — | TableRelation Table 99000780 “Capacity Unit of Measure” (Capacity Unit of Measure) |
| 22 | Move Time Unit of Meas. Code | Code[10] | — | 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 quantity of machines or personnel that can perform their expected functions simultaneously. | |
| 31 | Send-Ahead Quantity Δ BC28 | Decimal | Specifies the output of the operation that must be completed before the next operation can be started. | |
| 34 | Routing Link Code | Code[10] | Specifies the routing link code. via Page 99000863 “Planning Routing” | TableRelation Table 99000777 “Routing Link” (Routing Link) |
| 35 | Standard Task Code | Code[10] | — | 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 or machine center card. | |
| 41 | Recalculate | Boolean | — | not editable |
| 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 | — | |
| 61 | Output Quantity Δ BC28 | Decimal | — | not editable |
| 70 | Starting Time Δ BC28 | Time | Specifies the starting time for the operation for this planning routing line. | |
| 71 | Starting Date Δ BC28 | Date | Specifies the starting date for the operation for this planning routing line. | |
| 72 | Ending Time Δ BC28 | Time | Specifies the ending time of the operation for this planning routing line. | |
| 73 | Ending Date Δ BC28 | Date | Specifies the ending date of the operation for this planning routing line. | |
| 76 | Unit Cost Calculation | Enum “Unit Cost Calculation Type” | — | enum Enum 5409 “Unit Cost Calculation Type” |
| 77 | Input Quantity Δ BC28 | Decimal | — | not editable |
| 78 | Critical Path | Boolean | — | 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”. | |
| 99000909 | Expected Operation Cost Amt. Δ BC28 | Decimal | — | not editable |
| 99000910 | Expected Capacity Ovhd. Cost Δ BC28 | Decimal | — | not editable |
| 99000911 | Expected Capacity Need Δ BC28 | Decimal | — | not editable |
Keys
- Key1: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Operation No. (clustered)
- Key2: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Sequence No.(Forward)
- Key3: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Sequence No.(Backward)
- Key4: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Sequence No. (Actual)
- Key5: Worksheet Template Name, Worksheet Batch Name, Type, No., Starting Date
- Key6: Work Center No.
- Key7: Type, No.
Events published
OnAfterWorkCenterTransferFields(var PlanningRoutingLine: Record "Planning Routing Line"; var WorkCenter: Record "Work Center")(integration)OnAfterMachineCtrTransferFields(var PlanningRoutingLine: Record "Planning Routing Line"; var WorkCenter: Record "Work Center"; var MachineCenter: Record "Machine Center")(integration)OnAfterTransferFromProdOrderRouting(var PlanningRoutingLine: Record "Planning Routing Line"; var ProdOrderRtngLine: Record "Prod. Order Routing Line")(integration)OnAfterTransferFromRoutingLine(var PlanningRoutingLine: Record "Planning Routing Line"; var RoutingLine: Record "Routing Line")(integration)OnAfterTransferFromReqLine(var PlanningRoutingLine: Record "Planning Routing Line"; var RequisitionLine: Record "Requisition Line")(integration)OnAfterUpdateDatetime(var PlanningRoutingLine: Record "Planning Routing Line"; xPlanningRoutingLine: Record "Planning Routing Line"; FieldNo: Integer)(integration)OnBeforeCalcStartingEndingDates(var PlanningRoutingLine: Record "Planning Routing Line"; var IsHandled: Boolean)(integration)OnMachineCtrTransferFieldsOnAfterWorkCenterTransferFields(var PlanningRoutingLine: Record "Planning Routing Line"; xPlanningRoutingLine: Record "Planning Routing Line"; WorkCenter: Record "Work Center"; MachineCenter: Record "Machine Center"; var IsHandled: Boolean)+ BC25 (integration)OnBeforeWorkCenterTransferFields(var PlanningRoutingLine: Record "Planning Routing Line"; xPlanningRoutingLine: Record "Planning Routing Line"; WorkCenter: Record "Work Center"; var IsHandled: Boolean)+ BC25 (integration)
Trigger event subscribers
- OnBeforeInsertEvent: Codeunit 99000788 “Mfg. Experience Tier” BlockInsertPlanningRoutingLine
Procedures
Caption(): TextSetRecalcStatus()RunTimePer(): DecimalCalcStartingEndingDates()TransferFromProdOrderRouting(var ProdOrderRoutingLine: Record "Prod. Order Routing Line")TransferFromReqLine(ReqLine: Record "Requisition Line")TransferFromRoutingLine(RoutingLine: Record "Routing Line")UpdateDatetime()SetNextOperations()SetPreviousAndNext()IsSerial(): Boolean
Plus 8 local procedures.
Triggers
OnDelete, OnInsert, OnRename
Relations
- drill-down page Page 99000863 “Planning Routing”
- lookup page Page 99000863 “Planning Routing”
- Worksheet Template Name: TableRelation Table 244 “Req. Wksh. Template”
- Worksheet Batch Name: TableRelation Table 245 “Requisition Wksh. Name”
- Worksheet Line No.: TableRelation Table 246 “Requisition Line”
- No.: TableRelation Table 99000754 “Work Center” (conditional)
- Work Center No.: TableRelation Table 99000754 “Work Center”
- Work Center Group Code: TableRelation Table 99000756 “Work Center Group”
- No.: TableRelation Table 99000758 “Machine Center” (conditional)
- Routing Link Code: TableRelation Table 99000777 “Routing Link”
- Standard Task Code: TableRelation Table 99000778 “Standard Task”
- Move Time Unit of Meas. Code: TableRelation Table 99000780 “Capacity Unit of Measure”
- Run Time Unit of Meas. Code: TableRelation Table 99000780 “Capacity Unit of Measure”
- Setup Time Unit of Meas. Code: TableRelation Table 99000780 “Capacity Unit of Measure”
- Wait Time Unit of Meas. Code: TableRelation Table 99000780 “Capacity Unit of Measure”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table extension 99000860 “Mfg. Requisition Line”: Expected Operation Cost Amt.
Pages and codeunits on this table
- Page 99000863 “Planning Routing” (source 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.
- Codeunit 99000808 “PlanningRoutingManagement” (8 calls:
CalcStartingEndingDates → CalcSequenceFromActual,CalcStartingEndingDates → CalculateRoutingFromActual,CalculateRoutingBack → CalcSequenceFromActual, …) - Codeunit 5402 “Unit of Measure Management” (1 call:
RunTimePer → TimeRndPrecision)
Countries that replace 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: "Planning Routing Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.