Sales Proposal

    API Details

    Property Value
    Endpoint /tablesHousing/salesProposals
    Table name Sales Proposal
    Table id 11024063
    Table caption Sales Proposal
    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
    eenheidnr Realty Object No. Code 20 OGE
    nr No. Code 20 *
    vvE OA Text 50
    cbsBuurt Corporation Neighborhood Code Code 20
    huidigeExploitatievorm Current Tenure Code 20
    leegPer Vacant Per Date 4
    status Status Option 4 Aangemaakt, Lopend, Geaccepteerd, Vervallen
    eersteOfWederverkoop First Sale Or Resale Option 4 Eerste verkoop, Wederverkoop
    taxatiesoort Appraisal Type Option 4 Grond, Opstal, Grond en opstal Taxatie
    keuring Examination Integer 4
    makelaar Estate Agent Code 20 Vendor
    verkoopopdracht Sales Contract Date 4
    eindeVerkoopopdracht Date Cancelling Sales Contract Date 4
    redenEindeVerkoopopdracht Reason Cancelling Sales Contract Code 20 Reason Order Termination
    gegadigde Candidate Code 20 Contact
    bankGiro Bank/Giro Code 10
    currentTenant Proposal to Current Tenant Boolean 4
    brutoJaarinkomenLV Gross Annual Income (LCY) Decimal 12
    huishoudengrootte No. Of Family Members Integer 4
    huurLV Rent (LCY) Decimal 12
    nrreeks No. Series Code 20 No. Series
    notaris Notary Code 20 Customer
    volgnrTaxatie Reference No. Appraisal Integer 4
    verwachteTransportdatum Expected Transfer Date Date 4
    datumVoorlopigKoopcontract Date Preliminary Contract Date 4
    kostenKoper Kosten koper Boolean 4
    vvEbijdragePerMaand VvE-bijdrage per maand Decimal 12
    relatedSalesofferNo Related Salesoffer No. Code 20 Sales Proposal
    advertNo Advert No. Code 20
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    transportdatum Transfer Date Date 4
    activeUser Active User Code 20 Salesperson/Purchaser
    intermediaryNo Intermediary No. Code 20 Contact
    processStatusCode Process Status Code Code 10 Process Status
    purchaseagreementDate Purchase-agreement Date Date 4
    termDateDissolutionPrchAgr Termination Date dissolution Purchase-agreement Date 4
    termDateProposalCurrentTnt Termination Date Proposal current Tenant Date 4
    purchaseagreementSentOn Purchase-agreement Sent On Date 4
    purchaseagreemntReceiptDate Purchase-agreement Receipt Date Date 4
    clusterNo Cluster No. Code 20 Cluster
    dateSurplusValue Date Surplus Value Date 4
    surplusValue Surplus Value Decimal 12
    salesCosts Sales Costs Decimal 12
    cbsNeighborhoodCode CBS Neighborhood Code Code 8
    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