INT_OBP_FLX_LN_ACCT_BALANCES_H

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 VALUE_DATE TIMESTAMP 8
3 BRANCH_CODE CHARACTER VARYING(10) 10
4 PRODUCT_ID CHARACTER VARYING(30) 30
5 CURRENCY_CODE CHARACTER VARYING(3) 3
6 FEE_ARREARS_AMT DOUBLE PRECISION 8
7 LEGAL_ARREARS_AMT DOUBLE PRECISION 8
8 OUTGOING_ARREARS_AMT DOUBLE PRECISION 8
9 PREMIUM_ARREARS_AMT DOUBLE PRECISION 8
10 PRINCIPAL_ARREARS_AMT DOUBLE PRECISION 8
11 SUSP_FEE_ARREARS_AMT DOUBLE PRECISION 8
12 SUSP_LEGAL_ARREARS_AMT DOUBLE PRECISION 8
13 SUSP_PREMIUM_ARREARS_AMT DOUBLE PRECISION 8
14 SUSP_OUTGOING_ARREARS_AMT DOUBLE PRECISION 8
15 PREMIUM_ARREARS_CYCLE_AMT DOUBLE PRECISION 8
16 FEE_ARREARS_CYCLE_AMT DOUBLE PRECISION 8
17 DISBURSED_AMT DOUBLE PRECISION 8
18 NET_DISBURSED_AMT DOUBLE PRECISION 8
19 PRINCIPAL_BALANCE_AMT DOUBLE PRECISION 8
20 RPA_BALANCE_AMT DOUBLE PRECISION 8
21 LAST_INSTALLMENT_AMT DOUBLE PRECISION 8
22 RPA_INTEREST_BALANCE_AMT DOUBLE PRECISION 8
23 RPA_PRINCIPAL_BALANCE_AMT DOUBLE PRECISION 8
24 INTEREST_TO_COMP_AMT DOUBLE PRECISION 8
25 COMP_INTEREST_AMT DOUBLE PRECISION 8
26 LAST_INTEREST_COMP_AMT DOUBLE PRECISION 8
27 UNCOLL_INTEREST_AMT DOUBLE PRECISION 8
28 OBJECT_VERSION_NUMBER BIGINT 8
29 IRR_AMORTIZATION_BASE_AMT DOUBLE PRECISION 8
30 PRINCIPAL_ASSESSED_AMT DOUBLE PRECISION 8
31 MARGIN_BALANCE_AMT DOUBLE PRECISION 8
32 DISBURSED_TODAY_AMT DOUBLE PRECISION 8
33 INTEREST_ARREARS_AMT DOUBLE PRECISION 8
34 PENALTY_ARREARS_AMT DOUBLE PRECISION 8
35 PMI_ARREARS_AMT DOUBLE PRECISION 8
36 SUSP_PMI_ARREARS_INT DOUBLE PRECISION 8
37 SUSP_PENALTY_ARREARS_AMT DOUBLE PRECISION 8
38 SUSP_INTEREST_ARREARS_AMT DOUBLE PRECISION 8
39 CAPITALIZED_ARREARS_AMT DOUBLE PRECISION 8
40 ADHOC_CAPITALIZED_ARREARS_AMT DOUBLE PRECISION 8
41 CUMULATIVE_EXCESS_REPAY_AMT DOUBLE PRECISION 8
42 CUMULATIVE_ADVANCE_PAYMENT_AMT DOUBLE PRECISION 8
43 INTEREST_ASSESSED_AMT DOUBLE PRECISION 8
44 PENALTY_ASSESSED_AMT DOUBLE PRECISION 8
45 PMI_ASSESSED_AMT DOUBLE PRECISION 8
46 ASSESSED_FEE_ARREARS_AMT DOUBLE PRECISION 8
47 LEGAL_ASSESSED_AMT DOUBLE PRECISION 8
48 PREMIUM_ASSESSED_AMT DOUBLE PRECISION 8
49 OUTGOING_ASSESSED_AMT DOUBLE PRECISION 8
50 AUXILLARY_PAY_ASSESSED_AMT DOUBLE PRECISION 8
51 PRINCIPAL_PAYOFF_ASSESSED_AMT DOUBLE PRECISION 8
52 CONTRIBUTION_RECEIVED_AMT DOUBLE PRECISION 8
53 DISBURSEMENT_TO_SETTLE_AMT DOUBLE PRECISION 8
54 OFFSET_CLEAR_BALANCE DOUBLE PRECISION 8
55 OFFSET_UNCLEAR_BALANCE DOUBLE PRECISION 8
56 UNCLEAR_AMT DOUBLE PRECISION 8
57 UNCLEAR_UNAPP_INT_AMT DOUBLE PRECISION 8
58 IOA_BALANCE_AMT DOUBLE PRECISION 8
59 IOA_FOR_CURRENT_PERIOD_AMT DOUBLE PRECISION 8
60 TOLERANCE_AMOUNT DOUBLE PRECISION 8
61 OUTSTANDING_INSURANCE_AMT DOUBLE PRECISION 8
62 TOTAL_INSURANCE_AMT DOUBLE PRECISION 8
63 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
64 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
65 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
66 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8