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

TABLE: OKL.OKL_K_LINES

Object Details
Object Name: OKL_K_LINES
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_K_LINES
Subobject Name:
Status: VALID


OKL_K_LINES stores Oracle Lease Management specific attributes for each contract line. These attributes are not covered in the standard Contracts core line.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_K_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
KLE_SUB_FK_I NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUBSIDY_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key column
KLE_ID NUMBER

Foreign key to table OKL_K_LINES
STY_ID NUMBER

Foreign key to table OKL_STRM_TYPE_B
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
LAO_AMOUNT NUMBER (14)
Amount of add ons to asset
FEE_CHARGE NUMBER (14)
Fee Charge
TITLE_DATE DATE

Date the title was received by the title holder for the asset
DATE_RESIDUAL_LAST_REVIEW DATE

Date on which residual was reviewed last time
DATE_LAST_REAMORTISATION DATE

Date on which the amortisation was restarted
TERMINATION_PURCHASE_AMOUNT NUMBER (14)
The amount paid for buyout
DATE_LAST_CLEANUP DATE

Catchup when change of interest for fixed payment impacts interest payments
REMARKETED_AMOUNT NUMBER (14)
The currency amount received for sale of item
DATE_REMARKETED DATE

Date when asset remarketed
REMARKET_MARGIN NUMBER

The margin on the remarketing amount
REPURCHASED_AMOUNT NUMBER (14)
The currency amount received for sale of item to partner
DATE_REPURCHASED DATE

Date when asset was repurchased
GAIN_LOSS NUMBER (4)
Flag to indicate loss or gain on the leased asset
FLOOR_AMOUNT NUMBER (14)
The absolute minimum one should expect from a repurchase or remarket sale
PREVIOUS_CONTRACT VARCHAR2 (40)
Previous Lessors Contract Number
TRACKED_RESIDUAL NUMBER (14)
Field for tracking residual other than what is in the contract
DATE_TITLE_RECEIVED DATE

Date on which a title was received for this asset
ESTIMATED_OEC NUMBER (14)
Estimated original equipment cost
RESIDUAL_PERCENTAGE NUMBER (5)
The percentage of original equipment cost to be used for residual value
CAPITAL_REDUCTION NUMBER

Currency amount applied to principle
VENDOR_ADVANCE_PAID NUMBER (14)
Advance rent paid to the vendor
TRADEIN_AMOUNT NUMBER

Trade-in amount for the item/asset
DELIVERED_DATE DATE

Date in which the item is delivered
YEAR_OF_MANUFACTURE VARCHAR2 (240)
Year in which the item/asset is manufactured
INITIAL_DIRECT_COST NUMBER (14)
Direct costs such as documentation fee associated with leasing a piece of land, built-area.
OCCUPANCY NUMBER (20)
The percentage of occupancy of the built facility
DATE_LAST_INSPECTION DATE

Date when the built area was last inspected
DATE_NEXT_INSPECTION_DUE DATE

Next time the building will be inspected
WEIGHTED_AVERAGE_LIFE NUMBER (30)
Average life the building can stand on the ground
BOND_EQUIVALENT_YIELD NUMBER (5)
The yield on the building lease as a percentage of return from Bonds for the same investment
REFINANCE_AMOUNT NUMBER (14)
The amount used to refinance the lease of the building
YEAR_BUILT NUMBER (4)
Year the building was built.
COVERAGE_RATIO NUMBER (5)
Identifies the debt service coverage of the transaction
GROSS_SQUARE_FOOTAGE NUMBER (30)
Gross square footage of the building located on the property
NET_RENTABLE NUMBER (14)
Net square footage of the building which tenants will pay rent on
DATE_LETTER_ACCEPTANCE DATE

Date the customer signed the acceptance letter.
DATE_COMMITMENT_EXPIRATION DATE

Date the commitment expires
DATE_APPRAISAL DATE

Appraisal date
APPRAISAL_VALUE NUMBER (14)
Appraisal value
RESIDUAL_VALUE NUMBER (20)
Residual value
PERCENT NUMBER (5)
Rate for insurance premium calculation
COVERAGE NUMBER (14)
The amount of coverage for insurance premium calculation
LRV_AMOUNT NUMBER (14)
Residual value insurance amount
AMOUNT NUMBER

Amount
LRS_PERCENT NUMBER (5)
Not used
EVERGREEN_PERCENT NUMBER (5)
Evergreen Percentage
PERCENT_STAKE NUMBER (5)
Not used
AMOUNT_STAKE NUMBER (14)
Not used
DATE_SOLD DATE

