MSC_ST_MRSL_RULE_DETAILS_INT
The staging table used by the Supply Chain Planning collection program to validate and process data for Remaining Shelf Life rule details.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SR_INSTANCE_CODE | VARCHAR2 | 30 | Source Instance code from which data is being populated. | ||
| MRSL_RULE_DETAIL_ID | NUMBER | 18 | Unique identifier of Minimum Remaining shelf life rule detail. | ||
| MRSL_RULE_ID | NUMBER | 18 | Unique identifier of Minimum Remaining shelf life rule. | ||
| MRSL_RULE_NAME | VARCHAR2 | 30 | This column indicates Minimum Remaining shelf life rule name. | ||
| ASSIGNMENT_TYPE | NUMBER | 18 | This column indicates the Minimum Remaining shelf life assignment type. | ||
| ITEM_NAME | VARCHAR2 | 300 | This column indicates the item name. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | This column indicates the item identifier. | ||
| ORGANIZATION_CODE | VARCHAR2 | 18 | This column indicates the organization code. | ||
| ORGANIZATION_ID | NUMBER | 18 | This column indicates the organization identifier. | ||
| CUSTOMER_NUMBER | VARCHAR2 | 360 | Unique partner number generated on the source system for the trading partner. | ||
| CUSTOMER_ID | NUMBER | 18 | Unique identifier of Customer Party. | ||
| TP_SITE_CODE | VARCHAR2 | 30 | Unique identifier number of Customer Party Site. | ||
| CUSTOMER_SITE_ID | NUMBER | 18 | Unique identifier of Customer Party Site. | ||
| CATEGORY_NAME | VARCHAR2 | 250 | This column indicates the Category Name. | ||
| CATEGORY_ID | NUMBER | 18 | This column indicates the Category identifier. | ||
| DEMAND_CLASS | VARCHAR2 | 30 | This column indicates the lookup code of Demand Class. | ||
| REGION_NAME | VARCHAR2 | 360 | This column indicates the geography name. | ||
| COUNTRY_CODE | VARCHAR2 | 2 | This column indicates the Country Code. This will be Level 1 Region Name. | ||
| PARENT_REGION_NAME_1 | VARCHAR2 | 360 | Name of the parent region in the hierarchy. Represents Level 2 region. | ||
| PARENT_REGION_NAME_2 | VARCHAR2 | 360 | Name of the parent region in the hierarchy. Represents Level 3 region. | ||
| PARENT_REGION_NAME_3 | VARCHAR2 | 360 | Name of the parent region in the hierarchy. Represents Level 4 region. | ||
| PARENT_REGION_NAME_4 | VARCHAR2 | 360 | Name of the parent region in the hierarchy. Represents Level 5 region. | ||
| PARENT_REGION_NAME_5 | VARCHAR2 | 360 | Name of the parent region in the hierarchy. Represents Level 6 region. | ||
| PARENT_REGION_NAME_6 | VARCHAR2 | 360 | Name of the parent region in the hierarchy. Represents Level 7 region. | ||
| PARENT_REGION_NAME_7 | VARCHAR2 | 360 | Name of the parent region in the hierarchy. Represents Level 8 region. | ||
| PARENT_REGION_NAME_8 | VARCHAR2 | 360 | Name of the parent region in the hierarchy. Represents Level 9 region. | ||
| REGION_ID | NUMBER | 18 | This column indicates the geography identifier. | ||
| ZONE_NAME | VARCHAR2 | 360 | This column indicates the zone name. | ||
| ZONE_TYPE | VARCHAR2 | 30 | This column indicates the zone type. | ||
| ZONE_ID | NUMBER | 18 | This column indicates the zone identifier. | ||
| MRSL_DAYS | NUMBER | 18 | This column indicates the Minimum Remaining shelf Life days. | ||
| REFRESH_NUMBER | NUMBER | 18 | Refresh identifier populated by the collection program. | ||
| DELETED_FLAG | NUMBER | 2 | Indicates if record should be deleted. 1- Yes, 2 - No. | ||
| PROCESS_FLAG | NUMBER | 2 | Processing Flag indicating the status of records during pre-processing. 1-Compete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record. | ||
| ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record. | ||
| ERROR_TEXT | VARCHAR2 | 2000 | This will describe the reason for the error if any. | ||
| 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. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | It Stores the Request identifier of Job that loaded the data. |