Table 7501 "Item Attribute Value"

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

Properties

Property	Value
Caption	Item Attribute Value
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	Attribute ID	Integer	—	TableRelation Table 7500 “Item Attribute” (“Item Attribute”.ID where(Blocked = const(false))); NotBlank
2	ID	Integer	—	AutoIncrement
3	Value Δ BC28	Text[250]	Specifies the value of the item attribute.
4	Numeric Value Δ BC28	Decimal	—
5	Date Value	Date	—
6	Blocked Δ BC28	Boolean	Specifies that the attribute value cannot be assigned to an item. Items to which the attribute value is already assigned are not affected.
10	Attribute Name Δ BC24 Δ BC28	Text[250]	Specifies the name of the item attribute.	FlowField: lookup(“Item Attribute”.Name where(ID = field(“Attribute ID”)))

Keys

Key1: Attribute ID, ID (clustered)
Key2: Value

Events published

OnAfterGetValueInCurrentLanguage(ItemAttributeValue: Record "Item Attribute Value"; var ValueTxt: Text[250]) (integration)
OnAfterHasBeenUsed(ItemAttributeValue: Record "Item Attribute Value"; var AttributeHasBeenUsed: Boolean) (integration)
OnBeforeSetValueFilter(var ItemAttributeValue: Record "Item Attribute Value"; ItemAttribute: Record "Item Attribute"; FilterText: Text; var IsHandled: Boolean) (integration)
OnGetValueInCurrentLanguage(ItemAttribute: Record "Item Attribute"; var ItemAttributeValue: Record "Item Attribute Value") (integration)
OnLoadItemAttributesFactBoxDataOnBeforeInsert(var ItemAttributeValueMapping: Record "Item Attribute Value Mapping"; var ItemAttributeValue: Record "Item Attribute Value") (integration)

Procedures

LookupAttributeValue(AttributeID: Integer; var AttributeValueID: Integer)
GetAttributeNameInCurrentLanguage(): Text[250]
GetValueInCurrentLanguage(): Text[250]
GetValueInCurrentLanguageWithoutUnitOfMeasure(): Text[250]
GetTranslatedName(LanguageID: Integer): Text[250]
GetTranslatedNameByLanguageCode(LanguageCode: Code[10]): Text[250]
HasBeenUsed(): Boolean
SetValueFilter(var ItemAttribute: Record "Item Attribute"; FilterText: Text)
LoadItemAttributesFactBoxData(KeyValue: Code[20])
LoadCategoryAttributesFactBoxData(CategoryCode: Code[20])
LoadItemVariantAttributesFactBoxData(ItemNo: Code[20]; VariantCode: Code[10]) + BC28
AttributeExists(AttributeID: Integer): Boolean

Plus 4 local procedures.

Triggers

OnDelete

Relations

lookup page Page 7501 “Item Attribute Values”
Attribute Name: CalcFormula Table 7500 “Item Attribute”
Attribute ID: TableRelation Table 7500 “Item Attribute”

Referenced by

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

Table 7505 “Item Attribute Value Mapping”: Item Attribute Value ID
Table 7507 “Item Var. Attr. Value Mapping”: Item Attribute Value ID

Pages and codeunits on this table

Page 7501 “Item Attribute Values” (source table)
Page 7508 “Select Item Attribute Value” (source table)
Page 8012 “Service Object Attr. Factbox” (source table)
Page 9110 “Item Attributes Factbox” (source table)

Extended by

Table extension 8005 “Item Attribute Value”

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 43 “Language” (1 call: GetTranslatedName → GetLanguageCode)

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