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_PARTNERS

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores information about the different organizations: customers, vendors, and planned organizations.
Implementation/DBA Data:	MSC.MSC_TRADING_PARTNERS

Primary Key: MSC_TRADING_PARTNERS_PK

PARTNER_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_TRADING_PARTNERS	MSC_TRADING_PARTNERS	MSC_TRADING_PARTNERS.MODELED_CUSTOMER_ID
MSC_TRADING_PARTNERS	MSC_TRADING_PARTNERS	MSC_TRADING_PARTNERS.MODELED_SUPPLIER_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
MSC_ALLOCATIONS	MSC_TRADING_PARTNERS	MSC_ALLOCATIONS.PARTNER_ID
MSC_DEMANDS	MSC_TRADING_PARTNERS	MSC_DEMANDS.CUSTOMER_ID
MSC_ITEM_SOURCING	MSC_TRADING_PARTNERS	MSC_ITEM_SOURCING.SUPPLIER_ID
MSC_ITEM_SUPPLIERS	MSC_TRADING_PARTNERS	MSC_ITEM_SUPPLIERS.SUPPLIER_ID
MSC_LOCATION_ASSOCIATIONS	MSC_TRADING_PARTNERS	MSC_LOCATION_ASSOCIATIONS.PARTNER_ID
MSC_PARTNER_CONTACTS	MSC_TRADING_PARTNERS	MSC_PARTNER_CONTACTS.PARTNER_ID
MSC_SR_ASSIGNMENTS	MSC_TRADING_PARTNERS	MSC_SR_ASSIGNMENTS.PARTNER_ID
MSC_SR_RECEIPT_ORG	MSC_TRADING_PARTNERS	MSC_SR_RECEIPT_ORG.RECEIPT_PARTNER_ID
MSC_SR_SOURCE_ORG	MSC_TRADING_PARTNERS	MSC_SR_SOURCE_ORG.SOURCE_PARTNER_ID
MSC_TRADING_PARTNERS	MSC_TRADING_PARTNERS	MSC_TRADING_PARTNERS.MODELED_CUSTOMER_ID
MSC_TRADING_PARTNERS	MSC_TRADING_PARTNERS	MSC_TRADING_PARTNERS.MODELED_SUPPLIER_ID
MSC_TRADING_PARTNER_SITES	MSC_TRADING_PARTNERS	MSC_TRADING_PARTNER_SITES.PARTNER_ID