tableManufacturingofficial - Microsoftderived - from the source, no model text

Table 5405 "Production Order"

Base Application · Microsoft.Manufacturing.Document

Across versions

  1. BC23present
  2. BC243 events added, 2 procedures added
  3. BC252 events added, 1 events removed
  4. BC266 procedures added, 4 events added
  5. BC271 procedures added
  6. BC2841 fields changed, 1 fields added
  7. BC29unchanged
  8. BC301 fields changed

Neighbourhood 88 connected objects and pages

Table 5407 "Prod. Order Component" (relates to, 3 links)Prod. Order ComponentTable 349 "Dimension Value" (relates to, 2 links)Table 5409 "Prod. Order Routing Line" (relates to, 2 links)Table 5410 "Prod. Order Capacity Need" (relates to, 2 links)Prod. Order Capacity NeedTable 99000754 "Work Center" (relates to, 2 links)Page 99000815 "Production Order List" (pages and codeunits on it, 3 links)Production Order ListCodeunit 5407 "Prod. Order Status Management" (pages and codeunits on it)Prod. Order Status ManagementCodeunit 99000750 "ProdOrderChangeStatusBulk" (pages and codeunits on it)Page 9323 "Simulated Production Orders" (pages and codeunits on it)Simulated Production OrdersPage 9324 "Planned Production Orders" (pages and codeunits on it)Page 9325 "Firm Planned Prod. Orders" (pages and codeunits on it)Firm Planned Prod. OrdersPage 9326 "Released Production Orders" (pages and codeunits on it)Released Production OrdersPage 9327 "Finished Production Orders" (pages and codeunits on it)Finished Production OrdersPage 99000813 "Planned Production Order" (pages and codeunits on it)Planned Production OrderPage 99000816 "Production Order Statistics" (pages and codeunits on it)Page 99000829 "Firm Planned Prod. Order" (pages and codeunits on it)Page 99000831 "Released Production Order" (pages and codeunits on it)Page 99000867 "Finished Production Order" (pages and codeunits on it)Page 99000912 "Simulated Production Order" (pages and codeunits on it)Page 99000914 "Change Production Order Status" (pages and codeunits on it)Table extension 20505 "Subc. Production Order Ext." (extended by)Table extension 6242 "Sust. Production Order" (extended by)Codeunit 99000783 "Prod. Document Attachment Mgt." (event subscribers)Codeunit 99000788 "Mfg. Experience Tier" (event subscribers)Codeunit 408 "DimensionManagement" (calls, 6 links)DimensionManagementCodeunit 5404 "Lead-Time Management" (calls, 5 links)Lead-Time ManagementCodeunit 99000773 "Calculate Prod. Order" (calls, 4 links)Codeunit 5996 "Prod. Order Warehouse Mgt." (calls, 3 links)Prod. Order Warehouse Mgt.Codeunit 6500 "Item Tracking Management" (calls, 2 links)Page 456 "No. Series" (calls, 2 links)No. SeriesCodeunit 99000756 "VersionManagement" (calls)Codeunit 99000838 "Prod. Order Comp.-Reserve" (calls)Codeunit 99000845 "Reservation Management" (calls)Table 9056 "Manufacturing Cue" (referenced by, 5 links)Manufacturing CueTable 20560 "Subcontractor WIP Ledger Entry" (referenced by)About finished production order costs (Learn pages)About production orders (Learn pages)Create production orders (Learn pages)Manufacturing overview (Learn pages)Order subcontracting (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 99000831 “Released Production Order” (4 Learn pages), Page 9325 “Firm Planned Prod. Orders” (2), Page 99000815 “Production Order List” (2), Page 99000829 “Firm Planned Prod. Order” (2), Page 99000867 “Finished Production Order” (2), Page 9323 “Simulated Production Orders” (1), Page 9324 “Planned Production Orders” (1), Page 9326 “Released Production Orders” (1), Page 9327 “Finished Production Orders” (1), Page 99000813 “Planned Production Order” (1), Page 99000816 “Production Order Statistics” (1), Page 99000912 “Simulated Production Order” (1), Page 99000914 “Change Production Order Status” (1).

Properties

Property Value
Caption Production Order
DataClassification CustomerContent
Permissions TableData “Prod. Order Capacity Need” = r

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 Status Δ BC28 Enum “Production Order Status” Specifies the status of the production order. enum Enum 5405 “Production Order Status”
2 No. Δ BC28 Code[20] Specifies the number of the involved entry or record, according to the specified number series. TableRelation Table 5405 “Production Order” (“Production Order”.“No.” where(Status = field(Status)))
3 Description Δ BC28 Text[100] Specifies the description of the production order.
4 Search Description Δ BC28 Code[100] Specifies the search description.
5 Description 2 Δ BC28 Text[50] Specifies information in addition to the description.
6 Creation Date Δ BC28 Date Specifies the date on which you created the production order. not editable
7 Last Date Modified Δ BC28 Date Specifies when the production order card was last modified. not editable
9 Source Type Δ BC28 Enum “Prod. Order Source Type” Specifies the source type of the production order. enum Enum 5407 “Prod. Order Source Type”
10 Source No. Δ BC26 Δ BC28 Code[20] Specifies the number of the source document that the entry originates from. TableRelation Table 27 “Item”, Table 36 “Sales Header”, Table 99000773 “Family” (if (“Source Type” = const(Item)) Item where(Type = const(Inventory), “Production Blocked” = filter(<> Output)) else if (“Source Type” = const(Family)) Family else if (Status = const(Simulated), “Source Type” = const(“Sales Header”)) “Sales Header”.“No.” where(“Document Type” = const(Quote)) else if …)
11 Routing No. Δ BC28 Code[20] Specifies the routing number used for this production order. TableRelation Table 99000763 “Routing Header” (Routing Header)
12 Variant Code Δ BC26 Δ BC28 Code[10] Specifies the variant code for production order item. TableRelation Table 5401 “Item Variant” (if (“Source Type” = const(Item)) “Item Variant”.Code where(“Item No.” = field(“Source No.”), Code = field(“Variant Code”), “Production Blocked” = filter(<> Output)))
15 Inventory Posting Group Δ BC28 Code[20] Specifies links between business transactions made for the item and an inventory account in the general ledger, to group amounts for that item type. TableRelation Table 94 “Inventory Posting Group” (Inventory Posting Group)
16 Gen. Prod. Posting Group Δ BC28 Code[20] Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
17 Gen. Bus. Posting Group Δ BC28 Code[20] Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
19 Comment Boolean — FlowField: exist(“Prod. Order Comment Line” where(Status = field(Status), “Prod. Order No.” = field(“No.”))); not editable
20 Starting Time Δ BC28 Time Specifies the starting time of the production order.
21 Starting Date Δ BC28 Date Specifies the starting date of the production order.
22 Ending Time Δ BC28 Time Specifies the ending time of the production order.
23 Ending Date Δ BC28 Date Specifies the ending date of the production order.
24 Due Date Δ BC28 Date Specifies the due date of the production order.
25 Finished Date Δ BC28 Date Specifies the actual finishing date of a finished production order. not editable
28 Blocked Δ BC28 Boolean Specifies that the posting of consumption and output transactions for the released production order is blocked.
30 Shortcut Dimension 1 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
31 Shortcut Dimension 2 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
32 Location Code Δ BC28 Code[10] Specifies the location code to which you want to post the finished product from this production order. TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
33 Bin Code Δ BC28 Code[20] Specifies a bin to which you want to post the finished items. TableRelation Table 7354 “Bin” (if (“Source Type” = const(Item)) Bin.Code where(“Location Code” = field(“Location Code”), “Item Filter” = field(“Source No.”)) else if (“Source Type” = filter(<> Item)) Bin.Code where(“Location Code” = field(“Location Code”)))
34 Replan Ref. No. Code[20] — not editable
35 Replan Ref. Status Enum “Production Order Status” — enum Enum 5405 “Production Order Status”; not editable
38 Low-Level Code Integer — not editable
40 Quantity Δ BC28 Decimal Specifies how many units of the item or the family to produce (production quantity).
41 Unit Cost Δ BC28 Decimal —
42 Cost Amount Δ BC28 Decimal —
47 Work Center Filter Code[20] — TableRelation Table 99000754 “Work Center” (Work Center); FlowFilter
48 Capacity Type Filter Enum “Capacity Type” — FlowFilter; enum Enum 5871 “Capacity Type”
49 Capacity No. Filter Code[20] — TableRelation Table 99000754 “Work Center”, Table 99000758 “Machine Center” (if (“Capacity Type Filter” = const(“Machine Center”)) “Machine Center” else if (“Capacity Type Filter” = const(“Work Center”)) “Work Center”); FlowFilter
50 Date Filter Date — FlowFilter
51 Expected Operation Cost Amt. Δ BC28 Decimal — FlowField: sum(“Prod. Order Routing Line”.“Expected Operation Cost Amt.” where(Status = field(Status), “Prod. Order No.” = field(“No.”))); not editable
52 Expected Component Cost Amt. Δ BC28 Decimal — FlowField: sum(“Prod. Order Component”.“Cost Amount” where(Status = field(Status), “Prod. Order No.” = field(“No.”), “Due Date” = field(“Date Filter”))); not editable
55 Actual Time Used Δ BC28 Decimal — FlowField: sum(“Capacity Ledger Entry”.Quantity where(“Order Type” = const(Production), “Order No.” = field(“No.”), Type = field(“Capacity Type Filter”), “No.” = field(“Capacity No. Filter”), “Posting Date” = field(“Date Filter”))); not editable
56 Allocated Capacity Need Δ BC28 Decimal — FlowField: sum(“Prod. Order Capacity Need”.“Needed Time” where(Status = field(Status), “Prod. Order No.” = field(“No.”), Type = field(“Capacity Type Filter”), “No.” = field(“Capacity No. Filter”), “Work Center No.” = field(“Work Center Filter”), Date = field(“Date Filter”), “Requested Only” = const(false))); not editable
57 Expected Capacity Need Δ BC28 Decimal — FlowField: sum(“Prod. Order Capacity Need”.“Needed Time” where(Status = field(Status), “Prod. Order No.” = field(“No.”), Type = field(“Capacity Type Filter”), “No.” = field(“Capacity No. Filter”), “Work Center No.” = field(“Work Center Filter”), Date = field(“Date Filter”), “Requested Only” = const(false))); not editable
80 No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series); not editable
82 Planned Order No. Code[20] —
83 Firm Planned Order No. Code[20] —
85 Simulated Order No. Code[20] —
92 Expected Material Ovhd. Cost Δ BC28 Decimal — FlowField: sum(“Prod. Order Component”.“Overhead Amount” where(Status = field(Status), “Prod. Order No.” = field(“No.”))); not editable
94 Expected Capacity Ovhd. Cost Δ BC28 Decimal — FlowField: sum(“Prod. Order Routing Line”.“Expected Capacity Ovhd. Cost” where(Status = field(Status), “Prod. Order No.” = field(“No.”))); not editable
95 Inventory Adjmt. Entry Exists + BC28 Boolean Inventory Adjmt. Entry (Order) Exists caption FlowField: exist(“Inventory Adjmt. Entry (Order)” where(“Order Type” = const(Production), “Order No.” = field(“No.”), “Completely Invoiced” = const(false))); not editable
98 Starting Date-Time Δ BC28 DateTime Specifies the starting date and starting time of the production order.
99 Ending Date-Time Δ BC28 DateTime Specifies the ending date and ending time of the production order.
110 Document Put-away Status + BC26 Δ BC28 Option Specifies the status of the warehouse put-away. OptionCaption: ,Partially Put Away,Completely Put Away; not editable
200 Reopened + BC26 Δ BC28 Boolean Specifies if the production order is reopened. not editable
290 Manual Scheduling + BC26 Boolean Specifies that the End/Due Dates on the production have been scheduled manually. not editable
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
7300 Completely Picked Δ BC28 Δ BC30 Boolean Specifies whether all production components have been completely picked. FlowField: min(“Prod. Order Component”.“Completely Picked” where(Status = field(Status), “Prod. Order No.” = field(“No.”), “Supplied-by Line No.” = filter(0)))
9000 Assigned User ID Δ BC28 Code[50] Specifies the ID of the user who is responsible for the document. TableRelation Table 91 “User Setup” (User Setup); DataClassification EndUserIdentifiableInformation

