1. Tables and Views for SCM
  2. CST_PREV_PERIOD_AVG_COSTS_GT

CST_PREV_PERIOD_AVG_COSTS_GT

This transaction global temporary table will be used in PAC Processor to store periodic average cost computed in prior step.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
PERIODIC_COST_ID NUMBER 18 Yes Unique identifier for a periodic average cost row.
COST_ORG_ID NUMBER 18 Yes Identifies the cost organization associated with the inventory organization.
COST_BOOK_ID NUMBER 18 Yes Identifies the cost book assigned to the cost organization.
INVENTORY_ITEM_ID NUMBER 18 Yes Inventory item identifier associated with cost.
VAL_UNIT_ID NUMBER 18 Yes Valuation unit identifier associated with cost.
COST_ELEMENT_ID NUMBER 18 Yes Cost element corresponding to the cost.
PERIOD_NAME VARCHAR2 15 Yes Period for which the cost is calculated.
CURRENT_PERIOD_ONHAND NUMBER This column will be used to store the current period ending on-hand quantity.
PRIOR_PERIOD_ONHAND NUMBER Yes On-hand quantity of prior period.
PRIOR_PERIOD_COST NUMBER Yes Periodic average cost of the prior period.
COST_OWNED_TXN_QUANTITY NUMBER Yes Quantity of cost owned transactions.
COST_OWNED_TXN_AMOUNT NUMBER Yes Total amount of cost owned transactions.
ADJUSTMENT_AMOUNT NUMBER Yes Total amount of PAC adjustments.
VALUE_ADJUSTMENT_AMOUNT NUMBER Yes Total amount of value adjustments submitted and processed for the period.
TXN_ADJUSTMENT_AMOUNT NUMBER Yes Total amount of adjustment received against cost owned transaction during the period. Example of such adjustment are acquisition cost adjustment or receipt cost adjustment.
CALCULATED_PERIODIC_AVG_COST NUMBER Yes Calculated periodic average cost.
PERIODIC_AVG_COST NUMBER Yes Identifies the periodic average cost.
PERIODIC_AVG_COST_ADJ_VARIANCE NUMBER Yes Periodic average cost adjustment amount.
ADJUSTED_PRIOR_PERIOD_COST NUMBER This column indicates the variance calculated for opening balance adjustment.
CURRENCY_CODE VARCHAR2 15 Yes Identifies the currency code corresponding to the transaction.
PRIOR_PERIODIC_COST_ID NUMBER 18 Identifier for a periodic average cost row of the prior period.
PROP_PAC_TO_NEXT_PERIOD VARCHAR2 1 Flag that indicates if the periodic average cost is propagated to the next period. Possible values are: N: Periodic average cost has not been propagated to the next period. NULL: Periodic average cost has been propagated to the next period.
UOM_CODE VARCHAR2 3 Yes Unit of measure code of the transaction quantity.