eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PN.PN_VAR_TRX_HEADERS_ALL

Object Details

Object Name:	PN_VAR_TRX_HEADERS_ALL
Object Type:	TABLE
Owner:	PN
FND Design Data:	PN.PN_VAR_TRX_HEADERS_ALL
Subobject Name:
Status:	VALID

PN_VAR_TRX_HEADERS_ALL stores details of variable rent calculations

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_VAR_TRX_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRX_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRX_HEADER_ID	NUMBER	(15)	Yes	Identifier of the calculation sub-period
VAR_RENT_ID	NUMBER	(15)	Yes	Identifier of the variable rent agreement
PERIOD_ID	NUMBER	(15)	Yes	Identifier of the annual period
LINE_ITEM_ID	NUMBER	(15)	Yes	Identifier of the line item
GRP_DATE_ID	NUMBER	(15)	Yes	Identifier of the calculation period
CALC_PRD_START_DATE	DATE			Start date of the calculation sub-period
CALC_PRD_END_DATE	DATE			End date of the calculation sub-period
VAR_RENT_SUMM_ID	NUMBER	(15)		Identifier of the variable rent summary
LINE_ITEM_GROUP_ID	NUMBER			Identifier of the group for this line item in the Setup table
RESET_GROUP_ID	NUMBER			Identifier of the line item group at the end of a cumulative cycle after a change in break rate
PRORATION_FACTOR	NUMBER			Proration factor calculated as days in the calculation sub-period divided by the total number of days in calculation period
REPORTING_GROUP_SALES	NUMBER			Total sales for the calculation period
PRORATED_GROUP_SALES	NUMBER			Total sales for the calculation sub-period
YTD_SALES	NUMBER			Year-to-date sales for the calculation sub-period
REPORTING_GROUP_SALES_FOR	NUMBER			Total forecasted sales for the calculation period
PRORATED_GROUP_SALES_FOR	NUMBER			Total forecasted sales for the calculation sub-period
YTD_SALES_FOR	NUMBER			Year-to-date forecasted sales for the calculation sub-period
FY_PRORATION_SALES	NUMBER			Prorated sales for the first year
LY_PRORATION_SALES	NUMBER			Prorated sales for the last year
CALCULATED_RENT	NUMBER			Cumulative rent amount
PERCENT_RENT_DUE	NUMBER			Gross variable rent for the calculation sub-period
YTD_PERCENT_RENT	NUMBER			Year-to-date gross variable rent
PRORATED_RENT_DUE	NUMBER			Amount of prorated rent due using the partial year calculation methods of first year, last year, and first, last, and first year and last year
TRUEUP_RENT_DUE	NUMBER			Amount of true-up rent due
CALCULATED_RENT_FOR	NUMBER			Cumulative forecasted rent amount
PERCENT_RENT_DUE_FOR	NUMBER			Forecasted variable rent for the calculation sub-period
YTD_PERCENT_RENT_FOR	NUMBER			Year-to-date forecasted rent
REPORTING_GROUP_DEDUCTIONS	NUMBER			Total deduction amount for the calculation period
PRORATED_GROUP_DEDUCTIONS	NUMBER			Total deduction amount for the calculation sub-period
YTD_DEDUCTIONS	NUMBER			Year-to-date deduction amount
LY_PRORATION_DEDUCTIONS	NUMBER			Prorated deduction for the last year
FY_PRORATION_DEDUCTIONS	NUMBER			Prorated deduction for the first year
FIRST_YR_RENT	NUMBER			Amount of partial first year
INVOICE_FLAG	VARCHAR2	(1)		Flag indicating whether an invoice is to be created
ORG_ID	NUMBER	(15)		Identifier of the operating unit
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRX_HEADER_ID
,      VAR_RENT_ID
,      PERIOD_ID
,      LINE_ITEM_ID
,      GRP_DATE_ID
,      CALC_PRD_START_DATE
,      CALC_PRD_END_DATE
,      VAR_RENT_SUMM_ID
,      LINE_ITEM_GROUP_ID
,      RESET_GROUP_ID
,      PRORATION_FACTOR
,      REPORTING_GROUP_SALES
,      PRORATED_GROUP_SALES
,      YTD_SALES
,      REPORTING_GROUP_SALES_FOR
,      PRORATED_GROUP_SALES_FOR
,      YTD_SALES_FOR
,      FY_PRORATION_SALES
,      LY_PRORATION_SALES
,      CALCULATED_RENT
,      PERCENT_RENT_DUE
,      YTD_PERCENT_RENT
,      PRORATED_RENT_DUE
,      TRUEUP_RENT_DUE
,      CALCULATED_RENT_FOR
,      PERCENT_RENT_DUE_FOR
,      YTD_PERCENT_RENT_FOR
,      REPORTING_GROUP_DEDUCTIONS
,      PRORATED_GROUP_DEDUCTIONS
,      YTD_DEDUCTIONS
,      LY_PRORATION_DEDUCTIONS
,      FY_PRORATION_DEDUCTIONS
,      FIRST_YR_RENT
,      INVOICE_FLAG
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PN.PN_VAR_TRX_HEADERS_ALL;

Dependencies

[top of page]

PN.PN_VAR_TRX_HEADERS_ALL does not reference any database object

PN.PN_VAR_TRX_HEADERS_ALL is referenced by following:

APPS: PN_VAR_TRX_HEADERS; PN_VAR_TRX_HEADERS_ALL