Table 99000829 "Planning Component"
Base Application · Microsoft.Inventory.Planning
Across versions
- BC23present
- BC24declaration changed
- BC251 fields changed
- BC269 procedures changed, 7 procedures removed
- BC271 fields added, 1 procedures added
- BC2837 fields changed, 1 fields added
- BC29-30unchanged
Neighbourhood 29 connected objects and pages
Base Application · Microsoft.Inventory.Planning · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 99000861 “Planning Component List” (1 Learn page), Page 99000862 “Planning Components” (1), Page 99000900 “Avail. - Planning Components” (1).
Properties
| Property | Value |
|---|---|
| Caption | Planning Component |
| DataClassification | CustomerContent |
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) |
| 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”))) |
| 5 | Line No. | Integer | — | |
| 11 | Item No. Δ BC28 | Code[20] | Specifies the item number of the component. | TableRelation Table 27 “Item” (Item where(Type = filter(Inventory | “Non-Inventory”))) |
| 12 | Description Δ BC28 | Text[100] | Specifies the description of the component. | |
| 13 | Unit of Measure Code Δ BC28 | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))) |
| 14 | Quantity Δ BC28 | Decimal | — | not editable |
| 15 | Position Δ BC28 | Code[10] | Specifies the position of the component on the bill of material. | |
| 16 | Position 2 Δ BC28 | Code[10] | Specifies the second reference number for the component position, such as the alternate position number of a component on a circuit board. | |
| 17 | Position 3 Δ BC28 | Code[10] | Specifies the third reference number for the component position on a bill of material, such as the alternate position number of a component on a print card. | |
| 18 | Lead-Time Offset Δ BC28 | DateFormula | Specifies the lead-time offset for the planning component. | |
| 21 | Variant Code Δ BC28 | Code[10] | Specifies the variant of the item on the line. | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”))) |
| 22 | Qty. Rounding Precision Δ BC28 | Decimal | — | not editable |
| 23 | Qty. Rounding Precision (Base) Δ BC28 | Decimal | — | not editable |
| 25 | Expected Quantity Δ BC28 | Decimal | Specifies the expected quantity of this planning component line. | not editable |
| 27 | Description 2 + BC28 | Text[50] | Specifies additional description text. | |
| 28 | Flushing Method − BC26 + BC27 | Enum Microsoft.Manufacturing.Setup.“Flushing Method” | — | enum Microsoft.Manufacturing.Setup.“Flushing Method” |
| 30 | Location Code Δ BC28 | Code[10] | Specifies the code for the inventory location, where the item on the planning component line will be registered. | TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false))) |
| 31 | 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))) |
| 32 | 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))) |
| 33 | Bin Code | Code[20] | — | TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”))) |
| 35 | Supplied-by 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”), “Line No.” = field(“Supplied-by Line No.”))) |
| 36 | Planning Level Code | Integer | — | not editable |
| 37 | Ref. Order Status Δ BC26 | Enum Microsoft.Manufacturing.Document.“Production Order Status” | — | enum Microsoft.Manufacturing.Document.“Production Order Status” |
| 38 | Ref. Order No. | Code[20] | — | |
| 39 | Ref. Order Line No. | Integer | — | |
| 40 | Length Δ BC28 | Decimal | Specifies the length of one item unit when measured in the specified unit of measure. | |
| 41 | Width Δ BC28 | Decimal | Specifies the width of one item unit when measured in the specified unit of measure. | |
| 42 | Weight Δ BC28 | Decimal | Specifies the weight of one item unit when measured in the specified unit of measure. | |
| 43 | Depth Δ BC28 | Decimal | Specifies the depth of one item unit when measured in the specified unit of measure. | |
| 44 | Calculation Formula Δ BC28 | Enum “Quantity Calculation Formula” | Specifies how to calculate the Quantity field. | enum Enum 5444 “Quantity Calculation Formula” |
| 45 | Quantity per Δ BC28 | Decimal | Specifies how many units of the component are required to produce the parent item. | |
| 46 | Ref. Order Type Δ BC25 | Enum “Requisition Ref. Order Type” | — | enum Enum 99000905 “Requisition Ref. Order Type”; not editable |
| 50 | Unit Cost Δ BC28 | Decimal | Specifies the cost of one unit of the item or resource on the line. | |
| 51 | Cost Amount Δ BC28 | Decimal | Specifies the total cost for this planning component line. | |
| 52 | Due Date Δ BC28 | Date | Specifies the date when this planning component must be finished. | |
| 53 | Due Time | Time | — | |
| 55 | Direct Unit Cost Δ BC28 | Decimal | — | |
| 56 | Indirect Cost % Δ BC28 | Decimal | — | |
| 57 | Overhead Rate Δ BC28 | Decimal | — | |
| 58 | Direct Cost Amount Δ BC28 | Decimal | — | |
| 59 | Overhead Amount Δ BC28 | Decimal | — | |
| 60 | Qty. per Unit of Measure Δ BC28 | Decimal | — | not editable |
| 62 | Quantity (Base) Δ BC28 | Decimal | Specifies the value in the Quantity field on the line. via Page 99000900 “Avail. - Planning Components” | |
| 63 | Reserved Qty. (Base) Δ BC28 | Decimal | Specifies the reserved quantity of the item, in base units of measure. via Page 99000900 “Avail. - Planning Components” | FlowField: - sum(“Reservation Entry”.“Quantity (Base)” where(“Source ID” = field(“Worksheet Template Name”), “Source Ref. No.” = field(“Line No.”), “Source Type” = const(99000829), “Source Subtype” = const(“0”), “Source Batch Name” = field(“Worksheet Batch Name”), “Source Prod. Order Line” = field(“Worksheet L…; not editable |
| 71 | Reserved Quantity Δ BC28 | Decimal | Specifies the quantity of units that are reserved. | FlowField: - sum(“Reservation Entry”.Quantity where(“Source ID” = field(“Worksheet Template Name”), “Source Ref. No.” = field(“Line No.”), “Source Type” = const(99000829), “Source Subtype” = const(“0”), “Source Batch Name” = field(“Worksheet Batch Name”), “Source Prod. Order Line” = field(“Worksheet Line No.”)…; not editable |
| 73 | Expected Quantity (Base) Δ BC28 | Decimal | Specifies the contents of the Expected Quantity field on the line, in base units of measure. via Page 99000861 “Planning Component List” | not editable |
| 74 | Original Expected Qty. (Base) Δ BC28 | Decimal | — | not editable |
| 75 | Net Quantity (Base) Δ BC28 | Decimal | — | not editable |
| 76 | Due Date-Time Δ BC28 | DateTime | Specifies the due date and the due time, which are combined in a format called “due date-time”. | |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 99000875 | Critical | Boolean | — | |
| 99000915 | Planning Line Origin | Enum “Planning Line Origin Type” | — | enum Enum 99000915 “Planning Line Origin Type”; not editable |
Keys
- Key1: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Line No. (clustered)
- Key2: Item No., Variant Code, Location Code, Due Date, Planning Line Origin
- Key3: Item No., Variant Code, Location Code, Shortcut Dimension 1 Code, Shortcut Dimension 2 Code, Planning Line Origin, Due Date
- Key4: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Item No.
Events published
OnAfterInitDefaultDimensionSources(var PlanningComponent: Record "Planning Component"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])(integration)OnAfterFilterLinesWithItemToPlan(var PlanningComponent: Record "Planning Component"; var Item: Record Item)(integration)- subscribers: Codeunit 20518 “Subc. Planning Line Mgmt Ext.” PlanningComponent_OnAfterFilterLinesWithItemToPlan
OnAfterGetItem(var Item: Record Item; var PlanningComponent: Record "Planning Component")(integration)OnAfterCreateDim(var PlanningComponent: Record "Planning Component"; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])(integration)OnAfterFindLinesForReservation(var PlanningComponent: Record "Planning Component"; ReservationEntry: Record "Reservation Entry"; AvailabilityFilter: Text; Positive: Boolean)(integration)OnAfterSetReservationFilters(var ReservEntry: Record "Reservation Entry"; PlanningComponent: Record "Planning Component")(integration)OnAfterTransferFromAsmLine(var PlanningComponent: Record "Planning Component"; AssemblyLine: Record "Assembly Line")(integration)OnAfterValidateShortcutDimCode(var PlanningComponent: Record "Planning Component"; var xPlanningComponent: Record "Planning Component"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnAfterValidateItemNo(var PlanningComponent: Record "Planning Component"; Item: Record Item)(integration)OnBeforeShowReservation(var PlanningComponent: Record "Planning Component"; var IsHandled: Boolean)(integration)OnBeforeValidateShortcutDimCode(var PlanningComponent: Record "Planning Component"; var xPlanningComponent: Record "Planning Component"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnBeforeValidateCalculationFormula(var PlanningComponent: Record "Planning Component"; var IsHandled: Boolean)(integration)OnBeforeGetUpdateFromSKU(var PlanningComponent: Record "Planning Component"; var IsHandled: Boolean)(integration)OnBeforeGetWMSDefaultBin(var PlanningComponent: Record "Planning Component"; var BinCode: Code[20]; var IsHandled: Boolean; Location: Record Location)(integration)OnItemNoOnValidateOnAfterInitFromItem(var PlanningComponent: Record "Planning Component"; Item: Record Item)(integration)OnValidateCalculationFormulaEnumExtension(var PlanningComponent: Record "Planning Component")(integration)OnValidateCalculationFormulaOnAfterSetQuantity(var PlanningComponent: Record "Planning Component")(integration)OnAfterInitFromRequisitionLine(var PlanningComponent: Record "Planning Component"; RequisitionLine: Record "Requisition Line")(integration)OnAfterGetUpdateFromSKU(var PlanningComponent: Record "Planning Component"; StockeepingUnit: Record "Stockkeeping Unit")+ BC26 (integration)- subscribers: Codeunit 99000861 “Mfg. Planning Integration” OnAfterGetUpdateFromSKU
OnAfterValidateCalculationFormula(var PlanningComponent: Record "Planning Component")+ BC26 (integration)- subscribers: Codeunit 99000861 “Mfg. Planning Integration” PlanningCompomentOnAfterValidateCalculationFormula
OnGetToBinOnBeforeGetWMSDefaultCode(var PlanningComponent: Record "Planning Component"; var BinCode: Code[20])+ BC26 (integration)- subscribers: Codeunit 99000861 “Mfg. Planning Integration” OnGetToBinOnBeforeGetWMSDefaultCode
OnBeforeGetDefaultBin(var PlanningComponent: Record "Planning Component"; var xPlanningComponent: Record "Planning Component"; var IsHandled: Boolean)+ BC26 (integration)
Trigger event subscribers
- OnAfterTransferFromComponent: Codeunit 20522 “Subc. Planning Comp. Ext.” OnAfterTransferFromComponent
- OnAfterValidateEvent(Bin Code): Codeunit 20522 “Subc. Planning Comp. Ext.” OnAfterValidateBinCode
- OnAfterValidateEvent(Location Code): Codeunit 20522 “Subc. Planning Comp. Ext.” OnAfterValidateLocationCode
- OnAfterValidateEvent(Routing Link Code): Codeunit 20522 “Subc. Planning Comp. Ext.” OnAfterValidateRoutingLinkCode
Procedures
Caption(): TextShowReservation(): BooleanShowReservationEntries(Modal: Boolean)TransferFromAsmLine(var AsmLine: Record "Assembly Line")BlockDynamicTracking(SetBlock: Boolean)UpdateDatetime()Δ BC26OpenItemTrackingLines()CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])GetGLSetup()Δ BC26GetItem()Δ BC26GetReqLine()Δ BC26GetLocation(LocationCode: Code[10])Δ BC26GetDefaultBin()GetRemainingQty(var RemainingQty: Decimal; var RemainingQtyBase: Decimal)GetReservationQty(var QtyReserved: Decimal; var QtyReservedBase: Decimal; var QtyToReserve: Decimal; var QtyToReserveBase: Decimal): DecimalGetSourceCaption(): TextSetReservationEntry(var ReservationEntry: Record "Reservation Entry")Δ BC26SetReservationFilters(var ReservationEntry: Record "Reservation Entry")Δ BC26ReservEntryExist(): BooleanFilterLinesWithItemToPlan(var Item2: Record Item)Δ BC26FindLinesWithItemToPlan(var Item2: Record Item): BooleanΔ BC26FindLinesForReservation(ReservationEntry: Record "Reservation Entry"; AvailabilityFilter: Text; Positive: Boolean)FindCurrForecastName(var ForecastName: Code[10]): Boolean− BC26 + BC27SetRequisitionLine(RequisitionLine: Record "Requisition Line")ShowDimensions()InitFromRequisitionLine(RequisitionLine: Record "Requisition Line")CreateDimFromDefaultDim()SelectMultipleItems()+ BC26: Opens a page for selecting multiple items to add to the document. Selected items are added to the document.AddItems(SelectionFilter: Text)+ BC26: Adds items to the document based on the provided selection filter.AddItem(var PlanningComponent: Record "Planning Component"; ItemNo: Code[20])+ BC26: Adds an item to the document.InitNewLine(var NewPlanningComponent: Record "Planning Component")+ BC26: Initializes a new Planning Component based on the current Planning Component.
Plus 5 local procedures.
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- drill-down page Page 99000861 “Planning Component List”
- lookup page Page 99000861 “Planning Component List”
- Location Code: TableRelation Table 14 “Location”
- Worksheet Template Name: TableRelation Table 244 “Req. Wksh. Template”
- Worksheet Batch Name: TableRelation Table 245 “Requisition Wksh. Name”
- Supplied-by Line No.: TableRelation Table 246 “Requisition Line”
- Worksheet Line No.: TableRelation Table 246 “Requisition Line”
- Item No.: TableRelation Table 27 “Item”
- Reserved Qty. (Base): CalcFormula Table 337 “Reservation Entry”
- Reserved Quantity: CalcFormula Table 337 “Reservation Entry”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
- Bin Code: TableRelation Table 7354 “Bin”
Referenced by
2 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 246 “Requisition Line”: Expected Component Cost Amt.
- Table 27 “Item”: Planning Issues (Qty.)
Pages and codeunits on this table
- Page 99000861 “Planning Component List” (source table)
- Page 99000862 “Planning Components” (source table)
- Page 99000900 “Avail. - Planning Components” (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 408 “DimensionManagement” (5 calls:
CreateDim → GetCombinedDimensionSetID,CreateDim → GetRecDefaultDimID,InitDefaultDimensionSources → AddDimSource, …) - Codeunit 99000840 “Plng. Component-Reserve” (5 calls:
BlockDynamicTracking → Block,OnDelete → DeleteLine,OnInsert → VerifyQuantity, …) - Codeunit 5402 “Unit of Measure Management” (1 call:
CalcBaseQty → CalcBaseQty) - Codeunit 7302 “WMS Management” (1 call:
GetWMSDefaultBin → GetDefaultBin) - Codeunit 99000855 “Planning-Get Parameters” (1 call:
GetUpdateFromSKU → AtSKU) - Page 497 “Reservation Entries” (1 call:
ShowReservationEntries → (object))
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 Component"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.