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

Product:	PN - Property Manager
Description:	Information on leased or subleased locations
Implementation/DBA Data:	PN.PN_TENANCIES_ALL

Primary Key: PN_TENANCIES_PK

TENANCY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PN_TENANCIES_ALL	PN_LEASES_ALL	PN_TENANCIES_ALL.LEASE_ID
PN_TENANCIES_ALL	PN_LEASE_CHANGES_ALL	PN_TENANCIES_ALL.LEASE_CHANGE_ID
PN_TENANCIES_ALL	PN_LOCATIONS_ALL	PN_TENANCIES_ALL.LOCATION_ID
PN_TENANCIES_ALL	HZ_CUST_ACCOUNTS	PN_TENANCIES_ALL.CUSTOMER_ID
PN_TENANCIES_ALL	HZ_CUST_ACCOUNTS	PN_TENANCIES_ALL.CUSTOMER_ID
PN_TENANCIES_ALL	HZ_CUST_SITE_USES_ALL	PN_TENANCIES_ALL.CUSTOMER_SITE_USE_ID
PN_SPACE_ASSIGN_CUST_ALL	PN_TENANCIES_ALL	PN_SPACE_ASSIGN_CUST_ALL.TENANCY_ID
PN_SPACE_ASSIGN_CUST_ALL	PN_TENANCIES_ALL	PN_SPACE_ASSIGN_CUST_ALL.TENANCY_ID
PN_TENANCIES_HISTORY	PN_TENANCIES_ALL	PN_TENANCIES_HISTORY.TENANCY_ID