[Home] [Help] [Dependency Information]
Object Name: | OKL_K_HEADERS_H |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_K_HEADERS_H |
Subobject Name: | |
Status: | VALID |
OKL_K_HEADERS_H is the history table for OKL_K_HEADERS. It stores versioned contract header information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_K_HEADERS_H_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ID
MAJOR_VERSION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
MAJOR_VERSION | NUMBER | (4) | Yes | Major version |
ISG_ID | NUMBER | Unique identifier for sales region | ||
KHR_ID | NUMBER | Foreign key to table OKL_K_HEADERS | ||
PDT_ID | NUMBER | Foreign key to table OKL_PRODUCTS | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
DATE_FIRST_ACTIVITY | DATE | Date of first activity on the contract | ||
SYNDICATABLE_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for syndication or not | |
SALESTYPE_YN | VARCHAR2 | (3) | Indicates whether it is a sales type contract or not | |
DATE_REFINANCED | DATE | The date finance closed if this was a rollover, restructure, renew or refinance contract | ||
DATE_CONVERSION_EFFECTIVE | DATE | Date on which the deal conversion becomes active | ||
DATE_DEAL_TRANSFERRED | DATE | Date on which the deal was transferred from one lessee to another | ||
TERM_DURATION | NUMBER | (10) | The duration of the contract in months | |
DATETIME_PROPOSAL_EFFECTIVE | DATE | Date on which the proposal becomes effective | ||
DATETIME_PROPOSAL_INEFFECTIVE | DATE | Date on which the proposal becomes ineffective | ||
DATE_PROPOSAL_ACCEPTED | DATE | Date on which notification of acceptance of the proposal was received | ||
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 | |
AMD_CODE | VARCHAR2 | (30) | Acceptance method code. This is a foreign key to FND_LOOKUP code 'OKL_ACCEPTANCE_METHOD'. | |
GENERATE_ACCRUAL_YN | VARCHAR2 | (3) | Indicates whether to generate accrual or not | |
GENERATE_ACCRUAL_OVERRIDE_YN | VARCHAR2 | (3) | Indicates whether to override generation of accrual or not | |
CREDIT_ACT_YN | VARCHAR2 | (3) | Indicates whether contract is consumer credit act deal or not | |
CONVERTED_ACCOUNT_YN | VARCHAR2 | (3) | Indicates whether the contract account is a converted account or not | |
PRE_TAX_YIELD | NUMBER | Yield before tax | ||
AFTER_TAX_YIELD | NUMBER | Yield after tax | ||
IMPLICIT_INTEREST_RATE | NUMBER | Implicit interest rate | ||
IMPLICIT_NON_IDC_INTEREST_RATE | NUMBER | Implicit non-IDC interest rate | ||
TARGET_PRE_TAX_YIELD | NUMBER | Target pre tax yield | ||
TARGET_AFTER_TAX_YIELD | NUMBER | Target after tax yield | ||
TARGET_IMPLICIT_INTEREST_RATE | NUMBER | Target implicit interest rate | ||
TARGET_IMPLICIT_NONIDC_INTRATE | NUMBER | Target implicit non-IDC interest rate | ||
DATE_LAST_INTERIM_INTEREST_CAL | DATE | Last Interim interest calculation date | ||
DEAL_TYPE | VARCHAR2 | (30) | Book Classification of the contract | |
PRE_TAX_IRR | NUMBER | Pre tax IRR for the contract | ||
AFTER_TAX_IRR | NUMBER | After tax IRR for the contract | ||
EXPECTED_DELIVERY_DATE | DATE | Earliest date by which a line (financial asset) under this contract will be delivered to the lessee | ||
ACCEPTED_DATE | DATE | Earliest date by which all the lines on the contract will be accepted | ||
PREFUNDING_ELIGIBLE_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for pre-funding or not | |
REVOLVING_CREDIT_YN | VARCHAR2 | (3) | Indicates whether the contract is eligible for a revolving line of credit or not | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
MULTI_GAAP_YN | VARCHAR2 | (3) | Indicates whether the contract is setup for Multi-GAAP accounting | |
RECOURSE_CODE | VARCHAR2 | (30) | Recourse code | |
LESSOR_SERV_ORG_CODE | VARCHAR2 | (30) | Lessor service organization code | |
ASSIGNABLE_YN | VARCHAR2 | (3) | Indicates whether the lease contract can be assigned to an investor agreement | |
SECURITIZED_CODE | VARCHAR2 | (30) | Securitized Code | |
SECURITIZATION_TYPE | VARCHAR2 | (30) | Type of securitization | |
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 pre-tax IRR | ||
SUB_AFTER_TAX_IRR | VARCHAR2 | (240) | Subsidized after tax IRR | |
TOT_CL_TRANSFER_AMT | NUMBER | Total creditline transfer amount | ||
TOT_CL_NET_TRANSFER_AMT | NUMBER | Total creditline net transfer amount | ||
TOT_CL_LIMIT | NUMBER | Total creditline limit | ||
TOT_CL_FUNDING_AMT | NUMBER | Total creditline funding amount | ||
CRS_ID | NUMBER | Change request identifier | ||
TEMPLATE_TYPE_CODE | VARCHAR2 | (30) | Template type code | |
TRADEIN_DESCRIPTION | VARCHAR2 | (1995) | Description of trade in. | |
TRADEIN_AMOUNT | NUMBER | Tradein amount | ||
DATE_TRADEIN | DATE | Date on which tradein amount is applied | ||
DATE_FUNDING_EXPECTED | DATE | Date on which funding is expected for a lease contract | ||
LEGAL_ENTITY_ID | NUMBER | Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, MAJOR_VERSION
, ISG_ID
, KHR_ID
, PDT_ID
, OBJECT_VERSION_NUMBER
, DATE_FIRST_ACTIVITY
, SYNDICATABLE_YN
, SALESTYPE_YN
, DATE_REFINANCED
, DATE_CONVERSION_EFFECTIVE
, DATE_DEAL_TRANSFERRED
, TERM_DURATION
, DATETIME_PROPOSAL_EFFECTIVE
, DATETIME_PROPOSAL_INEFFECTIVE
, DATE_PROPOSAL_ACCEPTED
, 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
, AMD_CODE
, GENERATE_ACCRUAL_YN
, GENERATE_ACCRUAL_OVERRIDE_YN
, CREDIT_ACT_YN
, CONVERTED_ACCOUNT_YN
, PRE_TAX_YIELD
, AFTER_TAX_YIELD
, IMPLICIT_INTEREST_RATE
, IMPLICIT_NON_IDC_INTEREST_RATE
, TARGET_PRE_TAX_YIELD
, TARGET_AFTER_TAX_YIELD
, TARGET_IMPLICIT_INTEREST_RATE
, TARGET_IMPLICIT_NONIDC_INTRATE
, DATE_LAST_INTERIM_INTEREST_CAL
, DEAL_TYPE
, PRE_TAX_IRR
, AFTER_TAX_IRR
, EXPECTED_DELIVERY_DATE
, ACCEPTED_DATE
, PREFUNDING_ELIGIBLE_YN
, REVOLVING_CREDIT_YN
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, MULTI_GAAP_YN
, RECOURSE_CODE
, LESSOR_SERV_ORG_CODE
, ASSIGNABLE_YN
, SECURITIZED_CODE
, SECURITIZATION_TYPE
, 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
, TOT_CL_TRANSFER_AMT
, TOT_CL_NET_TRANSFER_AMT
, TOT_CL_LIMIT
, TOT_CL_FUNDING_AMT
, CRS_ID
, TEMPLATE_TYPE_CODE
, TRADEIN_DESCRIPTION
, TRADEIN_AMOUNT
, DATE_TRADEIN
, DATE_FUNDING_EXPECTED
, LEGAL_ENTITY_ID
FROM OKL.OKL_K_HEADERS_H;
OKL.OKL_K_HEADERS_H does not reference any database object
OKL.OKL_K_HEADERS_H is referenced by following:
|
|
|