Bailiff File

    API Details

    Property Value
    Endpoint /tablesFinance/bailiffDossiers
    Table name Deurwaarderdossier
    Table id 11024035
    Table caption Bailiff File
    Data per company True
    Group Finance

    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 Customer
    dossiernr File No. Code 20 *
    deurwaardernr Bailiff No. Code 50 Vendor
    dossiernrDeurwaarder Bailiff File No. Code 20
    status Status Code 10 Bailiff Dossier Status
    verstuurd Sent Date 4
    afgesloten Closed Date 4
    nrreeks No. Series Code 10
    name Name Text 100
    briefsjabloon Text Template Code 30
    ingangsdatum Start Date Date 4
    address Customer Address Text 100
    address2 Customer Address 2 Text 50
    postCode Customer Postcode Code 20 Post Code
    city Customer City Text 30
    contact Customer Contact Text 100
    phoneNo Customer Phone No. Text 30
    deurwaarderAdres Bailiff Address Text 100
    deurwaarderAdres2 Bailiff Address 2 Text 50
    deurwaarderPostcode Bailiff Postcode Code 20 Post Code
    deurwaarderPlaats Bailiff City Text 30
    deurwaarderContactpersoon Bailiff Contact Text 100
    deurwaarderTelefoon Bailiff Phone No. Text 30
    soortEigenaar Owner Type Option 4 , Eigenaar/Bewoner, Belegger
    controledatum Checking Date Date 4
    leefbaarheidsdossier Livability Dossier Boolean 4
    schuldbemiddeling Debt Mediation Boolean 4
    vonnisdatum Date Judgment Date 4
    vonnisToegewezen Judgment Assigned Boolean 4
    betaalvonnis Pay Judgment Boolean 4
    betaalvonnisTm Pay Judgment To Date Date 4
    ontruimingsdatum Eviction Date Date 4
    datumAfrekening Settlement Date Date 4
    redenAfsluiting Reason Closure Code 20 Reden afsluiting deurw.dossier
    eenheidnr Realty Object No. Code 20 OGE
    gebruikersID User ID Code 50
    brutoHuurprijs Gross Rent Decimal 12
    huurtoeslag Rent Surcharge Decimal 12
    geprolongeerdeHuur Prolonged Rent Decimal 12
    brutoHuurprijsAangepast Gross Rent Adjusted Boolean 4
    saldoAangemeldeStookkosten Balance of Notified Heating Costs Decimal 12
    saldoAangemeldeServicekosten Balance of Notified Service Costs Decimal 12
    saldoAangHerstelkostennota Balance of Notified Repair Costs Invoice Decimal 12
    saldoAangOvVorderingen Balance of Other Notified Claims Decimal 12
    afgerekendTm Settled To Date Date 4
    bedragIncassokosten Amount of Collection Costs Decimal 12
    nietVolledigAfgehandeld Not (Fully) Settled Boolean 4
    saldoAangemeldeHuurschuld Balance of Notified Rent Debt Decimal 12
    saldoHuurschuldAangepast Balance of Rent Debt Adjusted Boolean 4
    geprolongeerdeHuurAangepast Prolonged Rent Adjusted Boolean 4
    huurtoeslagAangepast Rent Surcharge Adjusted Boolean 4
    datumFiatFactuur Date Invoice Approved Date 4
    afgedrukt Printed Integer 4
    verzondenPerEmail E-Mail Sent Integer 4
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    contactResponsible Contact Responsible Code 20
    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