OGE Status History

    API Details

    Property Value
    Endpoint /tablesHousing/ogeStatusHistories
    Table name OGE Status History
    Table id 11024123
    Table caption OGE Status History
    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
    unitNo Realty Object No. Code 20 * OGE
    startDate Start Date Date 4 *
    endDate End Date Date 4 *
    customerContactNo Customer- / Contact No. Code 20
    usageType Usage Type Option 4 Rental, Sale
    status Status Option 4 Empty, Not Managed, Renovation, Let, Administrative, Sold, Development
    processed Processed Boolean 4
    offerType Offer Type Code 20 Proposal Type
    offerSubType Offer Sub-Type Code 20 Proposal Model
    sold Sold 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