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

关于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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/207/viewspace-780028/