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 |
Parent topic: Collateral Data