FND Design Data [Home] [Help]

Table: LNS_AMORTIZATION_SCHEDS

Product: LNS - Loans
Description: Amortizations Table - Records installments due for a loan as billing generates them. Also stores any reversal and re-amortization information
Implementation/DBA Data: TableLNS.LNS_AMORTIZATION_SCHEDS
Primary Key: LNS_AMORTIZATION_SCHEDS_PK
  1. ColumnAMORTIZATION_SCHEDULE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
LNS_AMORTIZATION_SCHEDS FK Joins to Table% LNS_AMORTIZATION_SCHEDS.LOAN_ID
LNS_AMORTIZATION_SCHEDS FK Joins to TableRA_CUSTOMER_TRX_ALL LNS_AMORTIZATION_SCHEDS.PRINCIPAL_TRX_ID
LNS_AMORTIZATION_SCHEDS FK Joins to TableRA_CUSTOMER_TRX_ALL LNS_AMORTIZATION_SCHEDS.INTEREST_TRX_ID
LNS_AMORTIZATION_SCHEDS FK Joins to TableRA_CUSTOMER_TRX_ALL LNS_AMORTIZATION_SCHEDS.FEE_TRX_ID
LNS_AMORTIZATION_SCHEDS FK Joins to Table% LNS_AMORTIZATION_SCHEDS.RATE_ID