CST_WO_INT_STATUS_GT
Use this table to stage those work orders for which we need to pull data from WIP.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| WORK_ORDER_ID | NUMBER | 18 | The unique identifier for the work order created in Manufacturing. | |
| STATUS_FLAG | VARCHAR2 | 1 | Status indicating whether the work order is valid and is available in WIP. 'N' - Not available. 'Y' - Available. | |
| SVC_REQUEST_ID | NUMBER | 18 | The unique identifier for the service request created in Service Requests application. | |
| SVC_REQUEST_NUMBER | VARCHAR2 | 80 | The unique number for the service request created in Service Requests application. | |
| SVC_DOCUMENT_ID | NUMBER | 18 | The unique identifier for the document number used to create work order charges in Service Logistics application. This attribute will store the debrief header identifier. | |
| SVC_DOCUMENT_NUMBER | VARCHAR2 | 255 | The document number used to create work order charges in Service Logistics application. This attribute will store the debrief number. |