Search Results pn_payment_schedules_all




Overview
Explore in AI Chat

Overview

The PN_PAYMENT_SCHEDULES_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Property Manager (PN) module. It serves as the central table for storing all payment or billing schedules associated with lease agreements, applicable to both landlord and tenant obligations. Its primary role is to define the financial terms and timelines for recurring payments, such as base rent, operating expenses, or other charges, as stipulated in a lease contract. The table's "ALL" suffix indicates it is a multi-organization table, storing data across all operating units configured within the EBS instance, which is essential for centralized property portfolio management in a global enterprise.

Key Information Stored

The table's structure is designed to capture the essential attributes of a payment schedule. The primary key, PAYMENT_SCHEDULE_ID, uniquely identifies each schedule. Critical foreign keys establish its relationships: LEASE_ID links the schedule to a specific lease in PN_LEASES_ALL, and LEASE_CHANGE_ID associates it with a specific lease amendment or modification in PN_LEASE_CHANGES_ALL. The table also tracks workflow and approval status through columns like APPROVED_BY_USER_ID and TRANSFERRED_BY_USER_ID, which reference the FND_USER table. Other significant columns typically include schedule type (e.g., payment, billing), frequency, start and end dates, status, and terms defining the payment calculation basis.

Common Use Cases and Queries

This table is fundamental for generating financial reports, processing invoices, and analyzing lease liabilities. Common operational and reporting scenarios include generating a rent roll for all active leases, calculating upcoming payment obligations for cash flow forecasting, and auditing payment terms during lease renewals. A typical query might join PN_PAYMENT_SCHEDULES_ALL with PN_LEASES_ALL and PN_LOCATIONS_ALL to report on all payment schedules for a specific property or portfolio. Another common pattern is to query schedules with a specific status (e.g., 'APPROVED') and a due date within a given period to feed the accounts payable or receivable subledgers. Analysts often aggregate data from this table to assess the total lease commitment value by fiscal year.

Related Objects

PN_PAYMENT_SCHEDULES_ALL is a pivotal object with several key dependencies. It is the parent table for PN_PAYMENT_ITEMS_ALL, which stores the individual line-item charges (e.g., rent, CAM, utilities) that constitute the schedule. As indicated by the foreign keys, it is a child of PN_LEASES_ALL and PN_LEASE_CHANGES_ALL, deriving its contractual context from these entities. The table also integrates with the EBS user management framework via FND_USER for approval and transfer audit trails. In application logic, it is heavily referenced by the Property Manager's APIs and public interfaces for creating, modifying, and querying lease payment terms.