[Home] [Help] [Dependency Information]
Object Name: | PN_RENT_INCREASE_DETAILACC_IT# |
---|---|
Object Type: | VIEW |
Owner: | PN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (50) | ||
LEASE_NUM | VARCHAR2 | (30) | ||
PAYMENT_TERM_PRORATION_RULE | NUMBER | |||
ABSTRACTED_BY_USER_NAME | VARCHAR2 | (100) | ||
LEASE_CLASS_MEANING | VARCHAR2 | (80) | ||
LEASE_COMMENCEMENT_DATE | DATE | |||
LEASE_TERMINATION_DATE | DATE | |||
LEASE_EXECUTION_DATE | DATE | |||
LEASE_EXTENSION_END_DATE | DATE | |||
PAYMENT_PURPOSE_MEANING | VARCHAR2 | (80) | ||
PAYMENT_TERM_TYPE_MEANING | VARCHAR2 | (80) | ||
FREQUENCY_MEANING | VARCHAR2 | (80) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
VENDOR_NAME | VARCHAR2 | (80) | ||
VENDOR_SITE_CODE | VARCHAR2 | (30) | ||
TARGET_DATE | DATE | |||
ACTUAL_AMOUNT | NUMBER | |||
ESTIMATED_AMOUNT | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
RATE | NUMBER | |||
CUSTOMER_NAME | VARCHAR2 | (50) | ||
CUSTOMER_BILL_SITE | VARCHAR2 | (50) | ||
NORMALIZE | VARCHAR2 | (1) | ||
LOCATION_CODE | VARCHAR2 | (30) | ||
LOCATION_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | ||
SCHEDULE_DAY | NUMBER | (15) | ||
CUSTOMER_SHIP_SITE | VARCHAR2 | (50) | ||
AP_AR_TERM_NAME | VARCHAR2 | (15) | ||
CUST_TRX_TYPE_NAME | VARCHAR2 | (30) | ||
PROJECT_NUMBER | VARCHAR2 | (30) | ||
TASK_NUMBER | VARCHAR2 | (20) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
INV_RULE_NAME | VARCHAR2 | (100) | ||
ACCOUNT_RULE_NAME | VARCHAR2 | (100) | ||
SALESREP_NAME | VARCHAR2 | (240) | ||
PAYTERM_STATUS | VARCHAR2 | (30) | ||
APPROVED_BY_NAME | VARCHAR2 | (100) | ||
PO_NUMBER | VARCHAR2 | (100) | ||
PAYMENT_METHOD | VARCHAR2 | (100) | ||
SUPPLIER_NUMBER | VARCHAR2 | (100) | ||
CUSTOMER_NUMBER | VARCHAR2 | (100) | ||
ANNUAL | NUMBER | |||
AREA | NUMBER | |||
ANNUAL_AREA | NUMBER | |||
TAX_CODE | VARCHAR2 | (100) | ||
TAX_GROUP | VARCHAR2 | (100) | ||
TAX_INCLUDED | VARCHAR2 | (1) | ||
INDEX_TERM_INDICATOR | VARCHAR2 | (30) | ||
INDEX_NAME | VARCHAR2 | (30) | ||
IL_COMMENCEMENT_DATE | DATE | |||
IL_TERMINATION_DATE | DATE | |||
INDEX_LEASE_NUMBER | VARCHAR2 | (100) | ||
IL_ASSESSMENT_DATE | DATE | |||
ASSESSMENT_INTERVAL | NUMBER | |||
SPREAD_FREQUENCY_MEANING | VARCHAR2 | (80) | ||
BASIS_PERCENT_DEFAULT | NUMBER | |||
INITIAL_BASIS | NUMBER | |||
BASE_INDEX | NUMBER | |||
INDEX_FINDER_METHOD | VARCHAR2 | (80) | ||
INDEX_FINDER_MONTHS | NUMBER | |||
NEGATIVE_RENT_TYPE_MEANING | VARCHAR2 | (80) | ||
INCREASE_ON_MEANING | VARCHAR2 | (80) | ||
BASIS_TYPE | VARCHAR2 | (30) | ||
REFERENCE_PERIOD_MEANING | VARCHAR2 | (80) | ||
BASE_YEAR | DATE | |||
ILP_ASSESSMENT_DATE | DATE | |||
BASIS_START_DATE | DATE | |||
BASIS_END_DATE | DATE | |||
INDEX_FINDER_DATE | DATE | |||
CURRENT_BASIS | NUMBER | |||
RELATIONSHIP_MEANING | VARCHAR2 | (80) | ||
INDEX_PERCENT_CHANGE | NUMBER | |||
BASIS_PERCENT_CHANGE | NUMBER | |||
CURRENT_INDEX_LINE_VALUE | NUMBER | |||
PREVIOUS_INDEX_LINE_VALUE | NUMBER | |||
UNCONSTRAINT_RENT_DUE | NUMBER | |||
CONSTRAINT_RENT_DUE | NUMBER | |||
CARRY_FORWARD_AMOUNT | NUMBER | |||
CARRY_FORWARD_PERCENT | NUMBER | |||
CONSTRAINT_APPLIED_AMOUNT | NUMBER | |||
CONSTRAINT_APPLIED_PERCENT | NUMBER | |||
OPEN_CARRY_FORWARD_AMOUNT | NUMBER | |||
OPEN_CARRY_FORWARD_PERCENT | NUMBER | |||
APP_CARRY_FORWARD_AMOUNT | NUMBER | |||
APP_CARRY_FORWARD_PERCENT | NUMBER | |||
OLD_RENT | NUMBER | |||
NEW_RENT | NUMBER | |||
CHANGE_RENT | NUMBER | |||
ACCOUNT_CLASS_MEANING | VARCHAR2 | (90) | ||
GL_CONCATENATED_SEGMENTS | VARCHAR2 | (2000) | ||
DISTRIBUTION_PERCENTAGE | NUMBER | |||
DISTRIBUTION_AMOUNT | NUMBER | |||
CONSTRAINT_PRORATION | VARCHAR2 | (80) | ||
INDEX_MULTIPLIER | NUMBER | |||
UNADJUSTED_INDEX_CHANGE | NUMBER | |||
ADJUSTED_INDEX_CHANGE_PERCENT | NUMBER | |||
INCLUDE_IN_VAR_RENT | VARCHAR2 | (80) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER |
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
, ACCOUNT_CLASS_MEANING
, GL_CONCATENATED_SEGMENTS
, DISTRIBUTION_PERCENTAGE
, DISTRIBUTION_AMOUNT
, 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_DETAILACC_IT#;
|
|
|