MSC_BM_OPTIONS
This table contains records for Backlog Management Options for a Backlog Management Run
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_BM_OPTIONS_PK |
CONFIGURATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| CONFIGURATION_ID | NUMBER | 10 | Yes | Field indicates the configuration id of Backlog Management Run | ||
| HORIZON_START | TIMESTAMP | Field indicates the start time of the horizon of planning | ||||
| BUCKETS_PER_HORIZON | NUMBER | 10 | Field indicates the number buckets to be considered for the horizon of planning | |||
| LAST_BASELINE_HORIZON_START | TIMESTAMP | Field indicates the start of plan horizon for previous Baseline Run | ||||
| 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. | |||
| DEFAULT_PRIORITY_RULE_ID | NUMBER | Field indicates the default priority rule to be considered for planning | ||||
| DEFAULT_ASSIGNMENT_SET_ID | NUMBER | Field indicates the default assignment set id that can be used for Baseline | ||||
| DAYS_PASTDUE | NUMBER | Field indicates the number of past due days to be considered for planning | ||||
| DEM_FULFIL_LEAD_TIME | NUMBER | Field indicates the demand fulfillment lead time to be considered for planning | ||||
| CATEGORY_SET_ID | NUMBER | Field indicates the category set id for Backlog Management run | ||||
| SUPPLY_PLAN | VARCHAR2 | 4000 | Field indicates the supply plan for Backlog Management Run | |||
| LAST_IMPORT_DATA_RUN_DATE | TIMESTAMP | This field indicates the last time dependency calculation run occurred | ||||
| RELEASE_ID | NUMBER | id to group set of orders to release together | Obsolete | |||
| ALLOCATION_ATTRIBUTE_ID_1 | NUMBER | Field indicates the first selected allocation attribute id for Backlog Management | ||||
| ALLOCATION_ATTRIBUTE_ID_2 | NUMBER | Field indicates the second selected allocation attribute id for Backlog Management | ||||
| ALLOCATION_ATTRIBUTE_ID_3 | NUMBER | Field indicates the third selected allocation attribute id for Backlog Management | ||||
| SUPPLY_ALLOCATION_TYPE | NUMBER | Field indicate the supply allocation bucket type that Backlog Management engine should consider while planning supply allocated item | ||||
| LAST_ATP_RULE_UPDATE | TIMESTAMP | Field indicates when the last ATP rule updated either through ui or post collections | ||||
| CALCULATE_CONSTRAINT | NUMBER | Field indicates the plan option to calculate constraints. The performance of the backlog planning improves by not computing constraints. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_BM_OPTIONS_U1 | Unique | Default | CONFIGURATION_ID |