eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: MSC_SR_ASSIGNMENTS

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level.
Implementation/DBA Data:	MSC.MSC_SR_ASSIGNMENTS

Primary Key: MSC_SR_ASSIGNMENTS_PK

ASSIGNMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_SR_ASSIGNMENTS	MSC_SOURCING_RULES	MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID
MSC_SR_ASSIGNMENTS	MSC_ASSIGNMENT_SETS	MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID
MSC_SR_ASSIGNMENTS	MSC_TRADING_PARTNERS	MSC_SR_ASSIGNMENTS.PARTNER_ID
MSC_SR_ASSIGNMENTS	MSC_TRADING_PARTNER_SITES	MSC_SR_ASSIGNMENTS.SHIP_TO_SITE_ID
MSC_SR_ASSIGNMENTS	MSC_CATEGORY_SETS	MSC_SR_ASSIGNMENTS.CATEGORY_SET_ID
MSC_ITEM_SOURCING	MSC_SR_ASSIGNMENTS	MSC_ITEM_SOURCING.ASSIGNMENT_ID