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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
MSC_BM_RUN_DEFINITIONS_U1 | Unique | Default | BM_RUN_ID, EXECUTION_ID |