Date syndication was sold to the investor
STY_ID_FOR NUMBER (10)
Not used
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
NTY_CODE VARCHAR2 (30)
Concept type code. Foreign key to FND_LOOKUPS
FCG_CODE VARCHAR2 (30)
Funding category code. Foreign key to FND_LOOKUPS
PRC_CODE VARCHAR2 (30)
Property class code. Foreign key to FND_LOOKUPS
RE_LEASE_YN VARCHAR2 (3)
Indicates whether asset is a re-leased asset or not
PRESCRIBED_ASSET_YN VARCHAR2 (3)
Indicates wheter asset is a prescribed asset or not
CREDIT_TENANT_YN VARCHAR2 (3)
Indicates whether tenant has to be credited or not. Used in real estate contracts only
SECURED_DEAL_YN VARCHAR2 (3)
Indicates whether this is a secured deal or not
CLG_ID NUMBER

Foreign key to table OKL_CNTR_LVLNG_GRPS_B
DATE_FUNDING DATE

Date on which funding is done
DATE_FUNDING_REQUIRED DATE

Date on which funding is required
DATE_ACCEPTED DATE

Acceptance date
DATE_DELIVERY_EXPECTED DATE

Date on which delivery of asset is expected
OEC NUMBER

Original equipment cost of the asset
CAPITAL_AMOUNT NUMBER

Capital amount
RESIDUAL_GRNTY_AMOUNT NUMBER (14)
Residual guaranty amount
RESIDUAL_CODE VARCHAR2 (30)
Residual code
RVI_PREMIUM NUMBER (14)
RVI Premium
CREDIT_NATURE VARCHAR2 (30)
For revolving line of credit indicates wherer the line is 'New', 'Add' or 'Reduce'
CAPITALIZED_INTEREST NUMBER (14)
Amount of capitalized interest
CAPITAL_REDUCTION_PERCENT NUMBER (5)
Capital reduction percentage
DATE_PAY_INVESTOR_START DATE

Investor agreement - date on which payment to investor starts
PAY_INVESTOR_FREQUENCY VARCHAR2 (30)
Investor agreement - investor payment frequency
PAY_INVESTOR_EVENT VARCHAR2 (30)
Investor agreemnt - investor payment event
PAY_INVESTOR_REMITTANCE_DAYS NUMBER

Investor agreement - investor payent eremittance day
FEE_TYPE VARCHAR2 (30)
Fee type for financed fees
SUBSIDY_ID NUMBER

Unique identifier for subsidy. Foreign key to OKL_SUBSIDIES_B.ID
SUBSIDY_OVERRIDE_AMOUNT NUMBER

Subsidy override amount
PRE_TAX_YIELD NUMBER

Pre tax yield
AFTER_TAX_YIELD NUMBER

After tax yield
IMPLICIT_INTEREST_RATE NUMBER

Implicit interest rate
IMPLICIT_NON_IDC_INTEREST_RATE NUMBER

Implicit non-IDC interest rate
PRE_TAX_IRR NUMBER

Pre-tax IRR
AFTER_TAX_IRR NUMBER

After tax IRR
SUB_PRE_TAX_YIELD NUMBER

subsidized pre-tax yield
SUB_AFTER_TAX_YIELD NUMBER

Subsidized after tax yield
SUB_IMPL_INTEREST_RATE NUMBER

Subsidized implicit interest rate
SUB_IMPL_NON_IDC_INT_RATE NUMBER

Subsidized implicit non-IDC interest rate
SUB_PRE_TAX_IRR NUMBER

Subsidized Pe-tax IRR
SUB_AFTER_TAX_IRR NUMBER

Subsidized after tax IRR
ITEM_INSURANCE_CATEGORY NUMBER

Denormalized column to capture the item insurance asset category at the time of asset entry
QTE_ID NUMBER

Rollover Quote Identifier
FUNDING_DATE DATE

Funding Date
STREAM_TYPE_SUBCLASS VARCHAR2 (30)
The sub-class code of the stream type
DATE_FUNDING_EXPECTED DATE

Date on which funding is expected
MANUFACTURER_NAME VARCHAR2 (360)
Manufacturer name
MODEL_NUMBER VARCHAR2 (40)
Model number
DOWN_PAYMENT_RECEIVER_CODE VARCHAR2 (30)
Down payment receiver code
CAPITALIZE_DOWN_PAYMENT_YN VARCHAR2 (3)
Indicates whether down payment has to be capitalized or not
FEE_PURPOSE_CODE VARCHAR2 (30)
Fee purpose code
TERMINATION_VALUE NUMBER

Termination value
EXPECTED_ASSET_COST NUMBER

Expected Asset Cost
ORIG_CONTRACT_LINE_ID NUMBER

Reference to the original contract line identifier
ORIGINATION_INCOME NUMBER

Origination Income
AMOUNT_BALANCE_LEGACY NUMBER

