表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
- INVENTORY_ITEM_ID
- COST_TYPE_ID
- 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
- 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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/207/viewspace-780029/