[Home] [Help] [Dependency Information]
Object Name: | PN_RENT_INCREASE_SUMMARY_ITF |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_RENT_INCREASE_SUMMARY_ITF |
Subobject Name: | |
Status: | VALID |
PN_RENT_INCREASE_SUMMARY_ITF used to create the RXi Rent Increase Summary Report
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (50) | Name of the lease | |
LEASE_NUM | VARCHAR2 | (30) | Lease number | |
PAYMENT_TERM_PRORATION_RULE | NUMBER | Defines the rule to determine the number of days per year in order to generate rent schedules. The year can be represented with 365 days or with 360 days | ||
ABSTRACTED_BY_USER_NAME | VARCHAR2 | (100) | User Name of the user who created the lease | |
LEASE_CLASS_MEANING | VARCHAR2 | (80) | Meaning of the lease class | |
LEASE_COMMENCEMENT_DATE | DATE | Commencement date of the lease | ||
LEASE_TERMINATION_DATE | DATE | Termination date of the lease | ||
LEASE_EXECUTION_DATE | DATE | Execution date of the lease | ||
LEASE_EXTENSION_END_DATE | DATE | Extension end date of the lease | ||
LOCATION_CODE | VARCHAR2 | (30) | Associates the location_code in PN_LOCATIONS_ALL with the row in this table | |
INDEX_NAME | VARCHAR2 | (30) | Associates the row in PN_INDEX_HISTORY_HEADERS with the row in this table | |
IL_COMMENCEMENT_DATE | DATE | Rent Increase Commencement date | ||
IL_TERMINATION_DATE | DATE | Rent Increase Termination date | ||
INDEX_LEASE_NUMBER | VARCHAR2 | (100) | Rent Increase Number | |
IL_ASSESSMENT_DATE | DATE | Date Rent Increase is assessed on | ||
ASSESSMENT_INTERVAL | NUMBER | Determines how frequently the rent increase is assessed. Has to be a postive whole integer | ||
SPREAD_FREQUENCY_MEANING | VARCHAR2 | (80) | Determines how the annual invoiced amount is spread over the year | |
BASIS_PERCENT_DEFAULT | NUMBER | Default basis percentage | ||
INITIAL_BASIS | NUMBER | Basis amount used in the first Rent Increase period | ||
BASE_INDEX | NUMBER | Given the Index Type and the Base Year defaults the Base Index from the table PN_INDEX_HISTORY_LINES | ||
INDEX_FINDER_METHOD | VARCHAR2 | (80) | Determines the options if the index value is unavailable.The value is derived from the lookup code in FND_LOOKUPS table where lookup_type= PN_INDEX_FINDER_METHOD | |
INDEX_FINDER_MONTHS | NUMBER | Denotes the whole number subtracted from the Date Assessed to determine the Index Finder Date | ||
NEGATIVE_RENT_TYPE_MEANING | VARCHAR2 | (80) | Determines the options when negative index rent is encountered.The value is derived from the lookup code in FND_LOOKUPS table where lookup_type= PN_INDEX_NEGATIVE_RENT | |
INCREASE_ON_MEANING | VARCHAR2 | (80) | Indicates the type of payment/billing term the increase is to be assessed on. The value is derived from the lookup code in FND_LOOKUPS table, where lookup_type= PN_PAYMENT_TERM_TYPE | |
BASIS_TYPE | VARCHAR2 | (30) | Determines how the basis amount is calculated.The value is derived from the lookup code in FND_LOOKUPS table,where lookup_type= PN_INDEX_BASIS_TYPE | |
REFERENCE_PERIOD_MEANING | VARCHAR2 | (80) | Required to calculate the index percentage.The value is derived from the lookup code in FND_LOOKUPS table, where lookup_type= PN_INDEX_REF_PERIOD | |
BASE_YEAR | DATE | Index date used to derive the Base Index value | ||
ILP_ASSESSMENT_DATE | DATE | Date the rent increase is assessed on | ||
BASIS_START_DATE | DATE | Period Basis start date | ||
BASIS_END_DATE | DATE | Period Basis end date | ||
INDEX_FINDER_DATE | DATE | Period Index Finder date | ||
CURRENT_BASIS | NUMBER | The current basis amount is calculated as the sum of schedule items lying between the basis start date and basis end date | ||
RELATIONSHIP_MEANING | VARCHAR2 | (80) | Determines whether the percentage calculated is a basis percentage, Basis Only, index percentage Index Only, the Greater of or Lesser Of the index percentage or Basis percentage. The value is derived from the lookup code in FND_LOOKUPS table, where lookup_type= PN_INDEX_RELATION | |
INDEX_PERCENT_CHANGE | NUMBER | System Calculated Index Percentage | ||
BASIS_PERCENT_CHANGE | NUMBER | Basis percentage | ||
CURRENT_INDEX_LINE_VALUE | NUMBER | Index value associated with the current index finder date | ||
PREVIOUS_INDEX_LINE_VALUE | NUMBER | Index value of the previous index finder date | ||
UNCONSTRAINT_RENT_DUE | NUMBER | Unconstrained rent increase amount | ||
CONSTRAINT_RENT_DUE | NUMBER | Rent increase amount after constraints have been applied | ||
CARRY_FORWARD_AMOUNT | NUMBER | Stores the carry forward amount available to the next period | ||
CARRY_FORWARD_PERCENT | NUMBER | Stores the carry forward percentage available to the next period | ||
CONSTRAINT_APPLIED_AMOUNT | NUMBER | Stores the amount of the minimum or maximum constraint applied to the unconstrained rent due for the period | ||
CONSTRAINT_APPLIED_PERCENT | NUMBER | Stores the percentage of the minimum or maximum constraint | ||
OPEN_CARRY_FORWARD_AMOUNT | NUMBER | Opening balance of the carry forward amount | ||
OPEN_CARRY_FORWARD_PERCENT | NUMBER | Opening balance of the carry forward percent | ||
APP_CARRY_FORWARD_AMOUNT | NUMBER | Carry forward amount applied in the current period | ||
APP_CARRY_FORWARD_PERCENT | NUMBER | Carry forward percent applied in the current period | ||
OLD_RENT | NUMBER | Constrained rent amount for the previous assessment period | ||
NEW_RENT | NUMBER | Constrained rent amount for the current assessment period | ||
CHANGE_RENT | NUMBER | Difference between old and new rent | ||
CONSTRAINT_PRORATION | VARCHAR2 | (80) | Timing method used to prorate lease costs over a shorter period of time. Valid values are No Proration, Days / 365, Full and Partial Months / 12 | |
INDEX_MULTIPLIER | NUMBER | Index Multiplier is applied to the index value to determine the final value by which the rent is increased from one period to the next | ||
UNADJUSTED_INDEX_CHANGE | NUMBER | System calculated index change | ||
ADJUSTED_INDEX_CHANGE_PERCENT | NUMBER | Index multiplier times unadjusted index change percent | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row | ||
LAST_UPDATED_BY | NUMBER | Standard Who column - user who last updated this row (foreign key to FND_USER.USER_ID) | ||
CREATION_DATE | DATE | Standard Who column - date when this row was created | ||
CREATED_BY | NUMBER | 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) | ||
REQUEST_ID | NUMBER | Concurrent Program Who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID) |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, LEASE_NUM
, PAYMENT_TERM_PRORATION_RULE
, ABSTRACTED_BY_USER_NAME
, LEASE_CLASS_MEANING
, LEASE_COMMENCEMENT_DATE
, LEASE_TERMINATION_DATE
, LEASE_EXECUTION_DATE
, LEASE_EXTENSION_END_DATE
, LOCATION_CODE
, INDEX_NAME
, IL_COMMENCEMENT_DATE
, IL_TERMINATION_DATE
, INDEX_LEASE_NUMBER
, IL_ASSESSMENT_DATE
, ASSESSMENT_INTERVAL
, SPREAD_FREQUENCY_MEANING
, BASIS_PERCENT_DEFAULT
, INITIAL_BASIS
, BASE_INDEX
, INDEX_FINDER_METHOD
, INDEX_FINDER_MONTHS
, NEGATIVE_RENT_TYPE_MEANING
, INCREASE_ON_MEANING
, BASIS_TYPE
, REFERENCE_PERIOD_MEANING
, BASE_YEAR
, ILP_ASSESSMENT_DATE
, BASIS_START_DATE
, BASIS_END_DATE
, INDEX_FINDER_DATE
, CURRENT_BASIS
, RELATIONSHIP_MEANING
, INDEX_PERCENT_CHANGE
, BASIS_PERCENT_CHANGE
, CURRENT_INDEX_LINE_VALUE
, PREVIOUS_INDEX_LINE_VALUE
, UNCONSTRAINT_RENT_DUE
, CONSTRAINT_RENT_DUE
, CARRY_FORWARD_AMOUNT
, CARRY_FORWARD_PERCENT
, CONSTRAINT_APPLIED_AMOUNT
, CONSTRAINT_APPLIED_PERCENT
, OPEN_CARRY_FORWARD_AMOUNT
, OPEN_CARRY_FORWARD_PERCENT
, APP_CARRY_FORWARD_AMOUNT
, APP_CARRY_FORWARD_PERCENT
, OLD_RENT
, NEW_RENT
, CHANGE_RENT
, CONSTRAINT_PRORATION
, INDEX_MULTIPLIER
, UNADJUSTED_INDEX_CHANGE
, ADJUSTED_INDEX_CHANGE_PERCENT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
FROM PN.PN_RENT_INCREASE_SUMMARY_ITF;
PN.PN_RENT_INCREASE_SUMMARY_ITF does not reference any database object
PN.PN_RENT_INCREASE_SUMMARY_ITF is referenced by following:
|
|
|