1. Tables and Views for SCM
  2. CST_OPERATION_TXN_COSTS_I_GT

CST_OPERATION_TXN_COSTS_I_GT

This global temporary table will contain the cost of operation transactions that are processed by cost accounting, e.g. Scrap, Scrap Returns etc. for internal processing within the cost processor.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CST_OPRN_TXN_COSTS_I_GT_PK

OPERATION_TXN_COST_ID

Columns

Name Datatype Length Precision Not-null Comments
OPERATION_TXN_COST_ID NUMBER 18 Yes Unique identifier for an operation transaction.
OPERATION_TRANSACTION_ID NUMBER 18 Yes Surrogate ID identifying the operation transaction in costing.
OPERATION_ADJ_TXN_ID NUMBER 18 Yes Surrogate ID indicating the adjustment transaction which triggered the adjustment.
COST_ORG_ID NUMBER 18 Yes Surrogate ID identifying the cost organization associated to the plant where the work order is executed.
COST_BOOK_ID NUMBER 18 Yes Surrogate ID identifying the cost book associated to the cost organization.
CST_WORK_ORDER_ID NUMBER 18 Yes Surrogate ID identifying the work order for which operation transaction was performed.
CST_WORK_ORDER_OPERATION_ID NUMBER 18 Yes Surrogate ID identifying the work order operation at which this operation was performed.
INVENTORY_ITEM_ID NUMBER 18 Yes Surrogate ID identifying the primary product associated to the work order where the resource was consumed.
COST_ELEMENT_ID NUMBER 18 Yes Surrogate ID identifying the cost element.
EXPENSE_POOL_ID NUMBER 18 Yes Surrogate ID identifying the expense pool.
EFF_DATE TIMESTAMP Yes Date from which the cost is effective.
COST_DATE TIMESTAMP Yes Cost date derived within costing for this operation transactions.
PERIOD_NAME VARCHAR2 15 Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.
COST_TRANSACTION_TYPE VARCHAR2 30 Yes Cost transaction type for the transaction. E.g RECEIPT/ISSUE.
BASE_TXN_TYPE_ID NUMBER 18 Yes Transaction type identifier. For operation transactions this value comes from CST_INTERNAL_TXN_TYPES_VL.
COST_SOURCE VARCHAR2 30 Identifies the source of the cost, such as Work Order (WO). The LOOKUP_TYPE for these values is CST_COST_SOURCES.
COST_REFERENCE VARCHAR2 100 Identifies a specific business object or value that further refines the cost source information, such as the source cost organization identifier or an effective date. Value would be Work Order Number - Operation Sequence.
QUANTITY NUMBER Yes Operation quantity for which this cost is applicable.
UOM_CODE VARCHAR2 3 Yes UOM of the operation transaction. Currently only primary UOM.
UNIT_COST NUMBER Yes The unit cost derived at cost element, expense pool level.
CURRENCY_CODE VARCHAR2 15 Yes Indicates the currency code at which cost is recorded in costing.
ABSORPTION_TYPE VARCHAR2 30 For the operation completion transactions, this value will be derived based on work center based overhead rules setup and can be: - Include in Inventory - Expense For the operation scrap transactions, this value will be derived based on the cost profile of the end item for the work order where scrap occurred.
POSTED_FLAG VARCHAR2 5 Indicates if distributions have been created for this row or not. Y - Yes, N - No.
DISTRIBUTION_ID NUMBER 18 Identifies the distribution created for this cost row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Columns
CST_OPRN_TXN_COSTS_I_GT_U1 Unique OPERATION_TXN_COST_ID
CST_OPRN_TXN_COSTS_I_GT_U2 Unique OPERATION_TRANSACTION_ID, COST_ELEMENT_ID, EXPENSE_POOL_ID, EFF_DATE