Oracle Inventory Unit Of Measure

rehcmzotku

UOM Tables Relationship



Units Of Measure Form

Form:INVSDUOM.fmb
Table:MTL_UNITS_OF_MEASURE
MTL_UNITS_OF_MEASUREisthedefinitiontableforboththe25-character andthe3-characterunitsofmeasure.
Thebase_uom_flagindicatesiftheunitofmeasureistheprimaryunit ofmeasurefortheuom_class.
OracleInventoryusesthistablekeeptrackoftheunitsofmeasure thancanbeusedtotransactanitem.Thistableisalsousedby OraclePurchasing,andOracleOrderEntry/Shipping.



Unit Of Measure Classes
Form:INVSDOCL.fmb
Table:MTL_UOM_CLASSES
MTL_UOM_CLASSESisthedefinitionoftheunitofmeasureclasses.A classisacategorytowhichunitsofmeasureareassigned.
OracleInventorydefinesthistable,anditisusedbyOracle PurchasingandOracleOrderEntry/Shipping.

Unit Of Measure Conversions
Form:INVSDOUC.fmb
Table1:MTL_UOM_CONVERSIONS
MTL_UOM_CONVERSIONSstoresconversionratesbetweennon-baseunitsof measureandtheirbaseunit.Thenon-baseunitsofmeasureare storedinthetable.
Thedefault_conversion_flagindicatesthattheconversionbeing definedis
1)associatedwithaspecificitemand
2)theconversion betweenunitsofmeasurehasalreadybeendefinedasastandard conversionwiththesameconversionrate.

Table2:MTL_UOM_CLASS_CONVERSIONS
MTL_UOM_CLASS_CONVERSIONSiswhereconversionsbetweenbaseunitsof measurearedefinedforanitem.Abaseunitofmeasureistheprimary unitforaclass.

Intra-Class VS Inter-Class
Under Intra-class And Standard Tab,User can only define conversation within same class;
Under Inter-class tab, you can define conversation between different base uom which in different UOM class;