Excel Add-In for Oracle Fusion Cloud SCM

Build 23.0.8839

UnitsOfMeasure

UnitsOfMeasure

Columns

Name Type Description
UOMId [KEY] Long Value that uniquely identifies the unit of measure. It is a value that the application generates when it creates a unit.
UOMCode String User-supplied short code that identifies the unit of measure. This attribute is required.
UOMClass String Class that categorizes the unit of measure. Either this attribute or the UOMClassName is required when creating a new unit. The value of this attribute is the value of the ClassId attribute of the unitOfMeasureClasses instance.
UOMClassName String Name of the class that categorizes the unit of measure. Either this attribute or the UOMClass is required when creating a new unit.
UOM String Name of the unit of measure. This attribute is required.
Description String Description of the unit of measure.
UOMReciprocalDescription String Description of how to process the unit of measure so that the quantity that results from dividing it equals one. For example: Per Month is the reciprocal display for a service that uses the Month unit of measure.
UOMPluralDescription String Description of the plural value of the unit of measure. For example: Feet is the plural value for the Foot unit of measure.
BaseUnitFlag Bool Contains one of the following values: true or false. If true, then the unit of measure is the base unit of the class, typically the smallest unit within the class. If false, then the unit is not the base unit. All conversions within a class are made through the base unit. The default value is false.
DisableDate Date Date when the unit of measure is no longer active.
StandardConversion Double Rate of conversion between the unit of measure and the base unit of the class. This attribute is required.
StandardConversionEndDate Date Date when the standard conversion for the unit of measure is no longer active.
GlobalAttributeCategory String GlobalAttributeCategory of UnitsOfMeasure
OkeiCode String OkeiCode of UnitsOfMeasure
DerivedUnitParentCode String DerivedUnitParentCode of UnitsOfMeasure
CreatedBy String CreatedBy of UnitsOfMeasure
CreationDate Datetime CreationDate of UnitsOfMeasure
LastUpdateDate Datetime LastUpdateDate of UnitsOfMeasure
LastUpdatedBy String LastUpdatedBy of UnitsOfMeasure

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839