Table 5715 "Item Substitution"

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

Learn documents this table through its pages: Page 5716 “Item Substitution Entry” (3 Learn pages), Page 5718 “Item Substitution Entries” (2), Page 5720 “Item Substitutions” (2).

Properties

Property	Value
Caption	Item Substitution
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	No.	Code[20]	—	TableRelation Table 5718 “Nonstock Item” (if (Type = const(Item)) Item.“No.” else if (Type = const(“Nonstock Item”)) “Nonstock Item”.“Entry No.”); NotBlank
2	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(“No.”)))
3	Substitute No. Δ BC28	Code[20]	Specifies the number of the item that can be used as a substitute in case the original item is unavailable.	TableRelation Table 5718 “Nonstock Item” (if (“Substitute Type” = const(Item)) Item.“No.” else if (“Substitute Type” = const(“Nonstock Item”)) “Nonstock Item”.“Entry No.”); NotBlank
4	Substitute Variant Code Δ BC28	Code[10]	Specifies the code of the variant that can be used as a substitute.	TableRelation Table 5401 “Item Variant” (if (“Substitute Type” = const(Item)) “Item Variant”.Code where(“Item No.” = field(“Substitute No.”)))
5	Description Δ BC28	Text[100]	Specifies the description of the substitute item.	not editable
6	Inventory Δ BC28	Decimal	Specifies how many units (such as pieces, boxes, or cans) of the item are available.
7	Interchangeable Δ BC28	Boolean	Specifies that the item and the substitute item are interchangeable.
8	Condition Δ BC28	Boolean	Specifies that a condition exists for this substitution.	FlowField: exist(“Substitution Condition” where(Type = field(Type), “No.” = field(“No.”), “Variant Code” = field(“Variant Code”), “Substitute Type” = field(“Substitute Type”), “Substitute No.” = field(“Substitute No.”), “Substitute Variant Code” = field(“Substitute Variant Code”))); not editable
9	Location Filter	Code[10]	—	TableRelation Table 14 “Location”; FlowFilter
100	Type	Enum “Item Substitution Type”	—	enum Enum 102 “Item Substitution Type”
101	Substitute Type Δ BC28	Enum “Item Substitute Type”	Specifies the type of the item that can be used as a substitute.	enum Enum 101 “Item Substitute Type”
102	Sub. Item No. Δ BC24 Δ BC28	Code[20]	Specifies the item number of the catalog substitute item.	FlowField: lookup(“Nonstock Item”.“Item No.” where(“Entry No.” = field(“Substitute No.”))); not editable
103	Relations Level Δ BC28	Integer	Specifies the priority level of this substitute item.	not editable
104	Quantity Avail. on Shpt. Date Δ BC28	Decimal	Specifies the substitute item quantity available on the shipment date.
105	Shipment Date Δ BC28	Date	Specifies when items on the document are shipped or were shipped. A shipment date is usually calculated from a requested delivery date plus lead time.

Keys

Key1: Type, No., Variant Code, Substitute Type, Substitute No., Substitute Variant Code (clustered)

Events published

OnAfterSetItemVariantDescription(Type: Integer; Number: Code[20]; Variant: Code[10]; var Description: Text[100]) (integration)
OnBeforeConfirmDeletion(var ItemSubstitution: Record "Item Substitution"; xItemSubstitution: Record "Item Substitution"; var Result: Boolean; var IsHandled: Boolean) (integration)
OnCreateInterchangeableItemOnBeforeInsertOrModifyItemSubstitution(var RecItemSubstitution: Record "Item Substitution"; xRecItemSubstitution: Record "Item Substitution"; var ItemSubstitution: Record "Item Substitution") (integration)

Procedures

CreateSubstitutionItem2Item(ItemNo1: Code[20]; Variant1: Code[10]; ItemNo2: Code[20]; Variant2: Code[10]; Substitutable: Boolean)
SetDescription(Type: Integer; Number: Code[20]; var Description: Text[100])
SetItemVariantDescription(Type: Integer; Number: Code[20]; Variant: Code[10]; var Description: Text[100])

Plus 6 local procedures.

Triggers

OnDelete

Relations

drill-down page Page 5716 “Item Substitution Entry”
lookup page Page 5716 “Item Substitution Entry”
Location Filter: TableRelation Table 14 “Location”
Substitute Variant Code: TableRelation Table 5401 “Item Variant”
Variant Code: TableRelation Table 5401 “Item Variant”
Condition: CalcFormula Table 5716 “Substitution Condition”
Sub. Item No.: CalcFormula Table 5718 “Nonstock Item”
No.: TableRelation Table 5718 “Nonstock Item” (conditional)
Substitute No.: TableRelation Table 5718 “Nonstock Item” (conditional)

Referenced by

11 fields in 7 objects relate to this table (TableRelation or CalcFormula).

Table 5716 “Substitution Condition”: No., Substitute No., Substitute Variant Code, Variant Code
Table 27 “Item”: No. of Substitutes, Substitutes Exist
Table 37 “Sales Line”: Substitution Available
Table 5108 “Sales Line Archive”: Substitution Available
Table 5407 “Prod. Order Component”: Substitution Available
Table 5902 “Service Line”: Substitution Available
Table 901 “Assembly Line”: Substitution Available

Pages and codeunits on this table

Page 5716 “Item Substitution Entry” (source table)
Page 5718 “Item Substitution Entries” (source table)
Page 5720 “Item Substitutions” (source table)
Page 5954 “Service Item Substitutions” (source table)
Page 7411 “Item Subst. Suggestion Sub” (source table)

Extended by

Table extension 7410 “Item Subst. Suggestion”

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