Legal Contract

    API Details

    Property Value
    Endpoint /tablesHousing/juridicalContracts
    Table name Juridical Contract
    Table id 11024208
    Table caption Legal 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 *
    contractNo Contract No. Code 20 *
    startdateRentalContract Startdate Rental Contract Date 4
    enddate Enddate Date 4
    revisionDate Revision Date Date 4
    duration Duration Text 10
    optie Optie Text 10
    termOfNotice Term of Notice DateFormula 32
    bestemming Bestemming Text 120
    lastDateModified Last Date Modified Date 4
    quaranteeNo Quarantee No. Code 20
    quaranteeAmount Quarantee Amount Decimal 12
    beneficiaryName Beneficiary Name Text 30
    bankName Bank Name Text 30
    address Address Text 30
    bankAccountNo Bank Account No. Text 30
    startdateQuarantee Startdate Quarantee Date 4
    deliveryDateOriginal Delivery Date Original Date 4
    locationOriginal Location Original Text 30
    dateOfPayment Date of Payment Date 4
    enddateQuarantee Enddate Quarantee Date 4
    beindigingstekst Beëindigingstekst Text 30
    rechtsopvolging Rechtsopvolging Boolean 4
    modificationDate Modification Date Date 4
    soort Soort Option 4 * Inhuur, Verhuur
    interestCode Interest Code Code 20 Interest Code
    expiryDate Expiry Date Date 4
    status Status Option 4 New, Current, Old, Ended
    noSeries No. Series Code 20 No. Series
    rider Rider Integer 4 *
    startdateRider Startdate Rider Date 4
    startdate1stRentalperiodExp Startdate 1st Rentalperiod Expound Text 50
    stRentalPeriod 1st Rental Period DateFormula 32
    stRentalPeriodExpound 1st Rental Period Expound Text 50
    enddate1stRentalPeriod Enddate 1st Rental Period Date 4
    enddate1stRentalPeriodExp Enddate 1st Rental Period Expound Text 50
    termOfNotice1stPeriod Term of Notice 1st Period DateFormula 32
    termOfNotice1stPeriodExp Term of Notice 1st Period Expound Text 50
    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 50
    startdate2ndRentalperiod Startdate 2nd Rentalperiod Date 4
    startdate2ndRentalperiodExp Startdate 2rd Rentalperiod Expound Text 50
    enddate2ndRentalPeriod Enddate 2nd Rental Period Date 4
    enddate2ndRentalPeriodExp Enddate 2nd Rental Period Expound Text 50
    termOfNotice2ndPeriod Term of Notice 2nd Period DateFormula 32
    termOfNotice2ndPeriodExp Term of Notice 2nd Period Expound Text 50
    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 50
    startdate3rdRentalperiod Startdate 3rd Rentalperiod Date 4
    startdate3rdRentalperiodExp Startdate 3rd Rentalperiod Expound Text 50
    enddate3rdRentalPeriod Enddate 3rd Rental Period Date 4
    enddate3rdRentalPeriodExp Enddate 3rd Rental Period Expound Text 50
    termOfNotice3rdPeriod Term of Notice 3rd Period DateFormula 32
    termOfNotice3rdPeriodExp Term of Notice 3rd Period Expound Text 50
    noticeDate3rdPeriod Notice Date 3rd Period Date 4
    noticeDate3rdPeriodExpound Notice Date 3rd Period Expound Text 50
    prolongation Prolongation Text 50
    termOfNoticeProlongation Term of Notice Prolongation DateFormula 32
    termOfNoticeProlongExpound Term of Notice Prolongation Expound Text 50
    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