OBP24_HST_FLX_PM_CS_OFFERS_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 OFFER_CODE CHARACTER VARYING(30) 30
2 ALLOWED_RATE_TYPE CHARACTER VARYING(1) 1
3 BACKDATED_ACCOUNT_OPEN_DAYS DOUBLE PRECISION 8
4 MIN_BAL_TYPE CHARACTER VARYING(2) 2
5 MIN_BAL_CHARGE_BREACH_BASIS CHARACTER VARYING(1) 1
6 SWEEP_IN_FLAG CHARACTER VARYING(1) 1
7 SWEEP_OUT_FLAG CHARACTER VARYING(1) 1
8 PASSBOOK_FLAG CHARACTER VARYING(1) 1
9 CHEQUE_BOOK_FLAG CHARACTER VARYING(1) 1
10 FUND_TRANSFER_FLAG CHARACTER VARYING(1) 1
11 INWARD_DIRECT_FLAG CHARACTER VARYING(1) 1
12 PRINCIPAL_OFFSET_FLAG CHARACTER VARYING(1) 1
13 BUSINESS_PAYMENTS_FLAG CHARACTER VARYING(1) 1
14 BUSINESS_COLLECTIONS_FLAG CHARACTER VARYING(1) 1
15 DEBIT_BALANCE_ALLOWED_FLAG CHARACTER VARYING(1) 1
16 OVERDRAFT_FLAG CHARACTER VARYING(1) 1
17 OVERLINE_FLAG CHARACTER VARYING(1) 1
18 AUF_FLAG CHARACTER VARYING(1) 1
19 TOD_FLAG CHARACTER VARYING(1) 1
20 PERIODIC_DEBIT_FLAG CHARACTER VARYING(1) 1
21 PERIODIC_CREDIT_FLAG CHARACTER VARYING(1) 1
22 OFFICE_OFFER_FLAG CHARACTER VARYING(1) 1
23 MULTI_FUND_SINGLE_FEE_FLAG CHARACTER VARYING(1) 1
24 MULTI_FUND_SINGLE_TXN_FLAG CHARACTER VARYING(1) 1
25 PSEUDO_FEES_FLAG CHARACTER VARYING(1) 1
26 PSEUDO_INTEREST_FLAG CHARACTER VARYING(1) 1
27 CHQ_LOCAL_AUTO_REORDER_NUM DOUBLE PRECISION 8
28 CHQ_MULTICITY_AUTO_REORDER_NUM DOUBLE PRECISION 8
29 PERSONALIZED_FLAG CHARACTER VARYING(1) 1
30 CHEQUE_BACK_GROUND CHARACTER VARYING(1) 1
31 CHANNEL_MOBILE_BANK_FLAG CHARACTER VARYING(1) 1
32 CHANNEL_BRANCH_FLAG CHARACTER VARYING(1) 1
33 CHANNEL_INTERNET_BANK_FLAG CHARACTER VARYING(1) 1
34 CHANNEL_PHONE_BANK_FLAG CHARACTER VARYING(1) 1
35 MAX_NO_ACC_PER_CUSTOMER DOUBLE PRECISION 8
36 CHANNEL_ATM_FLAG CHARACTER VARYING(1) 1
37 RECONCILIATION_REQUIRED_FLAG CHARACTER VARYING(1) 1
38 ACCOUNT_TYPE CHARACTER VARYING(30) 30
39 RECONCILIATON_TYPE CHARACTER VARYING(30) 30
40 MULTI_RECORD_OFFSET_ALLOWED CHARACTER VARYING(1) 1
41 UDM_ALLOWED_FLAG CHARACTER VARYING(1) 1
42 RATE_LOCK_REQUIRED_FLAG CHARACTER VARYING(1) 1
43 LOCKED_RATE_TO_BE_APPLIED_FLAG CHARACTER VARYING(1) 1
44 ALTERNATE_ACCOUNT_ALLOWED CHARACTER VARYING(1) 1
45 INTEREST_PAY_OFFSET_ALWD_FLAG CHARACTER VARYING(1) 1
46 MAX_NO_ACC_PRINCIPAL_OFFSET DOUBLE PRECISION 8
47 FCF_ENABLED_FLAG CHARACTER VARYING(1) 1
48 INTEREST_REPAYMENT_TYPE CHARACTER VARYING(30) 30
49 DEBIT_ALWD_DAYS_IN_FIXED_PRD DOUBLE PRECISION 8
50 OFFSET_BENEFIT_APPLICABLE_FLAG CHARACTER VARYING(1) 1
51 OFFSET_BENEFIT_TYPE CHARACTER VARYING(30) 30
52 FCF_INT_PAY_OFFSET_ALWD_FLAG CHARACTER VARYING(1) 1
53 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
54 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
55 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
56 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8