FND Design Data [Home] [Help]

Table: PN_PAYMENT_TERMS_ALL

Product: PN - Property Manager
Description: Payment and billing terms defined in a lease
Implementation/DBA Data: TablePN.PN_PAYMENT_TERMS_ALL
Primary Key: PN_PAYMENT_TERMS_PK
  1. ColumnPAYMENT_TERM_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PN_PAYMENT_TERMS_ALL FK Joins to TableHZ_CUST_ACCOUNTS PN_PAYMENT_TERMS_ALL.CUSTOMER_ID
PN_PAYMENT_TERMS_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_ALL FK Joins to TablePN_LEASES_ALL PN_PAYMENT_TERMS_ALL.LEASE_ID
PN_PAYMENT_TERMS_ALL FK Joins to TablePN_LEASE_CHANGES_ALL PN_PAYMENT_TERMS_ALL.LEASE_CHANGE_ID
PN_PAYMENT_TERMS_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I PN_PAYMENT_TERMS_ALL.SET_OF_BOOKS_ID
PN_PAYMENT_TERMS_ALL FK Joins to TableGL_CODE_COMBINATIONS PN_PAYMENT_TERMS_ALL.CODE_COMBINATION_ID
PN_PAYMENT_TERMS_ALL FK Joins to TableFND_CURRENCIES PN_PAYMENT_TERMS_ALL.CURRENCY_CODE
PN_PAYMENT_TERMS_ALL FK Joins to TablePO_VENDORS PN_PAYMENT_TERMS_ALL.VENDOR_ID
PN_PAYMENT_TERMS_ALL FK Joins to TablePO_VENDOR_SITES_ALL PN_PAYMENT_TERMS_ALL.VENDOR_SITE_ID
PN_PAYMENT_TERMS_ALL FK Joins to TableRA_CUSTOMERS PN_PAYMENT_TERMS_ALL.CUSTOMER_ID
PN_PAYMENT_TERMS_ALL FK Joins to TableRA_SITE_USES_ALL PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_ALL FK Joins to TableHZ_CUST_ACCOUNTS PN_PAYMENT_TERMS_ALL.CUSTOMER_ID
PN_PAYMENT_TERMS_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL PN_PAYMENT_TERMS_ALL.CUST_SHIP_SITE_ID
PN_PAYMENT_TERMS_ALL FK Joins to TablePN_REC_PERIOD_BILL_ALL PN_PAYMENT_TERMS_ALL.PERIOD_BILLREC_ID
PN_PAYMENT_TERMS_ALL FK Joins to Table% PN_PAYMENT_TERMS_ALL.OPEX_RECON_ID
PN_PAYMENT_TERMS_ALL FK Joins to TablePN_VAR_RENT_INV_ALL PN_PAYMENT_TERMS_ALL.VAR_RENT_INV_ID
PN_PAYMENT_TERMS_ALL FK Joins to TablePN_TERM_TEMPLATES_ALL PN_PAYMENT_TERMS_ALL.TERM_TEMPLATE_ID
TablePN_ADJUSTMENT_SUMMARIES FK Joins to PN_PAYMENT_TERMS_ALL PN_ADJUSTMENT_SUMMARIES.PAYMENT_TERM_ID
TablePN_DISTRIBUTIONS_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_DISTRIBUTIONS_ALL.PAYMENT_TERM_ID
TablePN_INDEX_EXCLUDE_TERM_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_INDEX_EXCLUDE_TERM_ALL.PAYMENT_TERM_ID
TablePN_INDEX_LEASE_TERMS_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_INDEX_LEASE_TERMS_ALL.LEASE_TERM_ID
TablePN_INDEX_LEASE_TERMS_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_INDEX_LEASE_TERMS_ALL.RENT_INCREASE_TERM_ID
TablePN_LEASE_MILESTONES_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_LEASE_MILESTONES_ALL.PAYMENT_TERM_ID
TablePN_PAYMENT_ITEMS_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_PAYMENT_ITEMS_ALL.PAYMENT_TERM_ID
TablePN_VAR_ABATEMENTS_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_VAR_ABATEMENTS_ALL.PAYMENT_TERM_ID
TablePN_DISTRIBUTIONS_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_DISTRIBUTIONS_ALL.PAYMENT_TERM_ID
TablePN_REC_LINBILL_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_REC_LINBILL_ALL.PAYMENT_TERM_ID
TablePN_PAYMENT_TERMS_HISTORY FK Joins to PN_PAYMENT_TERMS_ALL PN_PAYMENT_TERMS_HISTORY.PAYMENT_TERM_ID
TablePN_REC_LINBILL_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_REC_LINBILL_ALL.PAYMENT_TERM_ID
TablePN_VAR_ABATEMENTS_ALL FK Joins to PN_PAYMENT_TERMS_ALL PN_VAR_ABATEMENTS_ALL.PAYMENT_TERM_ID