Results for “first_yr_rent”
28 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PN_VAR_RENT_SUMM_ALL is a Property Manager (PN) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the calculated variable rent for a line item for a group date. Variable rent in Property Manager represents percentage or turnover rent derived from actual sales volume reported by tenants, calculated against a lease's rent lines and summarized by accounting period and grouping date. This table holds the summarized calculation output that then feeds downstream billing, invoicing, and true-up processing.
Owned by the PN schema with 36 documented columns, the table is registered as VALID. From a Data Vault modeling perspective, the heuristic classification derived from its foreign-key structure is a link. That interpretation is a modeling suggestion only: the table sits at the intersection of variable rent definitions, group dates, line items, and periods, resolving a many-to-many operational relationship rather than acting as a pure descriptive hub or a satellite of a single parent.
Key Information Stored
The surrogate primary key is VAR_RENT_SUMM_ID, enforced by the constraint PN_VAR_RENT_SUMM_PK and also backed by the unique index PN_VAR_RENT_SUMM_U1. In this schema the primary key column is the only documented business-key candidate; no separate natural unique key is exposed, so VAR_RENT_SUMM_ID is the canonical join key across related objects.
- VAR_RENT_SUMM_ID — surrogate primary key identifying each summary row.
- VAR_RENT_ID — foreign key to PN_VAR_RENTS_ALL, the variable rent definition being evaluated.
- PERIOD_ID — foreign key to PN_VAR_PERIODS_ALL, the accounting period for the summary.
- LINE_ITEM_ID — foreign key to PN_VAR_LINES_ALL, the lease line item to which the variable rent applies.
- GRP_DATE_ID — foreign key to PN_VAR_GRP_DATES_ALL, the grouping date record driving the calculation.
- GROUP_DATE and INVOICE_DATE — the group and invoice dates carried on the summary row.
- TOT_ACT_VOL and TOT_FOR_VOL — total actual and forecast volume used in the calculation.
- TOT_DED — total deductions applied against the volume.
- ACT_VAR_RENT, FOR_VAR_RENT, FIRST_YR_RENT, and TRUEUP_VAR_RENT — the actual, forecast, first-year, and true-up variable rent amounts produced by the calculation.
- ORG_ID — operating unit / multi-org partitioning column.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns.
- WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN audit fields.
Common Use Cases and Queries
The most frequent access pattern is retrieval of calculated variable rent for a given lease line item or variable rent definition within a period. A typical reporting query joins the summary to its parents to resolve descriptive context:
- Variable rent calculation review — select ACT_VAR_RENT, FOR_VAR_RENT, and TOT_ACT_VOL for a LINE_ITEM_ID and PERIOD_ID to validate turnover rent output.
- True-up analysis — compare TRUEUP_VAR_RENT against ACT_VAR_RENT to reconcile adjustments.
- Downstream billing — PN_VAR_TRX_HEADERS_ALL references VAR_RENT_SUMM_ID, so the summary feeds transaction and invoice generation.
- Period and group-date reporting — aggregate by GROUP_DATE and PERIOD_ID for turnover rent trend reporting by operating unit (ORG_ID).
Sample pattern:
SELECT s.var_rent_summ_id, s.line_item_id, s.period_id, s.group_date, s.tot_act_vol, s.act_var_rent, s.trueup_var_rent FROM pn_var_rent_summ_all s WHERE s.org_id = :p_org_id AND s.period_id = :p_period_id;
Related Objects
The following relationships are documented via foreign keys and referencing constraints:
- PN_VAR_GRP_DATES_ALL — joined on GRP_DATE_ID.
- PN_VAR_LINES_ALL — joined on LINE_ITEM_ID.
- PN_VAR_RENTS_ALL — joined on VAR_RENT_ID.
- PN_VAR_PERIODS_ALL — joined on PERIOD_ID.
- PN_VAR_TRX_HEADERS_ALL — references this table through VAR_RENT_SUMM_ID, making it the principal downstream consumer of summarized variable rent for transaction and invoice processing.
-
Stores the calculated variable rent for a line item for a group date.
-
This table stores details of variable rent calculations
-
Stores the calculated variable rent for a line item for a group date.
-
This table stores details of variable rent calculations
-
View: PN_VAR_RENT_SUMM_V 12.2.2
Form view used to view variable rent calculation details by line item.
APPS.PN_VAR_RENT_SUMM_V·↳ PN_VAR_PERIODS_ALL·↳ PN_VAR_RENT_CALC_PKG·↳ PN_VAR_RENT_SUMM·Explore PN module →
-
View: PN_VAR_RENT_SUMM_V 12.1.1
Form view used to view variable rent calculation details by line item.
APPS.PN_VAR_RENT_SUMM_V·↳ PN_VAR_PERIODS_ALL·↳ PN_VAR_RENT_CALC_PKG·↳ PN_VAR_RENT_SUMM·Explore PN module →
-
eTRM - PN Tables and Views 12.1.1
Interface table to contain batch lines information.
-
eTRM - PN Tables and Views 12.2.2
Interface table to contain batch lines information.