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

TABLE: LNS.LNS_AM_SCHEDS_EXPORTS

Object Details
Object Name: LNS_AM_SCHEDS_EXPORTS
Object Type: TABLE
Owner: LNS
Subobject Name:
Status: VALID


Amortization Schedules Exports Table - Contains amortization schedules of different loans in the system generated by LNS: Export Amortization schedules cp. Amortization schedules are provided for usage by external applications in reports, analytics and other modules.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
LNS_AM_SCHEDS_EXPORTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOAN_ID
ColumnSCHEDULE_TYPE
LNS_AM_SCHEDS_EXPORTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATION_DATE
Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Yes FK to LNS_LOAN_HEADERS_ALL.LOAN_ID
SCHEDULE_TYPE VARCHAR2 (30)
Schedule Type: CURRENT or ORIGINAL
CREATION_DATE DATE

Schedule Export Date
INSTALLMENT_NUMBER NUMBER

Installment Number
DUE_DATE DATE

Due Date
PRINCIPAL_AMOUNT NUMBER

Principal Amount
INTEREST_AMOUNT NUMBER

Interest Amount
FEE_AMOUNT NUMBER

Fee Amount
OTHER_AMOUNT NUMBER

Other Amount
BEGIN_BALANCE NUMBER

Installment Begin Balance
END_BALANCE NUMBER

Installment End Balance
TOTAL NUMBER

Installment Total Amount
INTEREST_CUMULATIVE NUMBER

Cumulative Interest Amount
PRINCIPAL_CUMULATIVE NUMBER

Cumulative Principal Amount
FEES_CUMULATIVE NUMBER

Cumulative Fee Amount
OTHER_CUMULATIVE NUMBER

Cumulative Other Amount
UNPAID_PRIN NUMBER

Unpaid Principal Amount
UNPAID_INT NUMBER

Unpaid Interest Amount
INTEREST_RATE NUMBER

Interest Rate
PERIOD VARCHAR2 (100)
Installment Period
DEFERRED_INT_AMOUNT NUMBER

Deferred Interest Amount
REQUEST_ID NUMBER

Concurrent Program Request ID
Query Text

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


SELECT LOAN_ID
,      SCHEDULE_TYPE
,      CREATION_DATE
,      INSTALLMENT_NUMBER
,      DUE_DATE
,      PRINCIPAL_AMOUNT
,      INTEREST_AMOUNT
,      FEE_AMOUNT
,      OTHER_AMOUNT
,      BEGIN_BALANCE
,      END_BALANCE
,      TOTAL
,      INTEREST_CUMULATIVE
,      PRINCIPAL_CUMULATIVE
,      FEES_CUMULATIVE
,      OTHER_CUMULATIVE
,      UNPAID_PRIN
,      UNPAID_INT
,      INTEREST_RATE
,      PERIOD
,      DEFERRED_INT_AMOUNT
,      REQUEST_ID
FROM LNS.LNS_AM_SCHEDS_EXPORTS;

Dependencies

[top of page]

LNS.LNS_AM_SCHEDS_EXPORTS does not reference any database object

LNS.LNS_AM_SCHEDS_EXPORTS is referenced by following:

SchemaLNS
ViewLNS_AM_SCHEDS_EXPORTS#