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. | ||
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. |