Field
Type
Length
Data element
Description
OBJECT_ID
CHAR
000020
Object ID
OBJECT_DESCRIPTION
CHAR
000030
Description of the Real Estate Object
OBJECT_OLD_REFERENCE_NO
CHAR
000032
Reference number for an external system
FIXTURES_FITTINGS_TYPE
CHAR
000006
Fixtures and Fittings type ID
OBJECT_AREA_UNIT_OF_MEASURE
UNIT
000003
Unit of measure for area
OBJ_AREA_UNIT_OF_MEASURE_ISO
CHAR
000003
ISO Code for Unit of Measurement
OBJ_VOL_UNIT_OF_MEASURE
UNIT
000003
Unit of Measure for Volume of Real Estate
OBJ_VOL_UNIT_OF_MEASURE_ISO
CHAR
000003
ISO Code for Unit of Measurement
OBJECT_CURRENCY
CUKY
000005
Object currency
OBJECT_CURRENCY_ISO
CHAR
000003
ISO Currency Code
MACRO_LOCATION_TYPE
CHAR
000006
Macro Location
MICRO_LOCATION_TYPE
CHAR
000006
Micro Location
TRANSPORT_CONNECTION_TYPE
CHAR
000006
Transport Connection
ENVIRONMENTAL_STATUS
CHAR
000006
Enviromental Status
IS_IN_FLOOD_ZONE
CHAR
000001
Indicator for Flood Zone
IS_IN_EARTHQUAKE_ZONE
CHAR
000001
Indicator for Eathquake Zone
IS_IN_ARCHITECT_CONSERVTN_AREA
CHAR
000001
Indicator for Architectural Conservation area
IS_A_HISTORIC_SITE
CHAR
000001
Indicator for Historical Site
IMPAIRING_FACTORS_EXIST
CHAR
000001
Indicates existence of Factors Impairing Real Estate Value
DESCRIPTN_OF_IMPAIRNG_FACTOR
CHAR
000030
Description of the value imparing factor
RISK_CODE
CHAR
000006
Risk Code
SAFETY_INDICATOR
CHAR
000002
Indicates that the asset has a default sfty discount or not
SAFETY_DISCOUNT
DEC
000010
Safety discount
SAFETY_AMOUNT
DEC
000023
Safety discount as an amount
CURRENCY_SAFETY_AMOUNT
CUKY
000005
Currency of the Safety discount amount
CURRENCY_SAFETY_AMOUNT_ISO
CHAR
000003
ISO Currency Code
VALUATION_TYPE
CHAR
000002
Type of Check conducted on the object
UNIT_VALUATION_FREQUENCY
CHAR
000002
Indicator: Units of time for revaluation of an asset
PERIOD_VALUATION_FREQUENCY
NUMC
000004
Period of revaluation for an asset
PREVIOUS_VALUATION_DATE
DATS
000008
Date on which the asset was last valued
VALID_FROM
DATS
000008
Valuation Start date
VALID_TO
DATS
000008
Valuation End date
LENDING_RATE_INDICATOR
CHAR
000002
Indicates that the asset has a default lending rate or not
LENDING_RATE1
DEC
000010
Lending Rate 1
LENDING_RATE2
DEC
000010
Lending Rate 2
LENDING_RATE3
DEC
000010
Lending Rate 3
LENDING_RATE4
DEC
000010
Lending Rate 4
LENDING_RATE5
DEC
000010
Lending Rate 5
LIQUIDATION_TYPE
CHAR
000006
Liquidation Type
LIQUIDATION_REASON
CHAR
000006
Liquidation Reason
LIQUIDATION_DATE
DATS
000008
Collateral Liquidation Date
LIQUIDATION_AMOUNT
DEC
000023
Returns from the Liquidation of Collateral
LIQUIDATION_CURRENCY
CUKY
000005
Currency of Liquidation Value
LIQUIDATION_CURRENCY_ISO
CHAR
000003
ISO Currency Code
BANK_ACCT
CHAR
000018
Bank account number
BANK_CTRY
CHAR
000003
Bank Country/Region Key
BANK_CTRY_ISO
CHAR
000002
ISO Code of the Country/Region
BANK_KEY
CHAR
000015
Bank Keys
BANK_CONTROL_KEY
CHAR
000002
Bank Control Key
VERIFICATION_UNIT_FREQUENCY
CHAR
000002
Indicator: Units of time for verification of an asset
VERIFICATION_PERIOD_FREQUENCY
NUMC
000004
Period of verification for an asset
LAST_VERF_DATE
DATS
000008
Last Verification Date
BANKAREA
CHAR
000004
Bank Area in Collateral Management
Length: 16343 Date: 20240425 Time: 154234 sap01-206 ( 34 ms )
