MSC_ASSIGNMENT_SETS
This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level. This table stores data which are created at planning server and source applications.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_ASSINGMENT_SETS_PK |
ASSIGNMENT_SET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ASSIGNMENT_SET_ID | NUMBER | 18 | Yes | Unique Identifier of the assignment set | |
| CATEGORY_SET_ID | NUMBER | 18 | This column represents the Category_set_id by which categories are filtered | ||
| SR_INSTANCE_ID | NUMBER | 18 | Yes | The value indicates the source system code from where the data is collected. | |
| ASSIGNMENT_SET_NAME | VARCHAR2 | 34 | Yes | Name assigned to the assignment set | |
| DESCRIPTION | VARCHAR2 | 80 | Description of the assignment set | ||
| SR_ASSIGNMENT_SET_ID | NUMBER | 18 | Yes | Assignment set identifier from source application instance | |
| DELETED_FLAG | NUMBER | Flag to indicate whether the row is no longer valid. SYS_YES means the row will be deleted | |||
| 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. | ||
| PROGRAM_UPDATE_DATE | DATE | This value indicates the update date of the program. | |||
| 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 identifier populated by the collection program. | |||
| COLLECTED_FLAG | NUMBER | Flag to indicate whether the row is collected from application instance. | |||
| 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. | |
| SUBINV_PLANNING_ENABLED | NUMBER | This column identifies if Plan Subinventories flag is set or not. Relevant for Replenishment planning. | |||
| SHORT_ASSIGNMENT_SET_ID | NUMBER | Short Assignment Set Id which will be used for creating Assignment Set partitions |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| msc_sr_assignments | msc_assignment_sets | ASSIGNMENT_ID |
| msc_plans | msc_assignment_sets | ASSIGNMENT_SET_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_ASSIGNMENTS_SETS_N1 | Non Unique | Default | SR_INSTANCE_ID, SR_ASSIGNMENT_SET_ID |
| MSC_ASSIGNMENT_SETS_U1 | Unique | Default | ASSIGNMENT_SET_ID, COLLECTED_FLAG |
| MSC_ASSIGNMENT_SETS_U2 | Unique | Default | ASSIGNMENT_SET_NAME, COLLECTED_FLAG, SR_INSTANCE_ID |
| MSC_ASSIGNMENT_SETS_U3 | Unique | Default | ASSIGNMENT_SET_ID |