OBP24_FLX_PM_OFFER_BUNDLES_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_FLX_PM_OFFER_BUNDLES_B

Columns
# Name Data Type Length
1 BUNDLE_CODE CHARACTER VARYING(30) 30
2 BUNDLE_NAME CHARACTER VARYING(40) 40
3 BUNDLE_DESC CHARACTER VARYING(120) 120
4 BUNDLE_TYPE CHARACTER VARYING(1) 1
5 SUBSCRIPTION_START_DATE TIMESTAMP 8
6 SUBSCRIPTION_END_DATE TIMESTAMP 8
7 LIMITED_PERIOD_FLAG CHARACTER VARYING(1) 1
8 PERPETUAL_FLAG CHARACTER VARYING(1) 1
9 RENEWAL_FLAG CHARACTER VARYING(1) 1
10 BUNDLE_BENEFIT_PERIOD DOUBLE PRECISION 8
11 BUNDLE_BENEFIT_UNIT_TYPE CHARACTER VARYING(1) 1
12 ALL_ACCOUNTS_FLAG CHARACTER VARYING(1) 1
13 NEW_ACCOUNTS_FLAG CHARACTER VARYING(1) 1
14 RELATIONSHIP_MANAGER_FLAG CHARACTER VARYING(1) 1
15 PORT_POLIO_MGMNT_FLAG CHARACTER VARYING(1) 1
16 FINANCIAL_COUNSELLING_FLAG CHARACTER VARYING(1) 1
17 WEALTH_PLANNING_FLAG CHARACTER VARYING(1) 1
18 BANK_AT_HOME_SERVICES_FLAG CHARACTER VARYING(1) 1
19 NON_FINANCIAL_SERVICES_FLAG CHARACTER VARYING(1) 1
20 CREATED_BY CHARACTER VARYING(254) 254
21 CREATION_DATE TIMESTAMP 8
22 LAST_UPDATED_BY CHARACTER VARYING(254) 254
23 LAST_UPDATED_DATE TIMESTAMP 8
24 OBJECT_STATUS_FLAG CHARACTER VARYING(1) 1
25 OBJECT_VERSION_NUMBER DOUBLE PRECISION 8
26 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
27 RULE_CODE CHARACTER VARYING(50) 50
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8