FND Design Data [Home] [Help]

Table: PN_CONTACT_ASSIGNMENTS_ALL

Product: PN - Property Manager
Description: Llinks locations or leases with the site of a service provider.
Implementation/DBA Data: TablePN.PN_CONTACT_ASSIGNMENTS_ALL
Primary Key: PN_CONTACT_ASSIGNMENTS_PK
  1. ColumnCONTACT_ASSIGNMENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PN_CONTACT_ASSIGNMENTS_ALL FK Joins to TablePN_COMPANIES_ALL PN_CONTACT_ASSIGNMENTS_ALL.COMPANY_ID
PN_CONTACT_ASSIGNMENTS_ALL FK Joins to TablePN_COMPANY_SITES_ALL PN_CONTACT_ASSIGNMENTS_ALL.COMPANY_SITE_ID
PN_CONTACT_ASSIGNMENTS_ALL FK Joins to TablePN_LEASES_ALL PN_CONTACT_ASSIGNMENTS_ALL.LEASE_ID
PN_CONTACT_ASSIGNMENTS_ALL FK Joins to TablePN_LEASE_CHANGES_ALL PN_CONTACT_ASSIGNMENTS_ALL.LEASE_CHANGE_ID
PN_CONTACT_ASSIGNMENTS_ALL FK Joins to TablePN_LOCATIONS_ALL PN_CONTACT_ASSIGNMENTS_ALL.LOCATION_ID
TablePN_CONTACT_ASSIGN_HISTORY FK Joins to PN_CONTACT_ASSIGNMENTS_ALL PN_CONTACT_ASSIGN_HISTORY.CONTACT_ASSIGNMENT_ID