CST_SCENARIO_OVERHEADS_GT
This table caches the overheads applicable for the scenario for each rollup level for improved performance.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Yes | Identifies the scenario rollup header for which the overheads applicable are cached. | |
| COST_UOM_CONVERSION_FACTOR | NUMBER | Indicates the costing UOM conversion factor for the item. | |||
| OVERHEAD_RATE_TYPE | VARCHAR2 | 30 | Yes | Identifies the overhead rate type of the overhead record. | |
| 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. | ||
| STD_OVERHEAD_RATE_DETAIL_ID | NUMBER | 18 | Yes | Identifies the overhead rate detail identifier of the overhead record. | |
| CATEGORY_ID | NUMBER | 18 | Identifies the item category of the overhead record. | ||
| CATEGORY_SET_ID | NUMBER | 18 | Identifies the item category set of the overhead record. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifies the item of the overhead record. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Identifies the plant of the overhead record. | ||
| WORK_CENTER_ID | NUMBER | 18 | Identifies the work center of the overhead record. | ||
| RESOURCE_TYPE | VARCHAR2 | 30 | Identifies the resource type of the overhead record. | ||
| COST_ELEMENT_ID | NUMBER | 18 | Yes | Identifies the cost element of the overhead record. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Identifies the expense pool of the overhead record. | ||
| ABSORPTION_TYPE | VARCHAR2 | 30 | Identifies the absorption type of the overhead record. | ||
| UNIT_RATE | NUMBER | Identifies the overhead rate applicable for the overhead record. | |||
| CALCULATION_BASIS | NUMBER | Indicates the calculation basis for the overhead calculation. | |||
| COSTING_BATCH_OUTPUT_SIZE | NUMBER | Indicates the costing batch output size of the scenario rollup header. | |||
| OUTPUT_QUANTITY | NUMBER | Indicates the output quantity of the scenario rollup header. | |||
| OUTPUT_UOM_CONVERSION_FACTOR | NUMBER | Indicates the output UOM conversion factor of the scenario rollup header. | |||
| OUTPUT_UOM_CODE | VARCHAR2 | 3 | Indicates the output UOM of the scenario rollup header. | ||
| BATCH_QUANTITY | NUMBER | Indicates the batch quantity of the scenario rollup header. | |||
| BATCH_UOM_CONVERSION_FACTOR | NUMBER | Indicates the batch UOM conversion factor of the scenario rollup header. | |||
| BATCH_UOM_CODE | VARCHAR2 | 3 | Indicates the batch UOM of the scenario rollup header. | ||
| OP_YIELD_FACTOR | NUMBER | Indicates the yield factor for the operation. Default value is 1 (100%). | |||
| OP_REV_YIELD_FACTOR | NUMBER | Indicates the reverse cumulative yield factor for the operation. Default value is 1 (100%). |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_OVERHEADS_GT_U1 | Unique | SCENARIO_ROLLUP_HEADER_ID, STD_OVERHEAD_RATE_DETAIL_ID |