Keys

  • Key1: Status, No. (clustered)
  • Key2: No., Status
  • Key3: Search Description
  • Key4: Low-Level Code, Replan Ref. No., Replan Ref. Status
  • Key5: Source Type, Source No.
  • Key6: Description
  • Key7: Source No.
  • Key8: Starting Date

Events published

  • OnAfterInitDefaultDimensionSources(var ProductionOrder: Record "Production Order"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; CallingFieldNo: Integer) (integration)
  • OnAdjustStartEndingDateOnBeforeSetDueDate(var ProductionOrder: Record "Production Order"; var ProdOrderLine: Record "Prod. Order Line"; var IsHandled: Boolean) (integration)
  • OnAfterOnDelete(var ProductionOrder: Record "Production Order"; var RefreshOrder: Boolean) (integration)
  • OnAfterCreateDim(var ProductionOrder: Record "Production Order"; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; xProductionOrder: Record "Production Order") + BC28 − BC28 (integration)
  • OnAfterValidateShortcutDimCode(var ProductionOrder: Record "Production Order"; var xProductionOrder: Record "Production Order"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
  • OnAfterUpdateDateTime(var ProductionOrder: Record "Production Order"; var xProductionOrder: Record "Production Order"; CallingFieldNo: Integer) (integration)
  • OnBeforeAssignItemNo(var ProdOrder: Record "Production Order"; xProdOrder: Record "Production Order"; var Item: Record Item; CallingFieldNo: Integer) (integration)
  • OnBeforeAssignFamily(var ProdOrder: Record "Production Order"; xProdOrder: Record "Production Order"; var Family: Record Family; CallingFieldNo: Integer) (integration)
  • OnBeforeAssignSalesHeader(var ProdOrder: Record "Production Order"; xProdOrder: Record "Production Order"; var SalesHeader: Record "Sales Header"; CallingFieldNo: Integer) (integration)
  • OnBeforeGetNoSeriesCode(var ProductionOrder: Record "Production Order"; MfgSetup: Record "Manufacturing Setup"; var NoSeriesCode: Code[20]; var IsHandled: Boolean) (integration)
  • OnBeforeDeleteFnshdProdOrderRelations(var ProdOrder: Record "Production Order") (integration)
  • OnBeforeDeleteProdOrderLines(ProductionOrder: Record "Production Order"; var ProdOrderLine: Record "Prod. Order Line") (integration)
  • OnBeforeDeleteRelations(var ProdOrder: Record "Production Order") (integration)
  • OnBeforeMultiLevelMessage(var IsHandled: Boolean; var ProductionOrder: Record "Production Order"; var xProductionOrder: Record "Production Order"; CurrentFieldNo: Integer) (integration)
  • OnBeforeUpdateEndingDate(var ProdOrderLine: Record "Prod. Order Line"; ProdOrder: Record "Production Order"; var IsHandled: Boolean; CurrFieldNo: Integer) (integration)
  • OnBeforeUpdateProdOrderLineDueDate(var ProdOrderLine: Record "Prod. Order Line"; var IsHandled: Boolean; var CalculateProdOrder: Codeunit "Calculate Prod. Order") + BC26 − BC26 (integration)
  • OnBeforeValidateShortcutDimCode(var ProductionOrder: Record "Production Order"; var xProductionOrder: Record "Production Order"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration)
  • OnBeforeValidateVariantCode(var ProductionOrder: Record "Production Order"; xProductionOrder: Record "Production Order"; FieldNumber: Integer; var IsHandled: Boolean) (integration)
  • OnValidateDueDateOnAfterModify(ProductionOrder: Record "Production Order") (integration)
  • OnValidateSourceNoOnSourceTypeEnumExtension(var ProductionOrder: Record "Production Order") (integration)
  • OnUpdateEndingDateOnBeforeCalcProdOrderRecalculate(var ProdOrderLine: Record "Prod. Order Line") (integration)
  • OnUpdateStartingEndingTimeOnBeforeProdOrderLineModify(var ProdOrderLine: Record "Prod. Order Line"; var ProductionOrder: Record "Production Order") (integration)
  • OnUpdateEndingDateOnBeforeProdOrderLineModify(var ProdOrderLine: Record "Prod. Order Line"; var ProductionOrder: Record "Production Order") (integration)
  • OnBeforeInitRecord(var ProductionOrder: Record "Production Order") (integration)
  • OnAfterInitRecord(var ProductionOrder: Record "Production Order") (integration)
  • OnBeforeOnInsert(var ProductionOrder: Record "Production Order"; var xProductionOrder: Record "Production Order"; var InvtAdjmtEntryOrder: Record "Inventory Adjmt. Entry (Order)"; var IsHandled: Boolean) (integration)
  • OnBeforeShowErrorOnRename(var IsHandled: Boolean; var ProductionOrder: Record "Production Order") (integration)
  • OnBeforeRunCreatePickFromWhseSource(var ProductionOrder: Record "Production Order"; AssignedUserID: Code[50]; SortingMethod: Option; PrintDocument: Boolean; DoNotFillQtyToHandle: Boolean; SetBreakBulkFilter: Boolean; HideValidationDialog: Boolean; var IsHandled: Boolean) (integration)
  • OnBeforeTestNoSeries(ProductionOrder: Record "Production Order"; MfgSetup: Record "Manufacturing Setup"; var IsHandled: Boolean) (integration)
  • OnBeforeCheckStatusNotFinished(ProductionOrder: Record "Production Order"; var IsHandled: Boolean) (integration)
  • OnBeforeCreateDim(var ProductionOrder: Record "Production Order"; var IsHandled: Boolean) (integration)
  • OnGetDefaultBinOnBeforeThirdPrioritySetBinCode(var ProductionOrder: Record "Production Order"; xProductionOrder: Record "Production Order"; var IsHandled: Boolean) (integration)
  • OnInsertOnBeforeStatusCheck(var ProductionOrder: Record "Production Order"; var IsHandled: Boolean) (integration)
  • OnBeforeConfirmUpdateAllLineDim(var ProductionOrder: Record "Production Order"; var xProductionOrder: Record "Production Order"; NewParentDimSetID: Integer; OldParentDimSetID: Integer; var Confirmed: Boolean; var IsHandled: Boolean) + BC24 (integration)
  • OnValidateShortcutDimCodeOnBeforeUpdateAllLineDim(var ProductionOrder: Record "Production Order"; var xProductionOrder: Record "Production Order"; FieldNumber: Integer) + BC24 + BC25 − BC25 (integration)
  • OnShowDocDimOnAfterSetDimensionSetID(var ProductionOrder: Record "Production Order"; xProductionOrder: Record "Production Order") + BC24 (integration)
  • OnUpdateAllLineDimOnAfterUpdateProdOrderCompDim(var ProductionOrder: Record "Production Order"; var ProdOrderLine: Record "Prod. Order Line"; NewParentDimSetID: Integer; OldParentDimSetID: Integer) + BC25 (integration)
  • OnAfterDeleteProdOrderRelations(var ProductionOrder: Record "Production Order"; var ProdOrderCommentLine: Record "Prod. Order Comment Line"; var WhsePickRequest: Record "Whse. Pick Request"; var ReservationManagement: Codeunit "Reservation Management"; var ItemTrackingManagement: Codeunit "Item Tracking Management") + BC26 (integration)
  • OnCreatePickOnBeforeFindProdOrderComponent(var ProdOrderComponent: Record "Prod. Order Component") + BC26 (integration)
  • OnCreatePickOnBeforeRunCreatePickFromWhseSource(var ProdOrderComponent: Record "Prod. Order Component") + BC26 (integration)

Trigger event subscribers

Procedures

  • InitRecord()
  • TestNoSeries()
  • AssistEdit(OldProdOrder: Record "Production Order"): Boolean
  • GetNoSeriesCode(): Code[20]
  • CheckProdOrderStatus(Name: Text[80])
  • DeleteProdOrderRelations()
  • DeleteFinishedProdOrderRelations()
  • AdjustStartEndingDate()
  • UpdateDatetime()
  • CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
  • ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
  • Navigate()
  • GetHeaderPutAwayStatus(SkipLineNo: Integer): Integer + BC26
  • CreatePick(AssignedUserID: Code[50]; SortingMethod: Option; SetBreakBulkFilter: Boolean; DoNotFillQtyToHandle: Boolean; PrintDocument: Boolean)
  • SetHideValidationDialog(NewHideValidationDialog: Boolean)
  • CreateInvtPutAwayPick()
  • SetUpdateEndDate()
  • ShowDocDim()
  • ProdOrderLineExist(): Boolean
  • IsStatusLessThanReleased(): Boolean
  • CreateDimFromDefaultDim()
  • GetQtyReservedFromStockState(): Enum "Reservation From Stock" (internal)

Plus 20 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

Referenced by

35 fields in 31 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

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: "Production Order"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources