[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PN_RENT_INCREASE_DETAIL_ITF |
|---|---|
| Object Type: | TABLE |
| Owner: | PN |
| FND Design Data: |  PN.PN_RENT_INCREASE_DETAIL_ITF
|
| Subobject Name: | |
| Status: | VALID |
Interface Table used in creating the RXi Report Rent Increase Detail 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 | ||
| PAYMENT_PURPOSE_MEANING | VARCHAR2 | (80) | Identifies the purpose of the term, for example whether it is for rent, operating expense, insurance. The value is derived from meaning in FND_LOOKUPS where lookup_type = PN_PAYMENT_PURPOSE_TYPE | |
| PAYMENT_TERM_TYPE_MEANING | VARCHAR2 | (80) | Identifies the type of the term, fore example, base, escalation, pre-payment. The value is derived from meaning in FND_LOOKUPS where lookup_type = PN_PAYMENT_TERM_TYPE | |
| FREQUENCY_MEANING | VARCHAR2 | (80) | The frequency of the term, specifying how often this term will come into effect, for example monthly, annually. The value is derived from meaning in FND_LOOKUPS where lookup_type = PN_PAYMENT_FREQUENCY_TYPE | |
| START_DATE | DATE | Start date of the term | ||
| END_DATE | DATE | End date of the term | ||
| VENDOR_NAME | VARCHAR2 | (80) | Associates the row in PO_VENDORS with the term row | |
| VENDOR_SITE_CODE | VARCHAR2 | (30) | Associates the row in PO_VENDOR_SITES with the payment or billing term | |
| TARGET_DATE | DATE | The date on which the term of the type PRE-PAYMENT is to be offset with the due date. For all other terms, this data element is null | ||
| ACTUAL_AMOUNT | NUMBER | The amount to be paid or billed | ||
| ESTIMATED_AMOUNT | NUMBER | The estimated amount to be paid or billed | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Functional currency code | |
| RATE | NUMBER | Currency conversion rate | ||
| CUSTOMER_NAME | VARCHAR2 | (50) | Associates the customer row in HZ_CUST_ACCOUNTS and HZ_PARTIES with the term row | |
| CUSTOMER_BILL_SITE | VARCHAR2 | (50) | The customer location to which bills are sent | |
| NORMALIZE | VARCHAR2 | (1) | Identify whether the Items related to the term need to be Normalized. valid Values are Y - Normalize, N - Don not Normalize | |
| LOCATION_CODE | VARCHAR2 | (30) | Associates the location_code in PN_LOCATIONS_ALL with the row in this table | |
| LOCATION_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Type of location, for example, building, floor, office, land, parcel, or section | |
| SCHEDULE_DAY | NUMBER | (15) | Day of the month for which schedules are to be created | |
| CUSTOMER_SHIP_SITE | VARCHAR2 | (50) | The customer location to which the shipment is sent | |
| AP_AR_TERM_NAME | VARCHAR2 | (15) | Accounts Payable/Receivables Term Name | |
| CUST_TRX_TYPE_NAME | VARCHAR2 | (30) | Customer transaction type name | |
| PROJECT_NUMBER | VARCHAR2 | (30) | The project number associated with an employee | |
| TASK_NUMBER | VARCHAR2 | (20) | The project task name associated with a customer | |
| ORGANIZATION_NAME | VARCHAR2 | (240) | Organization Name for calculating account id in AP | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Expenditure Type | |
| EXPENDITURE_ITEM_DATE | DATE | Expenditure Item Date for calculating Account Id in AP | ||
| INV_RULE_NAME | VARCHAR2 | (100) | Invoice Rule Name | |
| ACCOUNT_RULE_NAME | VARCHAR2 | (100) | Accounting Rule Name to be passed into AR | |
| SALESREP_NAME | VARCHAR2 | (240) | Salesperson Name to be passed into AR | |
| PAYTERM_STATUS | VARCHAR2 | (30) | Status of Index Payment Term | |
| APPROVED_BY_NAME | VARCHAR2 | (100) | Approver Name for Index Payment Term | |
| PO_NUMBER | VARCHAR2 | (100) | Purchase Order Number to be passed into AP | |
| PAYMENT_METHOD | VARCHAR2 | (100) | Payment method | |
| SUPPLIER_NUMBER | VARCHAR2 | (100) | The supplier number | |
| CUSTOMER_NUMBER | VARCHAR2 | (100) | The customer number | |
| ANNUAL | NUMBER | The annualized actual amount | ||
| AREA | NUMBER | Defaults from the rentable area associated with the primary location | ||
| ANNUAL_AREA | NUMBER | Calculated field indicating Actual/rentable area | ||
| TAX_CODE | VARCHAR2 | (100) | Tax Code Name for AP/AR | |
| TAX_GROUP | VARCHAR2 | (100) | Tax Group | |
| TAX_INCLUDED | VARCHAR2 | (1) | Tax included is an indicator to show that tax is included or not | |
| INDEX_TERM_INDICATOR | VARCHAR2 | (30) | Index term indicator values Example - ATLEAST, ATLEAST-BACKBILL | |
| 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 | ||
| INCLUDE_IN_VAR_RENT | VARCHAR2 | (80) | Checkbox to indicate whether the billing term is included in the Variaible rent calculations | |
| 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
, PAYMENT_PURPOSE_MEANING
, PAYMENT_TERM_TYPE_MEANING
, FREQUENCY_MEANING
, START_DATE
, END_DATE
, VENDOR_NAME
, VENDOR_SITE_CODE
, TARGET_DATE
, ACTUAL_AMOUNT
, ESTIMATED_AMOUNT
, CURRENCY_CODE
, RATE
, CUSTOMER_NAME
, CUSTOMER_BILL_SITE
, NORMALIZE
, LOCATION_CODE
, LOCATION_TYPE_LOOKUP_CODE
, SCHEDULE_DAY
, CUSTOMER_SHIP_SITE
, AP_AR_TERM_NAME
, CUST_TRX_TYPE_NAME
, PROJECT_NUMBER
, TASK_NUMBER
, ORGANIZATION_NAME
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, INV_RULE_NAME
, ACCOUNT_RULE_NAME
, SALESREP_NAME
, PAYTERM_STATUS
, APPROVED_BY_NAME
, PO_NUMBER
, PAYMENT_METHOD
, SUPPLIER_NUMBER
, CUSTOMER_NUMBER
, ANNUAL
, AREA
, ANNUAL_AREA
, TAX_CODE
, TAX_GROUP
, TAX_INCLUDED
, INDEX_TERM_INDICATOR
, 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
, INCLUDE_IN_VAR_RENT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
FROM PN.PN_RENT_INCREASE_DETAIL_ITF;
PN.PN_RENT_INCREASE_DETAIL_ITF does not reference any database object
PN.PN_RENT_INCREASE_DETAIL_ITF is referenced by following:
PN
PN_RENT_INCREASE_DETAIL_ITF#
|
|
|
|