CST_PERIODIC_AVG_COSTS

CostingUsed in 1 subject areas19 reporting columns

Cost Management (CST).

Primary key: not yet catalogued for CST_PERIODIC_AVG_COSTS — reference Oracle Tables & Views guide.

Columns

Column	In reports	Description (inferred)
ADJUSTED_PRIOR_PERIOD_COST	●	Adjusted prior period cost.
ADJUSTMENT_AMOUNT	●	Adjustment amount.
CALCULATED_PERIODIC_AVG_COST	●	Calculated periodic avg cost.
COST_OWNED_TXN_AMOUNT	●	Cost owned transaction amount.
COST_OWNED_TXN_QUANTITY	●	Cost owned transaction quantity.
CREATED_BY	●	User who created the row.
CREATION_DATE	●	Date and time the row was created.
CURRENCY_CODE	●	Code identifying the currency.
LAST_UPDATED_BY	●	User who last updated the row.
LAST_UPDATE_DATE	●	Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN	●	Session login of the user who last updated the row.
PERIODIC_AVG_COST	●	Periodic avg cost.
PERIODIC_AVG_COST_ADJ_VARIANCE	●	Periodic avg cost adj variance.
PERIODIC_COST_ID	●	Identifier for the periodic cost.
PRIOR_PERIOD_COST	●	Prior period cost.
PRIOR_PERIOD_ONHAND	●	Prior period onhand.
TXN_ADJUSTMENT_AMOUNT	●	Transaction adjustment amount.
UOM_CODE	●	Code identifying the unit of measure.
VALUE_ADJUSTMENT_AMOUNT	●	Value adjustment amount.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for CST_PERIODIC_AVG_COSTS?

We ship parameterized SQL, BICC config, and dbt models you own.