CST_RPROC_PAC_RESET_GT

Temporary table used in report processor to store the cost organization, cost book, item, valuation unit and the starting period information from which the periodic average amounts need to be reset.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: cst_rproc_pac_reset_gt

Columns

Name Datatype Length Precision Comments
COST_ORG_ID NUMBER 18 Identifies the cost organization of the period.
COST_BOOK_ID NUMBER 18 Identifies the cost book of the period.
INVENTORY_ITEM_ID NUMBER 18 Identifies the inventory item of unprocessed records.
VAL_UNIT_ID NUMBER 18 Identifies the valuation unit of unprocessed records.
MIN_COST_DATE DATE Identifies the minimum cost date of unprocessed records.
PERIOD_NAME VARCHAR2 60 Identifies the period name of the period.
PERIOD_START_DATE DATE Identifies period start date of the period.
PERIOD_END_DATE DATE Identifies period end date of the period.

Indexes

Index Uniqueness Columns
CST_RPROC_PAC_RESET_GT_N1 Non Unique COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, PERIOD_START_DATE