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_RENT_INV_ALL

Object Details

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

PN_VAR_RENT_INV_ALL stores the variable rent calculation details by period and by invoice date and information indicating whether a term has been created for forecasted,actual or actual-forecasted variable rent.This table is partitioned by org.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_VAR_RENT_INV_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VAR_RENT_INV_ID
PN_VAR_RENT_INV_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_ID
PN_VAR_RENT_INV_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_DATE
PN_VAR_RENT_INV_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VAR_RENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
VAR_RENT_INV_ID	NUMBER		Yes	Uniquely identifies the Variable Rent Invoice row.The value is populated using the sequence PN_VAR_RENT_INV_S.
ADJUST_NUM	NUMBER		Yes	Unique number of a variable rent invoice row identifying the number of adjustments made to a period and an invoice date.
INVOICE_DATE	DATE		Yes	Invoice Date derived from the table pn_var_grp_dates.
FOR_PER_RENT	NUMBER			Forecasted Variable rent calculated based on total forecasted volume.
TOT_ACT_VOL	NUMBER			Total actual volume on which actual variable rent calculation is based on.
ACT_PER_RENT	NUMBER			Actual Variable rent calculated based on total actual volume.
CONSTR_ACTUAL_RENT	NUMBER			Actual Variable rent after constraints have been applied.
ABATEMENT_APPL	NUMBER			Abatement applicable to the constrained actual variable rent.
NEGATIVE_RENT	NUMBER			Negative rent applicable to the constrained actual variable rent.
ACTUAL_INVOICED_AMOUNT	NUMBER			Actual variable rent to be invoiced.
PERIOD_ID	NUMBER		Yes	Associates the invoice row in this table with a period row.
VAR_RENT_ID	NUMBER		Yes	Associates the invoice row in this table with a variable rent row.
ACTUAL_TERM_STATUS	VARCHAR2	(1)	Yes	Has a value of 'Y' if a term has been created f or actual variable rent.
FORECASTED_TERM_STATUS	VARCHAR2	(1)	Yes	Has a value of 'Y' if a term has been created for forecasted variable rent.
VARIANCE_TERM_STATUS	VARCHAR2	(1)	Yes	Has a value of 'Y' if a term has been created for the difference between actual variable rent and forecasted variable rent.
ACTUAL_EXP_CODE	VARCHAR2	(1)	Yes	Identifies if actual rent amount has been exported for the invoice date and period.
FORECASTED_EXP_CODE	VARCHAR2	(1)	Yes	Identifies if forecasted rent amount has been exported for the invoice date and period.
VARIANCE_EXP_CODE	VARCHAR2	(1)	Yes	Identifies if the difference of forecasted variable rent and actual variable rent amount has been exported for the invoice date and period.
COMMENTS	VARCHAR2	(2000)		Comments related to the invoice row.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ORG_ID	NUMBER	(15)		Organization identifier
REC_ABATEMENT	NUMBER			Recurring abatement amount calculated by the system applicable to an invoice.
REC_ABATEMENT_OVERRIDE	NUMBER			Recurring abatement amount defined by the user. The user defined value takes precedence over the recurring abatement amount calculated by the system.
DEF_NEG_RENT	NUMBER			Specifies whether negative rent is to be deferred to next invoice period
TRUE_UP_AMT	NUMBER			True-up rent amount
TRUE_UP_STATUS	VARCHAR2	(1)		Indicates whether true-up term has been created
TRUE_UP_EXP_CODE	VARCHAR2	(1)		Code specifying whether the true-up term is approved.
CREDIT_FLAG	VARCHAR2	(1)		Flag indicating whether the invoice that is created is the result of reversal terms .

Query Text

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


SELECT VAR_RENT_INV_ID
,      ADJUST_NUM
,      INVOICE_DATE
,      FOR_PER_RENT
,      TOT_ACT_VOL
,      ACT_PER_RENT
,      CONSTR_ACTUAL_RENT
,      ABATEMENT_APPL
,      NEGATIVE_RENT
,      ACTUAL_INVOICED_AMOUNT
,      PERIOD_ID
,      VAR_RENT_ID
,      ACTUAL_TERM_STATUS
,      FORECASTED_TERM_STATUS
,      VARIANCE_TERM_STATUS
,      ACTUAL_EXP_CODE
,      FORECASTED_EXP_CODE
,      VARIANCE_EXP_CODE
,      COMMENTS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      REC_ABATEMENT
,      REC_ABATEMENT_OVERRIDE
,      DEF_NEG_RENT
,      TRUE_UP_AMT
,      TRUE_UP_STATUS
,      TRUE_UP_EXP_CODE
,      CREDIT_FLAG
FROM PN.PN_VAR_RENT_INV_ALL;

Dependencies

[top of page]

PN.PN_VAR_RENT_INV_ALL does not reference any database object

PN.PN_VAR_RENT_INV_ALL is referenced by following:

APPS: PN_VAR_RENT_INV; PN_VAR_RENT_INV_ALL