Available Realty Object

    API Details

    Property Value
    Endpoint /tablesRealEstate/hdsAvailableRealtyObjects
    Table name HDS Available Realty Object
    Table id 11151990
    Table caption Available Realty Object
    Data per company True
    Group RealEstate

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    realtyObjectNo Realty Object No. Code 20 * OGE
    rentalProposalEntryNo Rental Proposal Entry No. Integer 4 *
    entryNo Entry No. Integer 4 *
    hdsSystemCode HDS System Code Code 20 WRV System
    advertisementNo Advertisement No. Code 20
    availMessageSendDateTime Availability Message Send Date-Time DateTime 8
    availMessageSendCorrectly Availability Message Send Correctly Boolean 4
    availabilityMessageStatus Availability Message Status Option 4 , 1. Sent, 2. Receipt failed, 3. Receipt succesful, 4. Processing failed, 5. Processing succesful
    veraUnitTypeCode VERA Unit Type Code Code 10
    veraUnitDetailTypeCode VERA Unit Detail Type Code Code 10
    veraUnitStatusCode VERA Unit Status Code Code 10
    veraUnitStatusName VERA Unit Status Name Text 50
    name Name Text 250
    description Description Text 250
    floor Floor Integer 4
    floorApplicable Floor applicable Boolean 4
    noOfRooms No. of Rooms Integer 4
    noOfHeatedRooms No. of Heated Rooms Integer 4
    totalArea Total Area Decimal 12
    totalNoOfRooms Total No. of Rooms Integer 4
    totalAreaRooms Total Area Rooms Decimal 12
    totalAreaSpaces Total Area Spaces Decimal 12
    veraDestinationCode VERA Destination Code Code 10
    veraTargetGroupCode VERA Target Group Code Code 10 VERA Target Group
    veraLivingFormCode VERA Living Form Code Code 10
    separateHousing Separate Housing Boolean 4
    veraQualityLevelCode VERA Quality Level Code Code 10
    grossRent Gross Rent Decimal 12
    subsidyRent Subsidy Rent Decimal 12
    targetRent Target Rent Decimal 12
    veraSocialLabelCode VERA Social Label Code Code 10
    veraSocialLabelName VERA Social Label Name Text 50
    clusterNo Cluster No. Code 20
    veraClusterTypeCode VERA Cluster Type Code Code 10
    veraClusterTypeName VERA Cluster Type Name Text 50
    minimumNumberOfPeople Minimum Number of People Integer 4
    maximumNumberOfPeople Maximum Number of People Integer 4
    minimumAge Minimum Age Integer 4
    maximumAge Maximum Age Integer 4
    minimumIncome Minimum Income Decimal 12
    maximumIncome Maximum Income Decimal 12
    veraEnergyLabelCode VERA Energy Label Code Code 10 VeraEnergyLabel
    energyIndex Energy Index Decimal 12
    energyIndexApplicable Energy Index applicable Boolean 4
    streetName Street Name Text 50
    houseNo House No. Integer 4
    houseLetter House Letter Code 10
    addition Addition Code 20
    postCode Post Code Code 20
    city City Text 30
    cbsNeighborhoodCode CBS Neighborhood Code Code 8
    cbsNeighborhoodName CBS Neighborhood Name Text 250
    cbsDistrictCode CBS District Code Code 6
    cbsDistrictName CBS District Name Text 250
    municipalityCode Municipality Code Code 10
    municipalityName Municipality Name Text 250
    startingDate Starting Date Date 4
    endingDate Ending Date Date 4
    veraPublicationModuleCode VERA Publication Module Code Code 10 VERA Publication Module
    duration Duration Text 250
    advertisementURL Advertisement URL Text 250
    reactionURL Reaction URL Text 250
    veraPublicationModelCode VERA Publication Model Code Code 10 VERA Publication Model
    veraPublDetailModelCode VERA Publication Detail Model Code Code 10
    veraPublIntakeFormCode VERA Publication Intake Form Code Code 10 VERA Publication Intake Form
    veraPublContractFormCode VERA Publication Contract Form Code Code 10 VERA Publication Contract Form
    waitingPeriod Waiting Period Integer 4
    waitingPeriodWithPrecedence Waiting Period with Precedence Integer 4
    contactNoPreviousTenant Contact No. Previous Tenant Code 20 Customer
    departureDatePreviousTenant Departure Date Date 4
    firstNamePreviousTenant First Name Text 30
    initialsPreviousTenant Initials Text 30
    middleNamePreviousTenant Middle Name Text 30
    surnamePreviousTenant Surname Text 30
    phoneNoPreviousTenant Phone No. Text 30
    mobilePhoneNoPrevTenant Mobile Phone No. Text 30
    eMailPreviousTenant Email Text 80
    consentPreviousTenant Consent Previous Tenant Boolean 4
    totalUsageSurface Total Usage Surface Decimal 12
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8