Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

UnitsOfMeasure

Defines and manages the units of measure that can be used in transactions across applications, ensuring consistency and compatibility.

Columns

Name Type Description
UOMId [KEY] Long Unique identifier for the unit of measure. This value is system-generated when a unit is created.
UOMCode String User-defined short code that uniquely identifies the unit of measure. This attribute is required.
UOMClass String Class that categorizes the unit of measure. Either this attribute or UOMClassName is required when creating a new unit. This value corresponds to the ClassId of the unitOfMeasureClasses instance.
UOMClassCode String The unique code representing the unit of measure class.
UOMClassName String Name of the class that categorizes the unit of measure. Either this attribute or UOMClass is required when creating a new unit.
UOM String The name of the unit of measure. This attribute is required.
Description String A brief description of the unit of measure.
UOMReciprocalDescription String Explains how the unit of measure is processed when used in a reciprocal calculation. For example, 'Per Month' describes the reciprocal for a service measured in 'Month'.
UOMPluralDescription String The plural form of the unit of measure. For example, 'Feet' is the plural for 'Foot'.
BaseUnitFlag Bool Indicates whether this unit is the base unit of its class. 'True' means it is the base unit (typically the smallest unit in the class); 'False' means it is not. All conversions within a class occur through the base unit. Default is 'False'.
DisableDate Date The date when the unit of measure becomes inactive and is no longer used.
StandardConversion Decimal Conversion rate between this unit of measure and the base unit of its class. This attribute is required.
StandardConversionEndDate Date The date when the standard conversion for this unit of measure is no longer valid.
GlobalAttributeCategory String Specifies additional attributes for global extensions related to the unit of measure.
OkeiCode String The international OKEI code assigned to the unit of measure, used for global standardization.
DerivedUnitParentCode String The code of the parent unit if this unit is derived from another unit.
CreatedBy String Username or system entity that created this unit of measure entry.
CreationDate Datetime Timestamp indicating when this unit of measure entry was initially created.
LastUpdateDate Datetime Timestamp indicating when this unit of measure entry was last updated.
LastUpdatedBy String Username or system entity that last modified this unit of measure entry.
Finder String A system-defined query or lookup used to retrieve unit of measure records.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175