FND Design Data [Home] [Help]

Table: PN_PAYMENT_SCHEDULES_ALL

Product: PN - Property Manager
Description: Payment or billing schedules for both landlord and the tenant
Implementation/DBA Data: TablePN.PN_PAYMENT_SCHEDULES_ALL
Primary Key: PN_PAYMENT_SCHEDULES_PK
  1. ColumnPAYMENT_SCHEDULE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PN_PAYMENT_SCHEDULES_ALL FK Joins to TablePN_LEASES_ALL PN_PAYMENT_SCHEDULES_ALL.LEASE_ID
PN_PAYMENT_SCHEDULES_ALL FK Joins to TablePN_LEASE_CHANGES_ALL PN_PAYMENT_SCHEDULES_ALL.LEASE_CHANGE_ID
PN_PAYMENT_SCHEDULES_ALL FK Joins to TableFND_USER PN_PAYMENT_SCHEDULES_ALL.APPROVED_BY_USER_ID
PN_PAYMENT_SCHEDULES_ALL FK Joins to TableFND_USER PN_PAYMENT_SCHEDULES_ALL.TRANSFERRED_BY_USER_ID
TablePN_PAYMENT_ITEMS_ALL FK Joins to PN_PAYMENT_SCHEDULES_ALL PN_PAYMENT_ITEMS_ALL.PAYMENT_SCHEDULE_ID