MSC_ST_ITEM_SOURCING
This is a denormalized table for staging Sourcing Rules related data from Legacy Instances. The data in this table would be processed by the 'Pre-Processor' and sent to MSC_ST_ASSIGNMENT_SETS, MSC_ST_SR_ASSIGNMENTS, MSC_ST_SOURCING_RULES, MSC_ST_SR_RECEIPT_ORG and MSC_ST_SR_SOURCE_ORG. ODS Load would then transfer the data from these five staging tables to corresponding ODS tables.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
SR_SOURCE_ID | NUMBER | 18 | This indicates the source side value of the Source Id. | |||
STATUS | NUMBER | 2 | Status flag of the sourcing setup on planning side. | |||
SOURCING_RULE_TYPE | NUMBER | 2 | Sourcing rule type. This indicates whether it is a Bill of distribution or a Sourcing rule. | |||
CARRIER_NAME | VARCHAR2 | 80 | Carrier Name (Party Name of the Carrier) | |||
COUNTRY_CODE | VARCHAR2 | 30 | Country where this address belongs. | |||
CATEGORY_SET_NAME | VARCHAR2 | 80 | Name assigned to the item category set | |||
SERVICE_LEVEL | VARCHAR2 | 80 | Service level specified in the shipping method. | |||
SR_RECEIPT_ID | NUMBER | 18 | Source side value of the Receipt identifier in the sourcing. | |||
CARRIER_ID | NUMBER | 18 | Unique identifier for the carrier | |||
MODE_OF_TRANSPORT | VARCHAR2 | 80 | MODE_OF_TRANSPORT | |||
FROM_QTY | NUMBER | From Quantity. This is the initial value of quantity in the Qty based sourcing setup. | ||||
QTY_UOM | VARCHAR2 | 80 | Quantity unit of measure specified in the sourcing. | |||
TO_QTY | NUMBER | To Quantity of the Quantity type sourcing rule. | ||||
REFRESH_NUMBER | NUMBER | 18 | Refresh identifier populated by the collection program. | |||
ASSIGNMENT_ID | NUMBER | 18 | Unique Identifier of the allocation assignment | |||
SOURCING_RULE_ID | NUMBER | 18 | This value indicates the Sourcing Rule Id. | |||
ASSIGNMENT_SET_ID | NUMBER | 18 | Unique Identifier of the assignment set | |||
CATEGORY_ID | NUMBER | 18 | Unique identifier for the category | |||
CATEGORY_SET_ID | NUMBER | 18 | Unique identifier for the category set | |||
INVENTORY_ITEM_ID | NUMBER | 18 | Identifies the inventory item id | |||
ORGANIZATION_ID | NUMBER | 18 | Organization ID | |||
SR_INSTANCE_ID | NUMBER | 18 | Identifier of the source system from where the data is collected. | |||
RECEIPT_ORGANIZATION_ID | NUMBER | 18 | This value indicates the Receipt Organization Id. | |||
RECEIPT_ORG_INSTANCE_ID | NUMBER | 18 | This value indicates the Receipt organization source system identifier. | |||
EFFECTIVE_DATE | DATE | Date from when the sourcing rule is effective | ||||
DISABLE_DATE | DATE | Disable date of the item sourcing rule | ||||
SOURCE_ORGANIZATION_ID | NUMBER | 18 | This value indicates the Source Organization Id. | |||
SOURCE_ORG_INSTANCE_ID | NUMBER | 18 | Source organization instance identifier | |||
SOURCE_PARTNER_ID | NUMBER | 18 | This value indicates the Source Partner Id. | |||
SOURCE_PARTNER_SITE_ID | NUMBER | 18 | This value indicates the Source Partner Site identifier. | |||
ALLOCATION_PERCENT | NUMBER | Percent of supply allocated to this source | ||||
RANK | NUMBER | This value indicates the Rank of the record. | ||||
SOURCE_TYPE | NUMBER | Date from when the sourcing rule is effective | ||||
DESCRIPTION | VARCHAR2 | 80 | sourcing/assignment description | |||
PLANNING_ACTIVE | NUMBER | Flag indicates whether the row is planning active. Possible values 1- Yes and 2-No | ||||
SHIP_METHOD | VARCHAR2 | 30 | Shipping method used to move the material. | |||
ASSIGNMENT_TYPE | NUMBER | Date from when the sourcing rule is effective | ||||
ITEM_NAME | VARCHAR2 | 250 | Identifies the inventory item name | |||
CATEGORY_NAME | VARCHAR2 | 163 | Name assigned to the item category | |||
ORGANIZATION_CODE | VARCHAR2 | 18 | Organization code | |||
SR_INSTANCE_CODE | VARCHAR2 | 30 | The value indicates the source system code from where the data is collected. | |||
RECEIPT_ORGANIZATION_CODE | VARCHAR2 | 18 | This value indicates the Receipt Organization Code. | |||
RECEIPT_ORG_INSTANCE_CODE | VARCHAR2 | 30 | Receipt Organization Instance Code | |||
SOURCE_ORGANIZATION_CODE | VARCHAR2 | 18 | This value indicates the Source organization code. | |||
SOURCE_ORG_INSTANCE_CODE | VARCHAR2 | 30 | Source Organization Instance Code | |||
SOURCE_PARTNER_NAME | VARCHAR2 | 255 | This value indicates the Source Partner Name. | |||
SOURCE_PARTNER_SITE_CODE | VARCHAR2 | 30 | This value indicates the Source Partner Site Code. | |||
SOURCING_RULE_NAME | VARCHAR2 | 80 | Name of the sourcing rule used in supply chain sourcing. | |||
ASSIGNMENT_SET_NAME | VARCHAR2 | 34 | Name assigned to the assignment set | |||
DELETED_FLAG | NUMBER | Flag indicating whether this is a deleted record | Obsolete | |||
MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XMLl | ||||
ERROR_TEXT | VARCHAR2 | 2000 | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | |||
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 | ||||
BATCH_ID | NUMBER | 18 | Batch identifier generated during pre-processing. | |||
DATA_SOURCE_TYPE | VARCHAR2 | 15 | Source Type indicating the source of the records | |||
ST_TRANSACTION_ID | NUMBER | 18 | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | |||
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. | |||
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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
COMPANY_NAME | VARCHAR2 | 255 | Party name with which the company is registered. | |||
COMPANY_ID | NUMBER | Unique id assigned to the company | ||||
SOURCE_ORG_ID | NUMBER | 18 | This is the Organization ID for the Organization in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
SOURCE_RECEIPT_ORGANIZATION_ID | NUMBER | This is the Receipt Organization ID for the Receipt Organization in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_INVENTORY_ITEM_ID | NUMBER | This is the Inventory Item ID for the Item in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_CATEGORY_SET_ID | NUMBER | This is the Category Set ID for the Category Set in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_CATEGORY_ID | NUMBER | This is the Category ID for the Category in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_SOURCE_PARTNER_ID | NUMBER | This is the Trading Partner ID for the Trading Partner in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_SOURCE_PARTNER_SITE_ID | NUMBER | This is the Trading Partner Site ID for the Trading Partner Site in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_SOURCE_ORGANIZATION_ID | NUMBER | This is the Organization ID for the Sourcing Organization in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_SOURCING_RULE_ID | NUMBER | This is the Sourcing Rule ID for the Sourcing Rule in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_ASSIGNMENT_SET_ID | NUMBER | This is the Assignment Set ID for the Assignment Set in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||||
SOURCE_SR_RECEIPT_ID | NUMBER | 18 | This is the Receipt ID for the Receipt in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
SOURCE_SR_SOURCE_ID | NUMBER | 18 | This is the Organization Line ID for the Organization Line in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
SOURCE_ASSIGNMENT_ID | NUMBER | 18 | This is the Assignment ID for the Assignment in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | |||
RETRY_COUNT | NUMBER | Number of retries to process failed records. | ||||
ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record | |||
REGION_ID | NUMBER | 18 | Region identifier that is specified in the sourcing assignment. | |||
REGION_CODE | VARCHAR2 | 30 | Region code that is mapped to the location. | |||
REGION_TYPE | VARCHAR2 | 30 | This value indicates the Region type specified for the geography. | |||
PARENT_REGION_CODE_1 | VARCHAR2 | 30 | Parent region code 1 specified in the shipping network. | |||
PARENT_REGION_CODE_2 | VARCHAR2 | 30 | Parent region code 2 specified in the shipping network. | |||
PARENT_REGION_CODE_3 | VARCHAR2 | 30 | Parent region code 3 specified in the shipping network. | |||
PARENT_REGION_CODE_4 | VARCHAR2 | 30 | Parent region code 4 specified in the shipping network. | |||
PARENT_REGION_CODE_5 | VARCHAR2 | 30 | Parent region code 5 specified in the shipping network. | |||
PARENT_REGION_CODE_6 | VARCHAR2 | 30 | Parent region code 6 specified in the shipping network. | |||
PARENT_REGION_CODE_7 | VARCHAR2 | 30 | Parent region code 7 specified in the shipping network. | |||
PARENT_REGION_CODE_8 | VARCHAR2 | 30 | Parent region code 8 specified in the shipping network. | |||
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 | |||
DELETED_FLAG_ASSIGNMENTS | NUMBER | This delete flag indicates whether sourcing assignments is to be deleted. | ||||
DELETED_FLAG_SOURCING_RULES | NUMBER | This delete flag indicates whether sourcing rules is to be deleted. | ||||
DELETED_FLAG_SOURCE_ORG | NUMBER | This delete flag indicates whether source orgs entry is to be deleted. | ||||
DELETED_FLAG_RECEIPT_ORG | NUMBER | This delete flag indicates whether receipt orgs entry is to be deleted. | ||||
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. |