Search Results pn_var_trx_headers_pk

Overview

PN.PN_VAR_TRX_HEADERS_ALL is a Property Manager (PN) transaction table that stores the header-level results of variable rent calculations in Oracle E-Business Suite 12.1.1 and 12.2.2. Variable rent, commonly used in retail and commercial lease agreements, charges a tenant a percentage of reported sales in addition to (or instead of) base rent. Each row in this table represents one calculated variable rent transaction header, tying together the lease's variable rent definition, the accounting period, the reporting group, and the resulting rent amounts.

The object is documented as VALID in the PN schema with a surrogate primary key PN_VAR_TRX_HEADERS_PK on TRX_HEADER_ID, and a unique index PN_VAR_TRX_HEADERS_U1 on the same column. The physical schema contains 40 documented columns. The heuristic Data Vault classification mined from the foreign-key structure is standalone; from a modeling perspective this suggests treating the table as a self-contained transaction hub rather than a strict satellite of a parent entity, since its outbound foreign keys point to several different PN reference tables rather than a single dominant parent.

Key Information Stored

The most significant columns are:

• TRX_HEADER_ID — surrogate primary key; uniquely identifies each variable rent transaction header.
• VAR_RENT_ID — foreign key to PN_VAR_RENTS_ALL; the variable rent agreement rule that generated the calculation.
• VAR_RENT_SUMM_ID — foreign key to PN_VAR_RENT_SUMM_ALL; the variable rent summary driving this transaction.
• GRP_DATE_ID — foreign key to PN_VAR_GRP_DATES_ALL; the sales reporting group date range.
• PERIOD_ID and LINE_ITEM_ID / LINE_ITEM_GROUP_ID — accounting period and lease line item context.
• CALC_PRD_START_DATE, CALC_PRD_END_DATE — the calculation period boundaries.
• REPORTING_GROUP_SALES, PRORATED_GROUP_SALES, YTD_SALES — reported, pro-rated, and year-to-date sales figures (with _FOR variants for foreign-currency reporting).
• CALCULATED_RENT, PERCENT_RENT_DUE, PRORATED_RENT_DUE, TRUEUP_RENT_DUE, YTD_PERCENT_RENT — the computed rent amounts and amounts due.
• FIRST_YR_RENT, INVOICE_FLAG — first-year rent handling and whether the header has been invoiced.
• ORG_ID — operating unit (multi-org) identifier; audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include reviewing computed percentage rent for a lease period, reconciling sales reported against rent due, and tracing invoiced variable rent back to the AutoInvoice interface. A representative query:

• SELECT h.TRX_HEADER_ID, h.VAR_RENT_ID, h.PERIOD_ID, h.REPORTING_GROUP_SALES, h.CALCULATED_RENT, h.PERCENT_RENT_DUE, h.TRUEUP_RENT_DUE, h.INVOICE_FLAG FROM PN_VAR_TRX_HEADERS_ALL h WHERE h.ORG_ID = :org_id AND h.CALC_PRD_START_DATE >= :from_date AND h.CALC_PRD_END_DATE <= :to_date;
• Joining to PN_VAR_TRX_DETAILS_ALL d ON d.TRX_HEADER_ID = h.TRX_HEADER_ID to obtain line-level breakdown of a header.
• Filtering on INVOICE_FLAG to isolate unbilled percentage rent for AutoInvoice generation.

Related Objects

The table references PN_VAR_RENTS_ALL (via VAR_RENT_ID), PN_VAR_GRP_DATES_ALL (via GRP_DATE_ID), and PN_VAR_RENT_SUMM_ALL (via VAR_RENT_SUMM_ID). It is referenced by PN_VAR_TRX_DETAILS_ALL (via TRX_HEADER_ID) for line detail, and by the AutoInvoice interface tables AR_INV_API_HEADERS_GT, AR_INV_API_LINES_GT, AR_INV_API_DIST_GT, AR_TRX_HEADER_GT, AR_TRX_LINES_GT, AR_TRX_HEADER_TMP_GT, and AR_TRX_LINES_TMP_GT (all via TRX_HEADER_ID), reflecting the flow of variable rent into Receivables invoicing.