CST_WORK_ORDER_OPERATIONS
This is the persistent table that is used to store the work order operation information transferred from source manufacturing system. This table will have a system generated unique ID to identify each work order operation uniquely which will be used to identify these operations in downstream costing tables. This table will be source of truth for all work order operation reference in downstream costing tables.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_OPERATIONS_PK |
CST_WORK_ORDER_OPERATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order operation in costing. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order in costing. | |
| WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the operation in a work order. | |
| 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. | ||
| OPERATION_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of operation e.g. IN_HOUSE or SUPPLIER. Default IN_HOUSE. | |
| 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. | |||
| OSP_ITEM_ID | NUMBER | 18 | Item that represents the value added service in a supplier operation. This is also commonly known as a partially finished assembly. | ||
| SUPPLIER_ID | NUMBER | 18 | Represents the identifier of the suggested supplier for a supplier operation. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Represents the identifier of the suggested supplier site for a supplier operation. | ||
| WORK_DEFINITION_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying the work definition. | ||
| WORK_CENTER_ID | NUMBER | 18 | Identifies the work center where the operation is performed. | ||
| 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. | ||
| OP_YIELD_FACTOR | NUMBER | Indicates yield of a work order operation. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_WO_OPERATIONS_PK | Unique | Default | CST_WORK_ORDER_OPERATION_ID |
| CST_WO_OPERATIONS_U1 | Unique | Default | CST_WORK_ORDER_ID, WORK_ORDER_OPERATION_ID |