Balance amount in legacy system
DT_EFFECTIVE_BALANCE_LEGACY DATE

Effective date of the balance in legacy system
Query Text

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


SELECT ID
,      KLE_ID
,      STY_ID
,      OBJECT_VERSION_NUMBER
,      LAO_AMOUNT
,      FEE_CHARGE
,      TITLE_DATE
,      DATE_RESIDUAL_LAST_REVIEW
,      DATE_LAST_REAMORTISATION
,      TERMINATION_PURCHASE_AMOUNT
,      DATE_LAST_CLEANUP
,      REMARKETED_AMOUNT
,      DATE_REMARKETED
,      REMARKET_MARGIN
,      REPURCHASED_AMOUNT
,      DATE_REPURCHASED
,      GAIN_LOSS
,      FLOOR_AMOUNT
,      PREVIOUS_CONTRACT
,      TRACKED_RESIDUAL
,      DATE_TITLE_RECEIVED
,      ESTIMATED_OEC
,      RESIDUAL_PERCENTAGE
,      CAPITAL_REDUCTION
,      VENDOR_ADVANCE_PAID
,      TRADEIN_AMOUNT
,      DELIVERED_DATE
,      YEAR_OF_MANUFACTURE
,      INITIAL_DIRECT_COST
,      OCCUPANCY
,      DATE_LAST_INSPECTION
,      DATE_NEXT_INSPECTION_DUE
,      WEIGHTED_AVERAGE_LIFE
,      BOND_EQUIVALENT_YIELD
,      REFINANCE_AMOUNT
,      YEAR_BUILT
,      COVERAGE_RATIO
,      GROSS_SQUARE_FOOTAGE
,      NET_RENTABLE
,      DATE_LETTER_ACCEPTANCE
,      DATE_COMMITMENT_EXPIRATION
,      DATE_APPRAISAL
,      APPRAISAL_VALUE
,      RESIDUAL_VALUE
,      PERCENT
,      COVERAGE
,      LRV_AMOUNT
,      AMOUNT
,      LRS_PERCENT
,      EVERGREEN_PERCENT
,      PERCENT_STAKE
,      AMOUNT_STAKE
,      DATE_SOLD
,      STY_ID_FOR
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NTY_CODE
,      FCG_CODE
,      PRC_CODE
,      RE_LEASE_YN
,      PRESCRIBED_ASSET_YN
,      CREDIT_TENANT_YN
,      SECURED_DEAL_YN
,      CLG_ID
,      DATE_FUNDING
,      DATE_FUNDING_REQUIRED
,      DATE_ACCEPTED
,      DATE_DELIVERY_EXPECTED
,      OEC
,      CAPITAL_AMOUNT
,      RESIDUAL_GRNTY_AMOUNT
,      RESIDUAL_CODE
,      RVI_PREMIUM
,      CREDIT_NATURE
,      CAPITALIZED_INTEREST
,      CAPITAL_REDUCTION_PERCENT
,      DATE_PAY_INVESTOR_START
,      PAY_INVESTOR_FREQUENCY
,      PAY_INVESTOR_EVENT
,      PAY_INVESTOR_REMITTANCE_DAYS
,      FEE_TYPE
,      SUBSIDY_ID
,      SUBSIDY_OVERRIDE_AMOUNT
,      PRE_TAX_YIELD
,      AFTER_TAX_YIELD
,      IMPLICIT_INTEREST_RATE
,      IMPLICIT_NON_IDC_INTEREST_RATE
,      PRE_TAX_IRR
,      AFTER_TAX_IRR
,      SUB_PRE_TAX_YIELD
,      SUB_AFTER_TAX_YIELD
,      SUB_IMPL_INTEREST_RATE
,      SUB_IMPL_NON_IDC_INT_RATE
,      SUB_PRE_TAX_IRR
,      SUB_AFTER_TAX_IRR
,      ITEM_INSURANCE_CATEGORY
,      QTE_ID
,      FUNDING_DATE
,      STREAM_TYPE_SUBCLASS
,      DATE_FUNDING_EXPECTED
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      DOWN_PAYMENT_RECEIVER_CODE
,      CAPITALIZE_DOWN_PAYMENT_YN
,      FEE_PURPOSE_CODE
,      TERMINATION_VALUE
,      EXPECTED_ASSET_COST
,      ORIG_CONTRACT_LINE_ID
,      ORIGINATION_INCOME
,      AMOUNT_BALANCE_LEGACY
,      DT_EFFECTIVE_BALANCE_LEGACY
FROM OKL.OKL_K_LINES;

Dependencies

[top of page]

OKL.OKL_K_LINES does not reference any database object

OKL.OKL_K_LINES is referenced by following:

SchemaOKL
ViewOKL_K_LINES#