OBP24_FLX_DD_ACCOUNTS_EXTN_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_CODE CHARACTER VARYING(40) 40
2 FIRST_DISBURSMENT_DATE TIMESTAMP 8
3 ATM_FLAG CHARACTER(1) 1
4 POS_FLAG CHARACTER(1) 1
5 TELE_BANKING_FLAG CHARACTER(1) 1
6 INTERNET_BANKING_FLAG CHARACTER(1) 1
7 MOBILE_BANKING_FLAG CHARACTER(1) 1
8 DEBIT_CARD_FLAG CHARACTER(1) 1
9 ATM_CARD_FLAG CHARACTER(1) 1
10 BROKER_FLAG CHARACTER(1) 1
11 SWEEPIN_FLAG CHARACTER(1) 1
12 SWEEPOUT_FLAG CHARACTER(1) 1
13 TOD_FLAG CHARACTER(1) 1
14 OVERLINE_FLAG CHARACTER(1) 1
15 CHEQUE_BOOK_FLAG CHARACTER(1) 1
16 INWARD_DIRECT_DEBIT_FLAG CHARACTER(1) 1
17 STATEMENT_FLAG CHARACTER(1) 1
18 PASSBOOK_HOLDER CHARACTER(1) 1
19 LOCAL_CHQ_REORDER_PCT DOUBLE PRECISION 8
20 MULTICITY_CHQ_REORDER_PCT DOUBLE PRECISION 8
21 LOCAL_CHQ_MAX_LEAVES DOUBLE PRECISION 8
22 MULTICITY_CHQ_MAX_LEAVES DOUBLE PRECISION 8
23 SWEEP_OUT_INSTRUCTION_NUM_CODE DOUBLE PRECISION 8
24 STANDING_INSTRUCTION_NUM_CODE DOUBLE PRECISION 8
25 CHEQUE_INSTRUCTION_NUM_CODE DOUBLE PRECISION 8
26 DELINQUENCY_REASON CHARACTER VARYING(40) 40
27 RECOVERY_REASON CHARACTER VARYING(40) 40
28 RECOVERY_END_DATE TIMESTAMP 8
29 RECOVERY_START_DATE TIMESTAMP 8
30 DELINQUENCY_START_DATE TIMESTAMP 8
31 DELINQUENCY_END_DATE TIMESTAMP 8
32 DELINQUENCY_UPDATE_DATE TIMESTAMP 8
33 APPLICATION_ID CHARACTER VARYING(40) 40
34 PERIODIC_CREDIT_FLAG CHARACTER(1) 1
35 PERIODIC_DEBIT_FLAG CHARACTER(1) 1
36 LAST_AMEND_DATE TIMESTAMP 8
37 PREVENT_FAC_UTIL_FLAG CHARACTER(1) 1
38 PREVENT_PRC_OFFST_FLAG CHARACTER(1) 1
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8