MSC_ST_SR_ASSIGNMENTS
The staging table used by the collection program to validate and process data for table MSC_SR_ASSIGNMENTS.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Not-null | Comments | Status |
|---|---|---|---|---|---|
| ASSIGNMENT_ID | NUMBER | Unique Identifier of the allocation assignment | |||
| SR_ASSIGNMENT_ID | NUMBER | Unique identifier for the row from the source application | |||
| ASSIGNMENT_SET_ID | NUMBER | Assignment set unique identifier | |||
| ASSIGNMENT_SET_TYPE | NUMBER | Assignment Set Type. Possible values 1- Global, 2- Category, 3- Item, 4- Organization, 5- Category-Org, 6- Item_Org | Obsolete | ||
| SOURCING_RULE_ID | NUMBER | Sourcing rule / Bill of Distribution identifier | |||
| SOURCING_RULE_TYPE | NUMBER | Sourcing rule type. This indicates whether it is a Bill of distribution or a Sourcing rule. | |||
| INVENTORY_ITEM_ID | NUMBER | Identifies the inventory item id | |||
| PARTNER_ID | NUMBER | This value indicates the trading partner identifier generated during planning collections. | |||
| SHIP_TO_SITE_ID | NUMBER | Identifier of the party/partner where the shipment if headed for. | |||
| CUSTOMER_NAME | VARCHAR2 | 360 | Party name assigned to the customer | ||
| LOCATION | VARCHAR2 | 60 | This column indicates the location. | ||
| ORGANIZATION_ID | NUMBER | This column indicates the organization identifier. | |||
| CATEGORY_ID | NUMBER | Unique identifier for the category | |||
| CATEGORY_NAME | VARCHAR2 | 250 | Name assigned to the item category | ||
| CATEGORY_SET_IDENTIFIER | NUMBER | Unique identifier for the category set | |||
| CATEGORY_SET_NAME | VARCHAR2 | 30 | Name assigned to the item category set | ||
| DELETED_FLAG | NUMBER | Yes/No flag indicates whether corresponding record in ODS 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. | ||
| SR_INSTANCE_ID | NUMBER | Source application instance identifier | |||
| REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection progam | |||
| ASSIGNMENT_TYPE | NUMBER | Sourcing Assignment type for the item. | |||
| SR_ASSIGNMENT_INSTANCE_ID | NUMBER | Source application instance identifier for the source assignemnt record | |||
| REGION_ID | NUMBER | Region identifier that is mapped to the location. | |||
| PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed | |||
| RETRY_COUNT | NUMBER | Number of retries to process failed records. | |||
| 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. | ||
| SR_INSTANCE_CODE | VARCHAR2 | 30 | Source Instance code from which data is being populated. | ||
| REGION_TYPE | VARCHAR2 | 30 | This value indicates the Region type specified for the geography. | ||
| REGION_ZONE_FLAG | VARCHAR2 | 1 | This flag indicates whether the geography is marked as Region or Zone. | ||
| ORGANIZATION_CODE | VARCHAR2 | 18 | This column indicates the organization code. | ||
| ITEM_NAME | VARCHAR2 | 300 | Identifies the inventory item name | ||
| ASSIGNMENT_SET_NAME | VARCHAR2 | 34 | Name assigned to the assignment set | ||
| SOURCING_RULE_NAME | VARCHAR2 | 80 | Name of the sourcing rule used in supply chain sourcing. | ||
| REGION_CODE | VARCHAR2 | 360 | Region code that is mapped to the location. | ||
| PARENT_REGION_CODE_1 | VARCHAR2 | 360 | Parent region code 1 specified in the shipping network. | ||
| PARENT_REGION_CODE_2 | VARCHAR2 | 360 | Parent region code 2 specified in the shipping network. | ||
| PARENT_REGION_CODE_3 | VARCHAR2 | 360 | Parent region code 3 specified in the shipping network. | ||
| PARENT_REGION_CODE_4 | VARCHAR2 | 360 | Parent region code 4 specified in the shipping network. | ||
| PARENT_REGION_CODE_5 | VARCHAR2 | 360 | Parent region code 5 specified in the shipping network. | ||
| PARENT_REGION_CODE_6 | VARCHAR2 | 360 | Parent region code 6 specified in the shipping network. | ||
| PARENT_REGION_CODE_7 | VARCHAR2 | 360 | Parent region code 7 specified in the shipping network. | ||
| PARENT_REGION_CODE_8 | VARCHAR2 | 360 | Parent region code 8 specified in the shipping network. | ||
| COUNTRY_CODE | VARCHAR2 | 30 | Country where this address belongs. | ||
| CUST_ACCOUNT_NUMBER | VARCHAR2 | 30 | Account number associated to the customer | ||
| PARTY_SITE_NUMBER | VARCHAR2 | 30 | Unique party site number generated on the source system for the trading partner site. | ||
| ASSIGNED_ORGANIZATION_CODE | VARCHAR2 | 80 | Org code assigned to the sourcing rule | ||
| DEMAND_CLASS_ID | VARCHAR2 | 500 | Class to which the demand is tied. | ||
| LOAD_REQUEST_ID | NUMBER | It Stores the Request ID of Job that loaded the data. | |||
| ASSIGNED_SUB_INVENTORY_CODE | VARCHAR2 | 10 | Sub inventory code assigned to the sourcing rule. |