FCT_BANK_NROD_ACCOUNT_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BANK_NROD_ACCOUNT

Columns
# Name Data Type Length
1 ACCOUNT_SOURCE_UNIQUE_ID CHARACTER VARYING(32) 32
2 ACCOUNT_SOURCE_REF_ID CHARACTER VARYING(32) 32
3 ACCOUNT_NAME CHARACTER VARYING(100) 100
4 CUSTOMER_SOURCE_UNIQUE_ID CHARACTER VARYING(32) 32
5 ACCOUNT_STATUS_CODE CHARACTER VARYING(13) 13
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 CHARACTER VARYING(200) 200
11 OVERDRAFT_LIMIT CHARACTER VARYING(200) 200
12 PERIODIC_LOAN_AMOUNT CHARACTER VARYING(200) 200
13 LIFE_INS_CONTRACT_DURATION CHARACTER VARYING(12) 12
14 BRANCH_ID CHARACTER VARYING(36) 36
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 CHARACTER VARYING(200) 200
21 RISK_SCORE CHARACTER VARYING(200) 200
22 ACCOUNT_SEGMENT NATIONAL CHARACTER VARYING(250) 250
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 CHARACTER VARYING(12) 12
32 INST_PREMIUM_AMT CHARACTER VARYING(200) 200
33 ANN_PREMIUM_AMT CHARACTER VARYING(200) 200
34 SINGLE_PREMIUM_TOTAL CHARACTER VARYING(200) 200
35 SUM_INSURED CHARACTER VARYING(200) 200
36 PAYMENT_METHOD CHARACTER VARYING(50) 50
37 BENEFICIARY_FLAG CHARACTER VARYING(1) 1
38 GROSS_PREM_TTD CHARACTER VARYING(200) 200
39 CASH_SURR_VALUE CHARACTER VARYING(200) 200
40 DEATH_BENEFIT_AMT CHARACTER VARYING(200) 200
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 CHARACTER VARYING(200) 200
59 DEBIT_TURNOVER CHARACTER VARYING(1) 1
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 CHARACTER VARYING(200) 200
69 OTHER_HOLD_AMOUNT CHARACTER VARYING(200) 200
70 REPORTING_REGION CHARACTER VARYING(64) 64