ITPub博客

首页 > 数据库 > Oracle > Oracle App培训笔记(4) -- 成本管理模块主要表整理

Oracle App培训笔记(4) -- 成本管理模块主要表整理

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

关于Oracle App的表结构描述的文档特别少,自己先整理一部分。

记不住所有的表,整理一下至少下次找起来快。

核心表是 BOM.CST_ITEM_COST_DETAILS

[@more@]

Table relationship:

Table

 

Foreign Table

Foreign Key Column

CST_ITEM_COST_DETAILS

CST_ITEM_COSTS

CST_ITEM_COST_DETAILS.INVENTORY_ITEM_ID
CST_ITEM_COST_DETAILS.
COST_TYPE_ID
CST_ITEM_COST_DETAILS.
ORGANIZATION_ID

CST_ITEM_COST_DETAILS

CST_COST_TYPES

CST_ITEM_COST_DETAILS.COST_TYPE_ID

CST_ITEM_COST_DETAILS

MTL_SYSTEM_ITEMS_B

CST_ITEM_COST_DETAILS.INVENTORY_ITEM_ID
CST_ITEM_COST_DETAILS.
ORGANIZATION_ID

CST_ITEM_COST_DETAILS

CST_COST_ELEMENTS

CST_ITEM_COST_DETAILS.COST_ELEMENT_ID

CST_ITEM_COST_DETAILS

BOM_DEPARTMENTS

CST_ITEM_COST_DETAILS.DEPARTMENT_ID

CST_ITEM_COST_DETAILS

CST_ACTIVITIES

CST_ITEM_COST_DETAILS.ACTIVITY_ID

CST_ITEM_COST_DETAILS

BOM_RESOURCES

CST_ITEM_COST_DETAILS.RESOURCE_ID

CST_ITEM_COST_DETAILS

BOM_RESOURCES

CST_ITEM_COST_DETAILS.BASIS_RESOURCE_ID

CST_ITEM_COST_DETAILS

BOM_OPERATION_SEQUENCES

CST_ITEM_COST_DETAILS.OPERATION_SEQUENCE_ID

 

1. BOM.CST_ITEM_COSTS

 

CST_ITEM_COSTS stores item cost control information by cost type.
.
For standard costing organizations, the item cost control information
for the Frozen cost type is created when you enter a new item. For
average cost organizations, item cost control information is created
when you transact the item for the first time.
.
You can use the Item Costs window to enter cost control
information.

 

Primary Key: CST_ITEM_COSTS_PK
  1. INVENTORY_ITEM_ID

  2. COST_TYPE_ID

  3. ORGANIZATION_ID

Columns:

Name

Datatype

Length

Mandatory

Comments

INVENTORY_ITEM_ID

NUMBER

 

Yes

Inventory item identifier

ORGANIZATION_ID

NUMBER

 

Yes

Organization identifier

COST_TYPE_ID

NUMBER

 

Yes

Cost type identifier

COST_UPDATE_ID

NUMBER

 

 

Cost update session identifier

 

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

上一篇: 准备客户面试
请登录后发表评论 登录
全部评论
  • 博文量
    233
  • 访问量
    2009581