Table 5404 "Item Unit of Measure"
Base Application · Microsoft.Inventory.Item
Across versions
- BC23present
- BC24declaration changed
- BC252 procedures added, 1 procedures removed
- BC262 procedures added, 2 procedures removed
- BC27unchanged
- BC2810 fields changed, 1 procedures added
- BC292 procedures removed, 2 events removed
- BC30unchanged
Neighbourhood 115 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 5404 “Item Units of Measure” (2 Learn pages), Page 5417 “Item Avail. by UOM Lines” (1).
Properties
| Property | Value |
|---|---|
| Caption | Item Unit of Measure |
| 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 | Item No. Δ BC28 | Code[20] | Specifies the number of the item card from which you opened the Item Units of Measure window. | TableRelation Table 27 “Item”; NotBlank |
| 2 | Code Δ BC28 | Code[10] | Specifies a code to identify the unit of measure. | TableRelation Table 204 “Unit of Measure” (Unit of Measure); NotBlank |
| 3 | Qty. per Unit of Measure Δ BC28 | Decimal | Specifies how many of the base unit of measure are contained in one unit of the item. | |
| 4 | Qty. Rounding Precision Δ BC28 | Decimal | — | |
| 721 | Coupled to Dataverse Δ BC28 | Boolean | Specifies that the item unit of measure is coupled to a unit of measure in Dynamics 365 Sales. | FlowField: exist(“CRM Integration Record” where(“Integration ID” = field(SystemId), “Table ID” = const(Database::“Item Unit of Measure”))) |
| 7300 | Length Δ BC28 | Decimal | Specifies the length of one item unit when measured in the specified unit of measure. | |
| 7301 | Width Δ BC28 | Decimal | Specifies the width of one item unit when measured in the specified unit of measure. | |
| 7302 | Height Δ BC28 | Decimal | Specifies the height of one item unit when measured in the unit of measure in the Code field. | |
| 7303 | Cubage Δ BC28 | Decimal | Specifies the volume (cubage) of one item unit in the unit of measure in the Code field. | |
| 7304 | Weight Δ BC28 | Decimal | Specifies the weight of one item unit when measured in the specified unit of measure. |
Keys
- Key1: Item No., Code (clustered)
- Key2: Item No., Qty. per Unit of Measure
- Key3: Code
Events published
OnAfterCalcCubage(var ItemUnitOfMeasure: Record "Item Unit of Measure")(integration)OnAfterCalcWeight(var ItemUnitOfMeasure: Record "Item Unit of Measure")(integration)OnAfterTestItemSetup(var Rec: Record "Item Unit of Measure"; xRec: Record "Item Unit of Measure")(integration)OnBeforeCalcCubage(var ItemUnitOfMeasure: Record "Item Unit of Measure"; var xItemUnitOfMeasure: Record "Item Unit of Measure"; var IsHandled: Boolean)(integration)OnBeforeCheckNoRemQtyAssemblyLine(ItemUnitOfMeasure: Record "Item Unit of Measure"; xItemUnitOfMeasure: Record "Item Unit of Measure"; var AssemblyLine: Record "Assembly Line"; var IsHandled: Boolean)(integration)OnBeforeCheckNoOutstandingQtySalesLine(ItemUnitOfMeasure: Record "Item Unit of Measure"; xItemUnitOfMeasure: Record "Item Unit of Measure"; var SalesLine: Record "Sales Line"; var IsHandled: Boolean)(integration)OnBeforeCheckNoRemQtyAssemblyHeader(ItemUnitOfMeasure: Record "Item Unit of Measure"; xItemUnitOfMeasure: Record "Item Unit of Measure"; var AssemblyHeader: Record "Assembly Header"; var IsHandled: Boolean)(integration)OnBeforeCheckNoOutstandingQtyPurchLine(ItemUnitOfMeasure: Record "Item Unit of Measure"; xItemUnitOfMeasure: Record "Item Unit of Measure"; var PurchaseLine: Record "Purchase Line"; var IsHandled: Boolean)(integration)OnBeforeCheckNoOutstandingQtyTransferLine(ItemUnitOfMeasure: Record "Item Unit of Measure"; xItemUnitOfMeasure: Record "Item Unit of Measure"; var TransferLine: Record "Transfer Line"; var IsHandled: Boolean)(integration)OnBeforeCheckQtyPerUoMPrecision(ItemUnitofMeasure: Record "Item Unit of Measure"; BaseRoundingPrecision: Decimal; var IsHandled: Boolean)(integration)OnBeforeTestNoWhseAdjmtEntriesExist(ItemUnitOfMeasure: Record "Item Unit of Measure"; var IsHandled: Boolean)(integration)OnAfterCheckNoOutstandingQty(ItemUnitOfMeasure: Record "Item Unit of Measure"; xItemUnitOfMeasure: Record "Item Unit of Measure")(integration)- subscribers: Codeunit 6480 “Serv. Item Unit of Measure” OnAfterCheckNoOutstandingQty, Codeunit 99000795 “Mfg. Item Integration” ItemUnitOfMeasureOnAfterCheckNoOutstandingQty
Trigger event subscribers
- OnBeforeModifyEvent: Codeunit 5402 “Unit of Measure Management” ClearItemUnitOfMeasureRec
Procedures
CalcWeight()+ BC28TestItemSetup()CheckNoEntriesWithUoM()GetCannotModifyUnitOfMeasureErr(): Text+ BC25CalcWeight(QtyPerUoM: Decimal; NetWeight: Decimal)+ BC28
Plus 11 local procedures.
Triggers
OnDelete, OnInsert, OnRename
Relations
- lookup page Page 5404 “Item Units of Measure”
- Code: TableRelation Table 204 “Unit of Measure”
- Item No.: TableRelation Table 27 “Item”
- Coupled to Dataverse: CalcFormula Table 5331 “CRM Integration Record”
Referenced by
133 fields in 104 objects relate to this table (TableRelation or CalcFormula).
- Table 27 “Item”: Purch. Unit of Measure, Put-away Unit of Measure Code, Sales Unit of Measure
- Table 111 “Sales Shipment Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 113 “Sales Invoice Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 115 “Sales Cr.Memo Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 121 “Purch. Rcpt. Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 123 “Purch. Inv. Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 125 “Purch. Cr. Memo Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 246 “Requisition Line”: Unit of Measure Code, Unit Of Measure Code (Demand)
- Table 37 “Sales Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 39 “Purchase Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 5108 “Sales Line Archive”: Item Reference Unit of Measure, Unit of Measure Code
- Table 5110 “Purchase Line Archive”: Item Reference Unit of Measure, Unit of Measure Code
- Table 5768 “Whse. Cross-Dock Opportunity”: To-Src. Unit of Measure Code, Unit of Measure Code
- Table 5851 “Invt. Document Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 5853 “Invt. Receipt Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 5855 “Invt. Shipment Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 5870 “BOM Buffer”: BOM Unit of Measure Code, Unit of Measure Code
- Table 5878 “Phys. Invt. Record Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 5902 “Service Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 5993 “Service Invoice Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 5995 “Service Cr.Memo Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 6012 “Service Line Archive”: Item Reference Unit of Measure, Unit of Measure Code
- Table 6651 “Return Shipment Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 6661 “Return Receipt Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 7302 “Bin Content”: Unit of Measure Code, Unit of Measure Filter
- Table 7326 “Whse. Worksheet Line”: From Unit of Measure Code, Unit of Measure Code
- Table 7330 “Bin Content Buffer”: Base Unit of Measure, Unit of Measure Code
- Table 83 “Item Journal Line”: Item Reference Unit of Measure, Unit of Measure Code
- Table 1003 “Job Planning Line”: Unit of Measure Code
- Table 1013 “Job Item Price”: Unit of Measure Code
- Table 1304 “Sales Price and Line Disc Buff”: Unit of Measure Code
- Table 1315 “Purch. Price Line Disc. Buff.”: Unit of Measure Code
- Table 169 “Job Ledger Entry”: Unit of Measure Code
- Table 171 “Standard Sales Line”: Unit of Measure Code
- Table 174 “Standard Purchase Line”: Unit of Measure Code
- Table 20500 “Subcontractor Price”: Unit of Measure Code
- Table 20560 “Subcontractor WIP Ledger Entry”: Base Unit of Measure
- Table 210 “Job Journal Line”: Unit of Measure Code
- Table 281 “Phys. Inventory Ledger Entry”: Unit of Measure Code
- Table 30119 “Shpfy Order Line”: Unit of Measure Code
- Table 32 “Item Ledger Entry”: Unit of Measure Code
- Table 346 “Reservation Wksh. Line”: Unit of Measure Code
- Table 4812 “Intrastat Report Line”: Suppl. Unit of Measure
- Table 5137 “Job Planning Line Archive”: Unit of Measure Code
- Table 5406 “Prod. Order Line”: Unit of Measure Code
- Table 5407 “Prod. Order Component”: Unit of Measure Code
- Table 5476 “Sales Invoice Line Aggregate”: Unit of Measure Code
- Table 5478 “Purch. Inv. Line Aggregate”: Unit of Measure Code
- Table 5520 “Unplanned Demand”: Unit of Measure Code
- Table 5700 “Stockkeeping Unit”: Put-away Unit of Measure Code
- and 54 more objects (54 fields): data/code/relations/29.json
Pages and codeunits on this table
- Page 5404 “Item Units of Measure” (source table)
- Page 5417 “Item Avail. by UOM Lines” (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: "Item Unit of Measure"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.