1. Tables and Views for SCM
  2. CST_PAC_OPERATION_TXNS_INT

CST_PAC_OPERATION_TXNS_INT

This interface table is used to store work order operation transactions for processing by periodic average processor. Data in this table is cleaned at the end of processing.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

CST_PAC_OPERATION_TXNS_INT_PK

OPERATION_TRANSACTION_ID

Columns

Name Datatype Length Precision Not-null Comments
OPERATION_TRANSACTION_ID NUMBER 18 Yes Surrogate ID identifying the operation transaction in costing.
OPERATION_ADJ_TXN_ID NUMBER 18 Surrogate ID indicating the adjustment transaction which is triggered on work order close.
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.
PERIOD_NAME VARCHAR2 15 Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.
INVENTORY_ITEM_ID NUMBER 18 Yes Surrogate ID identifying the primary product associated to the work order where the resource was consumed.
COST_PROFILE_ID NUMBER 18 Identifies the Asset/Expense Cost Profile linked to the item cost profile. This cost profile is used to get the valuation options for the transaction.
DEFAULT_COST_ELEMENT_ID NUMBER 18 Identifies the default cost element to be used when a input cost is not available.
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.
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Yes Transaction source type identifier. For operation transactions this value will come from CST_INTERNAL_TXN_TYPES_VL. This value will always be 0.
BASE_TXN_ACTION_ID NUMBER 18 Yes Transaction action identifier. For operation transactions this value will come from CST_INTERNAL_TXN_TYPES_VL.
PRIMARY_QUANTITY NUMBER Yes Transaction quantity in primary unit of measure.
PRIMARY_UOM_CODE VARCHAR2 3 Yes Primary unit of measure for the item.
TRANSACTION_QUANTITY NUMBER Yes Transactional primary product quantity that is moved.
TRANSACTION_UOM_CODE VARCHAR2 3 Yes Transactional unit of measure of the primary product quantity that is moved.
TOTAL_SCRAP_QTY NUMBER Net total of scrap quantity reported at the work order operation linked to this operation transaction.
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.
OPERATION_SEQ_NUMBER NUMBER Yes Number identifying the operation sequence within a work order. This is the sequence in which operation will be performed in the work order.
EXECUTION_SEQUENCE NUMBER Indicates the execution sequence of the operation if the work order has re-sequence operations.
TRANSACTION_DATE TIMESTAMP Yes Identifies the date and time when the transaction was performed.
COST_DATE TIMESTAMP Costing internal date derived for sequencing of transactions for processing.
OPERATION_SCRAP_COST_TYPE VARCHAR2 30 Indicates how to handle scrap costs. Can take the following values: Include in Inventory - remaining quantity absorbs the full work order costs. Expense Out - scrap cost is expensed out.
OPERATION_SCRAP_VALUATION_TYPE VARCHAR2 30 Indicates when to calculate the value of scrap transactions. Can take the following values: -Value at WO close -Value immediately and at WO close -Value at cost cutoff date and WO close.
WO_UPDATE_EVENT_TXN_ID NUMBER 18 Surrogate ID identifying the work order close transaction. This reference is used to track if the scrap transaction was available in the system during work order close.
POSTED_FLAG VARCHAR2 5 Yes Indicates if the transaction has been processed and costs created in CST_OPERATION_TXN_COSTS.
COSTING_STATUS VARCHAR2 1 Status of the transaction which denotes, whether a transaction has been pre-processed, processed by cost processors, distributions have been created or processed by sub-ledger accounting etc. C Fully costed E Error N Not processed P Partially costed X Excluded W Pending.
ACCOUNTING_STATUS VARCHAR2 1 Current accounting status of the transaction for display: D Draft accounted E Error F Final accounted N Not accounted X Excluded from accounting Z Not applicable.
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 Tablespace Columns
CST_OPERATION_TXNS_INT_N1 Non Unique DEFAULT REQUEST_ID
CST_PAC_OPERATION_TXNS_INT_U1 Unique DEFAULT OPERATION_TRANSACTION_ID