[Home] [Help]
[Dependency Information]
[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:
OKL
OKL_K_HEADERS_H#
|
|
|
|