ITPub博客

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

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

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

表2. BOM.CST_ITEM_COST_DETAILS 和 3. BOM.CST_COST_TYPES

[@more@]

2. TABLE: BOM.CST_ITEM_COST_DETAILS (CORE Table)

CST_ITEM_COST_DETAILS stores detailed cost information for an item for
a cost type. It is the child table of CST_ITEM_COSTS.
.
There are three types of detailed item cost: User-defined, Defaulted,
and Rolled up. User-defined costs can be entered in the Item Costs
window. Defaulted and Rolled up costs are generated by Cost
Rollup.
.
If the item does not have cost control information for the cost type
you are rolling up, Cost Rollup copies this level detailed cost
information from the default cost type and marks the rows as
Defaulted. Previous level costs are rolled up costs.

 

Primary Key: CST_ITEM_COST_DETAILS_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

OPERATION_SEQUENCE_ID

NUMBER

 

 

Operation sequence identifier

OPERATION_SEQ_NUM

NUMBER

 

 

Operation sequence number in a routing

DEPARTMENT_ID

NUMBER

 

 

Department identifier

LEVEL_TYPE

NUMBER

 

Yes

Level at which cost is incurred

ACTIVITY_ID

NUMBER

 

 

Activity identifier

RESOURCE_SEQ_NUM

NUMBER

 

 

Resource sequence number in an operation

RESOURCE_ID

NUMBER

 

 

Resource identifier (sub-element)

BASIS_TYPE

NUMBER

 

Yes

Basis

BASIS_RESOURCE_ID

NUMBER

 

 

Resource identifier that the resource overhead is based on

BASIS_FACTOR

NUMBER

 

Yes

Basis factor

ITEM_COST

NUMBER

 

Yes

Item unit cost

COST_ELEMENT_ID

NUMBER

 

 

Cost element identifier

 

3. TABLE: BOM.CST_COST_TYPES

CST_COST_TYPES stores cost type definitions. The table is seeded with three cost types: Frozen, Average, and Pending. The Frozen cost type is used in standard costing organizations.
The average cost type is used in average costing organizations. All costs reference a cost type.

PL_ELEMENT_FLAG, PL_RESOURCE_FLAG, PL_OPERATION_FLAG, PL_ACTIVITY_FLAG values are used by the Cost Rollup to determine whether to group rollup costs by cost element, sub element, operation sequence number, or activity. BOM_SNAPSHOT_FLAG is used by the Cost Rollup to determine whether to save the bill structure when rolling up costs for a cost type.

Primary Key: CST_COST_TYPES_PK
  1. COST_TYPE_ID

Columns:

Name

Datatype

Length

Mandatory

Comments

COST_TYPE_ID

NUMBER

 

Yes

Cost type identifier

ORGANIZATION_ID

NUMBER

 

 

Organization identifier

COST_TYPE

VARCHAR2

(10)

Yes

Cost type name

COSTING_METHOD_TYPE

NUMBER

 

Yes

Costing method used, standard or average

DEFAULT_COST_TYPE_ID

NUMBER

 

Yes

Cost type identifier used as the default cost type when rolling up costs

 

 

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

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