MSC_SOURCE_ITEM_SOURCING
MSC_SOURCE_ITEM_SOURCING table is used to store the sourcing rule information assigned to assignmentset at different assignment levels.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_SOURCE_ITEM_SOURCING_PK |
TRANSACTION_ID, ASSIGNMENT_SET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | This is a sequence generated column. | |
| ASSIGNMENT_SET_ID | NUMBER | 18 | Yes | Unique Identifier of the assignment set | |
| ASSIGNMENT_SET_NAME | VARCHAR2 | 200 | Yes | This column indicates the assignment set name. | |
| ASSIGNMENT_ID | NUMBER | 18 | Yes | Unique identifier of assignments in assignment set. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | This column contains organization id which is given as input in ess request. | |
| SR_ORGANIZATION_ID | NUMBER | 18 | This column contains source side organization id. | ||
| ORGANIZATION_CODE | VARCHAR2 | 49 | Yes | This column indicates the organization code. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This column contains item id which is given as input in ess request. | |
| SR_INVENTORY_ITEM_ID | NUMBER | 18 | This column contains source side item id. | ||
| ITEM_NAME | VARCHAR2 | 300 | Yes | This column indicates the item name. | |
| SOURCING_RULE_ID | NUMBER | 18 | Yes | This value indicates Sourcing rule unique identifier | |
| SOURCING_RULE_NAME | VARCHAR2 | 80 | Yes | This value indicates Sourcing rule name | |
| RULE_ORGANIZATION_ID | NUMBER | 18 | This value indicates Organization unique identifier | ||
| RULE_ORGANIZATION_CODE | VARCHAR2 | 49 | This column indicates the sourcing rule organization code. | ||
| RULE_SUB_INVENTORY_ID | NUMBER | 18 | Sub Inventory identifier in the Planning system. | ||
| RULE_SUB_INVENTORY_CODE | VARCHAR2 | 200 | Sub Inventory code in the Planning system. | ||
| SUBINV_PLANNING_ENABLED | NUMBER | 1 | This column identifies if Plan Subinventories flag is set or not. Relevant for Replenishment planning. | ||
| RECEIPT_ID | NUMBER | 18 | Yes | Unique identifier for a row generated at planning server of receipts. | |
| EFFECTIVE_DATE | DATE | Yes | Effective date of the receipt orgs. | ||
| DISABLE_DATE | DATE | Disable date of the sourcing rule effectivity. | |||
| SOURCE_ID | NUMBER | 18 | Unique identifier for a row generated at planning server of sources. | ||
| SOURCE_TYPE | NUMBER | 1 | Flag indicating the source type | ||
| SOURCE_ORGANIZATION_ID | NUMBER | 18 | This value indicates the Source organization identifier. | ||
| SOURCE_ORGANIZATION_CODE | VARCHAR2 | 49 | This column indicates the sources organization code. | ||
| SOURCE_PARTNER_ID | NUMBER | 18 | This value indicates the Source supplier identifier. | ||
| SOURCE_PARTNER_NAME | VARCHAR2 | 360 | This column indicates the supplier name. | ||
| SOURCE_PARTNER_SITE_ID | NUMBER | 18 | This value indicates Source supplier site identifier | ||
| SOURCE_PARTNER_SITE_NAME | VARCHAR2 | 50 | This column indicates the supplier site name. | ||
| SOURCE_SUB_INVENTORY_ID | NUMBER | 18 | This column contains Subinventory Id for the Org when Plan Subinventories flag is set in MSC_SOURCING_RULES. | ||
| SOURCE_SUB_INVENTORY_CODE | VARCHAR2 | 200 | This column contains Subinventory code for the Org when Plan Subinventories flag is set in MSC_SOURCING_RULES. | ||
| FROM_QTY | NUMBER | From Quantity. This is the initial value of quantity in the Qty based sourcing setup. | |||
| TO_QTY | NUMBER | To Quantity of the Quantity type sourcing rule. | |||
| QTY_UOM | VARCHAR2 | 3 | Quantity unit of measure specified in the sourcing. | ||
| ALLOCATION_PERCENT | NUMBER | Percent of supply allocated to this source. | |||
| RANK | NUMBER | This value indicates the Rank of the record. | |||
| SHIP_METHOD | VARCHAR2 | 30 | Shipping method used to move the material. | ||
| CARRIER_ID | NUMBER | 38 | Unique identifier for the carrier | ||
| CARRIER_NAME | VARCHAR2 | 360 | This column indicates the carrier name. | ||
| MODE_OF_TRANSPORT | NUMBER | 18 | This column indicates mode of transport value | ||
| MODE_OF_TRANSPORT_CODE | VARCHAR2 | 200 | This column indicates the mode of transport code. | ||
| SERVICE_LEVEL | NUMBER | 18 | Service level specified in the shipping method. | ||
| SERVICE_LEVEL_CODE | VARCHAR2 | 200 | This column indicates the service level code. | ||
| CREATE_MOVEMENT_REQUEST | NUMBER | This column identifies whether to create a movement request or Transfer order between subinventories of the same org. Relevant for Replenishment planning. | |||
| ASSIGNMENT_TYPE | NUMBER | Yes | Sourcing Assignment type for the item. | ||
| CATEGORY_ID | NUMBER | 18 | Unique identifier for the category | ||
| CATEGORY_NAME | VARCHAR2 | 100 | This column indicates the category name. | ||
| 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_SOURCE_ORGANIZATION_ID | NUMBER | 18 | This column contains source side organization Identifier for Source Organization in sourcing Rule. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_SOURCE_ITEM_SOURCING_N1 | Non Unique | Default | ASSIGNMENT_SET_ID, SR_ORGANIZATION_ID, SR_INVENTORY_ITEM_ID, EFFECTIVE_DATE, DISABLE_DATE |
| MSC_SOURCE_ITEM_SOURCING_U1 | Unique | Default | TRANSACTION_ID, ASSIGNMENT_SET_ID |