MSC_API_WORK_DEF_HEADER
This table is used to populate Work definition staging table
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_API_WORK_DEF_HEADER_PK |
ORGANIZATION_ID, CONFIG_ITEM_ID, WORK_DEFINITION_CODE |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | Yes | ORGANIZATION_ID | |
| CONFIG_ITEM_ID | NUMBER | Yes | Unique identifier of the configured item | |
| AS_OF_DATE | TIMESTAMP | Indicates the date as of which the work definition information is obtained. | ||
| WORK_DEFINITION_ID | NUMBER | Yes | This value indicates identifier of the work definition. | |
| WORK_DEFINITION_CODE | VARCHAR2 | 30 | Yes | This value indicates code of the work definition. |
| WORK_DEFINITION_NAME | VARCHAR2 | 80 | Yes | This value indicates name of the work definition. |
| VERSION | VARCHAR2 | 10 | Yes | Work definition header version information collected from source system. |
| QUANTITY | NUMBER | Yes | Quantity of the work definition header or the routing. | |
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code of the work definition header. | |
| WORK_METHOD_ID | NUMBER | This value indicates Method identifier of the work definition. | ||
| WORK_DEFINITION_TYPE | VARCHAR2 | 30 | Yes | This value indicates type of the work definition. |
| SERIAL_TRACKING_FLAG | VARCHAR2 | 1 | Yes | A serial tracking flag for the work definition operation. |
| SR_BILL_SEQUENCE_ID | NUMBER | This value indicates the SR_BILL_SEQUENCE_ID. | ||
| COMPLETION_SUB_INVENTORY_NAME | VARCHAR2 | 10 | Name of the subinventory that stores the completed quantity of the wip job. | |
| COMPLETION_LOCATOR_ID | NUMBER | Indicates the completion locator identifier for the work definition obtained. | ||
| PRODUCTION_PRIORITY | NUMBER | This value indicates the production priority. | ||
| WORK_DEF_NAME_DESCRIPTION | VARCHAR2 | 240 | This value indicates description of the work definition. | |
| EFFECTIVE_FROM_DATE | TIMESTAMP | Yes | Indicates the effective start date for the work definition | |
| EFFECTIVE_TO_DATE | TIMESTAMP | Indicates the effective end date for the work definition obtained. | ||
| 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 | Tablespace | Columns |
|---|---|---|---|
| MSC_API_WD_HEADER_U1 | Unique | Default | ORGANIZATION_ID, CONFIG_ITEM_ID, WORK_DEFINITION_CODE |