Results for “actual_invoiced_amount”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PN_VAR_RENT_INV_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 details for a given period and invoice date. Variable rent, in the context of percentage-rent retail leases, represents the rent payable to a landlord that varies according to tenant sales volume rather than a fixed contractual amount. This table captures the outcome of the variable rent calculation process, serving as the persistent bridge between the underlying rent setup (period definitions and variable rent terms) and the downstream invoicing, abatement, and payment-term activities that consume those calculated amounts.

From a data-modeling perspective, the heuristic Data Vault classification for this object is satellite-leaning. It functions primarily as a descriptive, time-stamped structure that records the attributes and results of a specific variable rent calculation event, rather than acting as an independent hub of business entities or a pure link table. Analysts designing a Data Vault or dimensional model around Property Manager should treat PN_VAR_RENT_INV_ALL as a satellite keyed by its surrogate identifier, with foreign dependencies flowing toward PN_VAR_PERIODS_ALL and PN_VAR_RENTS_ALL as parent hubs.

Key Information Stored

The table contains 48 documented columns. The surrogate primary key is VAR_RENT_INV_ID, enforced by the PN_VAR_RENT_INV_PK constraint and additionally backed by the unique index PN_VAR_RENT_INV_U1, making it the single documented business-key candidate.

• VAR_RENT_INV_ID — surrogate primary key uniquely identifying each variable rent invoice calculation record.
• PERIOD_ID — foreign key to PN_VAR_PERIODS_ALL, identifying the accounting or sales-reporting period to which the calculation applies.
• VAR_RENT_ID — foreign key to PN_VAR_RENTS_ALL, tying the record to the governing variable rent term or agreement line.
• INVOICE_DATE — the date associated with the invoice for which variable rent was calculated.
• ADJUST_NUM — sequence number supporting adjustments applied to the calculation.
• TOT_ACT_VOL — total actual sales volume reported for the period.
• ACT_PER_RENT — actual percentage rent derived from the volume and rent percentage.
• FOR_PER_RENT — forecasted percentage rent for comparison against actuals.
• CONSTR_ACTUAL_RENT — the constrained actual rent value after application of contractual rules.
• ACTUAL_INVOICED_AMOUNT — the amount ultimately invoiced to the tenant.
• ABATEMENT_APPL and REC_ABATEMENT — indicators and recovered values related to rent abatement application and recovery, with REC_ABATEMENT_OVERRIDE allowing manual adjustment.
• NEGATIVE_RENT and DEF_NEG_RENT — indicators controlling whether negative rent is permitted and how it is deferred or handled.
• TRUE_UP_AMT and TRUE_UP_STATUS — the calculated true-up amount and its processing status.
• ORG_ID — the operating unit identifier supporting multi-organization security, alongside standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and 15 descriptive ATTRIBUTE flex columns.

Common Use Cases and Queries

The most frequent query pattern retrieves calculated variable rent for a lease or period, joining to the parent rent definition and period table:

• Reporting invoiced percentage rent by period: select INVOICE_DATE, TOT_ACT_VOL, ACT_PER_RENT, ACTUAL_INVOICED_AMOUNT from PN_VAR_RENT_INV_ALL where PERIOD_ID = :period and ORG_ID = :org.
• Variance analysis between forecasted and actual rent using FOR_PER_RENT versus ACT_PER_RENT, and the status columns ACTUAL_TERM_STATUS, FORECASTED_TERM_STATUS, and VARIANCE_TERM_STATUS with their corresponding EXP_CODE fields.
• Abatement and true-up reconciliation, joining to PN_VAR_ABATEMENTS_ALL by VAR_RENT_INV_ID to validate applied abatements against ABATEMENT_APPL and TRUE_UP_AMT.
• Feeding downstream billing by selecting records where ACTUAL_INVOICED_AMOUNT is non-zero and joining to PN_PAYMENT_TERMS_ALL for scheduled collections.

Related Objects

The table participates in a clearly documented foreign-key network within Property Manager:

• PN_VAR_PERIODS_ALL — referenced via PERIOD_ID; defines the periods for which variable rent is calculated.
• PN_VAR_RENTS_ALL — referenced via VAR_RENT_ID; holds the governing variable rent term.
• PN_VAR_ABATEMENTS_ALL — references PN_VAR_RENT_INV_ALL.VAR_RENT_INV_ID, storing abatement records tied to each calculation.
• PN_PAYMENT_TERMS_ALL — references VAR_RENT_INV_ID, holding payment schedules generated from the calculated rent.
• PN_PAYMENT_TERMS_HISTORY — references VAR_RENT_INV_ID, retaining historical payment-term versions.