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

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

核心表是 BOM.CST_ITEM_COST_DETAILS[@more@]

Table relationship:

TableForeign TableForeign Key Column

CST_ITEM_COST_DETAILSCST_ITEM_COST_DETAILS.INVENTORY_ITEM_IDCST_ITEM_COST_DETAILS.COST_TYPE_IDCST_ITEM_COST_DETAILS.ORGANIZATION_ID

CST_ITEM_COST_DETAILSCST_ITEM_COST_DETAILS.COST_TYPE_ID

CST_ITEM_COST_DETAILSCST_ITEM_COST_DETAILS.INVENTORY_ITEM_IDCST_ITEM_COST_DETAILS.ORGANIZATION_ID

CST_ITEM_COST_DETAILSCST_ITEM_COST_DETAILS.COST_ELEMENT_ID

CST_ITEM_COST_DETAILSCST_ITEM_COST_DETAILS.DEPARTMENT_ID

CST_ITEM_COST_DETAILSCST_ITEM_COST_DETAILS.ACTIVITY_ID

CST_ITEM_COST_DETAILSCST_ITEM_COST_DETAILS.RESOURCE_ID

CST_ITEM_COST_DETAILSCST_ITEM_COST_DETAILS.BASIS_RESOURCE_ID

CST_ITEM_COST_DETAILSCST_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_PKINVENTORY_ITEM_ID

COST_TYPE_ID

ORGANIZATION_ID

Columns:

NameDatatypeLengthMandatoryComments

INVENTORY_ITEM_IDNUMBERYesInventory item identifier

ORGANIZATION_IDNUMBERYesOrganization identifier

COST_TYPE_IDNUMBERYesCost type identifier

COST_UPDATE_IDNUMBERCost update session identifier