1. Tables and Views for SCM
  2. CST_PAC_PREPROCESS_GT

CST_PAC_PREPROCESS_GT

This global temporary table will be used in PAC Preprocessor for data processing.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
TRANSACTION_ID NUMBER 18 Unique identifier for the transaction in costing.
COST_ORG_ID NUMBER 18 Identifies the cost organization associated with the inventory organization.
COST_BOOK_ID NUMBER 18 Identifies the cost book assigned to the cost organization.
INVENTORY_ITEM_ID NUMBER 18 Identifier for the inventory item.
VAL_UNIT_ID NUMBER 18 Identifier for the valuation unit.
PERIOD_NAME VARCHAR2 15 Indicates the costing period in which the transaction is processed.
QUANTITY NUMBER Value that identifies the transaction quantity.
COST_OWNED_FLAG VARCHAR2 1 Identifies the transaction is cost owned or cost derived. Possible values are: Y- Cost owned transaction. N- Cost derived transaction.
BASE_TXN_TYPE_ID NUMBER 18 Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table.
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, but a custom source type is treated as INVENTORY (value>100 is brought in as 13), and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES.
BASE_TXN_ACTION_ID NUMBER 18 Inventory transaction action identifier. For Origin as INV, the value comes from lookup INV_TRANSACTION_ACTIONS and for Origin as CST the value is from lookup_type CST_BASE_TXN_ACTIONS.
WO_COST_ALLOCATION_BASIS VARCHAR2 30 The basis for cost allocation for output items in a process manufacturing work order. It can be either percentage or fixed value. Valid values exist in lookup ORA_WIS_COST_ALLOC_BASIS.
PROVISIONAL_COMPLETION_TYPE VARCHAR2 30 Work order valuation option for valuing work order partial completions into inventory. Following options will be available: - Value at standard cost (available for all cost methods) - Value at last actual cost (available for actual and perpetual average cost method) - Value at perpetual average cost (available for perpetual average cost method) - Value at prior periodic average cost (available only for periodic average cost method)
RESET_TYPE VARCHAR2 100 Indicates the type of reset required. Possible values are: StdCostUpdateReset, OverheadReset, CostDerivedReset, FullReset, PACVarianceAdjReset.
CST_WO_UPDATE_EVENT_ID NUMBER 18 Unique identifier for the work order status update in costing.