CST_WD_OUTPUT_PERCENTAGES_GT
This table is used to cache the percentage allocation for each item under each operation to improve performance of queries.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Precision | Not-null | Comments |
|---|---|---|---|---|
| SCENARIO_ID | NUMBER | 18 | Yes | Identifies the scenario for which the output percentages are being cached. |
| WORK_DEFINITION_ITEM_ID | NUMBER | 18 | Yes | Identifies the work definition identifier for which the output percentages are being cached. |
| WD_OPERATION_ID | NUMBER | 18 | Yes | Identifies the operation for which the output percentages are being cached. |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the item for which the output percentages are being cached. |
| ORGANIZATION_ID | NUMBER | 18 | Yes | Identifies the organization for which the output percentages are being cached. |
| THIS_ALLOCATION_PERCENTAGE | NUMBER | Indicates the cost allocation percentage for this item in that operation. | ||
| OTHER_ALLOCATION_PERCENTAGE | NUMBER | Indicates the cost allocation percentage for other items in that operation. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_WD_OUTPUT_PERC_U1 | Unique | SCENARIO_ID, WORK_DEFINITION_ITEM_ID, WD_OPERATION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID |