ODBC Driver for Oracle Fusion Cloud SCM

Build 26.0.9770

LotUnitOfMeasureConversions

Returns interclass unit of measure conversion rates for items assigned to inventory lots.

Columns

Name Type SupportedFinders Description
LotConversionId [KEY] Long PrimaryKey The unique identifier of the lot-specific conversion. This attribute is the primary key and is system generated.
InventoryItemId Long UomCurrentConversionFinder, UomHistoryFinder The unique identifier of the inventory item associated with the lot-specific conversion.
ItemNumber String The user-supplied name of the inventory item specifying the lot-specific conversion.
ItemDescription String The user-supplied description of the inventory item associated with the lot-specific conversion.
OrganizationId Long UomCurrentConversionFinder, UomHistoryFinder The unique identifier of the inventory organization associated with the lot-specific conversion.
OrganizationName String The user-supplied name of the inventory organization associated with the lot-specific conversion.
OrganizationCode String The user-supplied short code that uniquely identifies the inventory organization associated with the lot-specific conversion.
LotNumber String UomCurrentConversionFinder, UomHistoryFinder The number that uniquely identifies the lot for this conversion.
TransactionUOMBaseCode String The user-supplied short code of the base unit in the class of the secondary unit of measure for the item assigned to the lot.
TransactionUOMBaseName String The user-supplied name of the base unit in the class of the secondary unit of measure for the item assigned to the lot.
TransactionUOMClassCode String The user-supplied short code of the class of the secondary unit of measure for the item assigned to the lot.
TransactionUOMClassName String The user-supplied name of the class of the secondary unit of measure for the item assigned to the lot.
PrimaryUOMBaseCode String The user-supplied short code of the base unit in the class of the primary unit of measure for the item assigned to the lot.
PrimaryUOMBaseName String The user-supplied name of the base unit in the class of the primary unit of measure for the item assigned to the lot.
PrimaryUOMClassCode String The user-supplied short code of the class of the primary unit of measure for the item assigned to the lot.
PrimaryUOMClassName String The user-supplied name of the class of the primary unit of measure for the item assigned to the lot.
ConversionFactor Decimal The rate of conversion between the primary and secondary unit of measure classes for the item assigned to the inventory lot.
StartDatetime Datetime The start date and time of the lot conversion factor. Each update of the conversion factor ends the current definition and generates a new conversion with the system date and time as the start date and time.
EndDatetime Datetime The end date and time of the lot conversion factor. Each update of the conversion factor ends the current definition and generates a new conversion with the same value as the start date and time.
ReasonId Long The unique identifier of the transaction reason linked to the update of the lot-specific conversion.
ReasonName String The user-supplied name of the transaction reason associated with the update of the lot-specific conversion.
InverseConversionFlag Bool Indicates whether the conversion rate is modeled as an inverse quantity. Contains one of the following values: true or false. If true, the conversion factor represents the amount of secondary unit that equals one unit of the base unit. If false, the conversion factor represents one unit of the secondary unit converted to the corresponding amount of the base unit. The default value is false.
InverseConversionFactor Decimal The value inverted to determine the unit conversion rate.
Finder String The name of the finder method used to search and filter records.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770