FCT_OPC_NROD_FI_ACCOUNT_TYPE2_V

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP02_BANK..FCT_OPC_NROD_FI_ACCOUNT_TYPE2

Columns
# Name Data Type Length
1 ACCOUNT_SOURCE_UNIQUE_ID CHARACTER VARYING(22) 22
2 ACCOUNT_SOURCE_REF_ID CHARACTER VARYING(8) 8
3 ACCOUNT_NAME CHARACTER VARYING(100) 100
4 CUSTOMER_SOURCE_UNIQUE_ID CHARACTER VARYING(32) 32
5 ACCOUNT_STATUS_CODE CHARACTER VARYING(6) 6
6 CREDIT_DEBIT_CODE CHARACTER VARYING(10) 10
7 CURRENCY_CODE CHARACTER VARYING(3) 3
8 DATE_OPENED CHARACTER VARYING(200) 200
9 DATE_CLOSED CHARACTER VARYING(200) 200
10 ACCOUNT_BALANCE NUMERIC(19,4) 19
11 OVERDRAFT_LIMIT NUMERIC(16,2) 19
12 PERIODIC_LOAN_AMOUNT NUMERIC(16,2) 19
13 LIFE_INS_CONTRACT_DURATION INTEGER 4
14 BRANCH_ID CHARACTER VARYING(32) 32
15 RELATIONSHIP_MGR_ID CHARACTER VARYING(32) 32
16 IBAN CHARACTER VARYING(34) 34
17 BIC CHARACTER VARYING(32) 32
18 FROZEN_OVERRIDE_DATE CHARACTER VARYING(1) 1
19 PRODUCT_SOURCE_TYPE_CODE CHARACTER VARYING(20) 20
20 CREDIT_LIMIT NUMERIC(16,2) 19
21 RISK_SCORE DOUBLE PRECISION 8
22 ACCOUNT_SEGMENT CHARACTER VARYING(30) 30
23 DORMANT_STATUS_FLAG CHARACTER VARYING(1) 1
24 FROZEN_STATUS_FLAG CHARACTER VARYING(1) 1
25 CREDIT_GRADE CHARACTER VARYING(10) 10
26 REF_DEBT_COL_FLAG CHARACTER VARYING(1) 1
27 BALANCE_DATE CHARACTER VARYING(200) 200
28 COMMENTS CHARACTER VARYING(4000) 4000
29 ORG_UNIT_CODE CHARACTER VARYING(10) 10
30 ISSUE_DATE CHARACTER VARYING(1) 1
31 PAYMENT_FREQ INTEGER 4
32 INST_PREMIUM_AMT NUMERIC(16,2) 19
33 ANN_PREMIUM_AMT NUMERIC(16,2) 19
34 SINGLE_PREMIUM_TOTAL NUMERIC(16,2) 19
35 SUM_INSURED NUMERIC(16,2) 19
36 PAYMENT_METHOD CHARACTER VARYING(50) 50
37 BENEFICIARY_FLAG CHARACTER VARYING(1) 1
38 GROSS_PREM_TTD NUMERIC(16,2) 19
39 CASH_SURR_VALUE NUMERIC(16,2) 19
40 DEATH_BENEFIT_AMT NUMERIC(16,2) 19
41 CUSTOMER_INITIATED_CLOSURE CHARACTER VARYING(1) 1
42 DELAYED_ACCOUNT_FLAG CHARACTER VARYING(1) 1
43 LANGUAGE_PREF_CODE CHARACTER VARYING(2) 2
44 SETTLEMENT_BANK_NAME CHARACTER VARYING(80) 80
45 DELIVERY_INSTRUCTIONS CHARACTER VARYING(150) 150
46 SETTLEMENT_TYPE CHARACTER VARYING(10) 10
47 RISK_CATEGORY CHARACTER VARYING(10) 10
48 BLOCKED_TYPE CHARACTER VARYING(1) 1
49 BLOCKED_REASON CHARACTER VARYING(40) 40
50 PRIMARY_CARD_ID CHARACTER VARYING(32) 32
51 ADDRESS CHARACTER VARYING(400) 400
52 ZONE CHARACTER VARYING(100) 100
53 CITY CHARACTER VARYING(100) 100
54 POSTAL_CODE CHARACTER VARYING(20) 20
55 COUNTRY_CODE CHARACTER VARYING(400) 400
56 ADDRESS_VALID_FROM CHARACTER VARYING(1) 1
57 ADDRESS_VALID_TO CHARACTER VARYING(1) 1
58 CREDIT_TURNOVER NUMERIC(16,2) 19
59 DEBIT_TRUNOVER NUMERIC(16,2) 19
60 TURNOVER_FROM_DATE CHARACTER VARYING(1) 1
61 TURNOVER_TO_DATE CHARACTER VARYING(1) 1
62 HOLDING_BANK_NAME CHARACTER VARYING(80) 80
63 SALARY_LODGED_FLAG CHARACTER VARYING(1) 1
64 ACCOUNT_ON_HOLD_FLAG CHARACTER VARYING(1) 1
65 SENT_CORRESPONDENCE_FLAG CHARACTER VARYING(1) 1
66 ACCOUNT_PURPOSE CHARACTER VARYING(64) 64
67 PRIMARY_CUSTOMER_CATEGORY_CODE CHARACTER VARYING(20) 20
68 COLLECTED_BALANCE NUMERIC(16,2) 19
69 OTHER_HOLD_AMOUNT NUMERIC(16,2) 19
70 REPORTING_REGION CHARACTER VARYING(64) 64
71 EFFECTIVE_START_TIMESTAMP CHARACTER VARYING(200) 200
72 EFFECTIVE_END_TIMESTAMP CHARACTER VARYING(200) 200
73 EOD_RNK BIGINT 8
74 ALL_RNK BIGINT 8