Cluster

    API Details

    Property Value
    Endpoint /tablesHousing/clusters
    Table name Cluster
    Table id 11024003
    Table caption Cluster
    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
    nr No. Code 20 *
    naam Name Text 50
    zoeknaam Search Name Code 50
    gewijzigdOp Modified On Date 4
    aantalVerhuurd No. Rented Integer 4
    aantalLeegstand No. Vacant Integer 4
    banknrBeheergever Bank Code Owner Code 20 Bank Account
    betalingslimietLV Payment Limit (LCY) Decimal 12
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    afhandeling Handling Option 4 Beheerder, Beheergever, Eerste lijn, Tweede lijn
    resultaatMelden Report Result Boolean 4
    naam2 Name 2 Text 50
    opzichter Supervisor Code 20 Contact
    huismeester Caretaker Text 30
    adres Address Text 100
    telefoon Phone No. Text 30
    semafoon Pager Text 30
    fax Fax Text 30
    email E-mail Text 80
    huisadres Home Address Text 100
    postcodeThuis Post Code Home Address Code 20 Post Code
    plaatsThuis Home City Text 30
    telefoonThuis Private Phone No. Text 30
    postcode Post Code Code 20 Post Code
    provisiepercVerhuur Rental Commission Pct. Decimal 12
    minBedragProvisie Min. Amount Commision Decimal 12
    maxBedragProvisie Max. Amount Commission Decimal 12
    productboekingsgroepProvisie Product Posting Group Commision Code 20 Gen. Product Posting Group
    btWproductbgrpProvisie VAT-Product Posting Group Commission Code 20 VAT Product Posting Group
    complexsoort Complex Type Option 4 Beheergever, VvE
    provisiepercLeegstand Vacancy Commision Pct. Decimal 12
    provisiebedrag Commision Amount Decimal 12
    bvo Surface Decimal 12
    locationCode Location Code Code 10
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    servicebureau Servicebureau Code 20 Service Company
    weatherStationCode Weather Station Code Code 10 Weather Station
    afrekenperiode Statement Period Option 4 Period 1, Period 2
    grondeigenaar Land Owner Code 20 Contact
    kadastraleGemeente Cadastral Municipality Code 20 Cadastral Community
    kadastraleSectie Cadastral Section Code 2
    kadastraalNummer Cadastral Number Code 6
    kadastraleAppIndex Cadastral App. index Code 5
    cbsBuurt Corporation Neighborhood Code Code 20 CBS Area
    beheertype Management Type Code 20 Management Type
    gebouwd Constructed Date 4
    gerenoveerd Renovated Date 4
    clustersoort Cluster Type Code 20 Cluster Type
    technisch Technical Boolean 4
    boeken Post Boolean 4
    erfpacht Leasehold Boolean 4
    vvE HOA Boolean 4
    lampendepot lamp Depot Code 20 Customer
    laatsteIngreep Last Operation Code 20 Last Intervention
    projectnaam Project Name Text 30
    oudNummer Olde Number Text 20
    waardering Appreciation Option 4 , 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
    wsw WSW Boolean 4
    pmc PMC Boolean 4
    aantalM2 No. sqm Decimal 12
    grondwaardeLV Land Value (LCY) Decimal 12
    technischeLocatie Technical Location Code 20 Technical Location
    ibvComplexnr IBV Complex No. Text 30
    toekomstigExploitatielabel Future operating label Code 20 Future Exploitation Label
    huidigeExploitatievorm Current Tenure Code Code 20 Proposal Model
    onderhoudslabel Maintenance Label Option 4 , Hoog, Midden, Laag
    huurlijn Lease Line Code 20 Rental Line
    toegankelijkheidslabel Accessibility Label Code Code 20 Accessibility Label
    marktlabel Market Label Code Code 20 Market Label
    maatregelenMarktlabel Measures Market Label Code Text 250
    wanneerVerkopen When Selling Text 250
    maatregelenOnderhoud Maintenance measures Text 250
    bijzonderheden Details Text 250
    woonmilieu Residential Environment Code Code 20 Environmental Class
    wijzigingsdatumExplvorm Change Date of tenure Date 4
    wijzigingsdatumMarktlabel Change Date Market Label Date 4
    bezoekcluster Visit Cluster Code 20 Bezoekcluster
    herbouwwaarde Reinstatement Decimal 12
    premiepromillage Premium Per Mille Decimal 12
    verzekeringspremie Insurance Premium Decimal 12
    indexcijfer Index Decimal 12
    budgethouder Budget Holder Code 50 User Setup
    woZcategorie WOZ Category Option 4 , 130.000, 150.000, 175.000, 195.000, 205.000
    beheerder Administrator Code Code 20 Contact
    statusVvE HOA Status Option 4 , Actief, Slapend
    huurbeleid Rent Policy Option 4 Hoogste bedrag, Streefhuur, Elementsjabloon, Huidige huur, Markthuurwaarde
    activeUser Active User Code 20 Salesperson/Purchaser
    customerNoVvE Customer No. HOA Code 20 Customer
    paymentMethodCodeSVVvE Payment Method Code S&V HOA Code 10 Payment Method
    vooropnameVerplicht Pre-Intake Required Boolean 4
    plaats City Text 30
    rentalStrategyAtEndDate Rental Strategy at End Date Code 10 Rental Strategy at End Date
    rentalStrategyAtExpDate Rental Strategy at Expiration Date Code 10 Rental Strategy at Exp. Date
    fundingCode Funding Code Code 10 Funding
    codeOwnersAssociation HOA Code (external) Text 30
    distributiemethode Distribution Method Code 10 WRB Distribution Method
    verdelingsmethode Division Method Option 4 Score, Draw, Response Moment
    drawDate Draw Date Date 4
    finalDraw Final Lots Boolean 4
    dateLastDraw Date last Lots Date 4
    visableOnWebsite Visable on Website Boolean 4
    buildingBlock Building Block Boolean 4
    componentOfCluster Component of Cluster Code 20
    mjoId MJO Id Integer 4
    commonAreaCluster Common Area Cluster Boolean 4
    mutationType Mutation Type Code 20 DM - Mutation Type
    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