CST_SCENARIO_ROLLUP_ITEMS_GT
Global temporary table used by the scenario rollup background process to resolve item cost selection rules.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Indicates the surrogate key reference of the cost planning scenario. | |
| SCENARIO_COST_ESTIMATE_ID | NUMBER | 18 | Indicates the surrogate key reference of the cost estimate to scenario association. | |
| COST_ESTIMATE_ID | NUMBER | Indicates the surrogate key reference of the cost estimate plan. | ||
| COST_ESTIMATE_LINE_ID | NUMBER | 18 | Indicates the surrogate key reference of the cost estimate line. | |
| COST_ESTIMATE_ASSIGN_ID | NUMBER | 18 | Indicates the surrogate key reference of the cost estimate assignment. | |
| VAL_UNIT_COMBINATION_ID | NUMBER | 18 | Indicates the surrogate key reference of the valuation unit combination. | |
| PRIORITY | NUMBER | 9 | Indicates the priority of the item cost plan for the cost planning scenario. | |
| CURRENCY_CONVERSION_RATE | NUMBER | Indicates the currency conversion factor to be used for converting the costs coming from the item cost plan to scenario currency. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifies the item for which the item cost is entered. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Identifies the organization of the item for which the item cost is entered. | |
| COST_ORG_ID | NUMBER | 18 | Identifies the cost organization costing attribute. | |
| INV_ORG_ID | NUMBER | 18 | Identifies the inventory organizaton costing attribute | |
| SUBINVENTORY_CODE | VARCHAR2 | 240 | Identifies the subinventory code costing attribute. | |
| LOCATOR_ID | NUMBER | 18 | Identifies the inventory locator costing attribute. | |
| GRADE_CODE | VARCHAR2 | 240 | Identifies the grade costing attribute. | |
| LOT_NUMBER | VARCHAR2 | 240 | Identifies the lot costing attribute. | |
| SERIAL_NUMBER | VARCHAR2 | 240 | Identifies the serial number costing attribute. | |
| STATUS_CODE | VARCHAR2 | 15 | Indicates the status code of the item cost resolution for use by the rollup process. | |
| COST_UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure. | |
| PUBLISHED_FLAG | VARCHAR2 | 1 | Indicates the record has been published to the cost accounting domain. Possible values are Y or N. | |
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Indicates the surrogate identifier generated for rollup headers. | |
| SOURCE_TYPE | VARCHAR2 | 30 | Indicates the cost rollup derived source table linked to the rollup header. | |
| SOURCE_ID | NUMBER | 18 | Indicates the cost rollup derived source identifier of the input material cost or the resource rate linked to the rollup header. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_ROLLUP_ITEMS_GT_N1 | Non Unique | SCENARIO_ROLLUP_HEADER_ID |
| CST_SCN_ROLLUP_ITEMS_GT_N2 | Non Unique | INVENTORY_ITEM_ID, PRIORITY |