Sales Dossier

    API Details

    Property Value
    Endpoint /tablesHousing/salesDossiers
    Table name SP - Dossier
    Table id 11024230
    Table caption Sales Dossier
    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
    objectNo Object No. Code 20 * OGE
    entryNo Entry No. Integer 4 *
    salesProposalNo Sales Proposal Code 20
    repurchaseNo Repurchase Code 20
    changeProcessEntryNo Change Process Entry No. Integer 4
    appraisalType Appraisal Type Option 4 Land, Building, Land and Building
    appraisalEntryNo Appraisal Entry No. Integer 4
    entryNoStructInspection Entry No. Structural Inspection Integer 4
    entryNoGEInspection Gas and Electrical Inspection Integer 4
    terminationContractNo Termination Contract No. Integer 4
    startDateSalesProcess Start Date Sales Process Date 4
    dateSalesOrderToAgent Date Sales Order to Agent Date 4
    dateKeyTransferToAgent Date Key Transfer to Agent Date 4
    dateNewOnWebsite Date New in Sales on Website Date 4
    dateOfficiallyOnWebsite Date Officially on Website Date 4
    dateSalesPresToOffice Date Sales Presentation Sent to Office Date 4
    dateApproved Date Approved Date 4
    toDateOptionProvided To Date Option Provided Date 4
    optionFirstSaleOrResale Option First Sale or Resale Option 4 , First Sale, Resale
    salesOption Sales Option Option 4 , Koopgarant, Koopcomfort, Free Sale
    discountPct Discount % Decimal 12
    dateContrPrepared Date Contract Prepared Date 4
    dateContrForSignCust Date Contract Ready For Signature Customer Date 4
    dateContrSignedByCust Date Contract Signed by Customer and Returned Date 4
    dateContrForSignOffice Date Contract For Signature To Office Date 4
    dateContrSignedByOffice Date Contract Signed by Office and Returned Date 4
    dateContrSignedAllParties Date Contract Signed by All Parties Date 4
    dateContrToNotary Date Contract to Notary Date 4
    dateCopyContrToCust Date Copy Contract Sent Registered to Customer Date 4
    dateCopyContrToOffice Date Copy Contract to Office Date 4
    subsidyOnSale Subsidy on Sale Boolean 4
    expDateResConditions Expiration Date Resolutive Conditions Date 4
    dateKeysToNotary Date Keys to Notary Date 4
    groningerAct Groninger Act Boolean 4
    floor Floor Text 2
    epaLabel Energy Label Code 30 Energy Label
    noOfRooms No. of Rooms (Appraisal Report) Integer 4
    noOfSquareMeters No. of Square Meters (Appraisal Report) Decimal 12
    dateInstChangeLock Date Installation Change Lock Date 4
    dateRemovalChangeLock Date Removal Change Lock Date 4
    dateMaintOrderProvided Date Maintenance Order Provided Date 4
    expComplDateMaintOrder Expected Completion Date Maintenance Order Date 4
    dateMaintOrderTechnCompl Date Maintenance Order Technically Completed Date 4
    presentTenant Present Tenant Boolean 4
    codeCandidate Code Candidate Code 20 Contact
    priceFrontageAppraisal Price Frontage Appraisal Decimal 12
    expDatePriceFrontageAppr Expiration Date Price Frontage Appraisal Date 4
    priceKoopcomfort Price Koopcomfort (Appraisal Report) Decimal 12
    priceKoopgarant Price Koopgarant (Appraisal Report) Decimal 12
    askingPriceFreeSale Asking Price (Free Sale) Decimal 12
    salePriceFreeSale Sale Price (Free Sale) Decimal 12
    invoiceAmount Invoice Amount Decimal 12
    nameSalesman Name Salesman Text 50
    leaseholdConversion Leasehold Conversion Boolean 4
    groundRentTotallyRedeemed Ground Rent Totally Redeemed Boolean 4
    endDateLeasehMasterContr End Date Leasehold Master Contract Date 4
    endDateLeaseholdRedeemed End Date Leasehold Redeemed Date 4
    freehold Freehold Boolean 4
    collectingSewer Collecting Sewer Boolean 4
    totalInvestmentOnFunda Investment totally on Funda Boolean 4
    dateSalesProcessAborted Sales Process Aborted Date 4
    codeReasonAbortionProcess Code Reason Abortion Sales Process Code 20 Reason Order Termination
    energyIndex Energy Index Decimal 12
    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