DOS_PROD_RPT_OPERATIONS
Operations table for Contract Manufacturing Portal.
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
DOS_PROD_RPT_OPERATIONS_PK |
REPORT_OPERATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REPORT_OPERATION_ID | NUMBER | 18 | Yes | The Primary Key for Operations table system generated. | |
| REPORT_ID | NUMBER | 18 | Yes | The Foreign Key in Operations table to Report Header. | |
| OPERATION_SEQUENCE | NUMBER | 18 | Yes | Operation sequence (routing step) of the enterprise work order in the contract manufacturing organization. | |
| TRANSACTION_DATE | TIMESTAMP | Yes | The column indicates the date of transaction. | ||
| FROM_DISPATCH_STATE | VARCHAR2 | 30 | Yes | Manufacturing state before reported work. | |
| TO_DISPATCH_STATE | VARCHAR2 | 30 | Yes | Manufacturing state reached for report. | |
| TRANSACTION_NOTE | VARCHAR2 | 4000 | This column is exclusive to the WOLC transaction. This note is captured upon performing the WOLC Completion/Return/Scrap transactions. The underlying table in the UI to capture this information is WMTI. The note captured here will then be eventually passed on to the last operation transaction that is created based on the work definition data. Users will be able to review operation transactions and the last operation transaction for WOLC will contain this captured transaction note. | ||
| 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. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOS_PROD_RPT_OPERATIONS_U1 | Unique | Default | REPORT_OPERATION_ID |