FND Design Data [Home] [Help]

Table: PN_TENANCIES_HISTORY

Product: PN - Property Manager
Description: Track changes in the leased or subleased locations
Implementation/DBA Data: TablePN.PN_TENANCIES_HISTORY
Primary Key: PN_TENANCIES_HISTORY_PK
  1. ColumnTENANCY_HISTORY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PN_TENANCIES_HISTORY FK Joins to TablePN_LEASES_ALL PN_TENANCIES_HISTORY.LEASE_ID
PN_TENANCIES_HISTORY FK Joins to TablePN_LEASE_CHANGES_ALL PN_TENANCIES_HISTORY.LEASE_CHANGE_ID
PN_TENANCIES_HISTORY FK Joins to TablePN_LOCATIONS_ALL PN_TENANCIES_HISTORY.LOCATION_ID
PN_TENANCIES_HISTORY FK Joins to TablePN_TENANCIES_ALL PN_TENANCIES_HISTORY.TENANCY_ID
PN_TENANCIES_HISTORY FK Joins to TableHZ_CUST_ACCOUNTS PN_TENANCIES_HISTORY.CUSTOMER_ID
PN_TENANCIES_HISTORY FK Joins to TableHZ_CUST_SITE_USES_ALL PN_TENANCIES_HISTORY.CUSTOMER_SITE_USE_ID