CST_WO_UPDATE_EVENT_STATUS
This table will be used to explode the work order close transactions received from manufacturing for each book. This is in line with the current model where the explosion of transactions and creation of actual transactions is separated.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_UPDATE_EVENT_STATUS_PK |
COST_ORG_ID, COST_BOOK_ID, CST_WO_UPDATE_EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_WO_UPDATE_EVENT_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order status update in costing. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost organization associated to the plant on the work order. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost book. | |
| TRANSACTION_DATE | TIMESTAMP | Yes | Identifies the system date time when the work order update was performed | ||
| PROCESSING_BATCH_ID | NUMBER | 18 | Identifier used to segregate and identify transactions currently being processed. | ||
| POSTED_FLAG | VARCHAR2 | 1 | Indicates if this transaction has been created in cst_wo_update_event_txns or not. Possible values: N - Not processed E - CUET transaction in error Y - CUET transaction created successfully. | ||
| 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_UPDATE_EVENT_STATUS_N1 | Non Unique | Default | PROCESSING_BATCH_ID |
| CST_WO_UPDATE_EVENT_STATUS_N2 | Non Unique | Default | COST_ORG_ID, COST_BOOK_ID, TRANSACTION_DATE |
| CST_WO_UPDATE_EVENT_STATUS_PK | Unique | Default | COST_ORG_ID, COST_BOOK_ID, CST_WO_UPDATE_EVENT_ID |