Oracle App 培訓筆記(5) -- 成本管理模組表結構整理 續

表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