MSC_BM_RUN_DEFINITIONS
This table contains the run time values that are used for analyzing the planning behavior.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_BM_RUN_DEFINITIONS_PK |
BM_RUN_ID, EXECUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BM_RUN_ID | NUMBER | 18 | Yes | Backlog Management Planning Run Identifier. | |
| EXECUTION_ID | NUMBER | 18 | Yes | Version of Backlog Management Planning Run. | |
| BM_RUN_TYPE | NUMBER | Backlog Management Planning Run type of processing. | |||
| PLAN_START_DATE | TIMESTAMP | Backlog Management Planning start date. | |||
| MAX_MOVING_DAYS | NUMBER | Maximum number of moving days from last execution for items, | |||
| MAX_PASTDUE_DEMAND_DAYS | NUMBER | Maximum number of days for past due demand. | |||
| MAX_PASTDUE_SUPPLY_DAYS | NUMBER | Maximum number of days for past due supplies. | |||
| DEMAND_PRIORITY_RULE_ID | NUMBER | 18 | Demand Priority Rule Identifier. | ||
| CATEGORY_ID | NUMBER | 18 | Field indicates identifier for Category. | ||
| CUSTOMER_ID | NUMBER | 18 | Field indicates identifier for Customer. | ||
| ORGANIZATION_ID | NUMBER | 18 | Field indicates identifier for Organization. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Field indicates identifier for inventory item. | ||
| PLAN_STATUS | VARCHAR2 | 180 | Backlog Management Planning status. | ||
| ALLOCATION_SCENARIO_ID | NUMBER | 18 | Field indicates identifier for Allocation Scenario. | ||
| ORG_PARAMS | CLOB | Field indicates the Organizations selected by the user as filters. | |||
| ITEM_PARAMS | CLOB | Field indicates the Items selected by the user as filters. | |||
| CATEGORY_PARAMS | CLOB | Field indicates the Categories selected by the user as filters. | |||
| CUSTOMER_PARAMS | CLOB | Field indicates the Customers selected by the user as filters. | |||
| PART_KEY1 | NUMBER | 18 | Source application instance identifier. | ||
| SERVER_NAME | VARCHAR2 | 64 | Server that Backlog Engine used to process planning. | ||
| INSTANCE_ID | NUMBER | 18 | Field indicates the instanceId selected in ess job specific for that plan run. | ||
| REPLAY_DATA_SET_FLAG | NUMBER | Field indicates whether Replay Data set flag is set or not. | |||
| 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. | ||
| SEARCH_CRITERIA | CLOB | Field indicates search criteria used in backlog analysis screen for Backlog Management Plan Run. | |||
| EDITED_ATTRIBUTE_LIST | CLOB | Field indicates attributes edited in Backlog Analysis Screen. | |||
| EDITED_DEMAND_LIST | CLOB | Field indicates orders edited in Backlog Analysis Screen. | |||
| SPLIT_ATTRIBUTE_LIST | CLOB | Field indicates attributes of line split in the Backlog Management Plan Run. | |||
| SPLIT_DEMAND_LIST | CLOB | Field indicates split orders in Backlog Management Plan Run. | |||
| SAVE_PLAN_EXECUTION_ID | NUMBER | 18 | Field indicates Execution Identifier for save plan. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_BM_RUN_DEFINITIONS_U1 | Unique | Default | BM_RUN_ID, EXECUTION_ID |