FCT_BNK_EFS_LOAN_PURPOSE_RECLASS_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ENTITY NATIONAL CHARACTER VARYING(24) 24
2 FACILITY_NR NATIONAL CHARACTER VARYING(40) 40
3 PARENT_FACILITY_NR NATIONAL CHARACTER VARYING(80) 80
4 DEAL_ID NATIONAL CHARACTER VARYING(40) 40
5 RECORD_ID NATIONAL CHARACTER VARYING(2) 2
6 START_VALIDITY_DATE DATE 4
7 END_VALIDITY_DATE DATE 4
8 CUSTOMER_NR NATIONAL CHARACTER VARYING(60) 60
9 CUSTOMER_LEGAL_NAME NATIONAL CHARACTER VARYING(128) 128
10 INTERCOMPANY NATIONAL CHARACTER VARYING(2) 2
11 DOMICILE NATIONAL CHARACTER VARYING(3) 3
12 SESCA NATIONAL CHARACTER VARYING(30) 30
13 RESIDENCY CHARACTER VARYING(12) 12
14 COUNTERPARTY CHARACTER VARYING(19) 19
15 BUSINESS_SIZE CHARACTER VARYING(6) 6
16 ORIG_INDUSTRY_CODE NATIONAL CHARACTER VARYING(30) 30
17 CUST_INDUSTRY_CODE NATIONAL CHARACTER VARYING(30) 30
18 DERV_PURPOSE NATIONAL CHARACTER VARYING(40) 40
19 ORIGINAL_PURPOSE NATIONAL CHARACTER VARYING(40) 40
20 PURPOSE_DESC CHARACTER VARYING(61) 61
21 CURRENCY NATIONAL CHARACTER VARYING(6) 6
22 IS_SECURED_FACILITY BYTEINT 1
23 CCY_AMOUNT NUMERIC(25,8) 19
24 DEAL_DATE DATE 4
25 START_DATE DATE 4
26 MATURITY_DATE DATE 4
27 IS_COMMITTED BYTEINT 1
28 IS_CANCELLABLE BYTEINT 1
29 IS_UNCONDITIONALLY_CANCELLABLE BYTEINT 1
30 CANCELLATION_NOTICE_PERIOD_DAYS INTEGER 4
31 SECURED_PERCENTAGE NUMERIC(13,7) 19
32 DEAL_TYPE NATIONAL CHARACTER VARYING(50) 50
33 DEAL_SUBTYPE NATIONAL CHARACTER VARYING(60) 60
34 FACILITY_TERM_OUT_DATE DATE 4
35 BOOK_CODE NATIONAL CHARACTER VARYING(40) 40
36 PRODUCT_TYPE CHARACTER VARYING(33) 33
37 PROFIT_CENTRE NATIONAL CHARACTER VARYING(24) 24
38 SOURCE_SYSTEM NATIONAL CHARACTER VARYING(80) 80
39 FACILITY_COLLATERALISATION NATIONAL CHARACTER VARYING(40) 40
40 SUBORDINATED_COLLATERAL_FLAG BYTEINT 1
41 PREDOMN_INTEREST_RATE_TYPE NATIONAL CHARACTER VARYING(80) 80
42 PRODUCT_CODE NATIONAL CHARACTER VARYING(80) 80
43 ACCOUNT_CODE NATIONAL CHARACTER VARYING(80) 80
44 SECURED_BY_RES_PROP_FLAG NATIONAL CHARACTER VARYING(80) 80
45 IMPAIRED_FLAG NUMERIC(25,8) 19
46 PREDOMN_REPAYMENT_TYPE NUMERIC(25,8) 19
47 FOREIGN_SRC_INC_FLAG NATIONAL CHARACTER VARYING(30) 30
48 RV_INDIC_CREDIT_LIMIT_FIX_USED NATIONAL CHARACTER VARYING(30) 30
49 RV_INDIC_CREDIT_LIMIT_USED NATIONAL CHARACTER VARYING(30) 30
50 RV_INDIC_FUNDED_DTM NATIONAL CHARACTER VARYING(30) 30
51 PER_COST_OF_FUNDS NUMERIC(9,4) 19
52 PER_INT_RATE_AMOR NUMERIC(9,4) 19
53 PER_INT_RATE_IO NUMERIC(9,4) 19
54 PER_INT_RATE_FIXED NUMERIC(9,4) 19
55 PER_INT_RATE_VARIABLE NUMERIC(9,4) 19
56 PREDOMN_INTEREST_RATE NUMERIC(9,4) 19
57 LOAN_INT_RATE_TYPE NATIONAL CHARACTER VARYING(10) 10
58 LOAN_INT_RATE NUMERIC(38,14) 19
59 NUM_OF_ACCTS INTEGER 4
60 RV_INCUR_INT INTEGER 4
61 FIRST_HOME_BUYER_FLAG INTEGER 4
62 LOCN_OF_PROPERTY NATIONAL CHARACTER VARYING(30) 30
63 FUNDED_FIRST_DTM NATIONAL CHARACTER VARYING(30) 30
64 APPLN_RECD_DTM NATIONAL CHARACTER VARYING(30) 30
65 REDRAW_INDC NATIONAL CHARACTER VARYING(30) 30
66 PER_LVR_AT_COMMIT NUMERIC(9,4) 19
67 PER_INTEREST_RATE NUMERIC(9,4) 19
68 BUS_SIZE NUMERIC(9,4) 19
69 RESIDUAL_FIX_INT_MNTH INTEGER 4
70 RESIDUAL_TERM_DAYS INTEGER 4
71 RESIDUAL_FIX_INT_YRS NUMERIC(10,2) 19
72 FIX_RESIDUAL_TERM CHARACTER VARYING(21) 21
73 FAC_RESIDUAL_TERM_DAYS INTEGER 4
74 FAC_RESIDUAL_FIX_INT_YRS NUMERIC(10,2) 19
75 RV_COA NATIONAL CHARACTER VARYING(255) 255
76 VALUATION_TYPE NATIONAL CHARACTER VARYING(40) 40
77 AMOUNT NUMERIC(25,8) 19
78 ACCOUNT_NUMBER CHARACTER VARYING(50) 50
79 LOAN_PURPOSE CHARACTER VARYING(250) 250
80 LOAN_SUB_PURPOSE CHARACTER VARYING(250) 250