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_TRADING_PARTNER_SITES

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores information about the different sites of an organization.
Implementation/DBA Data:	MSC.MSC_TRADING_PARTNER_SITES

Primary Key: MSC_TRADING_PARTNER_SITES_PK

PARTNER_SITE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_TRADING_PARTNER_SITES	MSC_TRADING_PARTNERS	MSC_TRADING_PARTNER_SITES.PARTNER_ID
MSC_ALLOCATIONS	MSC_TRADING_PARTNER_SITES	MSC_ALLOCATIONS.PARTNER_SITE_ID
MSC_DEMANDS	MSC_TRADING_PARTNER_SITES	MSC_DEMANDS.SHIP_TO_SITE_ID
MSC_DEMANDS	MSC_TRADING_PARTNER_SITES	MSC_DEMANDS.CUSTOMER_SITE_ID
MSC_ITEM_SOURCING	MSC_TRADING_PARTNER_SITES	MSC_ITEM_SOURCING.SUPPLIER_SITE_ID
MSC_ITEM_SUPPLIERS	MSC_TRADING_PARTNER_SITES	MSC_ITEM_SUPPLIERS.SUPPLIER_SITE_ID
MSC_LOCATION_ASSOCIATIONS	MSC_TRADING_PARTNER_SITES	MSC_LOCATION_ASSOCIATIONS.PARTNER_SITE_ID
MSC_PARTNER_CONTACTS	MSC_TRADING_PARTNER_SITES	MSC_PARTNER_CONTACTS.PARTNER_SITE_ID
MSC_SR_ASSIGNMENTS	MSC_TRADING_PARTNER_SITES	MSC_SR_ASSIGNMENTS.SHIP_TO_SITE_ID
MSC_SR_RECEIPT_ORG	MSC_TRADING_PARTNER_SITES	MSC_SR_RECEIPT_ORG.RECEIPT_PARTNER_SITE_ID
MSC_SR_SOURCE_ORG	MSC_TRADING_PARTNER_SITES	MSC_SR_SOURCE_ORG.SOURCE_PARTNER_SITE_ID
MSC_TRADING_PARTNERS	MSC_TRADING_PARTNER_SITES	MSC_TRADING_PARTNERS.MODELED_CUSTOMER_SITE_ID
MSC_TRADING_PARTNERS	MSC_TRADING_PARTNER_SITES	MSC_TRADING_PARTNERS.MODELED_SUPPLIER_SITE_ID