[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | LNS_TERMS |
|---|---|
| Object Type: | TABLE |
| Owner: | LNS |
| FND Design Data: |  LNS.LNS_TERMS
|
| Subobject Name: | |
| Status: | VALID |
Loans Terms Table
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| LNS_TERMS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 TERM_ID
|
| LNS_TERMS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOAN_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TERM_ID | NUMBER | (15) | Yes | Term identifier |
| LOAN_ID | NUMBER | (15) | Yes | Loan identifier (foreign key to LNS_LOAN_HEADERS_ALL.LOAN_ID) |
| DAY_COUNT_METHOD | VARCHAR2 | (50) | Yes | Day Count Method. Lookup type is DAY_COUNT_METHOD |
| BASED_ON_BALANCE | VARCHAR2 | (30) | Yes | Based on Balance. Lookup type is BASED_ON_BALANCE |
| FIRST_RATE_CHANGE_DATE | DATE | First Rate Change Date | ||
| NEXT_RATE_CHANGE_DATE | DATE | Next Rate Change Date | ||
| PERCENT_INCREASE | NUMBER | Maximum Rate Increase Percentage Term | ||
| PERCENT_INCREASE_TERM | VARCHAR2 | (30) | Maximum Rate Increase Percentage Term Period. Lookup type is FREQUENCY | |
| PERCENT_INCREASE_LIFE | NUMBER | Max / Min Percent Increase Life | ||
| FIRST_PERCENT_INCREASE | NUMBER | First Max / Min Percent Increase | ||
| OPEN_PERCENT_INCREASE | NUMBER | Open Max / Min Percent Increase | ||
| OPEN_PERCENT_INCREASE_LIFE | NUMBER | Open Max / Min Percent Increase Life | ||
| OPEN_FIRST_PERCENT_INCREASE | NUMBER | First Open Max / Min Percent Increase | ||
| PAYMENT_APPLICATION_ORDER | VARCHAR2 | (30) | Payment Application Order. This column stores the concatenation of the lookup codes from the lookup type PAYMENT_APPLICATION_TYPE . For example, if the payment application order is Interest first, then Principal and then Fees, this column will have the value INT_PRIN_FEE | |
| PMT_APPL_ORDER_SCOPE | VARCHAR2 | (30) | Payment Application Order Scope | |
| PREPAY_PENALTY_FLAG | VARCHAR2 | (1) | Prepayment Penalty Flag | |
| PREPAY_PENALTY_DATE | DATE | Prepayment Penalty Date | ||
| DELINQUENCY_THRESHOLD_NUMBER | NUMBER | Delinquency Threshold Number. Denotes the limit on the Number of Consecutive Missed Payments before delinquency. | ||
| DELINQUENCY_THRESHOLD_AMOUNT | NUMBER | Delinquency Threshold Amount. Denotes the limit on the Amount Past Due before delinquency. | ||
| CALCULATION_METHOD | VARCHAR2 | (30) | Yes | Interest Calculation Method Code. Denotes Simple or Compound interest. Lookup type is INTEREST_CALCULATION_METHOD |
| REAMORTIZE_OVER_PAYMENT | VARCHAR2 | (1) | Flag to denote if overpayments result in reamortization of the loan | |
| REAMORTIZE_UNDER_PAYMENT | VARCHAR2 | (1) | Flag to denote if underpayments result in reamortization of the loan | |
| REAMORTIZE_WITH_INTEREST | VARCHAR2 | (1) | Flag to indicate if interest is included in reamortization | |
| INTEREST_COMPOUNDING_FREQ | VARCHAR2 | (30) | Yes | Interest Compunding Frequency. Lookup type is FREQUENCY |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID) | |
| OBJECT_VERSION_NUMBER | NUMBER | Yes | This column is used for locking purposes | |
| AMORTIZATION_FREQUENCY | VARCHAR2 | (30) | Yes | Amortization Frequency |
| NUMBER_GRACE_DAYS | NUMBER | Number of Grace Days | ||
| RATE_TYPE | VARCHAR2 | (30) | Rate Type code. Denotes if Fixed or Variable. Lookup type is RATE_TYPE | |
| CEILING_RATE | NUMBER | Ceiling rate percentage | ||
| FLOOR_RATE | NUMBER | Floor rate percentage | ||
| OPEN_CEILING_RATE | NUMBER | Open Phase Ceiling Rate | ||
| OPEN_FLOOR_RATE | NUMBER | Open Phase Floor Rate | ||
| INDEX_RATE_ID | NUMBER | (15) | FK to LNS_INT_RATE_HEADERS.INDEX_RATE_ID | |
| INDEX_NAME | VARCHAR2 | (50) | Index Name code. Lookup type is INDEX_TYPE | |
| LOAN_PAYMENT_FREQUENCY | VARCHAR2 | (30) | Loan Payment Frequency. Lookup type is FREQUENCY | |
| ADJUSTMENT_FREQUENCY | NUMBER | Adjustment Frequency. | ||
| ADJUSTMENT_FREQUENCY_TYPE | VARCHAR2 | (30) | Adjustment Frequency Period type code. Lookup type is PERIOD | |
| FIXED_RATE_PERIOD | NUMBER | Fixed Rate Period | ||
| FIXED_RATE_PERIOD_TYPE | VARCHAR2 | (30) | Fixed Rate Period type code. Lookup type is PERIOD | |
| FIRST_PAYMENT_DATE | DATE | First Payment Date | ||
| NEXT_PAYMENT_DUE_DATE | DATE | Next Payment Due Date | ||
| OPEN_FIRST_PAYMENT_DATE | DATE | First Payment Date of the open phase of the loan | ||
| OPEN_PAYMENT_FREQUENCY | VARCHAR2 | (30) | Payment Frequency of the open phase | |
| OPEN_NEXT_PAYMENT_DATE | DATE | Next payment date of the open phase | ||
| LOCK_IN_DATE | DATE | Rate Lock In Date | ||
| LOCK_TO_DATE | DATE | Rate Lock to Date | ||
| RATE_CHANGE_FREQUENCY | VARCHAR2 | (30) | Rate Change Frequency | |
| OPEN_INDEX_DATE | DATE | Open Phase Rate Index Date | ||
| TERM_INDEX_DATE | DATE | Term Phase Rate Index Date | ||
| OPEN_PROJECTED_RATE | NUMBER | Rate percentage used to calculate future interest for the Open phase of the loan | ||
| TERM_PROJECTED_RATE | NUMBER | Rate percentage used to calculate future interest for the Term phase of the loan | ||
| PAYMENT_CALC_METHOD | VARCHAR2 | (30) | Payment Calculation Method used in calculation of the Amortization schedule | |
| ORIG_PAY_CALC_METHOD | VARCHAR2 | (30) | This Calc method implies the last used paymentCalculationMethod for that loan before customized. | |
| CUSTOM_CALC_METHOD | VARCHAR2 | (30) | This method is used to calculate the customized loans. | |
| PRIN_FIRST_PAY_DATE | DATE | For a Separate Schedule loan, this column holds the first Principal payment date. | ||
| PRIN_PAYMENT_FREQUENCY | VARCHAR2 | (30) | For a Separate schedule loan, this field holds the Principal payment frequency. | |
| PENAL_INT_RATE | NUMBER | Penal Interest Rate | ||
| PENAL_INT_GRACE_DAYS | NUMBER | Penal Interest Grace Days |
Cut, paste (and edit) the following text to query this object:
SELECT TERM_ID
, LOAN_ID
, DAY_COUNT_METHOD
, BASED_ON_BALANCE
, FIRST_RATE_CHANGE_DATE
, NEXT_RATE_CHANGE_DATE
, PERCENT_INCREASE
, PERCENT_INCREASE_TERM
, PERCENT_INCREASE_LIFE
, FIRST_PERCENT_INCREASE
, OPEN_PERCENT_INCREASE
, OPEN_PERCENT_INCREASE_LIFE
, OPEN_FIRST_PERCENT_INCREASE
, PAYMENT_APPLICATION_ORDER
, PMT_APPL_ORDER_SCOPE
, PREPAY_PENALTY_FLAG
, PREPAY_PENALTY_DATE
, DELINQUENCY_THRESHOLD_NUMBER
, DELINQUENCY_THRESHOLD_AMOUNT
, CALCULATION_METHOD
, REAMORTIZE_OVER_PAYMENT
, REAMORTIZE_UNDER_PAYMENT
, REAMORTIZE_WITH_INTEREST
, INTEREST_COMPOUNDING_FREQ
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, AMORTIZATION_FREQUENCY
, NUMBER_GRACE_DAYS
, RATE_TYPE
, CEILING_RATE
, FLOOR_RATE
, OPEN_CEILING_RATE
, OPEN_FLOOR_RATE
, INDEX_RATE_ID
, INDEX_NAME
, LOAN_PAYMENT_FREQUENCY
, ADJUSTMENT_FREQUENCY
, ADJUSTMENT_FREQUENCY_TYPE
, FIXED_RATE_PERIOD
, FIXED_RATE_PERIOD_TYPE
, FIRST_PAYMENT_DATE
, NEXT_PAYMENT_DUE_DATE
, OPEN_FIRST_PAYMENT_DATE
, OPEN_PAYMENT_FREQUENCY
, OPEN_NEXT_PAYMENT_DATE
, LOCK_IN_DATE
, LOCK_TO_DATE
, RATE_CHANGE_FREQUENCY
, OPEN_INDEX_DATE
, TERM_INDEX_DATE
, OPEN_PROJECTED_RATE
, TERM_PROJECTED_RATE
, PAYMENT_CALC_METHOD
, ORIG_PAY_CALC_METHOD
, CUSTOM_CALC_METHOD
, PRIN_FIRST_PAY_DATE
, PRIN_PAYMENT_FREQUENCY
, PENAL_INT_RATE
, PENAL_INT_GRACE_DAYS
FROM LNS.LNS_TERMS;
LNS.LNS_TERMS does not reference any database object
LNS.LNS_TERMS is referenced by following:
APPS
LNS_LOAN_DTLS_ALL_MV
LNS_TERMS
|
|
|
|