Contract

    API Details

    Property Value
    Endpoint /tablesHousing/contracts
    Table name Contract
    Table id 11024011
    Table caption Contract
    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
    soort Type Option 4 * Inhuur, Verhuur, Erfpacht, Moedercontract
    eenheidnr Realty Object No. Code 20 *
    volgnr Entry No. Integer 4 *
    customerNo Customer No. Code 20
    naam Name Text 250
    status Status Option 4 Nieuw, Huidig, Oud
    ingangsdatum Starting Date Date 4
    einddatum Ending Date Date 4
    beindigd Ended Boolean 4
    prolongatietermijn Prolongation Period DateFormula 32
    geprolongeerdTot Prolonged until Date 4
    prolongatiedatum Prolongation Date Date 4
    indexeringsdatum Rent Increase Date Date 4
    weigeringsbedrag Refusal Amount Decimal 12
    huisnr House No. Code 20
    toevoegsel Addition Code 20
    indexcode Indexing Code Code 20 Indexing Code
    indexeringsmethode Indexing Method Code 10 Indexeringsmethode
    markthuurwaardeLV Market Rent (LCY) Decimal 12
    bedrijfsboekingsgrpLeegstand Vacancy Posting Group Code 10 Gen. Business Posting Group
    boekingsgroep Posting Group Code 30 VacancyPostingGroupFDN
    btWbedrijfsbgrpLeegstand Vacancy VAT Posting Group Code 10 VAT Business Posting Group
    ingangsdatumWeigering Start Date Refusal Date 4
    indexeringsbatchnaam Indexing Batch Name Code 20 Indexing Batch
    indexeringVerwerkt Rent Increase Processed Boolean 4
    bezwaarHuurverhoging Rent Increase Objection Boolean 4
    coderegeling Code arrangement Integer 4
    postcode Post Code Code 20
    vervallenIndexeringsdatum Past due indexing date Date 4
    eindafrekening Final Settlement Date 4
    valutacode Currency code Code 10 Currency
    facturerenIn Invoicing currency Option 4 Klant-valuta, Contract-valuta
    huurprijsliberalisatie Liberalized Contract Boolean 4
    motiveringVerplicht Motivation obligatory Boolean 4
    gemaximaliseerd Maximized Boolean 4
    objectionStatus Objection Status Option 4 , Pending, Withdrawn Tenant, Withdrawn Landlord, Granted, Rejected
    dateWithdrawGrantedRejected Objection Granted/Rejection Date Date 4
    reasonCodeWdrwnGrntdRejtd Objection Status Reason Code Code 20 Objection Status Reason
    livabilityDossierNo Complaint No. Code 20 Livability Dossier
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    huurvastperiode Fixed / Secure Rent Period DateFormula 32
    einddatumHuurvastperiode Ending Date Fixed / Secure Rent Period Date 4
    bezwaarToegewezen Objection granted Boolean 4
    moedercontract Parent contract Code 20
    soortUitgifte Issue type Option 4 Canon, Afkoop
    datumOverdracht Transport date Date 4
    duurMoedercontract Duration parent contract DateFormula 32
    wmAfkoopEinddatum Settled end date Date 4
    grondeigenaar Land owner Code 20 Contact
    datumHeroverweging Date reconcilliation Date 4
    soortHeroverweging Type reconcilliation Code 20 Review Type
    huidigeCanon Current canon Decimal 12
    opslagPctCanonVerkoop Sales surcharge % canon Decimal 12
    afkoopsom Settlement Amount Decimal 12
    afgekocht Settled Boolean 4
    afgekochtPer Settlement date Date 4
    afkooptermijn Settlement term Decimal 12
    afgekochtTot Settled until Date 4
    afschrijvingVergoeding Fee depreciation Option 4 Anders, Lineair, Nominaal, % Opstal taxatie, % Totale taxatie
    percentageAfschrijving Percentage depreciation Decimal 12
    bedragAfschrijvingVergoeding Amount fee depreciation Decimal 12
    clusterNo Cluster No. Code 20 Cluster
    nrreeks No. series Code 10
    moedercontractvolgnr Parent contract line no. Integer 4
    opmerkingen Remarks Text 50
    grondslagIndexering Indexing base Code 20 Indexing Basis
    aantalM2 Number m2 Decimal 12
    grondwaardeLV Land value (LCY) Decimal 12
    betalingsbereid Willing to Pay Boolean 4
    afkooptermijnFormule Settlement term (formula) DateFormula 32
    aangemaaktVanuitSVmodule Created in S&V module Boolean 4
    aanbiedingsvorm Proposal Form Code 20
    aanbiedingssoort Proposal Type Code 20
    eindbedragHuurzeker Final Amount + 1 yr. Secure Rent Decimal 12
    huurzekerpercentage Secure Rent Percentage Decimal 12
    rentIncreaseApplied Rent increase applied Boolean 4
    verkoop Sales Boolean 4
    huurtoeslag Housing Benefit Boolean 4
    verhuuraanbiedingvolgnr Rent proposal entry no. Integer 4
    aangemaaktOp Created on Date 4
    sortingID Sorting ID Code 20
    incomeClassCode Household Declaration Code Code 10 Income Class
    dummyContract Logically Deleted Boolean 4
    exploitationStateType Exploitation State Type Option 4 Empty, Not Managed, Renovation, Let, Administrative, Sold, Development
    exploitationEndReasonCode Exploitation End Reason Code 20
    salesProposalNo Sales Proposal No. Code 20 Sales Proposal
    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