Search Results pn_var_rent_summ_all




Overview
Explore in AI Chat

Overview

The PN_VAR_RENT_SUMM_ALL table is a core transactional data store within the Oracle E-Business Suite Property Manager (PN) module. It plays a critical role in the management of variable or percentage rent lease agreements. The table's primary function is to persist the final calculated variable rent amount for a specific lease line item, aggregated for a particular group date. This stored summary data is essential for generating accurate rent invoices, financial reporting, and providing a historical audit trail of all variable rent calculations performed by the system. As an "_ALL" table, it is designed to support multi-organization access (MOAC) by including the ORG_ID column, allowing data partitioning by operating unit.

Key Information Stored

The table's structure is centered around linking key lease components and storing the resultant calculated amounts. Its primary key is the unique identifier, VAR_RENT_SUMM_ID. The most critical columns are foreign keys that establish essential relationships: VAR_RENT_ID links to the main variable rent header (PN_VAR_RENTS_ALL), PERIOD_ID connects to the calculation period (PN_VAR_PERIODS_ALL), LINE_ITEM_ID points to the specific lease line (PN_VAR_LINES_ALL), and GRP_DATE_ID associates the record with a specific date grouping for aggregation (PN_VAR_GRP_DATES_ALL). The table also stores the calculated monetary amounts, typically in columns such as CALCULATED_AMOUNT or similar, though the exact name is implied by the table's purpose. The inclusion of ORG_ID enforces data security at the operating unit level.

Common Use Cases and Queries

This table is central to post-calculation reporting and reconciliation. A common use case is generating a detailed report of all variable rent charges for a specific lease or across a portfolio for a given period. Financial analysts may query this table to verify calculated amounts against source data or to audit rent invoices. A typical reporting query would join PN_VAR_RENT_SUMM_ALL to its related master tables to pull descriptive information. For example:

  • Identifying all summarized variable rent for a specific lease agreement by joining on VAR_RENT_ID to PN_VAR_RENTS_ALL and filtering by a lease or customer identifier.
  • Aggregating total variable rent liability by property or operating unit by summing the calculated amount column, grouped by ORG_ID and related property data.
  • Troubleshooting calculation runs by selecting records for a specific PERIOD_ID and LINE_ITEM_ID to review amounts for a particular line in a specific period.

Direct data manipulation (DML) on this table is strongly discouraged; all calculations and entries should be made through the standard Property Manager application interfaces.

Related Objects

As documented by its foreign key constraints, PN_VAR_RENT_SUMM_ALL has direct, integral relationships with several other Property Manager tables. These relationships form the backbone of the variable rent calculation and storage hierarchy.

  • PN_VAR_RENTS_ALL: Joined via VAR_RENT_ID. This is the parent header record defining the variable rent agreement for a lease.
  • PN_VAR_PERIODS_ALL: Joined via PERIOD_ID. This table defines the time period (e.g., a calendar quarter) for which the variable rent is calculated.
  • PN_VAR_LINES_ALL: Joined via LINE_ITEM_ID. This table holds the specific line item details (like sales breakpoints or percentage rates) used in the rent formula.
  • PN_VAR_GRP_DATES_ALL: Joined via GRP_DATE_ID. This table manages the date groupings used for aggregating transactional data (like monthly sales) that feed into the variable rent calculation for the period.

The primary key constraint PN_VAR_RENT_SUMM_PK ensures the uniqueness of each summary record. Data is typically accessed via these foreign key joins for any comprehensive reporting or integration.