| ACCOUNT_ID |
int |
10 |
|
|
|
|
|
| ORIG_PRINCIPAL |
decimal |
10,3 |
√ |
|
null |
|
|
| ORIG_PRINCIPAL_CURRENCY_ID |
smallint |
5 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
loan_summary_ibfk_1 |
|
| ORIG_INTEREST |
decimal |
10,3 |
√ |
|
null |
|
|
| ORIG_INTEREST_CURRENCY_ID |
smallint |
5 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
loan_summary_ibfk_2 |
|
| ORIG_FEES |
decimal |
10,3 |
√ |
|
null |
|
|
| ORIG_FEES_CURRENCY_ID |
smallint |
5 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
loan_summary_ibfk_3 |
|
| ORIG_PENALTY |
decimal |
10,3 |
√ |
|
null |
|
|
| ORIG_PENALTY_CURRENCY_ID |
smallint |
5 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
loan_summary_ibfk_4 |
|
| PRINCIPAL_PAID |
decimal |
10,3 |
√ |
|
null |
|
|
| PRINCIPAL_PAID_CURRENCY_ID |
smallint |
5 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
loan_summary_ibfk_5 |
|
| INTEREST_PAID |
decimal |
10,3 |
√ |
|
null |
|
|
| INTEREST_PAID_CURRENCY_ID |
smallint |
5 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
loan_summary_ibfk_6 |
|
| FEES_PAID |
decimal |
10,3 |
√ |
|
null |
|
|
| FEES_PAID_CURRENCY_ID |
smallint |
5 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
loan_summary_ibfk_7 |
|
| PENALTY_PAID |
decimal |
10,3 |
√ |
|
null |
|
|
| PENALTY_PAID_CURRENCY_ID |
smallint |
5 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
loan_summary_ibfk_8 |
|
| RAW_AMOUNT_TOTAL |
decimal |
10,3 |
√ |
|
null |
|
|
| RAW_AMOUNT_TOTAL_CURRENCY_ID |
smallint |
5 |
√ |
|
null |
|
| currency.CURRENCY_ID
|
FK_LOAN_SUMMARY_RAW_AMOUNT_TOTAL |
|
