INT_OBP_FEE_WAIVER_INFLIGHT_LENDING_FEE

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
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 LVR DOUBLE PRECISION 8
7 CHANNEL CHARACTER VARYING(10) 10
8 OFFER_CODE CHARACTER VARYING(30) 30
9 OFFER_DESC CHARACTER VARYING(100) 100
10 FEE_TYPE CHARACTER VARYING(20) 20
11 PRICE_NAME CHARACTER VARYING(40) 40
12 PRICE_TYPE CHARACTER VARYING(50) 50
13 ORIGINAL_AMOUNT DOUBLE PRECISION 8
14 NEGOTIATE_TYPE CHARACTER VARYING(20) 20
15 NEGOTIATE_AMOUNT DOUBLE PRECISION 8
16 NEGOTIATE_VALUE 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 CREATED_BY CHARACTER VARYING(254) 254
22 APPROVED_BY CHARACTER VARYING(254) 254
23 BRANCH_CODE CHARACTER VARYING(10) 10