CST_WORK_ORDER_OPERATIONS_INT
This is the interface table that is used to store the work order operation information transferred from source manufacturing system. This table will hold the data temporarily till the preprocessing program processes it and moves them to the persistent table. On successful move of data the rows in this table would be deleted.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_OPERATIONS_INT_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, WORK_ORDER_OPERATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Code identifying the external system owning this work order definition. | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Surrogate ID identifying the work order in the source system. Manufacturing work order ID. | |
| 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. | |
| 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. | ||
| PREPROCESSING_STATUS | VARCHAR2 | 1 | Indicates the preprocessing status of the row. | ||
| 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_OPERATIONS_INT_PK | Unique | Default | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID, WORK_ORDER_OPERATION_ID |