INT_OBP_FLX_TD_DEPOSITS_B_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_OBP_FLX_TD_DEPOSITS_B

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 DEPOSIT_ID DOUBLE PRECISION 8
3 PARTY_ID CHARACTER VARYING(40) 40
4 ORG_DEPOSIT_ID DOUBLE PRECISION 8
5 OLD_PARENT_DEPOSIT_ID DOUBLE PRECISION 8
6 BRANCH_ID CHARACTER VARYING(10) 10
7 PRODUCT_ID CHARACTER VARYING(30) 30
8 OFFER_ID CHARACTER VARYING(30) 30
9 CURRENCY_ID CHARACTER VARYING(3) 3
10 OLD_RENEWAL_COUNTER DOUBLE PRECISION 8
11 DEPOSIT_STATUS CHARACTER VARYING(40) 40
12 DEPOSIT_DATE TIMESTAMP 8
13 VALUE_DATE TIMESTAMP 8
14 MATURITY_DATE TIMESTAMP 8
15 UNCLAIMED_DATE TIMESTAMP 8
16 CLOSURE_DATE TIMESTAMP 8
17 INT_START_DATE TIMESTAMP 8
18 WINDOW_EXPIRY_DATE TIMESTAMP 8
19 LOCK_IN_EXPIRY_DATE TIMESTAMP 8
20 CERTIFICATE_STATUS CHARACTER VARYING(40) 40
21 LIEN_ALLOW_FLAG CHARACTER(1) 1
22 BLOCK_FLAG CHARACTER(1) 1
23 PRINCIPAL_AMT DOUBLE PRECISION 8
24 MATURITY_AMT DOUBLE PRECISION 8
25 CLOSEOUT_AMT DOUBLE PRECISION 8
26 UNCOLLECTED_PRINCIPAL_AMT DOUBLE PRECISION 8
27 UNCOLLECTED_INT_AMT DOUBLE PRECISION 8
28 UNCLAIMED_PRINCIPAL_AMT DOUBLE PRECISION 8
29 UNCLAIMED_INT_AMT DOUBLE PRECISION 8
30 INT_WITHHELD_AMT DOUBLE PRECISION 8
31 TOTAL_INT_WITHHELD_AMT DOUBLE PRECISION 8
32 PRINCIPAL_DUE_AMT DOUBLE PRECISION 8
33 INT_DUE_AMT DOUBLE PRECISION 8
34 LIEN_PRINCIPAL_AMT DOUBLE PRECISION 8
35 LIEN_INTEREST_AMT DOUBLE PRECISION 8
36 DEPOSIT_TERM_DAYS DOUBLE PRECISION 8
37 DEPOSIT_TERM_MNTHS DOUBLE PRECISION 8
38 DEPOSIT_TERM_YEARS DOUBLE PRECISION 8
39 AUTO_RENEWAL_TERM_DAYS DOUBLE PRECISION 8
40 AUTO_RENEWAL_TERM_MNTHS DOUBLE PRECISION 8
41 AUTO_RENEWAL_TERM_YEARS DOUBLE PRECISION 8
42 FORCE_RENEWAL_TERM_LIEN_DAYS DOUBLE PRECISION 8
43 FORCE_RENEWAL_TERM_LIEN_MNTHS DOUBLE PRECISION 8
44 FORCE_RENEWAL_TERM_LIEN_YEARS DOUBLE PRECISION 8
45 INT_PAYOUT_FREQ CHARACTER VARYING(40) 40
46 NEXT_INT_PAYOUT_DATE TIMESTAMP 8
47 ANNIVERSARY_ST_DATE DOUBLE PRECISION 8
48 ANNIVERSARY_ST_MONTH CHARACTER VARYING(40) 40
49 CAMPAIGN_CODE CHARACTER VARYING(40) 40
50 CONTRACT_MOD_COUNTER DOUBLE PRECISION 8
51 CONTRACT_MOD_DATE TIMESTAMP 8
52 CONTRACT_MOD_VALUE_DATE TIMESTAMP 8
53 CONTRACT_MOD_PRIMARY_REASON CHARACTER VARYING(10) 10
54 CONTRACT_MOD_SECONDARY_REASON CHARACTER VARYING(10) 10
55 NARRATIVE_CONTRACT_MOD CHARACTER VARYING(40) 40
56 CREATED_BY CHARACTER VARYING(254) 254
57 OBJECT_STATUS_FLAG CHARACTER(1) 1
58 CREATION_DATE TIMESTAMP 8
59 LAST_UPDATED_BY CHARACTER VARYING(254) 254
60 LAST_UPDATE_DATE TIMESTAMP 8
61 OBJECT_VERSION_NUMBER DOUBLE PRECISION 8
62 ANNUAL_EQUIVALENT_RATE DOUBLE PRECISION 8
63 BANK_ID CHARACTER VARYING(10) 10
64 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
65 DEPOSIT_RATE_TYPE CHARACTER VARYING(40) 40
66 AUTO_RENEWAL_REINVEST_COUNTER DOUBLE PRECISION 8
67 LAST_ACTIVITY_DATE TIMESTAMP 8
68 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
69 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
70 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
71 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
72 RENEWAL_COUNTER DOUBLE PRECISION 8
73 PARENT_DEPOSIT_ID DOUBLE PRECISION 8