OBP24_HST_FLX_LN_ACCT_BALANCES

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_FLX_LN_ACCT_BALANCES

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