3.3.2 Collateral Details

Entity Name: COLL

Description: This table holds collateral details data from product processor.

Data Sequence:

COLL|Collateral Code|Collateral Type|Collateral Sub Type|Collateral Category|Collateral Currency|Assessed Value|Assessment Date|Bank Value|Sold By |Date of Sale|Nature|Amount Realized|Date of Settlement|Realization Status|Amount Recovered|Collateral Description|Collateral Address Line1|Collateral Address Line2|Collateral Address Line3|Collateral Address Line4|City code|State code|Country code|Postal code|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10|udf11|udf12|udf13|udf14|udf15|udf16|udf17|udf18|udf19|udf20|udf21|udf22|udf23|udf24|udf25|udf26|udf27|udf28|udf29|udf30|udf31|udf32|udf33|udf34|udf35|udf36|udf37|udf38|udf39|udf40|udf41|udf42|udf43|udf44|udf45|udf46|udf47|udf48|udf49|udf50

Table 3-15 Collateral Details

Field Name	Description	Possible Values / Examples	Data Type	Data Length	Required/Optional
Collateral Code	Collateral Code as stored in host	-	VARCHAR2	30	Required
Collateral Type	Type of Collateral	-	VARCHAR2	30	Required
Collateral Sub Type	If there are any collateral sub type	-	VARCHAR2	30	Optional
Collateral Category	Collateral Category	-	VARCHAR2	30	Optional
Collateral Currency	Collateral Currency	-	VARCHAR2	3	Required
Assessed Value	Market Value	-	NUMBER	36,18	Optional
Assessment Date	Date of assessment	-	DATE	-	Optional
Bank Value	Book Value	-	NUMBER	36,18	Optional
Sold By	This property is required to identify entity which sold the collateral	Customer (Borrower)/ Bank / Court	VARCHAR2	240	Optional
Date of Sale	Date on which the collateral was sold	-	DATE	-	Optional
Nature	Normal/ Guarantee	-	VARCHAR2	30	Optional
Amount Realized	Gross Sale amount	-	NUMBER	36,18	Optional
Date of Settlement	Date on which settlement took place	-	DATE	-	Optional
Realization Status	Final status of realization	-	VARCHAR2	60	Optional
Amount Recovered	Gross Sale Amount less Costs incurred for sale of collateral	-	NUMBER	36,18	Optional
Collateral Description	Collateral Description	-	VARCHAR2	240	Optional
Collateral Address Line1	Collateral Address Line1	-	VARCHAR2	120	Optional
Collateral Address Line2	Collateral Address Line2	-	VARCHAR2	120	Optional
Collateral Address Line3	Collateral Address Line3	-	VARCHAR2	120	Optional
Collateral Address Line4	Collateral Address Line4	-	VARCHAR2	120	Optional
City code	City code	-	VARCHAR2	50	Optional
State code	State code	-	VARCHAR2	6	Optional
Country code	Country code	-	VARCHAR2	30	Optional
Postal code	Postal code	-	VARCHAR2	30	Optional