1. Tables and Views for SCM
  2. CST_CWOTS_TXNS_TO_PROC_GT

CST_CWOTS_TXNS_TO_PROC_GT

This transaction temporary table will be used to create the resource transactions from the exploded resource transactions.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
CST_WO_OPERATION_TXN_ID NUMBER 18 Surrogate ID identifying a operation transaction in costing.
COST_ORG_ID NUMBER 18 Surrogate ID identifying the cost organization associated to the plant where the resource was consumed.
COST_BOOK_ID NUMBER 18 Surrogate ID identifying the cost book associated to the cost organization.
MASTER_ORGANIZATION_ID NUMBER 18 Surrogate ID identifying the master inventory organization associated to the cost organization. This value is derived from CST_COST_ORG_PARAMETERS.
INVENTORY_ITEM_ID NUMBER 18 Surrogate ID identifying the end item associated with the work order.
COST_PROFILE_TYPE_FLAG VARCHAR2 1 Cost profile type that needs to be derived. This will always be A as of now for asset.
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Surrogate ID identifying the internal transaction source.
BASE_TXN_ACTION_ID NUMBER 18 Surrogate ID identifying the transaction action.
INVENTORY_ORGANIZATION_ID NUMBER 18 Surrogate ID identifying the plant where the operation was performed.
CST_WORK_ORDER_ID NUMBER 18 Surrogate ID identifying the work order in costing.
CST_WORK_ORDER_OPERATION_ID NUMBER 18 Surrogate ID identifying the work order operation in costing.
WORK_CENTER_ID NUMBER 18 Identifies the work center where the operation is carried out.
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Surrogate ID identifying the work order operation transaction in the source system.
BASE_TXN_TYPE_ID NUMBER 18 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.
TRANSACTION_DATE TIMESTAMP Identifies the date and time when the operation is performed.
OP_YIELD_FACTOR NUMBER Indicates yield of a work order operation.
TRANSACTION_QUANTITY NUMBER Transactional primary product quantity that is moved.
TRANSACTION_UOM_CODE VARCHAR2 3 Transactional unit of measure of the primary product quantity that is moved.
PRIMARY_QUANTITY NUMBER Transaction quantity in primary unit of measure.
PRIMARY_UOM_CODE VARCHAR2 3 Primary unit of measure for the item.
OPERATION_SEQ_NUMBER NUMBER 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.
FROM_DISPATCH_STATE VARCHAR2 30 The status from which this transaction takes place.
TO_DISPATCH_STATE VARCHAR2 30 The end resulting status where the transaction quantity moves to.
REASON_CODE VARCHAR2 30 Reason for either rejecting the quantities at the operation or scrapping at the operation.
WORK_ORDER_LESS_FLAG VARCHAR2 1 When products have well defined product definitions, They can be produced by means of something called work order less completions. Such completion transaction can trigger the creation of a work order and marks that with the ORDER_LESS_FLAG = "Y".
WORK_ORDER_NUMBER VARCHAR2 120 Work Order Number in manufacturing. The uniqueness of which will be controlled by user at the work method level or at the plant level.