FCT_BNK_QRM_CHARGES

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CHARGE_ID CHARACTER VARYING(18) 18
2 COLLATERAL_ID CHARACTER VARYING(18) 18
3 COLLATERAL_TYPE CHARACTER VARYING(50) 50
4 COLLATERAL_CATEGORY CHARACTER VARYING(50) 50
5 COLLATERAL_SUB_CATEGORY CHARACTER VARYING(50) 50
6 CHARGE_TYPE CHARACTER VARYING(20) 20
7 CHARGE_NATURE_TYPE CHARACTER VARYING(2) 2
8 CHARGE_STATUS CHARACTER VARYING(2) 2
9 BANK_CODE CHARACTER VARYING(10) 10
10 BANK_NAME CHARACTER VARYING(105) 105
11 PRIORITY NUMERIC(20,0) 19
12 REMARKS CHARACTER VARYING(40) 40
13 CHARGE_AMOUNT NUMERIC(20,0) 19
14 CURRENCY_CODE CHARACTER VARYING(3) 3
15 PERCENTAGE_VALUE NUMERIC(20,0) 19
16 DISCHARGE_DATE TIMESTAMP 8
17 OBSOLUTE_DISCHARGE_DATE TIMESTAMP 8
18 CHARGE_REG_NUMBER CHARACTER VARYING(20) 20
19 STAMPING_REQUIRED CHARACTER VARYING(1) 1
20 PMSI_FLAG CHARACTER VARYING(1) 1
21 STAMPING_DATE TIMESTAMP 8
22 STAMPING_AMOUNT NUMERIC(20,0) 19
23 EXECUTION_DATE TIMESTAMP 8
24 REGISTRATION_REQUIRED CHARACTER VARYING(1) 1
25 REGISTRATION_DATE TIMESTAMP 8
26 REGISTRATION_AMOUNT NUMERIC(20,0) 19
27 TITLE_DOC_STATUS CHARACTER VARYING(30) 30
28 REGISTRATION_END_DATE TIMESTAMP 8
29 MORTGAGEE_NAME CHARACTER VARYING(120) 120
30 REG_AUTHORITY CHARACTER VARYING(120) 120
31 STATUS CHARACTER(1) 1
32 DISCHARGED_BY CHARACTER VARYING(9) 9
33 CHANGED_END_DATE CHARACTER VARYING(1) 1
34 PROCESSED_DATE TIMESTAMP 8
35 TOKEN CHARACTER VARYING(50) 50
36 SECURED_PARTY_GROUP CHARACTER VARYING(20) 20
37 CHANGE_NUMBER CHARACTER VARYING(20) 20
38 ORIGINATION CHARACTER VARYING(15) 15
39 AMENDED_DATE TIMESTAMP 8
40 AMENDED_BY CHARACTER VARYING(10) 10
41 REMOVED_DATE TIMESTAMP 8
42 REMOVED_BY CHARACTER VARYING(7) 7
43 GIVING_OF_NOTICE CHARACTER VARYING(50) 50
44 TRANSITIONAL_FLAG CHARACTER VARYING(1) 1
45 EARLIER_REGISTRATION_NUM CHARACTER VARYING(20) 20
46 PURPOSE_TYPE CHARACTER VARYING(20) 20
47 CREATION_DATE TIMESTAMP 8