ItemUnitOfMeasureConversion
Item unit of measure conversions specify all item-specific conversion factors between each eligible UOM for use in a transaction to the items primary UOM. For example, the item unit of measure conversion from the transactional unit of Box to the primary UOM of Each for item XYZ is 20, meaning 20 each in a box.
Label, Plural Label
Item UOM Conversion, Item UOM Conversions
Qualified Label, Qualified Plural Label
Item UOM Conversion, Item UOM Conversions
Module
oraScmCoreUnitOfMeasure
Keys
-
$primary: id (default)
-
altKey: inventoryItemId, primaryUOMCode, transactionUOMCode
Fields
* Field can't be null- conversionRate (big-decimal)*
Value that uniquely identifies the number of primary UOM units that equal a transaction unit. For example, 20 Each of item ABC are equal to a Box as the transaction unit of measure.
Label
Conversion Rate
Properties
- searchable
- not nullable
- createdBy (string)*
The user who created the record.
Label
Created By
Properties
- not nullable
- id (int64)*
Value that uniquely identifies the item-specific conversion between a transaction UOM to the primary UOM of that item. It's a value that the application generates when it creates the conversion.
Label
ID
Properties
- searchable
- sortable
- not nullable
- inventoryItemId (int64)*
Value that uniquely identifies the item that the conversion is defined for.
Label
Inventory Item ID
Properties
- searchable
- not nullable
- inverseConversionRate (big-decimal)
Value that uniquely identifies the number of transaction units that equal the primary unit of measure. For example, the inverse conversion for item ABC is equal to 0.05 as the inverse conversion rate.
Label
Inverse Conversion Rate
Properties
- searchable
- primaryUOMCode (string)*
Value that uniquely identifies the primary unit of measure of the item that the conversion is defined for.
Label
Primary UOM Code
Properties
- searchable
- not nullable
- timeCreated (date-time)*
The date and time when the record was created.
Label
Creation Date
Properties
- not nullable
- timeUpdated (date-time)*
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- not nullable
- transactionUOMCode (string)*
Value that uniquely identifies the transaction unit of measure that the conversion is defined for.
Label
Transaction UOM Code
Properties
- not nullable
- updatedBy (string)*
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
Reference Objects
- inventoryItem (object)
Object reference to the associated item that the conversion is defined for.
Label
Inventory Item
Cardinality Target Object One to One - Module: oraScmCoreProductMgmtItems
- Business Object: Item
Additional Mapping Details
Field in Current Object Field in Target Object inventoryItemId itemId - primaryUOM (object)
Object reference to the associated primary unit of measure of the item that the conversion is defined for.
Label
Primary UOM
Cardinality Target Object One to One - Module: oraScmCoreUnitOfMeasure
- Business Object: UnitOfMeasure
Additional Mapping Details
Field in Current Object Field in Target Object primaryUOMCode code - transactionUOM (object)
Object reference to the associated transaction unit of measure that the conversion is defined for.
Label
Transaction UOM
Cardinality Target Object One to One - Module: oraScmCoreUnitOfMeasure
- Business Object: UnitOfMeasure
Additional Mapping Details
Field in Current Object Field in Target Object transactionUOMCode code
Business Views
** Available for extracting data- default
Data Source
RDBMS
Fields
- id (int64)
Value that uniquely identifies the item-specific conversion between a transaction UOM to the primary UOM of that item. It's a value that the application generates when it creates the conversion.
Label
ID
Properties
- searchable
- sortable
- not nullable
- inventoryItemId (int64)
Value that uniquely identifies the item that the conversion is defined for.
Label
Inventory Item ID
Properties
- searchable
- not nullable
Reference Object
- primaryUOM (UnitOfMeasure)
Object reference to the associated primary unit of measure of the item that the conversion is defined for.
Business Object
UnitOfMeasureFields
- code (string)
User-supplied short code that identifies the unit of measure. This attribute is required.
Label
Code
Properties
- creatable
- searchable
- sortable
- not nullable
- id (int64)
Value that uniquely identifies the unit of measure. It's a value that the application generates when it creates a unit.
Label
ID
Properties
- creatable
- searchable
- sortable
- not nullable
- code (string)
- transactionUOM (UnitOfMeasure)
Object reference to the associated transaction unit of measure that the conversion is defined for.
Business Object
UnitOfMeasureFields
- code (string)
User-supplied short code that identifies the unit of measure. This attribute is required.
Label
Code
Properties
- creatable
- searchable
- sortable
- not nullable
- id (int64)
Value that uniquely identifies the unit of measure. It's a value that the application generates when it creates a unit.
Label
ID
Properties
- creatable
- searchable
- sortable
- not nullable
- code (string)
- id (int64)
- itemUnitOfMeasureConversionsExtract**
A view that gets UOM conversions. This view exposes all conversion information provided for supply chain application use.
Label
Item UOM Conversions
Data Source
Read-optimized data store
Fields
- conversionRate (big-decimal)
Value that uniquely identifies the number of primary UOM units that equal a transaction unit. For example, 20 Each of item ABC are equal to a Box as the transaction unit of measure.
Label
Conversion Rate
Properties
- searchable
- not nullable
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- id (int64)
Value that uniquely identifies the item-specific conversion between a transaction UOM to the primary UOM of that item. It's a value that the application generates when it creates the conversion.
Label
ID
Properties
- searchable
- sortable
- not nullable
- inventoryItemId (int64)
Value that uniquely identifies the item that the conversion is defined for.
Label
Inventory Item ID
Properties
- searchable
- not nullable
- inverseConversionRate (big-decimal)
Value that uniquely identifies the number of transaction units that equal the primary unit of measure. For example, the inverse conversion for item ABC is equal to 0.05 as the inverse conversion rate.
Label
Inverse Conversion Rate
Properties
- searchable
- primaryUOMCode (string)
Value that uniquely identifies the primary unit of measure of the item that the conversion is defined for.
Label
Primary UOM Code
Properties
- searchable
- not nullable
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- not nullable
- transactionUOMCode (string)
Value that uniquely identifies the transaction unit of measure that the conversion is defined for.
Label
Transaction UOM Code
Properties
- not nullable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- conversionRate (big-decimal)
Other Properties
| Property | Value |
|---|---|
| Application Package Name | ora_scm_core_unit_of_measure |
| Extensible | No |