I_RealEstateObjectData

Real Estate Object Details | view: IREOBJDATA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Column Name Description
RealEstateUUID GUID for Real Estate Object
Column Name Description
Column Name Description
Column Name Description
RealEstateEnteredDate Created On
RealEstateEnteredTime Created At
RealEstateLastChangedDate Last Changed On
RealEstateLastChangedTime Last Changed At
Column Name Description
RealEstateFixtureFittingType Fixtures and Fittings Type ID Show values
RealEstateIsFloodZone Indicator for Flood Zone Show values
RealEstateIsEarthquakeZone Indicator : Eathquake Zone Show values
RealEstateIsArchlConsvnArea Indicator for Architectural Conservation Area Show values
RealEstateIsHistoricalSite Indicator for Historical Site Show values
RealEstateHasFctrsImpairingVal Indicates existence of Factors Impairing Real Estate Value Show values
Column Name Description Domain name
RealEstateInternalID Reference ID for the object CMS_OBJ_REFID
RealEstateID Object ID CMS_RE_OBJECT_ID
CollateralRealEstateType Real Estate Object Type ID CMS_RE_TYP
RealEstateAddressID Address ID AD_ADDRNUM
RealEstateDescription Description of the Real Estate Object CMS_RE_DESC
RealEstateParentUUID GUID for Real Estate Object SYSUUID
RealEstateExtRefNumber External reference Number of an External System CMS_RE_REFID
RealEstateMacroLocation Macro Location CMS_ATT_ID_TYP
RealEstateMicroLocation Micro Location CMS_ATT_ID_TYP
RealEstateObjectTransptConncn Transport Connection CMS_ATT_ID_TYP
RealEstateEnvironmentalStatus Enviromental Status CMS_ATT_ID_TYP
RealEstteFctrsImpairingValDesc Description of the value imparing factor CMS_RE_DESC
CollateralAdminOrgUnit Administration Organizational Unit TEXT12
CollateralBankArea Bank Area in Collateral Management CMS_BANKAREA
RealEstateEnteredBy Real Estate Add-On User CMS_RE_USER
RealEstateEnteredSource Sorce of Initial entry CMS_RE_SOURCE
RealEstateLastChangedBy Last Changed By CMS_RE_USER
RealEstateLastChangedSource Processing Source CMS_RE_SOURCE