eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PN_PAYMENT_TERMS_ALL

Product:	PN - Property Manager
Description:	Payment and billing terms defined in a lease
Implementation/DBA Data:	PN.PN_PAYMENT_TERMS_ALL

Primary Key: PN_PAYMENT_TERMS_PK

PAYMENT_TERM_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PN_PAYMENT_TERMS_ALL	HZ_CUST_ACCOUNTS	PN_PAYMENT_TERMS_ALL.CUSTOMER_ID
PN_PAYMENT_TERMS_ALL	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_ALL	PN_LEASES_ALL	PN_PAYMENT_TERMS_ALL.LEASE_ID
PN_PAYMENT_TERMS_ALL	PN_LEASE_CHANGES_ALL	PN_PAYMENT_TERMS_ALL.LEASE_CHANGE_ID
PN_PAYMENT_TERMS_ALL	GL_SETS_OF_BOOKS_11I	PN_PAYMENT_TERMS_ALL.SET_OF_BOOKS_ID
PN_PAYMENT_TERMS_ALL	GL_CODE_COMBINATIONS	PN_PAYMENT_TERMS_ALL.CODE_COMBINATION_ID
PN_PAYMENT_TERMS_ALL	FND_CURRENCIES	PN_PAYMENT_TERMS_ALL.CURRENCY_CODE
PN_PAYMENT_TERMS_ALL	PO_VENDORS	PN_PAYMENT_TERMS_ALL.VENDOR_ID
PN_PAYMENT_TERMS_ALL	PO_VENDOR_SITES_ALL	PN_PAYMENT_TERMS_ALL.VENDOR_SITE_ID
PN_PAYMENT_TERMS_ALL	RA_CUSTOMERS	PN_PAYMENT_TERMS_ALL.CUSTOMER_ID
PN_PAYMENT_TERMS_ALL	RA_SITE_USES_ALL	PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_ALL	HZ_CUST_ACCOUNTS	PN_PAYMENT_TERMS_ALL.CUSTOMER_ID
PN_PAYMENT_TERMS_ALL	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_TERMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_TERMS_ALL	HZ_CUST_SITE_USES_ALL	PN_PAYMENT_TERMS_ALL.CUST_SHIP_SITE_ID
PN_PAYMENT_TERMS_ALL	PN_REC_PERIOD_BILL_ALL	PN_PAYMENT_TERMS_ALL.PERIOD_BILLREC_ID
PN_PAYMENT_TERMS_ALL	PN_OPEX_RECON_ALL	PN_PAYMENT_TERMS_ALL.OPEX_RECON_ID
PN_PAYMENT_TERMS_ALL	PN_VAR_RENT_INV_ALL	PN_PAYMENT_TERMS_ALL.VAR_RENT_INV_ID
PN_PAYMENT_TERMS_ALL	PN_TERM_TEMPLATES_ALL	PN_PAYMENT_TERMS_ALL.TERM_TEMPLATE_ID
PN_ADJUSTMENT_SUMMARIES	PN_PAYMENT_TERMS_ALL	PN_ADJUSTMENT_SUMMARIES.PAYMENT_TERM_ID
PN_DISTRIBUTIONS_ALL	PN_PAYMENT_TERMS_ALL	PN_DISTRIBUTIONS_ALL.PAYMENT_TERM_ID
PN_INDEX_EXCLUDE_TERM_ALL	PN_PAYMENT_TERMS_ALL	PN_INDEX_EXCLUDE_TERM_ALL.PAYMENT_TERM_ID
PN_INDEX_LEASE_TERMS_ALL	PN_PAYMENT_TERMS_ALL	PN_INDEX_LEASE_TERMS_ALL.LEASE_TERM_ID
PN_INDEX_LEASE_TERMS_ALL	PN_PAYMENT_TERMS_ALL	PN_INDEX_LEASE_TERMS_ALL.RENT_INCREASE_TERM_ID
PN_LEASE_MILESTONES_ALL	PN_PAYMENT_TERMS_ALL	PN_LEASE_MILESTONES_ALL.PAYMENT_TERM_ID
PN_PAYMENT_ITEMS_ALL	PN_PAYMENT_TERMS_ALL	PN_PAYMENT_ITEMS_ALL.PAYMENT_TERM_ID
PN_VAR_ABATEMENTS_ALL	PN_PAYMENT_TERMS_ALL	PN_VAR_ABATEMENTS_ALL.PAYMENT_TERM_ID
PN_DISTRIBUTIONS_ALL	PN_PAYMENT_TERMS_ALL	PN_DISTRIBUTIONS_ALL.PAYMENT_TERM_ID
PN_REC_LINBILL_ALL	PN_PAYMENT_TERMS_ALL	PN_REC_LINBILL_ALL.PAYMENT_TERM_ID
PN_PAYMENT_TERMS_HISTORY	PN_PAYMENT_TERMS_ALL	PN_PAYMENT_TERMS_HISTORY.PAYMENT_TERM_ID
PN_REC_LINBILL_ALL	PN_PAYMENT_TERMS_ALL	PN_REC_LINBILL_ALL.PAYMENT_TERM_ID
PN_VAR_ABATEMENTS_ALL	PN_PAYMENT_TERMS_ALL	PN_VAR_ABATEMENTS_ALL.PAYMENT_TERM_ID