Table 99000855 "Untracked Planning Element"

Base Application · Microsoft.Inventory.Planning · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 9101 “Untracked Plng. Elements Part” (1 Learn page), Page 99000855 “Untracked Planning Elements” (1).

Properties

Property	Value
Caption	Untracked Planning Element
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); not editable
2	Worksheet Batch Name	Code[10]	—	TableRelation Table 245 “Requisition Wksh. Name” (“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	Track Line No.	Integer	—
11	Item No. Δ BC28	Code[20]	Specifies the number of the item in the requisition line for which untracked planning surplus exists.	TableRelation Table 27 “Item”
12	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.”), Code = field(“Variant Code”)))
13	Location Code Δ BC28	Code[10]	Specifies the location code in the requisition line associated with the untracked planning surplus.	TableRelation Table 14 “Location”
21	Source Type	Integer	—
23	Source ID Δ BC28	Code[20]	Specifies the identification code for the source of the untracked planning quantity.
70	Parameter Value Δ BC28	Decimal	Specifies the value of this planning parameter.
71	Untracked Quantity Δ BC28	Decimal	Specifies how much this planning parameter contributed to the total surplus quantity.
72	Track Quantity From Δ BC28	Decimal	Specifies how much the total surplus quantity is, including the quantity from this entry.
73	Track Quantity To Δ BC28	Decimal	Specifies what the surplus quantity would be without the quantity from this entry.
74	Source Δ BC28	Text[200]	Specifies what the source of this untracked surplus quantity is.
75	Warning Level	Option	—	OptionCaption: ,Emergency,Exception,Attention

Keys

Key1: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Track Line No. (clustered)

Relations

Location Code: TableRelation Table 14 “Location”
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”
Item No.: TableRelation Table 27 “Item”
Variant Code: TableRelation Table 5401 “Item Variant”

Pages and codeunits on this table

Page 9101 “Untracked Plng. Elements Part” (source table)
Page 99000855 “Untracked Planning Elements” (source table)

Ask your agent

Procedure bodies are not stored here (D10). 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: "Untracked Planning Element"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.