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 |