Unit Of Measure UOM in Oracle Applications Inventory

最新推荐文章于 2022-05-22 09:47:40 发布

弱弱的羊羔

最新推荐文章于 2022-05-22 09:47:40 发布

阅读量337

点赞数

本文链接：https://blog.csdn.net/hsghggt/article/details/83855714

版权

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

UOM Tables Relationship

Units Of Measure Form

Form: INVSDUOM.fmb

Table: MTL_UNITS_OF_MEASURE

MTL_UNITS_OF_MEASURE is the definition table for both the 25-character and the 3-character units of measure.
The base_uom_flag indicates if the unit of measure is the primary unit of measure for the uom_class.
Oracle Inventory uses this table keep track of the units of measure than can be used to transact an item. This table is also used by Oracle Purchasing, and Oracle Order Entry/Shipping.

Unit Of Measure Classes

Form:INVSDOCL.fmb
Table: MTL_UOM_CLASSES
MTL_UOM_CLASSES is the definition of the unit of measure classes. A class is a category to which units of measure are assigned.
Oracle Inventory defines this table, and it is used by Oracle Purchasing and Oracle Order Entry/Shipping.

Unit Of Measure Conversions

Form: INVSDOUC.fmb
Table1: MTL_UOM_CONVERSIONS
MTL_UOM_CONVERSIONS stores conversion rates between non-base units of measure and their base unit. The non-base units of measure are stored in the table.
The default_conversion_flag indicates that the conversion being defined is
1) associated with a specific item and
2) the conversion between units of measure has already been defined as a standard conversion with the same conversion rate.

Table2: MTL_UOM_CLASS_CONVERSIONS
MTL_UOM_CLASS_CONVERSIONS is where conversions between base units of measure are defined for an item. A base unit of measure is the primary unit for a class.

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;

Lot Inter-Class Unit of Measure Conversions

Form:INVSDLUC.fmb
Table:MTL_LOT_UOM_CLASS_CONVERSIONS
Conversion between the Base UOMs of two different UOM classes specific to an Item and Lot (Organization Specific).

Unit of Measure conversions in Transactions

Each Transaction involves three units of measure -

§ Transaction UOM

§ Primary UOM

§ Secondary UOM

It should be clarified that although there could be three units of measures on a transaction, the onhand quantity is always stored in the primary UoM.

o The simplest case of UOM Conversion in Transactions is - All the Three UOMs belong to the same UOM Class (assume that none of them are base UOM). This case requires three conversions -

1. Convert Transaction UOM to Base UOM

2. Convert Base UOM to Primary UOM

3. Convert Base UOM to Secondary UOM

o Most Complex Case of UOM Conversion in Transactions is- Each of the Three UOMs belong to different UOM Classes –

- - Transaction UOM belongs to UOM Class T
  - Primary UOM belongs to UOM Class P
  - Secondary UOM belongs to UOM Class S

For such a case, it requires five conversions -

1. Convert Transaction UOM in Class T to Base UOMin Class T

2. Convert Base UOM in Class T to Base UOM in ClassP

3. Convert Base UOM in Class P to Primary UOM inClass P (this gives Primary UOM)

4. Convert Base UOM in Class P to Base UOM in Base UOM in Class S

5. ConvertBase UOM in Class S to Secondary UOM inClass S (this gives Secondary UOM)

From the Two cases, it is evident that a conversion from Transaction UOM to Secondary UOM requires a minimum of two conversions (in simplest case)to a maximum of 4 conversions (in complex case) and after each conversion, the result might potentially be rounded to inventory rounding (5 digits).

给我老师的人工智能教程打call！http://blog.csdn.net/jiangjunshow

你好！这是你第一次使用 **Markdown编辑器** 所展示的欢迎页。如果你想学习如何使用Markdown编辑器, 可以仔细阅读这篇文章，了解一下Markdown的基本语法知识。

新的改变

