Realty Object

    API Details

    Property Value
    Endpoint /tablesHousing/oges
    Table name OGE
    Table id 11024008
    Table caption Realty Object
    Data per company True
    Group Housing

    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
    huisnr House No. Code 20
    toevoegsel House No. Addition Code 20
    straatnaam Street Name Text 50
    postcode Post Code Code 20 Post Code
    plaats City Text 30
    type Realty Object Type Code 10
    status Status Option 4 Empty, Not Managed, Renovation, Let, Administrative, Sold, Development
    betreft Concerned Text 50
    gewijzigdOp Last Date Modified Date 4
    nr No. Code 20 *
    zoeknaam Search Name Code 50
    checkRename Check Rename Boolean 4
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    provisiepercVerhuur Provision Perc. Rent Decimal 12
    provisiepercLeegstand Provision Perc. Vacancy Decimal 12
    minBedragProvisie Minimum Amount Provision Decimal 12
    maxBedragProvisie Maximum Amount Provision Decimal 12
    dateOutOfManagement Date Out of Management Date 4
    provisiebedrag Provision Amount Decimal 12
    technicalType Technical Type Code 10 Technical Unit Type
    floorApplicable Floor Applicable Boolean 4
    floor Floor Integer 4
    decisionTreeTypeCode Decision Tree Type Code 20 DM - Decision Tree Type
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    oudNummer Old Number Code 83
    rijksnummer State No. Text 10
    mivaEenmalig MIVA One-off Amount Text 15
    streefhuurpercMaxHuurprijs Target Rent Percentage Decimal 12
    vhEalgemeen VHE General Code 20
    grondeigenaar Estate Owner Code 20 Contact
    kadastraleGemeente Cadastral Community Code 20 Cadastral Community
    kadastraleSectie Cadastral Section Code 2
    kadastraalNummer Cadastral No. Code 6
    kadastraleAppIndex Cadastral App. Index Code 5
    cbsBuurt Corporation Neighborhood Code Code 20 CBS Area
    gebouwd Build Date Date 4
    gerenoveerd Renovation Date Date 4
    huidigeLabelconditie Destination Code 20 Proposal Type
    nrreeks No. Series Code 20 No. Series
    stemdeel Vote Part Decimal 12
    breukdeel Fraction Part Decimal 12
    bijzondereDoelgroepen Special Target Groups Boolean 4
    seniorenlabel Senior Label Boolean 4
    woningTbvAsielzoekers House for Asylum Seeker Boolean 4
    rechtOpSubsidie Legal On Allowance Boolean 4
    bedrijfswaardeWals Business Value Wals Decimal 12
    deelgemeente Borough Code Code 20 Borough
    wijk District Code 20 District
    codeHuurPctMaxHuurprijs Target Rent Code Code 20 Target Rent % Max. Reas. Rent
    aanslagnummerOZB Tax No. OZB Text 30
    ozBgrondslag OZB Ground Decimal 12
    ozBtariefEigenaar OZB Rate Owner Decimal 12
    ozBtariefBewoner OZB Rate Resident Decimal 12
    ozbEigenaar OZB Owner Part Decimal 12
    ozbBewoner OZB Resident Part Decimal 12
    waterschap Water Board Code 20 Vendor
    waterschTariefEigenaar Water Board Rate Owner Decimal 12
    waterschTariefBewoner Water Board Rate Resident Decimal 12
    waterschapslastenEigenaar Water Board Owner Part Decimal 12
    waterschapslastenBewoner Water Board Resident Part Decimal 12
    grondslagWaterschap Ground Water Board Decimal 12
    belastingjaar Tax Year Integer 4
    rioolrecht Sewer Tax Decimal 12
    wozObjectnummer WOZ Object No. Text 30
    aanslagnummerWaterschap Tax No. Water Board Text 30
    peildatumBedrwaardeWals Reference Date Business Value Wals Date 4
    mivaJaarlijks MIVA Yearly Amount Text 15
    mivaBedrag MIVA Amount Decimal 12
    dateSold Date Sold Date 4
    aanbiedingsvormVerkoop Sales Proposal Form Code 20 Proposal Model
    pmcNr PMC No. Code 20 Cluster
    bouwnr Building No. Text 10
    juridischeStatus Legal Status Option 4 , , , Volledig eigendom, , , Erfpacht, , , Bloot eigendom, , , Afgekocht erfpacht
    jaarAfloopErfpacht Ground Lease Expiration Year Text 4
    bedrijfsobject Business Object Option 4 , , , Sociaal maatschappelijk, , , Garage etc., , , Ov. bedrijfsobject
    categorie Category Option 4 , , , Galerijflat, , , Portiekflat, , , Maisonnette, , , Ov. stapelwoning, , , Rijtjeswoning, , , Tweekapper, , , Ov. eenheid, , Monument, Intramurale woonvorm, , , Onzelfstandige woning
    redenInactief Reason Inactive Text 30
    beginExploitatie In Exploitation Date Date 4
    inactief Inactive Boolean 4
    redenInExploitatie In Exploitation Reason Code 20 Exploitation Reason Code
    eindeExploitatie Out of Exploitation Date Date 4
    redenUitExploitatie Out of Exploitation Reason Code 20 Exploitation End Reason Code
    advertentienummer Ad No. Code 20
    advertentieexportdatum Ad Export Date Date 4
    woningNetNr WoningNet No. Code 20
    earchiefNr E-archive No. Code 20
    woonruimte Property Valuation System Option 4 IndependentLivingSpace, SharedAccommodation, MobileHome, Stand, None
    vooropnameVerplicht Pre-intake Obligatory Boolean 4
    streefhuur Target Rent Decimal 12
    ntohuurTovMaxhuurprsPct Net Rent Maximum Rent Ratio Decimal 12
    berekeningsjaar Calculation Year Integer 4
    lagerDanLaagsteNormhuur Below Lowest Normal Rent Boolean 4
    olaStraatnaam OLA Street Name Text 30
    advertentienrWoonnet Ad No. Woonnet Text 20
    distributiemethode Distribution Method Code 10
    verdelingsmethode Division Method Option 4 Score, Draw, Response Moment
    huurbeleid Rent Policy Option 4 Hoogste bedrag, Streefhuur, Elementsjabloon, Huidige huur, Markthuurwaarde
    beheerder Supervisor Code 20 Contact
    statusVvE Status Owners Association Option 4 , Actief, Slapend
    targetGroupCode Target Group Code Code 10 Target Group
    targetRentMethod Target Rent Method Option 4 Dynamisch, Statisch, Puntprijs
    cadastralAreaHectare Hectares Decimal 12
    cadastralAreaAre Are Decimal 12
    cadastralAreaCentiare Centiare (= m²) Decimal 12
    reportToEnergySupplier Report To Energy Supplier Boolean 4
    eanCodeGas EAN Code Gas Code 18
    dateGasRegistered Date Gas Registered Date 4
    dateGasDeregistered Date Gas Deregistered Date 4
    eanCodeElectricity EAN Code Electricity Code 18
    dateElectricityRegistered Date Electricity Registered Date 4
    dateElectricityDeregistered Date Electricity Deregistered Date 4
    countryRegionCode Country/Region Code Code 10 Country/Region
    municipalityCode Municipality Code Code 10
    constructionYear Construction Year Integer 4
    renovationYear Renovation Year Integer 4
    commonArea Common Area Boolean 4
    typeDescription Description Text 70
    noOfPreInspections No. of Pre-inspections Integer 4
    durationOfPreInspections Duration of Pre-inspections Duration 8
    termFirstInspection Term First Inspection DateFormula 32
    noOfFinalInspections No. of Final Inspections Integer 4
    durationOfFinalInspections Duration of Final Inspections Duration 8
    mutationType Mutation Type Code 20 DM - Mutation Type
    externalRealtyObjectNo External Realty Object No. Code 20
    externalCustomerNo External Customer No. Code 20 Customer
    filterBuildingBlock Filter Building Block Boolean 4
    selectionDescription Selection Description Text 250
    veraDestinationCode VERA Destination Code Code 10 VERA Destination
    veraLivingFormCode VERA Living Form Code Code 10 VERA Living Form
    veraQualityLevelCode VERA Quality Level Code Code 10 VERA Quality Level
    veraUnitDetailTypeCode VERA Unit Detail Type Code Code 10 VERA Unit Detail Type
    veraEnergyLabel VERA Energy Label Code Code 10 VeraEnergyLabel
    veraTargetGroupCode VERA Target Group Code Code 10 VERA Target Group
    mjoId MJO Id Integer 4
    rentIncreasePolicyTypeCode Rent Increase Policy Type Code Code 20 Rent Increase Policy Type
    netRentCappingCode Net Rent Capping Code Code 20 Net Rent Capping
    targetRentCappingCode Target Rent Capping Code Code 20 Target Rent Capping
    inCareHome In Care Home Boolean 4
    veraPublicationModuleCode VERA Publication Module Code Code 10 VERA Publication Module
    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
    noOfOtherNonIndepUnits Number of Other Non-Independent Objects Integer 4
    justifyAsHouse Justify as House Option 4 , Yes, No
    cbsDistrictCode CBS District Code Code 6
    cbsNeighborhoodCode CBS Neighborhood Code Code 8
    exemptionTemporaryHouse Exemption Temporary House Boolean 4
    houseLetter House Letter Text 1
    houseNoExtension House No. Extension Text 4
    bagAddressableObjectId BAG Addressable Object ID Code 16
    grossFloorSurface Gross Floor Surface Decimal 12
    netFloorSurface Net Floor Surface Decimal 12
    lettableFloorSurface Lettable Floor Surface Decimal 12
    usableSurfaceLiving Usable Surface Living Decimal 12
    usableSurfaceOtherIndoorSpace Usable Surface Other Indoor Space Decimal 12
    usableSurfaceBuildingOutdSpace Usable Surface Building-related Outdoor Space Decimal 12
    usableSurfaceExtStorageSpace Usable Surface External Storage Space Decimal 12
    totalUsageSurface Total Usage Surface Decimal 12
    surfaceToRegister Surface(s) to Register Option 4 Subtotals, Grand Total
    conditionScore Condition Score Integer 4
    rentIncreaseAmountCappingCode Rent Increase Amount Capping Code Code 20 RentIncreaseAmountCapping
    effectiveTargetGroupLimitAmt Effective Target Group Limit Amount Decimal 12
    mutationNetRent Mutation Net Rent Decimal 12
    expectedOutOfExploitationDate Expected Out of Exploitation Date Date 4
    lettableObjectIndication Object Indication Text 20
    realtyObjectIsPledge Realty Object is Pledge Option 4 Yes, No, Released
    securityTakerName Security Taker Name Text 30
    securityType Security Type Option 4 Empty, Mortgage, RightOfPledgeRentalPayments, MortgageAndRightOfPledgeRentalPayments, PositiveStatementOfMortgageAndOrPositiveStatementOfPledge, MortgageAndPositiveStatementOfPledgeOnRentalPayments, PledgeOfRentAndPositiveStatementOfMortgage, Other, NotApplicable
    ownershipPercentage Ownership Percentage Decimal 12
    familyHomeType Family Home Type Option 4 Empty, SingleFamilyHome, MultiFamilyHome
    targetEpvCategoryCode Target EPV Category Code 20 TargetEpvCategoryFDN
    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