FND Design Data [Home] [Help]

Table: PN_LEASE_CHANGES_ALL

Product: PN - Property Manager
Description: Lease abstracted, amended and edited
Implementation/DBA Data: TablePN.PN_LEASE_CHANGES_ALL
Primary Key: PN_LEASE_CHANGES_PK
  1. ColumnLEASE_CHANGE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PN_LEASE_CHANGES_ALL FK Joins to TablePN_LEASES_ALL PN_LEASE_CHANGES_ALL.LEASE_ID
PN_LEASE_CHANGES_ALL FK Joins to TablePN_LEASE_TRANSACTIONS_ALL PN_LEASE_CHANGES_ALL.LEASE_TRANSACTION_ID
PN_LEASE_CHANGES_ALL FK Joins to TableFND_USER PN_LEASE_CHANGES_ALL.ABSTRACTED_BY_USER
PN_LEASE_CHANGES_ALL FK Joins to TableFND_USER PN_LEASE_CHANGES_ALL.RESPONSIBLE_USER
TablePN_CONTACT_ASSIGNMENTS_ALL FK Joins to PN_LEASE_CHANGES_ALL PN_CONTACT_ASSIGNMENTS_ALL.LEASE_CHANGE_ID
TablePN_CONTACT_ASSIGN_HISTORY FK Joins to PN_LEASE_CHANGES_ALL PN_CONTACT_ASSIGN_HISTORY.LEASE_CHANGE_ID
TablePN_INSURANCE_REQUIREMENTS_ALL FK Joins to PN_LEASE_CHANGES_ALL PN_INSURANCE_REQUIREMENTS_ALL.LEASE_CHANGE_ID
TablePN_INSUR_REQUIRE_HISTORY FK Joins to PN_LEASE_CHANGES_ALL PN_INSUR_REQUIRE_HISTORY.LEASE_CHANGE_ID
TablePN_LANDLORD_SERVICES_ALL FK Joins to PN_LEASE_CHANGES_ALL PN_LANDLORD_SERVICES_ALL.LEASE_CHANGE_ID
TablePN_LANDLORD_SERVICE_HISTORY FK Joins to PN_LEASE_CHANGES_ALL PN_LANDLORD_SERVICE_HISTORY.LEASE_CHANGE_ID
TablePN_LEASE_DETAILS_ALL FK Joins to PN_LEASE_CHANGES_ALL PN_LEASE_DETAILS_ALL.LEASE_CHANGE_ID
TablePN_LEASE_DETAILS_HISTORY FK Joins to PN_LEASE_CHANGES_ALL PN_LEASE_DETAILS_HISTORY.LEASE_CHANGE_ID
TablePN_LEASE_MILESTONES_ALL FK Joins to PN_LEASE_CHANGES_ALL PN_LEASE_MILESTONES_ALL.LEASE_CHANGE_ID
TablePN_OPTIONS_ALL FK Joins to PN_LEASE_CHANGES_ALL PN_OPTIONS_ALL.LEASE_CHANGE_ID
TablePN_OPTIONS_HISTORY FK Joins to PN_LEASE_CHANGES_ALL PN_OPTIONS_HISTORY.LEASE_CHANGE_ID
TablePN_PAYMENT_SCHEDULES_ALL FK Joins to PN_LEASE_CHANGES_ALL PN_PAYMENT_SCHEDULES_ALL.LEASE_CHANGE_ID
TablePN_PAYMENT_TERMS_ALL FK Joins to PN_LEASE_CHANGES_ALL PN_PAYMENT_TERMS_ALL.LEASE_CHANGE_ID
TablePN_PAYMENT_TERMS_HISTORY FK Joins to PN_LEASE_CHANGES_ALL PN_PAYMENT_TERMS_HISTORY.LEASE_CHANGE_ID
TablePN_RIGHTS_ALL FK Joins to PN_LEASE_CHANGES_ALL PN_RIGHTS_ALL.LEASE_CHANGE_ID
TablePN_RIGHTS_HISTORY FK Joins to PN_LEASE_CHANGES_ALL PN_RIGHTS_HISTORY.LEASE_CHANGE_ID
TablePN_RIGHTS_HISTORY FK Joins to PN_LEASE_CHANGES_ALL PN_RIGHTS_HISTORY.NEW_LEASE_CHANGE_ID
TablePN_TENANCIES_ALL FK Joins to PN_LEASE_CHANGES_ALL PN_TENANCIES_ALL.LEASE_CHANGE_ID
TablePN_TENANCIES_HISTORY FK Joins to PN_LEASE_CHANGES_ALL PN_TENANCIES_HISTORY.LEASE_CHANGE_ID