[Home] [Help] [Dependency Information]
Object Name: | LNS_AMORTIZATION_LINES |
---|---|
Object Type: | TABLE |
Owner: | LNS |
FND Design Data: | LNS.LNS_AMORTIZATION_LINES |
Subobject Name: | |
Status: | VALID |
Amortization Lines reprensents the details of any give Amortization represented on the Amortization Schedules table
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
LNS_AMORTIZATION_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AMORTIZATION_LINE_ID |
LNS_AMORTIZATION_LINES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CUST_TRX_LINE_ID |
LNS_AMORTIZATION_LINES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LOAN_ID
AMORTIZATION_SCHEDULE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AMORTIZATION_LINE_ID | NUMBER | (15) | Yes | Amortization Line Identifier |
AMORTIZATION_SCHEDULE_ID | NUMBER | (15) | Yes | Amortization Schedule identifier (foreign key to LNS_AMORTIZATION_SCHEDS.AMORTIZATION_SCHEDULE_ID) |
LOAN_ID | NUMBER | (15) | Yes | Loan identifier (foreign key to LNS_LOAN_HEADERS_ALL.LOAN_ID) |
FEE_SCHEDULE_ID | NUMBER | (15) | FK to LNS_FEE_SCHEDULES | |
LINE_TYPE | VARCHAR2 | (30) | Amortization Line Type (INTEREST, PRINCIPAL, FEES) | |
AMOUNT | NUMBER | Amortization Line Amount | ||
CUST_TRX_ID | NUMBER | (15) | Customer Transaction identifier (foreign key to RA_CUSTOMER_TRX.CUSTOMER_TRX_ID) | |
CUST_TRX_LINE_ID | NUMBER | (15) | Customer Transaction Line identifier (foreign key to RA_CUSTOMER_TRX_LINES.CUSTOMER_TRX_LINE_ID) | |
FEE_ID | NUMBER | (15) | Fee identifier (foreign key to LNS_FEE_ASSIGNMENTS.FEE_ID) | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT AMORTIZATION_LINE_ID
, AMORTIZATION_SCHEDULE_ID
, LOAN_ID
, FEE_SCHEDULE_ID
, LINE_TYPE
, AMOUNT
, CUST_TRX_ID
, CUST_TRX_LINE_ID
, FEE_ID
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM LNS.LNS_AMORTIZATION_LINES;
LNS.LNS_AMORTIZATION_LINES does not reference any database object
LNS.LNS_AMORTIZATION_LINES is referenced by following:
|
|
|