MSC_RELEASE_DETAILS_INT
Interface table for storing alternalte resources and component substitute data that are to be released during release process.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ERROR_TEXT | VARCHAR2 | 90 | The error text for the failure of release code. | ||
| ERROR_FLAG | NUMBER | 1 | This column determines status of the record during release process. If the ERROR_TEXT is not null for the record then this should be set to 1. For good records, this should be set to 2. | ||
| BATCH_ID | NUMBER | 18 | Batch identifier of the records being released. For a given release cycle, this value will be same for all the records. | ||
| PLAN_ID | NUMBER | 18 | This value indicates the plan identifier for the record. | ||
| TRANSACTION_ID | NUMBER | 18 | Transaction id of the type of supplies that mark the record as unique identifier along with plan id | ||
| LOAD_TYPE | VARCHAR2 | 30 | Determines if the detail is for alternate resource or material. | ||
| OPERATION_SEQ_NUM | NUMBER | Operation sequence number . | |||
| EFFECTIVITY_DATE | DATE | Date of effectivity for substitute component | |||
| MATERIAL_SEQ_NUMBER | NUMBER | Material sequence number of the component | |||
| PRIMARY_ITEM_NAME | VARCHAR2 | 300 | Primary component's name. Populated when it is substituted with another component. | ||
| PRIMARY_COMP_QTY_PER | NUMBER | Primary component's quantity per assembly/product. Populated when it is substituted with another component. | |||
| OPERATION_EFFECTIVITY_DATE | DATE | Effectivity date of operation . | |||
| SUBSTITUTE_ITEM_NAME | VARCHAR2 | 300 | Component name of substiute item. | ||
| SUBS_COMPONENT_QTY_PER | NUMBER | Substitute component's quantity per assembly/product. Populated when it is substituted with another component. | |||
| UOM_CODE | VARCHAR2 | 3 | UOM code of substitute component or alternate resource. | ||
| RESOURCE_SEQ_NUM | NUMBER | Sequence number of the alternate resource | |||
| RESOURCE_CODE | VARCHAR2 | 40 | Resource code of substitute resource. | ||
| ALTERNATE_NUMBER | NUMBER | Alternate number of the corresponding alternate resource | |||
| RESOURCE_HOURS | NUMBER | This value indicates the alternate Resource hours required. | |||
| PRIMARY_RESOURCE_CODE | VARCHAR2 | 40 | Resource code of primary resource | ||
| START_DATE | DATE | Start date of the resource requirement or Demand date | |||
| END_DATE | NUMBER | End date of the resource requirement | |||
| 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. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| DATE_REQUIRED | DATE | Using assembly demand date (due date) of the demand. | |||
| REQUIRED_QUANTITY | NUMBER | Required quantity (demand quantity) of the demand. | |||
| QUANTITY_ISSUED | NUMBER | This value indicates the Quantity issued. | |||
| WIP_SUPPLY_TYPE | NUMBER | Work in process supply type value for the record. Mainly used for phantom identification. | |||
| RESOURCE_USAGE | NUMBER | Alternate resource volume necessary for this operation resource | |||
| BASIS_TYPE | NUMBER | Indicates the usage of this resource i.e whether the resource usage is fixed (e.g., usage per lot produced) or variable (e.g., usage per item produced) |