Oracle App培訓筆記(4) -- 成本管理模組主要表整理

zhyuh發表於2004-11-05
OracleAPP筆記

關於Oracle App的表結構描述的文件特別少，自己先整理一部分。

記不住所有的表，整理一下至少下次找起來快。

核心表是 BOM.CST_ITEM_COST_DETAILS

[@more@]

Table relationship:

Table

 

Foreign Table

Foreign Key Column

CST_ITEM_COST_DETAILS

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_ITEM_COST_DETAILS.COST_TYPE_ID

CST_ITEM_COST_DETAILS

CST_ITEM_COST_DETAILS.INVENTORY_ITEM_ID
CST_ITEM_COST_DETAILS.ORGANIZATION_ID

CST_ITEM_COST_DETAILS

CST_ITEM_COST_DETAILS.COST_ELEMENT_ID

CST_ITEM_COST_DETAILS

CST_ITEM_COST_DETAILS.DEPARTMENT_ID

CST_ITEM_COST_DETAILS

CST_ITEM_COST_DETAILS.ACTIVITY_ID

CST_ITEM_COST_DETAILS

CST_ITEM_COST_DETAILS.RESOURCE_ID

CST_ITEM_COST_DETAILS

CST_ITEM_COST_DETAILS.BASIS_RESOURCE_ID

CST_ITEM_COST_DETAILS

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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章