Oracle App 培訓筆記(6) -- 成本管理模組表結構整理 續
表 4. BOM.CST_COST_ELEMENTS , 5. BOM.CST_ACTIVITIES 和 6. INV.MTL_SYSTEM_ITEMS_B
[@more@]
4. TABLE: BOM.CST_COST_ELEMENTS
CST_COST_ELEMENTS stores the five seeded cost elements: Material, Material Overhead, Resource, Outside Processing, and Overhead.
Primary Key: CST_COST_ELEMENTS_PK
COST_ELEMENT_ID
Columns
Name | Datatype | Length | Mandatory | Comments |
COST_ELEMENT_ID | NUMBER |
| Yes | Cost element identifier |
COST_ELEMENT | VARCHAR2 | (50) | Yes | Cost element name |
DESCRIPTION | VARCHAR2 | (240) | Yes | Description |
5. TABLE: BOM.CST_ACTIVITIES
CST_ACTIVITIES stores activities information. An activity can be
specific to one organization or shared among all organizations. For
shared activities, the ORGANIZATION_ID column holds the organization
identifier. For non-shared activities, the ORGANIZATION_ID is NULL.
Primary Key: CST_ACTIVITIES_PK
ACTIVITY_ID
ColumnsName
Datatype
Length
Mandatory
Comments
ACTIVITY_ID
NUMBER
Yes
Activity identifier
ACTIVITY
VARCHAR2
(10)
Yes
Activity name
ORGANIZATION_ID
NUMBER
Organization identifier
DESCRIPTION
VARCHAR2
(240)
Yes
Description
DEFAULT_BASIS_TYPE
NUMBER
Default basis for the activity
DISABLE_DATE
DATE
Date activity becomes inactive
OUTPUT_UOM
VARCHAR2
(50)
Activity measurement unit
VALUE_ADDED_ACTIVITY_FLAG
VARCHAR2
(150)
Flag indicating whether the activity adds value
6. TABLE: INV.MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_B is the definition table for items. This table holds
the definitions for inventory items, engineering items, and purchasing
items. You can specify item-related information in fields such as:
Bill of Material, Costing, Purchasing, Receiving, Inventory, Physical attributes, General Planning, MPS/MRP Planning, Lead times, Work in Process, Order Management, and Invoicing.
.
You can set up the item with multiple segments, since it is
implemented as a flexfield. Use the standard 'System Items' flexfield
that is shipped with the product to configure your item flexfield.
The flexfield code is MSTK.
.
The primary key for an item is the INVENTORY_ITEM_ID and ORGANIZATION_ID. Therefore, the same item can be defined in more than one organization.
.
Each item is initially defined in an item master organization. The
user then assigns the item to other organizations that need to
recognize this item. A row is inserted for each new organization
the item is assigned to. Many columns such as MTL_TRANSACTIONS_ENABLED_FLAG and
BOM_ENABLED_FLAG correspond to item attributes defined in the
MTL_ITEM_ATTRIBUTES table. The attributes that are available to the
user depend on which Oracle applications are installed. The table
MTL_ATTR_APPL_DEPENDENCIES maintains the relationships between item
attributes and Oracle applications.
.
Two unit of measure columns are stored in MTL_SYSTEM_ITEMS_B table. PRIMARY_UOM_CODE is the 3-character unit that is used throughout Oracle Manufacturing. PRIMARY_UNIT_OF_MEASURE is the 25-character Unit of Measure that is used throughout Oracle Purchasing. Unlike the PRIMARY_UOM_CODE, the Unit of Measure is language-dependent attribute, however, PRIMARY_UNIT_OF_MEASURE column stores value in the installation base language only.
.
Items now support multilingual description. MLS is implemented with a pair of tables: MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_TL. Translations table (MTL_SYSTEM_ITEMS_TL) holds item Description and Long Description in multiple languages. DESCRIPTION column in the base table (MTL_SYSTEM_ITEMS_B) is for backward compatibility and is maintained in the installation base language only.
Primary Key: MTL_SYSTEM_ITEMS_B_PK
INVENTORY_ITEM_ID ORGANIZATION_ID
Columns
Name
Datatype
Length
Mandatory
Comments
INVENTORY_ITEM_ID
NUMBER
Yes
Inventory item identifier
ORGANIZATION_ID
NUMBER
Yes
Organization identifier
DESCRIPTION
VARCHAR2
(240)
Item description is maintained in the installation base language only. Translations table (MTL_SYSTEM_ITEMS_TL) holds item descriptions in multiple languages
BUYER_ID
NUMBER
(9)
Buyer identifier
ACCOUNTING_RULE_ID
NUMBER
Accounting rule identifier
INVOICING_RULE_ID
NUMBER
Invoicing rule identifier
REVISION_QTY_CONTROL_CODE
NUMBER
Revision quantity control code
ITEM_CATALOG_GROUP_ID
NUMBER
Item catalog group identifier
Name
Datatype
Length
Mandatory
Comments
ACTIVITY_ID
NUMBER
Yes
Activity identifier
ACTIVITY
VARCHAR2
(10)
Yes
Activity name
ORGANIZATION_ID
NUMBER
Organization identifier
DESCRIPTION
VARCHAR2
(240)
Yes
Description
DEFAULT_BASIS_TYPE
NUMBER
Default basis for the activity
DISABLE_DATE
DATE
Date activity becomes inactive
OUTPUT_UOM
VARCHAR2
(50)
Activity measurement unit
VALUE_ADDED_ACTIVITY_FLAG
VARCHAR2
(150)
Flag indicating whether the activity adds value
the definitions for inventory items, engineering items, and purchasing
items. You can specify item-related information in fields such as:
Bill of Material, Costing, Purchasing, Receiving, Inventory, Physical attributes, General Planning, MPS/MRP Planning, Lead times, Work in Process, Order Management, and Invoicing.
.
You can set up the item with multiple segments, since it is
implemented as a flexfield. Use the standard 'System Items' flexfield
that is shipped with the product to configure your item flexfield.
The flexfield code is MSTK.
.
The primary key for an item is the INVENTORY_ITEM_ID and ORGANIZATION_ID. Therefore, the same item can be defined in more than one organization.
.
Each item is initially defined in an item master organization. The
user then assigns the item to other organizations that need to
recognize this item. A row is inserted for each new organization
the item is assigned to. Many columns such as MTL_TRANSACTIONS_ENABLED_FLAG and
BOM_ENABLED_FLAG correspond to item attributes defined in the
MTL_ITEM_ATTRIBUTES table. The attributes that are available to the
user depend on which Oracle applications are installed. The table
MTL_ATTR_APPL_DEPENDENCIES maintains the relationships between item
attributes and Oracle applications.
.
Two unit of measure columns are stored in MTL_SYSTEM_ITEMS_B table. PRIMARY_UOM_CODE is the 3-character unit that is used throughout Oracle Manufacturing. PRIMARY_UNIT_OF_MEASURE is the 25-character Unit of Measure that is used throughout Oracle Purchasing. Unlike the PRIMARY_UOM_CODE, the Unit of Measure is language-dependent attribute, however, PRIMARY_UNIT_OF_MEASURE column stores value in the installation base language only.
.
Items now support multilingual description. MLS is implemented with a pair of tables: MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_TL. Translations table (MTL_SYSTEM_ITEMS_TL) holds item Description and Long Description in multiple languages. DESCRIPTION column in the base table (MTL_SYSTEM_ITEMS_B) is for backward compatibility and is maintained in the installation base language only.
Name
Datatype
Length
Mandatory
Comments
INVENTORY_ITEM_ID
NUMBER
Yes
Inventory item identifier
ORGANIZATION_ID
NUMBER
Yes
Organization identifier
DESCRIPTION
VARCHAR2
(240)
Item description is maintained in the installation base language only. Translations table (MTL_SYSTEM_ITEMS_TL) holds item descriptions in multiple languages
BUYER_ID
NUMBER
(9)
Buyer identifier
ACCOUNTING_RULE_ID
NUMBER
Accounting rule identifier
INVOICING_RULE_ID
NUMBER
Invoicing rule identifier
REVISION_QTY_CONTROL_CODE
NUMBER
Revision quantity control code
ITEM_CATALOG_GROUP_ID
NUMBER
Item catalog group identifier
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/207/viewspace-780030/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle高階培訓 第6課 學習筆記Oracle筆記
- Oracle高階培訓 第5課 學習筆記Oracle筆記
- Oracle高階培訓 第7課 學習筆記Oracle筆記
- 關於培訓結構
- 好程式設計師web前端培訓分享JavaScript學習筆記分支結構程式設計師Web前端JavaScript筆記
- Oracle體系結構學習筆記Oracle筆記
- 【EBS】Oracle EBS 之 OM 模組整理(1)Oracle
- 好程式設計師web前端培訓分享JavaScript學習筆記之迴圈結構程式設計師Web前端JavaScript筆記
- 線性表__資料結構筆記資料結構筆記
- Oracle WareHouse Builder培訓OracleUI
- rust 模組組織結構Rust
- [oracle零碎筆記]oracle零碎筆記(持續更新…)Oracle筆記
- 2018最新JAVA架構師全套vip培訓(附筆記、原始碼)Java架構筆記原始碼
- logging模組配置筆記筆記
- Python collections 模組筆記Python筆記
- 資料結構筆記——線性表(下)資料結構筆記
- 資料結構筆記——線性表(中)資料結構筆記
- web前端培訓分享node學習筆記Web前端筆記
- iOS 模組化進階整理記錄iOS
- Java培訓教程之JDBC URL結構分析JavaJDBC
- .NET 雲原生架構師訓練營(模組二 基礎鞏固 安全)--學習筆記架構筆記
- <node.js學習筆記(6)>koa-router,模組化Node.js筆記
- ES6--ES12筆記整理(1)筆記
- Oracle學習筆記(6)——函式Oracle筆記函式
- Java培訓:長沙Java培訓機構排名Java
- 架構師的Netty 筆記整理架構Netty筆記
- 組員技術培訓
- 好程式設計師web前端培訓分享之uni-app學習筆記uni-app詳解程式設計師Web前端APP筆記
- .NET 雲原生架構師訓練營(模組二 基礎鞏固 Scrum 核心)--學習筆記架構Scrum筆記
- .NET 雲原生架構師訓練營(模組二 基礎鞏固 MongoDB 聚合)--學習筆記架構MongoDB筆記
- 二、FFmpeg的模組結構
- 教育培訓機構客戶管理系統有哪些?
- 培訓機構班課管理軟體怎麼選?
- 長沙Java培訓機構課件:HarmonyOS 專案結構Java
- .NET 雲原生架構師訓練營(模組二 基礎鞏固 敏捷開發)--學習筆記架構敏捷筆記
- web前端培訓教程中程式的順序結構及選擇結構Web前端
- python 基礎筆記——常用模組Python筆記
- oracle學習筆記(十五) PL/SQL語法結構以及使用Oracle筆記SQL
- .NET 雲原生架構師訓練營(組合模式)--學習筆記架構模式筆記