CST_STD_OVERHEAD_RATES_GT
This table holds the temporary data during the publish of standard overhead rates.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_STD_OVERHEAD_RATES_GT_PK |
STD_OVERHEAD_RATE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STD_OVERHEAD_RATE_ID | NUMBER | 18 | Yes | Indicates the surrogate key of the overhead rate record. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Indicates the cost organization for which the overhead rate is defined. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Indicates the cost book for which the overhead rate is defined. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates the plant for which the overhead rate is defined. | |
| OVERHEAD_RATE_TYPE | VARCHAR2 | 30 | Yes | Indicates the overhead rate tyof the overhead rate. Valid values are (1) Plant (2) Work Center. | |
| CATEGORY_SET_ID | NUMBER | 18 | Indicates the category set if the overhead is defined for plant overhead rate type and the category is selected. | ||
| CATEGORY_ID | NUMBER | 18 | Indicates the category for which the plant overhead is defined. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the item for which the plant overhead is defined. | ||
| WORK_CENTER_ID | NUMBER | 18 | Indicates the work center for which the work center overhead is defined. | ||
| RESOURCE_TYPE | VARCHAR2 | 30 | Indicates the resource type for which the work center overhead is defined. | ||
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| SCENARIO_EVENT_ID | NUMBER | 18 | Yes | Indicates the scenario event using which the overhead rate is being published. | |
| PREVIOUS_STD_OVERHEAD_RATE_ID | NUMBER | 18 | Indicates the surrogate key reference of the previous overhead rate. | ||
| PREVIOUS_EFFECTIVE_START_DATE | DATE | Indicates the effective start date of the previous overhead rate. | |||
| PREVIOUS_EFFECTIVE_END_DATE | DATE | Indicates the effective end date of the previous overhead rate. | |||
| FUTURE_STD_OVERHEAD_RATE_ID | NUMBER | 18 | Indicates the surrogate key reference of the future overhead rate. | ||
| FUTURE_EFFECTIVE_START_DATE | DATE | Indicates the effective start date of the future overhead rate. | |||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status code of the overhead rate being published. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_STD_OVERHEAD_RATES_GT_PK | Unique | STD_OVERHEAD_RATE_ID |
| CST_STD_OVERHEAD_RATES_GT_U1 | Unique | COST_ORG_ID, COST_BOOK_ID, INVENTORY_ORG_ID, OVERHEAD_RATE_TYPE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, CATEGORY_SET_ID, CATEGORY_ID, INVENTORY_ITEM_ID, WORK_CENTER_ID, RESOURCE_TYPE |