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: PO_LOCATION_ASSOCIATIONS

Product:	PO - Purchasing
Description:	Location associations to customers and customer sites
Implementation/DBA Data:	Not implemented in this database

Primary Key: PO_LOCATION_ASSOCATIONS_PK

LOCATION_ID

Primary Key: PO_LOCATION_ASSOCATIONS_UPK01

SITE_USE_ID
LOCATION_ID

Primary Key: PO_LOCATION_ASSOCIATIONS_UK02

SUBINVENTORY
LOCATION_ID

Primary Key: PO_LOCATION_ASSOCIATIONS_UK03

LOCATION_ID
SUBINVENTORY
SITE_USE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PO_LOCATION_ASSOCIATIONS	RA_CUSTOMERS	PO_LOCATION_ASSOCIATIONS.CUSTOMER_ID
PO_LOCATION_ASSOCIATIONS	RA_ADDRESSES_ALL	PO_LOCATION_ASSOCIATIONS.ADDRESS_ID
PO_LOCATION_ASSOCIATIONS	RA_SITE_USES_ALL	PO_LOCATION_ASSOCIATIONS.SITE_USE_ID
WSH_CALENDAR_ASSIGNMENTS	PO_LOCATION_ASSOCIATIONS	WSH_CALENDAR_ASSIGNMENTS.LOCATION_ASSOCIATION_ID