CST_SCENARIO_ROLLUP_TOTALS_GT

Global temporary table used in the cost roll up background process to calculate running total costs.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Precision Comments
SCENARIO_ROLLUP_DETAIL_ID NUMBER 18 Indicates the surrogate identifier for the scenario rollup detail record.
RUNNING_EXTENDED_TOTAL NUMBER Captures the running total of extended cost.
RUNNING_UNIT_TOTAL NUMBER Captures the running total of unit cost.

Indexes

Index Uniqueness Columns
CST_SCN_ROLLUP_TOTALS_GT_U1 Unique SCENARIO_ROLLUP_DETAIL_ID