Table 5401 "Item Variant"
Base Application · Microsoft.Inventory.Item
Across versions
- BC23present
- BC241 fields added
- BC253 fields changed, 1 events added
- BC261 procedures removed, 1 events added
- BC27unchanged
- BC288 fields changed, 3 events added
- BC29-30unchanged
Neighbourhood 169 connected objects and pages
Base Application · Microsoft.Inventory.Item · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 30052 “APIV2 - Item Variants” (5 Learn pages), Page 5401 “Item Variants” (2), Page 5415 “Item Avail. by Variant Lines” (1).
Properties
| Property | Value |
|---|---|
| Caption | Item Variant |
| 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 | Code Δ BC25 Δ BC28 | Code[10] | Specifies a code to identify the variant. | NotBlank |
| 2 | Item No. Δ BC28 | Code[20] | Specifies the number of the item card from which you opened the Item Variant Translations window. | TableRelation Table 27 “Item” |
| 3 | Description Δ BC25 Δ BC28 | Text[100] | Specifies text that describes the item variant. | |
| 4 | Description 2 Δ BC25 Δ BC28 | Text[50] | Specifies the item variant in more detail than the Description field. | |
| 5 | Item Id | Guid | — | TableRelation Item.SystemId |
| 54 | Blocked Δ BC28 | Boolean | Specifies that the related record is blocked from being posted in transactions, for example an item variant that is placed in quarantine. | |
| 92 | Picture + BC28 | MediaSet | Specifies the picture that has been inserted for the item variant. | |
| 8003 | Sales Blocked Δ BC28 | Boolean | Specifies that the item variant cannot be entered on sales documents, except return orders and credit memos, and journals. | |
| 8004 | Purchasing Blocked Δ BC28 | Boolean | Specifies that the item variant cannot be entered on purchase documents, except return orders and credit memos, and journals. | |
| 8010 | Service Blocked + BC24 Δ BC28 | Boolean | Specifies that the item variant cannot be entered on service items, service contracts and service documents, except credit memos. |
Keys
- Key1: Item No., Code (clustered)
- Key2: Code
- Key3: Description
- Key4: Item Id, Code
Events published
OnAfterOnDelete(ItemVariant: Record "Item Variant")+ BC25 (integration)- subscribers: Codeunit 5920 “ServItemManagement” ItemVariantOnAfterOnDelete
OnDeleteOnAfterCheck(var ItemVariant: Record "Item Variant")+ BC26 (integration)- subscribers: Codeunit 99000795 “Mfg. Item Integration” ItemVariantOnDeleteOnAfterCheck
OnAfterDeleteItemVariantPicture(var ItemVariant: Record "Item Variant")+ BC28 (integration)OnAfterTakeNewPicture(var ItemVariant: Record "Item Variant"; IsPictureAdded: Boolean)+ BC28 (integration)OnImportFromDeviceOnAfterModify(var ItemVariant: Record "Item Variant")+ BC28 (integration)
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 7006 “Price Helper - V16” AfterDeleteItemVariant, Codeunit 7019 “Price Helper - V15” AfterDeleteItemVariant
- OnAfterRenameEvent: Codeunit 7006 “Price Helper - V16” AfterRenameItemVariant
- OnBeforeInsertEvent: Codeunit 5152 “API - Update Referenced Fields” UpdateReferencedIdsItemVariantOnInsert
- OnBeforeRenameEvent: Codeunit 5152 “API - Update Referenced Fields” UpdateReferencedIdsItemVariantOnRename, Codeunit 99000795 “Mfg. Item Integration” OnBeforeRenameItemVariant
Procedures
UpdateReferencedIds()
Plus 1 local procedures.
Triggers
OnInsert, OnRename, OnDelete
Relations
- lookup page Page 5401 “Item Variants”
- Item No.: TableRelation Table 27 “Item”
Referenced by
158 fields in 146 objects relate to this table (TableRelation or CalcFormula).
- Table 246 “Requisition Line”: Original Variant Code, Variant Code
- Table 32 “Item Ledger Entry”: Originally Ordered Var. Code, Variant Code
- Table 37 “Sales Line”: Originally Ordered Var. Code, Variant Code
- Table 5108 “Sales Line Archive”: Originally Ordered Var. Code, Variant Code
- Table 5407 “Prod. Order Component”: Original Variant Code, Variant Code
- Table 5476 “Sales Invoice Line Aggregate”: Variant Code, Variant Id
- Table 5478 “Purch. Inv. Line Aggregate”: Variant Code, Variant Id
- Table 5715 “Item Substitution”: Substitute Variant Code, Variant Code
- Table 5907 “Service Ledger Entry”: Variant Code, Variant Code (Serviced)
- Table 5908 “Warranty Ledger Entry”: Variant Code, Variant Code (Serviced)
- Table 753 “Standard Item Journal Line”: Originally Ordered Var. Code, Variant Code
- Table 83 “Item Journal Line”: Originally Ordered Var. Code, Variant Code
- Table 1003 “Job Planning Line”: Variant Code
- Table 1013 “Job Item Price”: Variant Code
- Table 111 “Sales Shipment Line”: Variant Code
- Table 113 “Sales Invoice Line”: Variant Code
- Table 115 “Sales Cr.Memo Line”: Variant Code
- Table 121 “Purch. Rcpt. Line”: Variant Code
- Table 123 “Purch. Inv. Line”: Variant Code
- Table 125 “Purch. Cr. Memo Line”: Variant Code
- Table 1304 “Sales Price and Line Disc Buff”: Variant Code
- Table 1315 “Purch. Price Line Disc. Buff.”: Variant Code
- Table 169 “Job Ledger Entry”: Variant Code
- Table 171 “Standard Sales Line”: Variant Code
- Table 174 “Standard Purchase Line”: Variant Code
- Table 20405 “Qlty. Inspection Header”: Source Variant Code
- Table 20500 “Subcontractor Price”: Variant Code
- Table 20560 “Subcontractor WIP Ledger Entry”: Variant Code
- Table 210 “Job Journal Line”: Variant Code
- Table 27 “Item”: Variant Filter
- Table 281 “Phys. Inventory Ledger Entry”: Variant Code
- Table 2900 “Forecast Item Variant Loc”: Variant Filter
- Table 30 “Item Translation”: Variant Code
- Table 30119 “Shpfy Order Line”: Variant Code
- Table 30129 “Shpfy Variant”: Variant Code
- Table 307 “Inventory Buffer”: Variant Code
- Table 336 “Tracking Specification”: Variant Code
- Table 337 “Reservation Entry”: Variant Code
- Table 346 “Reservation Wksh. Line”: Variant Code
- Table 39 “Purchase Line”: Variant Code
- Table 5110 “Purchase Line Archive”: Variant Code
- Table 5137 “Job Planning Line Archive”: Variant Code
- Table 520 “Availability Info. Buffer”: Variant Code Filter
- Table 5405 “Production Order”: Variant Code
- Table 5406 “Prod. Order Line”: Variant Code
- Table 5530 “Inventory Event Buffer”: Variant Code
- Table 5531 “Inventory Page Data”: Variant Code
- Table 5700 “Stockkeeping Unit”: Variant Code
- Table 5701 “Stockkeeping Unit Comment Line”: Variant Code
- Table 5741 “Transfer Line”: Variant Code
- and 96 more objects (96 fields): data/code/relations/29.json
Pages and codeunits on this table
- Page 20052 “APIV1 - Item Variants” (source table)
- Page 30052 “APIV2 - Item Variants” (source table)
- Page 409 “Item Variant Picture” (source table)
- Page 5401 “Item Variants” (source table)
- Page 5405 “Item Variant Card” (source table)
- Page 5415 “Item Avail. by Variant Lines” (source table)
- Page 7511 “Item Variant Attribute Editor” (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 7500 “Item Attribute Management” (1 call:
OnInsert → InheritAttributesFromItem)
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: "Item Variant"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.