FND Design Data [Home] [Help]

Table: PN_PAYMENT_ITEMS_ALL

Product: PN - Property Manager
Description: Payment and billing items associated with a payment or a billing schedule
Implementation/DBA Data: TablePN.PN_PAYMENT_ITEMS_ALL
Primary Key: PN_PAYMENT_ITEMS_PK
  1. ColumnPAYMENT_ITEM_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PN_PAYMENT_ITEMS_ALL FK Joins to TableHZ_CUST_ACCOUNTS PN_PAYMENT_ITEMS_ALL.CUSTOMER_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TablePN_PAYMENT_SCHEDULES_ALL PN_PAYMENT_ITEMS_ALL.PAYMENT_SCHEDULE_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TablePN_PAYMENT_TERMS_ALL PN_PAYMENT_ITEMS_ALL.PAYMENT_TERM_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I PN_PAYMENT_ITEMS_ALL.SET_OF_BOOKS_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TableFND_CURRENCIES PN_PAYMENT_ITEMS_ALL.CURRENCY_CODE
PN_PAYMENT_ITEMS_ALL FK Joins to TableFND_CURRENCIES PN_PAYMENT_ITEMS_ALL.EXPORT_CURRENCY_CODE
PN_PAYMENT_ITEMS_ALL FK Joins to TablePO_VENDORS PN_PAYMENT_ITEMS_ALL.VENDOR_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TablePO_VENDOR_SITES_ALL PN_PAYMENT_ITEMS_ALL.VENDOR_SITE_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TableRA_CUSTOMERS PN_PAYMENT_ITEMS_ALL.CUSTOMER_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TableRA_SITE_USES_ALL PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TableHZ_CUST_ACCOUNTS PN_PAYMENT_ITEMS_ALL.CUSTOMER_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL PN_PAYMENT_ITEMS_ALL.CUSTOMER_SITE_USE_ID
PN_PAYMENT_ITEMS_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL PN_PAYMENT_ITEMS_ALL.CUST_SHIP_SITE_ID
TablePN_ADJUSTMENT_DETAILS FK Joins to PN_PAYMENT_ITEMS_ALL PN_ADJUSTMENT_DETAILS.PAYMENT_ITEM_ID