MSC_DESIGNATORS
This table stores MPS and MDS schedule names defined at source applications and planning server. MPS_RELIEF indicates whether or not the Planning Manager should consume this master demand or master production schedule. . INVENTORY_ATP_FLAG indicates whether or not inventory can consider this master production schedule as a source of supply as defined by ATP rules. It will always be No for master demand schedules. This table is populated by the Define Master Schedule Names form and the Collection program.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_DESIGNATORS_PK |
DESIGNATOR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| SCHEDULE_DESIGNATOR_ID | NUMBER | 18 | designator_id in remote system for the loaded schedule | |||
| DESIGNATOR | VARCHAR2 | 10 | Yes | Source application schedule name | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | Source application organization identifier | ||
| SR_INSTANCE_ID | NUMBER | 18 | Yes | Identifier of the source system from where the data is collected. | Obsolete | |
| SCHEDULE_TYPE | NUMBER | indicates type of schedule: MPS, MDS etc | ||||
| MPS_RELIEF | NUMBER | Yes | Flag to indicate whether MPS relief performed against this designator | |||
| INVENTORY_ATP_FLAG | NUMBER | Yes | Inventory available to promise flag | |||
| DESCRIPTION | VARCHAR2 | 50 | Description of the this designator | |||
| DISABLE_DATE | DATE | Date indicating Designator disable date | ||||
| DEMAND_CLASS | VARCHAR2 | 34 | Class to which the demand is tied. | |||
| ORGANIZATION_SELECTION | NUMBER | This value indicates the organization selection(Single/Multiple). | ||||
| PRODUCTION | NUMBER | This flag indicates whether the supplies can be auto released at the end of the plan completion. | ||||
| RECOMMENDATION_RELEASE | NUMBER | This value indicates the Planned order release flag. | ||||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates 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. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||||
| DESIGNATOR_ID | NUMBER | 18 | Yes | Unique id of the forecast designator | ||
| DESIGNATOR_TYPE | NUMBER | 22 | Yes | Indicate the designator type: MPS, MDS, MRP, or DRP | ||
| COLLECTED_FLAG | NUMBER | Flag indicating whether the row is collected from source application instance | ||||
| CONSUME_FORECAST | NUMBER | Flag to indicate whether forecast is consumed | ||||
| UPDATE_TYPE | NUMBER | This value indicates Forecast update type code. | ||||
| FORWARD_UPDATE_TIME_FENCE | NUMBER | Number of days forward which can be considered for consumption | ||||
| BACKWARD_UPDATE_TIME_FENCE | NUMBER | Backward consumption days for the forecast | ||||
| OUTLIER_UPDATE_PERCENTAGE | NUMBER | Forecast outlier update percentage | ||||
| FORECAST_SET_ID | VARCHAR2 | 10 | ID assigned to the forecast set | |||
| CUSTOMER_ID | NUMBER | 18 | Unique Partner identifier generated by the collection program | |||
| SHIP_ID | NUMBER | 18 | This value indicates the Forecast ship code identifier. | |||
| BILL_ID | NUMBER | 18 | Forecast billing address identifier | |||
| BUCKET_TYPE | NUMBER | Forecast bucket type - days, weeks or periods | ||||
| PROBABILITY | NUMBER | This value indicates the probability for the demand/designator. | ||||
| LAUNCH_WORKFLOW_FLAG | NUMBER | Flag indicates whether the workflow is launched. | ||||
| COPY_DESIGNATOR_ID | NUMBER | 18 | Stores the link between the original plan and the temp plan in case of 24x7 ATP | |||
| PURGE_CURRENT_PLAN | NUMBER | Flag indicates whether the current plan needs to be purged. | ||||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_DESIGNATORS_N1 | Non Unique | Default | COPY_DESIGNATOR_ID |
| MSC_DESIGNATORS_U1 | Unique | Default | DESIGNATOR_ID |
| MSC_DESIGNATORS_U2 | Unique | Default | DESIGNATOR_TYPE, DESIGNATOR, ORGANIZATION_ID |