CST_WORK_DEFINITIONS_GT
This table contains the work definition header information obtained by calling the manufacturing api for getting configured work definition information.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | 18 | Yes | Indicates the plant in which the work definition is created. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Indicates the item for which the work definition information is obtained. | |
| AS_OF_DATE | TIMESTAMP | Yes | Indicates the date as of which the work definition information is obtained. | ||
| WORK_DEFINITION_ID | NUMBER | 18 | Yes | Indicates the work definition identifier for the work definition obtained. | |
| WORK_DEFINITION_CODE | VARCHAR2 | 30 | Yes | Indicates the work definition code for the work definition obtained. | |
| VERSION | VARCHAR2 | 10 | Yes | Indicates the work definition version for the work definition obtained. | |
| QUANTITY | NUMBER | Yes | Indicates the work definition output quantity for the work definition obtained. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Indicates the unit of measure for the quantity for the work definition obtained. | |
| WORK_METHOD_ID | NUMBER | 18 | Yes | Indicates the work method identifier for the work definition obtained. | |
| WORK_DEFINITION_TYPE | VARCHAR2 | 30 | Yes | Indicates the work definition type for the work definition obtained. | |
| SERIAL_TRACKING_FLAG | VARCHAR2 | 1 | Yes | Indicates the serial tracking indicator for the work definition obtained. | |
| COMPLETION_SUBINVENTORY_NAME | VARCHAR2 | 10 | Indicates the completion sub-inventory for the work definition obtained. | ||
| COMPLETION_LOCATOR_ID | NUMBER | 18 | Indicates the completion locator identifier for the work definition obtained. | ||
| PRODUCTION_PRIORITY | NUMBER | Indicates the production priority for the work definition obtained. | |||
| BILL_SEQUENCE_ID | NUMBER | 18 | Indicates the bill of materials identifier for the work definition obtained. | ||
| WORK_DEF_NAME | VARCHAR2 | 120 | Indicates the work definition name for the work definition obtained. | ||
| WORK_DEF_NAME_DESCRIPTION | VARCHAR2 | 240 | Indicates the work definition description for the work definition obtained. | ||
| EFFECTIVE_FROM_DATE | TIMESTAMP | Yes | Indicates the effective start date for the work definition obtained. | ||
| 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 | Columns |
|---|---|---|
| CST_WORK_DEFINITIONS_GT_PK | Unique | ORGANIZATION_ID, INVENTORY_ITEM_ID, WORK_DEFINITION_ID, AS_OF_DATE |