CST_WD_OPERATIONS_GT
This table contains information of the operations under the work definition which is obtained by calling the manufacturing api to get the configured item's work definition snapshot.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WD_OPERATION_ID | NUMBER | 18 | Yes | Indicates the Fusion manufacturing operation identifier as stored in WIS_WD_OPERATIONS_VL. For CTO snapshot data, this identifier can be shared across different assemblies and therefore should only be used to reference the data stored in WIS_WD_OPERATIONS_VL. | |
| CST_OPERATION_ID | NUMBER | 18 | Yes | Indicates the Fusion costing operation identifier and is used to model the BOM structure of all assemblies in the snapshot as it uniquely identifies an operation for every assembly structure. | |
| WORK_DEFINITION_ID | NUMBER | 18 | Yes | Indicates the work definition identifier under which the operation is performed. | |
| OPERATION_SEQ_NUMBER | NUMBER | Yes | Indicates the sequence of the operation in the work definition snap shot. | ||
| OPERATION_DESCRIPTION | VARCHAR2 | 240 | Indicates the description of the operation performed. | ||
| OPERATION_NAME | VARCHAR2 | 120 | Yes | Indicates the name of the operation performed. | |
| OPERATION_TYPE | VARCHAR2 | 30 | Indicates the type of operation. Valid values are: (1) In-House (2) Supplier. | ||
| OSP_ITEM_ID | NUMBER | 18 | Identifies the outside processing item reference for the operation. | ||
| SUPPLIER_ID | NUMBER | 18 | Identifies the supplier reference for the outside processing operation. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Identifies the supplier site reference for the outside processing operation. | ||
| WORK_CENTER_ID | NUMBER | 18 | Indicates the work center identifier for the work definition operation. | ||
| WORK_CENTER_NAME | VARCHAR2 | 80 | Indicates the work center name for the work definition operation. | ||
| COUNT_POINT_FLAG | VARCHAR2 | 1 | Indicates the value of the count point flag. | ||
| AUTO_TRANSACT_FLAG | VARCHAR2 | 1 | Indicates the value of the auto transact flag. | ||
| SERIAL_TRACKING_FLAG | VARCHAR2 | 1 | Yes | Indicates the value of the serial tracking flag. | |
| EFFECTIVE_FROM_DATE | TIMESTAMP | Yes | Indicates the date from which the work definition operation is effective. | ||
| EFFECTIVE_TO_DATE | TIMESTAMP | Indicates the date till which the work definition operation is effective. | |||
| PLANNING_PERCENT | NUMBER | Indicates the planning percentage for the operation performed. | |||
| WORK_CENTER_CODE | VARCHAR2 | 30 | Indicates the work center code for the work definition operation. | ||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_WD_OPERATIONS_GT_PK | Unique | WD_OPERATION_ID |