Table 9152 "My Item"
Base Application · Microsoft.Inventory.Item
Across versions
- BC23present
- BC24declaration changed
- BC25-27unchanged
- BC284 fields changed
- BC29-30unchanged
Neighbourhood 3 connected objects and pages
Base Application · Microsoft.Inventory.Item · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | My Item |
| 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 | User ID | Code[50] | — | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 2 | Item No. Δ BC28 | Code[20] | Specifies the item numbers that are displayed in the My Item Cue on the Role Center. | TableRelation Table 27 “Item”; NotBlank |
| 3 | Description Δ BC28 | Text[100] | Specifies a description of the item. | not editable |
| 4 | Unit Price Δ BC28 | Decimal | Specifies the item’s unit price. | not editable |
| 5 | Inventory Δ BC28 | Decimal | Specifies the inventory quantities of my items. | FlowField: sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“Item No.”))); not editable |
Keys
- Key1: User ID, Item No. (clustered)
- Key2: Description
- Key3: Unit Price
Procedures
1 local procedures, no public ones.
Relations
- Item No.: TableRelation Table 27 “Item”
- Inventory: CalcFormula Table 32 “Item Ledger Entry”
Pages and codeunits on this table
- Page 9152 “My Items” (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: "My Item"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.