1. Tables and Views for SCM
  2. CST_WO_OPERATION_TXNS

CST_WO_OPERATION_TXNS

This is the persisted table that holds work order operation transactions within costing. This table acts as source of truth for all costing downstream tables. System will generate a unique identifier for every external_system_reference + external_system_ref_id.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CST_WO_OPERATION_TXNS_PK

CST_WO_OPERATION_TXN_ID

Columns

Name Datatype Length Precision Not-null Comments
CST_WO_OPERATION_TXN_ID NUMBER 18 Yes Surrogate ID identifying the work order operation in costing.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 Yes Code identifying the external system owning this operation transactions.
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Yes Surrogate ID identifying the work order operation transaction in the source system.
WORK_ORDER_ID NUMBER 18 Yes Surrogate ID identifying the work order in the source system.
WORK_ORDER_OPERATION_ID NUMBER 18 Yes Surrogate ID identifying the work order operation tied to this operation transaction.
CST_WORK_ORDER_ID NUMBER 18 Yes Surrogate ID identifying the work order in costing.
CST_WORK_ORDER_OPERATION_ID NUMBER 18 Yes Surrogate ID identifying the work order operation in costing.
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.
RESEQUENCE_FLAG VARCHAR2 1 Flag used to indicate if the operation can be re-sequenced while executing the operation. Valid values are Y or N.
EXECUTION_SEQUENCE NUMBER Indicates the execution sequence of the operation if the work order has re-sequence operations.
INVENTORY_ORGANIZATION_ID NUMBER 18 Yes Surrogate ID identifying the plant where the operation was performed.
INVENTORY_ITEM_ID NUMBER 18 Yes Surrogate ID identifying the end item on the work order.
BASE_TXN_TYPE_ID NUMBER 18 Yes Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table. This will be 0 as all operation transactions are costing internal transactions.
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Yes Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES.
BASE_TXN_ACTION_ID NUMBER 18 Yes 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.
WORK_CENTER_ID NUMBER 18 Identifies the work center where the operation is carried out.
TRANSACTION_TYPE_CODE VARCHAR2 30 Yes Operation transaction type code as defined in lookup WIE_OP_TRANSACTION_TYPE.
FROM_DISPATCH_STATE VARCHAR2 30 Yes The status from which this transaction takes place.
TO_DISPATCH_STATE VARCHAR2 30 Yes The end resulting status where the transaction quantity moves to.
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.
TRANSACTION_DATE TIMESTAMP Yes Identifies the date and time when the operation is performed.
REASON_CODE VARCHAR2 30 Reason for either rejecting the quantities at the operation or scrapping at the operation.
PROCESSED_BY_CA_FLAG VARCHAR2 5 Flag to indicate whether the row has been processed by cost accounting.
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_WO_OPERATION_TXNS_N1 Non Unique Default CST_WORK_ORDER_ID, CST_WORK_ORDER_OPERATION_ID, TRANSACTION_DATE, TRANSACTION_TYPE_CODE
CST_WO_OPERATION_TXNS_PK Unique Default CST_WO_OPERATION_TXN_ID
CST_WO_OPERATION_TXNS_U1 Unique Default EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID