Rental Contract

    API Details

    Property Value
    Endpoint /tablesHousing/additional
    Table name Additioneel
    Table id 11024012
    Table caption Rental 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
    customerNo Customer No. Code 20 *
    eenheidnr Realty Object No. Code 20 * OGE
    contractnr Contract No. Code 20
    ingangsdatum Rental Contract Starting Date Date 4
    einddatum Rental Contract Ending Date Date 4
    herzieningsdatum Review Date Date 4
    looptijd Duration Text 10
    optie Option Text 10
    opzegtermijn Notice Period DateFormula 32
    bestemming Destination Text 120
    gewijzigdOp Changed On Date 4
    garantienr Guarantee No. Code 20
    garantiebedrag Guarantee Amount Decimal 12
    naamBegunstigde Name Beneficiary Text 30
    banknaam Bank Account Name Text 30
    adres Address Text 30
    bankrekeningnr Bank Account No. Text 30
    ingangsdatumGarantie Start Date Guarantee Date 4
    ontvangstdatumOrigineel Date Original Received Date 4
    locatieOrigineel Location Original Text 30
    uitbetalingsdatum Payment Date Date 4
    einddatumGarantie End Date Guarantee Date 4
    beindigingstekst Termination Text Text 30
    rechtsopvolging Succession Boolean 4
    gen Gen Boolean 4
    mutatiedatum Modification Date Date 4
    exploitatieplicht Exploitation Obligation Boolean 4
    soort Type Option 4 * Inhuur, Verhuur
    vvElidnr Membership no. VvE Code 20
    functie Function Text 30
    lening Loan Code 20 Contact
    verpanding Pledge Code 20 Contact
    juridisch Legal Code 20 Contact
    verhuurd Leased Code 20 Contact
    beslag Confiscation Code 20 Contact
    aandeel Share Decimal 12
    provisiepercVerhuur Leased Fee Percentage Decimal 12
    provisiepercLeegstand Vacancy Fee Percentage Decimal 12
    provisiebedrag Fee Amount Decimal 12
    minBedragProvisie Minimal Fee Amount Decimal 12
    maxBedragProvisie Maximum Fee Amount Decimal 12
    btWbedrijfsboekingsgroep VAT Posting Group Code 10 VAT Business Posting Group
    bedrijfsboekingsgroep Posting Group Code 10
    waarborgsom Deposit Decimal 12
    renteBerekendTot Interest Calculated Until Date 4
    rentecode Interest Code Code 20 Interest Code
    expiratiedatum Expiration Date Date 4
    noSeries No. Series Code 20
    dueDateMessage Due Date Message Text 30
    legalEntityTenant Legal Entity Tenant Boolean 4
    subletThroughLegalEntity Sublet Through Legal Entity Boolean 4
    startdate1stRentalperiodExp Start Date 1st Rental Period Expound Text 50
    stRentalPeriod 1st Rental Period DateFormula 32
    stRentalPeriodExpound 1st Rental Period Expound Text 250
    enddate1stRentalPeriod End Date 1st Rental Period Date 4
    enddate1stRentalPeriodExp End Date 1st Rental Period Expound Text 50
    termOfNotice1stPeriod Term of Notice 1st Period DateFormula 32
    termOfNotice1stPeriodExp Term of Notice 1st Period Expound Text 250
    noticeDate1stPeriod Notice Date 1st Period Date 4
    noticeDate1stPeriodExpound Notice Date 1st Period Expound Text 50
    ndRentalPeriod 2nd Rental Period DateFormula 32
    ndRentalPeriodExpound 2nd Rental Period Expound Text 250
    startdate2ndRentalperiod Start Date 2nd Rental Period Date 4
    startdate2ndRentalperiodExp Start Date 2rd Rental Period Expound Text 50
    enddate2ndRentalPeriod End Date 2nd Rental Period Date 4
    enddate2ndRentalPeriodExp End Date 2nd Rental Period Expound Text 50
    termOfNotice2ndPeriod Term of Notice 2nd Period DateFormula 32
    termOfNotice2ndPeriodExp Term of Notice 2nd Period Expound Text 250
    noticeDate2ndPeriod Notice Date 2nd Period Date 4
    noticeDate2ndPeriodExp Notice Date 2nd Period Expound Text 50
    rdRentalPeriod 3rd Rental Period DateFormula 32
    rdRentalPeriodExpound 3rd Rental Period Expound Text 250
    startdate3rdRentalperiod Start Date 3rd Rental Period Date 4
    startdate3rdRentalperiodExp Start Date 3rd Rental Period Expound Text 50
    enddate3rdRentalPeriod End Date 3rd Rental Period Date 4
    enddate3rdRentalPeriodExp End Date 3rd Rental Period Expound Text 50
    termOfNotice3rdPeriod Term of Notice 3rd Period DateFormula 32
    termOfNotice3rdPeriodExp Term of Notice 3rd Period Expound Text 250
    noticeDate3rdPeriod Notice Date 3rd Period Date 4
    noticeDate3rdPeriodExpound Notice Date 3rd Period Expound Text 50
    prolongation Extension Period Description Text 50
    termOfNoticeProlongation Notice Period Extension DateFormula 32
    termOfNoticeProlongExpound Notice Period Extension Expound Text 250
    stuknrVerrekendeWaarborgsom Document No. Applied Deposit Code 20
    invalidContract Invalid Contract Boolean 4
    prolongationPeriod Extension Period DateFormula 32
    rentalContractType Rental Contract Type Code 20 RentalContractType
    daebRentalForNonDAEBUnit DAEB Rental Contract for non-DAEB Realty Object Boolean 4
    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