FCT_BNK_FEE_WAIVER_INFLIGHT_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PRODUCT_GROUP_DESC CHARACTER VARYING(120) 120
2 APPLICATION_ID CHARACTER VARYING(50) 50
3 SUBMISSION_ID CHARACTER VARYING(50) 50
4 SUBMISSION_DATE TIMESTAMP 8
5 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
6 CHANNEL CHARACTER VARYING(10) 10
7 OFFER_CODE CHARACTER VARYING(30) 30
8 OFFER_DESC CHARACTER VARYING(100) 100
9 LVR DOUBLE PRECISION 8
10 FEE_TYPE CHARACTER VARYING(20) 20
11 PRICE_NAME CHARACTER VARYING(40) 40
12 PRICE_TYPE CHARACTER VARYING(50) 50
13 NET_PRICE_AMOUNT DOUBLE PRECISION 8
14 NEGOTIATION_TYPE CHARACTER VARYING(20) 20
15 NEGOTIATION_VALUE DOUBLE PRECISION 8
16 NEGOTIATED_AMOUNT DOUBLE PRECISION 8
17 VALIDITY_START_DATE TIMESTAMP 8
18 VALIDITY_END_DATE TIMESTAMP 8
19 UDM_REASON_CODE CHARACTER VARYING(200) 200
20 UDM_REASON_DESCRIPTION CHARACTER VARYING(120) 120
21 LENDER_USER_ID CHARACTER VARYING(254) 254
22 LENDER_USER_NAME CHARACTER VARYING(100) 100
23 APPROVED_USER_ID CHARACTER VARYING(254) 254
24 APPROVED_BY_NAME CHARACTER VARYING(100) 100
25 BRANCH CHARACTER VARYING(105) 105
26 REGION CHARACTER VARYING(35) 35