ITPub博客

首页 > 数据库 > Oracle > Oracle App 培训笔记(6) -- 成本管理模块表结构整理 续

Oracle App 培训笔记(6) -- 成本管理模块表结构整理 续

原创 Oracle 作者:zhyuh 时间:2004-11-05 09:30:36 0 删除 编辑

表 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
  1. 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
  1. ACTIVITY_ID

Columns

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

 

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
  1. INVENTORY_ITEM_ID

  2. 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

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/207/viewspace-780030/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    233
  • 访问量
    2008825