我们对Markdown编辑器进行了一些功能拓展与语法支持，除了标准的Markdown编辑器功能，我们增加了如下几点新功能，帮助你用它写博客：

全新的界面设计 ，将会带来全新的写作体验；
在创作中心设置你喜爱的代码高亮样式，Markdown 将代码片显示选择的高亮样式 进行展示；
增加了 图片拖拽 功能，你可以将本地的图片直接拖拽到编辑区域直接展示；
全新的 KaTeX数学公式 语法；
增加了支持甘特图的mermaid语法¹ 功能；
增加了 多屏幕编辑 Markdown文章功能；
增加了 焦点写作模式、预览模式、简洁写作模式、左右区域同步滚轮设置 等功能，功能按钮位于编辑区域与预览区域中间；
增加了 检查列表 功能。

功能快捷键

撤销：Ctrl/Command + Z
重做：Ctrl/Command + Y
加粗：Ctrl/Command + B
斜体：Ctrl/Command + I
标题：Ctrl/Command + Shift + H
无序列表：Ctrl/Command + Shift + U
有序列表：Ctrl/Command + Shift + O
检查列表：Ctrl/Command + Shift + C
插入代码：Ctrl/Command + Shift + K
插入链接：Ctrl/Command + Shift + L
插入图片：Ctrl/Command + Shift + G

合理的创建标题，有助于目录的生成

直接输入1次#，并按下space后，将生成1级标题。
输入2次#，并按下space后，将生成2级标题。
以此类推，我们支持6级标题。有助于使用TOC语法后生成一个完美的目录。

如何改变文本的样式

强调文本 强调文本

加粗文本 加粗文本

标记文本

~~删除文本~~

引用文本

H₂O is是液体。

2¹⁰ 运算结果是 1024.

插入链接与图片

链接: link.

图片:

带尺寸的图片:

当然，我们为了让用户更加便捷，我们增加了图片拖拽功能。

如何插入一段漂亮的代码片

去博客设置页面，选择一款你喜欢的代码片高亮样式，下面展示同样高亮的 代码片.

// An highlighted block var foo = 'bar';

生成一个适合你的列表

项目
- 项目
  - 项目

项目1
项目2
项目3

计划任务
完成任务

创建一个表格

一个简单的表格是这么创建的：

项目	Value
电脑	$1600
手机	$12
导管	$1

设定内容居中、居左、居右

使用:---------:居中
使用:----------居左
使用----------:居右

第一列	第二列	第三列
第一列文本居中	第二列文本居右	第三列文本居左

SmartyPants

SmartyPants将ASCII标点字符转换为“智能”印刷标点HTML实体。例如：

TYPE	ASCII	HTML
Single backticks	`'Isn't this fun?'`	‘Isn’t this fun?’
Quotes	`"Isn't this fun?"`	“Isn’t this fun?”
Dashes	`-- is en-dash, --- is em-dash`	– is en-dash, — is em-dash

创建一个自定义列表

Markdown

Text-to- HTML conversion tool

Authors

John

Luke

如何创建一个注脚

一个具有注脚的文本。²

注释也是必不可少的

Markdown将文本转换为 HTML。

KaTeX数学公式

您可以使用渲染LaTeX数学表达式 KaTeX:

Gamma公式展示 $\Gamma(n) = (n-1)!\quad\forall n\in\mathbb N$ 是通过欧拉积分

$\Gamma(z) = \int_0^\infty t^{z-1}e^{-t}dt\,.$

你可以找到更多关于的信息 LaTeX 数学表达式here.

新的甘特图功能，丰富你的文章

gantt
        dateFormat  YYYY-MM-DD
        title Adding GANTT diagram functionality to mermaid
        section 现有任务
        已完成               :done,    des1, 2014-01-06,2014-01-08
        进行中               :active,  des2, 2014-01-09, 3d
        计划一               :         des3, after des2, 5d
        计划二               :         des4, after des3, 5d