--- id: object/table/5715 type: object title: Table 5715 "Item Substitution" summary: Table 5715 "Item Substitution" in Base Application (Microsoft.Inventory.Item.Substitution). 15 fields, 3 public procedures, 3 events. Present since at least BC23, still in BC30, changed in BC24, BC28. tier: official language: en tags: - table - base application versions: introduced: null last_changed: "28" deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: 0efdb804bd8c5d40c6072ab2564365d8213500446d7efd9f1f35105b71bdf18d evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Item/Substitution/ItemSubstitution.Table.al title: src/Layers/W1/BaseApp/Inventory/Item/Substitution/ItemSubstitution.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: - https://learn.microsoft.com/dynamics365/business-central/inventory-how-register-new-items - https://learn.microsoft.com/dynamics365/business-central/inventory-item-variants - https://learn.microsoft.com/dynamics365/business-central/suggest-item-substitutions-copilot objects: [] features: [] topics: - topic/business-central/business-functionality/inventory - topic/business-central/business-functionality/set-up-business-central/set-up-inventory - topic/business-central/copilot-and-agent-capabilities/suggest-item-substitutions-preview localizations: [] videos: [] posts: [] guidelines: [] object_type: table object_id: 5715 name: Item Substitution namespace: Microsoft.Inventory.Item.Substitution app: Base Application extends: null first_version: "23" last_version: "30" present_in: - "23" - "24" - "25" - "26" - "27" - "28" - "29" - "30" changed_in: - "24" - "28" source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 15 procedures: 12 events: 3 subscribers: 0 relations: out: 9 referenced_by: 11 pages: 5 extended_by: 1 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 5715 "Item Substitution" > Table 5715 "Item Substitution" in Base Application (Microsoft.Inventory.Item.Substitution). 15 fields, 3 public procedures, 3 events. Present since at least BC23, still in BC30, changed in BC24, BC28. Base Application · Microsoft.Inventory.Item.Substitution · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Item/Substitution/ItemSubstitution.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 5716 "Item Substitution Entry"](../page/5716.md) (3 Learn pages), [Page 5718 "Item Substitution Entries"](../page/5718.md) (2), [Page 5720 "Item Substitutions"](../page/5720.md) (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"](../table/5718.md) (if (Type = const(Item)) Item."No." else if (Type = const("Nonstock Item")) "Nonstock Item"."Entry No."); NotBlank | | 2 | Variant Code | Code[10] | Specifies the variant of the item on the line. | TableRelation [Table 5401 "Item Variant"](../table/5401.md) ("Item Variant".Code where("Item No." = field("No."))) | | 3 | Substitute No. | 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"](../table/5718.md) (if ("Substitute Type" = const(Item)) Item."No." else if ("Substitute Type" = const("Nonstock Item")) "Nonstock Item"."Entry No."); NotBlank | | 4 | Substitute Variant Code | Code[10] | Specifies the code of the variant that can be used as a substitute. | TableRelation [Table 5401 "Item Variant"](../table/5401.md) (if ("Substitute Type" = const(Item)) "Item Variant".Code where("Item No." = field("Substitute No."))) | | 5 | Description | Text[100] | Specifies the description of the substitute item. | not editable | | 6 | Inventory | Decimal | Specifies how many units (such as pieces, boxes, or cans) of the item are available. | | | 7 | Interchangeable | Boolean | Specifies that the item and the substitute item are interchangeable. | | | 8 | Condition | 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"](../table/14.md); FlowFilter | | 100 | Type | Enum "Item Substitution Type" | — | enum [Enum 102 "Item Substitution Type"](../enum/102.md) | | 101 | Substitute Type | Enum "Item Substitute Type" | Specifies the type of the item that can be used as a substitute. | enum [Enum 101 "Item Substitute Type"](../enum/101.md) | | 102 | Sub. Item No. | 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 | Integer | Specifies the priority level of this substitute item. | not editable | | 104 | Quantity Avail. on Shpt. Date | Decimal | Specifies the substitute item quantity available on the shipment date. | | | 105 | Shipment Date | 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"](../page/5716.md) - lookup page [Page 5716 "Item Substitution Entry"](../page/5716.md) - Location Filter: TableRelation [Table 14 "Location"](../table/14.md) - Substitute Variant Code: TableRelation [Table 5401 "Item Variant"](../table/5401.md) - Variant Code: TableRelation [Table 5401 "Item Variant"](../table/5401.md) - Condition: CalcFormula [Table 5716 "Substitution Condition"](../table/5716.md) - Sub. Item No.: CalcFormula [Table 5718 "Nonstock Item"](../table/5718.md) - No.: TableRelation [Table 5718 "Nonstock Item"](../table/5718.md) (conditional) - Substitute No.: TableRelation [Table 5718 "Nonstock Item"](../table/5718.md) (conditional) ## Referenced by 11 fields in 7 objects relate to this table (TableRelation or CalcFormula). - [Table 5716 "Substitution Condition"](../table/5716.md): No., Substitute No., Substitute Variant Code, Variant Code - [Table 27 "Item"](../table/27.md): No. of Substitutes, Substitutes Exist - [Table 37 "Sales Line"](../table/37.md): Substitution Available - [Table 5108 "Sales Line Archive"](../table/5108.md): Substitution Available - [Table 5407 "Prod. Order Component"](../table/5407.md): Substitution Available - [Table 5902 "Service Line"](../table/5902.md): Substitution Available - [Table 901 "Assembly Line"](../table/901.md): Substitution Available ## Pages and codeunits on this table - [Page 5716 "Item Substitution Entry"](../page/5716.md) (source table) - [Page 5718 "Item Substitution Entries"](../page/5718.md) (source table) - [Page 5720 "Item Substitutions"](../page/5720.md) (source table) - [Page 5954 "Service Item Substitutions"](../page/5954.md) (source table) - [Page 7411 "Item Subst. Suggestion Sub"](../page/7411.md) (source table) ## Extended by - [Table extension 7410 "Item Subst. Suggestion"](../tableextension/7410.md) ## Across versions - Present in: BC23-30 - Changed (declaration) in: BC24, BC28 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). 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.