INT_OBP_HST_FLX_LN_ACCOUNTS_B_LOANS_INCOMING_20200425084436

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 APPLICATION_ID CHARACTER VARYING(50) 50
3 OFFER_ID CHARACTER VARYING(30) 30
4 PRODUCT_ID CHARACTER VARYING(30) 30
5 ARRANGEMENT_ID CHARACTER VARYING(40) 40
6 ACCOUNT_TITLE CHARACTER VARYING(300) 300
7 PARTY_ID CHARACTER VARYING(40) 40
8 LOAN_PURPOSE_TYPE CHARACTER VARYING(40) 40
9 PURPOSE_CODE CHARACTER VARYING(10) 10
10 BUNDLE_ID CHARACTER VARYING(40) 40
11 CAMPAIGN_CODE CHARACTER VARYING(20) 20
12 BORROWING_ENTITY_ID CHARACTER VARYING(16) 16
13 FACILITY_ID CHARACTER VARYING(40) 40
14 PARTY_NICK_NAME CHARACTER VARYING(100) 100
15 APPROVED_AMOUNT DOUBLE PRECISION 8
16 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
17 BRANCH_CODE CHARACTER VARYING(10) 10
18 CURRENCY_CODE CHARACTER VARYING(3) 3
19 LANGUAGE_ID CHARACTER(3) 3
20 SCHEDULE_CODE CHARACTER VARYING(40) 40
21 DISBURSEMENT_COUNT BIGINT 8
22 PAYMENTS_DONE_TODAY_NUM BIGINT 8
23 TERM_MONTHS BIGINT 8
24 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
25 ACCOUNT_OPENING_DATE TIMESTAMP 8
26 FIRST_DISBURSEMENT_DATE TIMESTAMP 8
27 LAST_COMPUTATION_DATE TIMESTAMP 8
28 LAST_CHARGING_DATE TIMESTAMP 8
29 LAST_DISBURSEMENT_DATE TIMESTAMP 8
30 LAST_PENALTY_DATE TIMESTAMP 8
31 LAST_PAYMENT_DATE TIMESTAMP 8
32 LAST_REMINDER_DATE TIMESTAMP 8
33 LAST_DUE_DATE TIMESTAMP 8
34 MATURITY_DATE TIMESTAMP 8
35 ACCRUAL_STATUS_FLAG CHARACTER(1) 1
36 OBJECT_STATUS CHARACTER(1) 1
37 DRAWDOWN_RETRY_COUNT BIGINT 8
38 LAST_COMP_DATE TIMESTAMP 8
39 UTILISED_TODAY_AMT DOUBLE PRECISION 8
40 USER_STATUS_CODE CHARACTER VARYING(120) 120
41 LAST_RESTRUCTURE_DATE TIMESTAMP 8
42 ACCOUNT_DATE_BASIS_CODE BIGINT 8
43 IBAN_CODE CHARACTER VARYING(40) 40
44 CONTRIBUTION_AMT DOUBLE PRECISION 8
45 WARNING_INDICATORS CHARACTER VARYING(100) 100
46 CREDIT_RISK_RATING_CODE CHARACTER VARYING(40) 40
47 IS_ACCELERATED_PYMNT_AVAL CHARACTER(1) 1
48 IS_OFFSET_ACCOUNT_AVAL CHARACTER(1) 1
49 IS_ACCOUNT_PYMNT_INSTR_AVAL CHARACTER(1) 1
50 IS_REPAYMENT_HOLIDAY_AVAL CHARACTER(1) 1
51 INSTALLMENT_NUM BIGINT 8
52 PAYMENT_DONE_TODAY_AMT DOUBLE PRECISION 8
53 BUSINESS_UNIT CHARACTER VARYING(40) 40
54 DELIQUENCY_START_DATE TIMESTAMP 8
55 DELIQUENCY_END_DATE TIMESTAMP 8
56 OBJECT_VERSION_NUMBER BIGINT 8
57 LAST_UPDATED_BY CHARACTER VARYING(254) 254
58 CREATED_BY CHARACTER VARYING(254) 254
59 LAST_UPDATED_DATE TIMESTAMP 8
60 CREATION_DATE TIMESTAMP 8
61 FACILITY_EARMARK_REF_NO CHARACTER VARYING(50) 50
62 LAST_CAPITALIZATION_DATE TIMESTAMP 8
63 SUSPENDED_FLAG CHARACTER(1) 1
64 MARKET_ENTITY CHARACTER VARYING(40) 40
65 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
66 BUNDLE_REFERENCE_ID CHARACTER VARYING(40) 40
67 IS_BUNDLE_BENEFIT_APPLICABLE CHARACTER VARYING(4) 4
68 HAS_HARDSHIP_RELIEF CHARACTER(1) 1
69 LAST_DEFERMENT_DATE TIMESTAMP 8
70 LAST_STMT_OPENING_BAL_AMT DOUBLE PRECISION 8
71 LAST_STMT_CLOSING_BAL_AMT DOUBLE PRECISION 8
72 LAST_STMT_GENERATED_TILL TIMESTAMP 8
73 BANK_CODE CHARACTER VARYING(10) 10
74 IS_SUBSEQUENT_ACCT CHARACTER(1) 1
75 IS_ACCT_NOMINATED_FOR_CAP CHARACTER(1) 1
76 IS_ACCT_NOMINATED_FOR_BUNDLE CHARACTER(1) 1
77 REQUESTED_AMOUNT DOUBLE PRECISION 8
78 LAST_AMEND_DATE TIMESTAMP 8
79 FIRST_DEFAULT_DATE TIMESTAMP 8
80 INSURANCE_QUOTE_ID CHARACTER VARYING(40) 40
81 APR DOUBLE PRECISION 8
82 LAST_ACTIVITY_DATE TIMESTAMP 8
83 IS_ACCT_NOMINATED_FOR_FEES CHARACTER(1) 1
84 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
85 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
86 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
87 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
88 RNK_PER_ACCTID_COMMIT_LATEST BIGINT 8
89 RNK_PER_ACCTID_DATE_LATEST BIGINT 8
90 RNK_PER_ACCTID_LATEST BIGINT 8