Table : deals

Raw table description

Fields

id id

{
  "name": "id",
  "type": "primaryKey"
}

buyerGroupId  → buyerGroups  (The buyerGroup that is set to buy the deal.)

{
  "name": "buyerGroupId",
  "type": "foreignKey",
  "table": "buyerGroups",
  "note": "The buyerGroup that is set to buy the deal."
}

objectStatus E  (Which status the deal have.)

{
  "name": "objectStatus",
  "type": "enum",
  "enums": [
    "ENUMS_OBJECTSTATUS_TYPE_IN_PROGRESS (Pågående)",
    "ENUMS_OBJECTSTATUS_TYPE_REPOSSESSED (Återtagen)",
    "ENUMS_OBJECTSTATUS_TYPE_ESTIMATE (Värdering)",
    "ENUMS_OBJECTSTATUS_TYPE_DORMANT (Vilande)",
    "ENUMS_OBJECTSTATUS_TYPE_RESERVED (Reserverad)",
    "ENUMS_OBJECTSTATUS_TYPE_COMING (Kommande)",
    "ENUMS_OBJECTSTATUS_TYPE_NO ASSIGNMENT (Inget uppdrag)",
    "ENUMS_OBJECTSTATUS_TYPE_LOST_LISTING (Förlorat intag)",
    "ENUMS_OBJECTSTATUS_TYPE_OTHER (Annat)",
    "ENUMS_OBJECTSTATUS_TYPE_ARCHIVED (Arkiverat)",
    "ENUMS_OBJECTSTATUS_TYPE_CLOSED (Avslutat)",
    "ENUMS_OBJECTSTATUS_TYPE_REFERENCE (Referensobjekt)",
    "ENUMS_OBJECTSTATUS_TYPE_FOR_SALE (Till salu)",
    "ENUMS_OBJECTSTATUS_TYPE_INTAKE (Under intag)",
    "ENUMS_OBJECTSTATUS_TYPE_MARKETING (Annonsering)",
    "ENUMS_OBJECTSTATUS_TYPE_SOLD (Såld)",
    "ENUMS_OBJECTSTATUS_TYPE_LEASED (Uthyrd)",
    "ENUMS_OBJECTSTATUS_TYPE_TERMINATED (Uppsagt)",
    "ENUMS_OBJECTSTATUS_TYPE_AVAILABLE_FOR_RENT (Hyresledig)",
    "ENUMS_OBJECTSTATUS_TYPE_ASSIGNMENT_SIGNED (Uppdrag påskrivet)"
  ],
  "note": "Which status the deal have."
}

communicationTokenId  → communicationTokens  (Token used for incoming sms and a short code to identify the deal.)

{
  "name": "communicationTokenId",
  "type": "foreignKey",
  "table": "communicationTokens",
  "schema": "mspx_admin",
  "note": "Token used for incoming sms and a short code to identify the deal."
}

mainEstateId  → estates  (The main estate of the deal, will be used as the main marketing estate.)

{
  "name": "mainEstateId",
  "type": "foreignKey",
  "table": "estates",
  "note": "The main estate of the deal, will be used as the main marketing estate."
}

mainBrokerContactId  → contacts  (The responsible broker.)

{
  "name": "mainBrokerContactId",
  "type": "foreignKey",
  "table": "contacts",
  "note": "The responsible broker."
}

capitalGainCalculationId  → capitalGainCalculations

{
  "name": "capitalGainCalculationId",
  "type": "foreignKey",
  "table": "capitalGainCalculations"
}

webPageURL

{
  "name": "webPageURL",
  "type": "text",
  "maxLength": 200
}

webPageImagesURL

{
  "name": "webPageImagesURL",
  "type": "text",
  "maxLength": 200
}

webPageAccessibleOnlyByDirectUrl bit

{
  "name": "webPageAccessibleOnlyByDirectUrl",
  "type": "bit"
}

contractType E

{
  "name": "contractType",
  "type": "enum",
  "enums": [
    "ENUMS_CONTRACTTYPES_TYPE_WRITE ASSIGNMENT (Skrivuppdrag)",
    "ENUMS_CONTRACTTYPES_TYPE_SALES (Förmedling)",
    "ENUMS_CONTRACTTYPES_TYPE_PAID ESTIMATE (Värderingsuppdrag)"
  ],
  "note": ""
}

organizationUnitId  → organizationUnits  (The organizationUnit the deal is administered in.)

{
  "name": "organizationUnitId",
  "type": "foreignKey",
  "table": "organizationUnits",
  "note": "The organizationUnit the deal is administered in."
}

currentFlowStepId  → flowSteps  (The flow step the deal is currently in.)

{
  "name": "currentFlowStepId",
  "type": "foreignKey",
  "table": "flowSteps",
  "schema": "mspx_admin",
  "note": "The flow step the deal is currently in."
}

biddingId  → biddings  (The bidding that belongs to the deal.)

{
  "name": "biddingId",
  "type": "foreignKey",
  "table": "biddings",
  "note": "The bidding that belongs to the deal."
}

mainImageFileId  → files  (The image that represents the deal in flow and deal page.)

{
  "name": "mainImageFileId",
  "type": "foreignKey",
  "table": "files",
  "note": "The image that represents the deal in flow and deal page."
}

currency D  → currencies  (The currency the deal is dealt in.)

{
  "name": "currency",
  "mandatory": "true",
  "default": "MDAtMXwwMDAwMDAwMDAwMXwxMw..",
  "type": "foreignKey",
  "table": "currencies",
  "schema": "mspx_admin",
  "note": "The currency the deal is dealt in."
}

sellingTextSubject

{
  "name": "sellingTextSubject",
  "type": "text",
  "maxLength": 100
}

sellingTextSubjectMultiLang   (Allowed languages: en, sv, es, de, da, fr, nl. Structure: {"en": "Selling text with a maxLength of 100", "sv": "Säljande text med en maxlängd på 100", "es": "Venta de texto con una longitud máxima de 100" })

{
  "name": "sellingTextSubjectMultiLang",
  "type": "jsonObject",
  "validationSchema": {
    "id": "deals/sellingTextSubjectMultiLang",
    "type": "object",
    "additionalProperties": false,
    "properties": {
      "sv": {
        "type": "string",
        "maxLength": 100
      },
      "en": {
        "type": "string",
        "maxLength": 100
      },
      "es": {
        "type": "string",
        "maxLength": 100
      },
      "de": {
        "type": "string",
        "maxLength": 100
      },
      "da": {
        "type": "string",
        "maxLength": 100
      },
      "fr": {
        "type": "string",
        "maxLength": 100
      },
      "nl": {
        "type": "string",
        "maxLength": 100
      }
    }
  },
  "note": "Allowed languages: en, sv, es, de, da, fr, nl. Structure: {\"en\": \"Selling text with a maxLength of 100\", \"sv\": \"Säljande text med en maxlängd på 100\", \"es\": \"Venta de texto con una longitud máxima de 100\" }"
}

sellingTextShort

{
  "name": "sellingTextShort",
  "type": "text",
  "maxLength": 300
}

sellingTextShortMultiLang   (Allowed languages: en, sv, es, de, da, fr, nl. Structure: {"en": "Selling text with a maxLength of 300", "sv": "Säljande text med en maxlängd på 300", "es": "Venta de texto con una longitud máxima de 300" })

{
  "name": "sellingTextShortMultiLang",
  "type": "jsonObject",
  "validationSchema": {
    "id": "deals/sellingTextShortMultiLang",
    "type": "object",
    "additionalProperties": false,
    "properties": {
      "sv": {
        "type": "string",
        "maxLength": 300
      },
      "en": {
        "type": "string",
        "maxLength": 300
      },
      "es": {
        "type": "string",
        "maxLength": 300
      },
      "de": {
        "type": "string",
        "maxLength": 300
      },
      "da": {
        "type": "string",
        "maxLength": 300
      },
      "fr": {
        "type": "string",
        "maxLength": 300
      },
      "nl": {
        "type": "string",
        "maxLength": 300
      }
    }
  },
  "note": "Allowed languages: en, sv, es, de, da, fr, nl. Structure: {\"en\": \"Selling text with a maxLength of 300\", \"sv\": \"Säljande text med en maxlängd på 300\", \"es\": \"Venta de texto con una longitud máxima de 300\" }"
}

sellingText

{
  "name": "sellingText",
  "type": "text"
}

sellingTextMultiLang   (Allowed languages: en, sv, es, de, da, fr, nl. Structure: {"en": "Selling text without a specified maxLength", "sv": "Säljande text utan en specifik maxlängd", "es": "Venta de texto sin una longitud máxima específica" })

{
  "name": "sellingTextMultiLang",
  "type": "jsonObject",
  "validationSchema": {
    "id": "deals/sellingTextMultiLang",
    "type": "object",
    "additionalProperties": false,
    "properties": {
      "sv": {
        "type": "string"
      },
      "en": {
        "type": "string"
      },
      "es": {
        "type": "string"
      },
      "de": {
        "type": "string"
      },
      "da": {
        "type": "string"
      },
      "fr": {
        "type": "string"
      },
      "nl": {
        "type": "string"
      }
    }
  },
  "note": "Allowed languages: en, sv, es, de, da, fr, nl. Structure: {\"en\": \"Selling text without a specified maxLength\", \"sv\": \"Säljande text utan en specifik maxlängd\", \"es\": \"Venta de texto sin una longitud máxima específica\" }"
}

externalId   (Used by brokers to set their own identifier on deals)

{
  "name": "externalId",
  "type": "text",
  "maxLength": 100,
  "note": "Used by brokers to set their own identifier on deals"
}

displayName   (The name the deal is displayed in bidding, flow page and deal page.)

{
  "name": "displayName",
  "type": "text",
  "maxLength": 100,
  "note": "The name the deal is displayed in bidding, flow page and deal page."
}

listingStartDate   (Start date when the deal mediation process started.)

{
  "name": "listingStartDate",
  "type": "date",
  "note": "Start date when the deal mediation process started."
}

listingEndDate   (End date when the deal mediation process ended.)

{
  "name": "listingEndDate",
  "type": "date",
  "note": "End date when the deal mediation process ended."
}

contractDate   (Time when the contract should be written.)

{
  "name": "contractDate",
  "type": "date",
  "note": "Time when the contract should be written."
}

downPaymentDate   (When the down payment should be paid.)

{
  "name": "downPaymentDate",
  "type": "date",
  "note": "When the down payment should be paid."
}

downPaymentAmount $$  (Amount of the down payment.)

{
  "name": "downPaymentAmount",
  "type": "money",
  "note": "Amount of the down payment."
}

isDownPaymentDepositedWithBroker bit

{
  "name": "isDownPaymentDepositedWithBroker",
  "type": "bit"
}

isDownPaymentInBrokerClientAccount bit

{
  "name": "isDownPaymentInBrokerClientAccount",
  "type": "bit",
  "default": "true"
}

downPaymentAccountId  → bankAccounts  (The bank account the down payment should be stored.)

{
  "name": "downPaymentAccountId",
  "type": "foreignKey",
  "table": "bankAccounts",
  "note": "The bank account the down payment should be stored."
}

sellerDownPaymentAccountId  → bankAccounts  (The bank account the down payment should be stored if it should be paid directly to one seller.)

{
  "name": "sellerDownPaymentAccountId",
  "type": "foreignKey",
  "table": "bankAccounts",
  "note": "The bank account the down payment should be stored if it should be paid directly to one seller."
}

depositedInAmount $$  (The amount the buyers have paid of the down payment.)

{
  "name": "depositedInAmount",
  "type": "money",
  "note": "The amount the buyers have paid of the down payment."
}

depositedInDate   (Date when the down payment is submitted.)

{
  "name": "depositedInDate",
  "type": "date",
  "note": "Date when the down payment is submitted."
}

depositedInComment   (Comment on incoming down payment.)

{
  "name": "depositedInComment",
  "type": "text",
  "maxLength": 200,
  "note": "Comment on incoming down payment."
}

legalEntityAcceptableSetting E

{
  "name": "legalEntityAcceptableSetting",
  "type": "enum",
  "enums": [
    "ENUM_LEGAL_ENTITY_ACCEPTABLE_SETTING_AFTER_CONSIDERATION (Föreningen kan acceptera juridisk person efter särskild prövning)",
    "ENUM_LEGAL_ENTITY_ACCEPTABLE_SETTING_NO (Nej)",
    "ENUM_LEGAL_ENTITY_ACCEPTABLE_SETTING_YES (Ja)"
  ]
}

isVIP bit  (Set true if the deal should not be used for statistics, like mäklarstatistik.)

{
  "name": "isVIP",
  "type": "bit",
  "note": "Set true if the deal should not be used for statistics, like mäklarstatistik."
}

isBuyerApprovedByTennant bit

{
  "name": "isBuyerApprovedByTennant",
  "type": "bit"
}

buyerApprovalByTennantSentDate

{
  "name": "buyerApprovalByTennantSentDate",
  "type": "date"
}

buyerApprovedByTennantDate

{
  "name": "buyerApprovedByTennantDate",
  "type": "date"
}

archiveNumber

{
  "name": "archiveNumber",
  "type": "text",
  "maxLength": 40
}

accessDate   (The date when the buyers can access the property.)

{
  "name": "accessDate",
  "type": "date",
  "note": "The date when the buyers can access the property."
}

accessComment

{
  "name": "accessComment",
  "type": "text"
}

accessDateSeller   (When the sellers should meet the broker.)

{
  "name": "accessDateSeller",
  "type": "datetime",
  "note": "When the sellers should meet the broker."
}

accessDateBuyer   (When the buyers should meet the broker.)

{
  "name": "accessDateBuyer",
  "type": "datetime",
  "note": "When the buyers should meet the broker."
}

cashDefinitiveStatementComment

{
  "name": "cashDefinitiveStatementComment",
  "type": "text"
}

startingPrice $$  (Currency is deals.currencyId)

{
  "name": "startingPrice",
  "type": "money",
  "note": "Currency is deals.currencyId"
}

finalPrice $$  (Currency is deals.currencyId)

{
  "name": "finalPrice",
  "type": "money",
  "note": "Currency is deals.currencyId"
}

finalPriceInText

{
  "name": "finalPriceInText",
  "type": "text",
  "maxLength": 200
}

startingPriceType T

{
  "name": "startingPriceType",
  "type": "text",
  "enums": [
    "ENUMS_ASKINGPRICETYPE_TYPE_OR_BY_APPOINTMENT (Enligt ök)",
    "ENUMS_ASKINGPRICETYPE_TYPE_HIGHEST_BIDDER (Högstbjudande)",
    "ENUMS_ASKINGPRICETYPE_TYPE_IS_ACCEPTED_PRICE (Accepterat pris)",
    "ENUMS_ASKINGPRICETYPE_TYPE_SOLD_BY_QUOTATION (Säljs via anbudsförfarande)",
    "ENUMS_ASKINGPRICETYPE_TYPE_PRICE (Pris)",
    "ENUMS_ASKINGPRICETYPE_TYPE_STARTING_PRICE (Utgångspris)"
  ],
  "maxLength": 100
}

foreignStartingPrice $$

{
  "name": "foreignStartingPrice",
  "type": "money"
}

foreignStartingPriceCurrencyId  → currencies

{
  "name": "foreignStartingPriceCurrencyId",
  "type": "foreignKey",
  "table": "currencies",
  "schema": "mspx_admin"
}

abortionCompensation $$  (The payment the broker will received if the deal is aborted for some reason.)

{
  "name": "abortionCompensation",
  "type": "money",
  "note": "The payment the broker will received if the deal is aborted for some reason."
}

isInternational bit

{
  "name": "isInternational",
  "type": "bit"
}

approveMarketingOfFinalPrice bit

{
  "name": "approveMarketingOfFinalPrice",
  "type": "bit"
}

approveMarketingOfDeal bit

{
  "name": "approveMarketingOfDeal",
  "type": "bit"
}

archiveExternalId

{
  "name": "archiveExternalId",
  "type": "text",
  "maxLength": 200
}

buyersPartOfMonthlyRent $$

{
  "name": "buyersPartOfMonthlyRent",
  "type": "money"
}

buyersPartOfMunicipalPropertyTax $$

{
  "name": "buyersPartOfMunicipalPropertyTax",
  "type": "money"
}

outgoingDownPaymentTransactionGroupId  → transactionGroups  (The transactions of the down payment to the sellers.)

{
  "name": "outgoingDownPaymentTransactionGroupId",
  "type": "foreignKey",
  "table": "transactionGroups",
  "note": "The transactions of the down payment to the sellers."
}

incomingPaymentTransactionGroupId  → transactionGroups  (How the main payment will be made.(How the buyers will pay).)

{
  "name": "incomingPaymentTransactionGroupId",
  "type": "foreignKey",
  "table": "transactionGroups",
  "note": "How the main payment will be made.(How the buyers will pay)."
}

outgoingPaymentTransactionGroupId  → transactionGroups  (3rd, How the main payment will be distributed.(How the sellers will be paid).)

{
  "name": "outgoingPaymentTransactionGroupId",
  "type": "foreignKey",
  "table": "transactionGroups",
  "note": "3rd, How the main payment will be distributed.(How the sellers will be paid)."
}

outgoingPaymentBankAccountId  → bankAccounts  (1th, The main payment will be to only this account)

{
  "name": "outgoingPaymentBankAccountId",
  "type": "foreignKey",
  "table": "bankAccounts",
  "note": "1th, The main payment will be to only this account"
}

outgoingPaymentBankAccountText   (2th, The main payment will be to only this account)

{
  "name": "outgoingPaymentBankAccountText",
  "type": "text",
  "maxLength": 150,
  "note": "2th, The main payment will be to only this account"
}

isAccessReady bit  (Marks the deal to be ready for access.)

{
  "name": "isAccessReady",
  "type": "bit",
  "note": "Marks the deal to be ready for access."
}

accessLocation   (Location where clearance will be sorted.)

{
  "name": "accessLocation",
  "type": "text",
  "maxLength": 150,
  "note": "Location where clearance will be sorted."
}

accessOfficer   (Name of the officer that will handle money transactions.)

{
  "name": "accessOfficer",
  "type": "text",
  "maxLength": 150,
  "note": "Name of the officer that will handle money transactions."
}

accessLocationContactInfo   (Contact info to the location where the access will take place)

{
  "name": "accessLocationContactInfo",
  "type": "text",
  "note": "Contact info to the location where the access will take place"
}

commissionId  → commissions

{
  "name": "commissionId",
  "type": "foreignKey",
  "table": "commissions"
}

description

{
  "name": "description",
  "type": "text"
}

identifier

{
  "name": "identifier",
  "type": "text",
  "maxLength": 50
}

cashDefinitiveStatementCommentSeller

{
  "name": "cashDefinitiveStatementCommentSeller",
  "type": "text"
}

cashDefinitiveStatementCommentBuyer

{
  "name": "cashDefinitiveStatementCommentBuyer",
  "type": "text"
}

cashDefinitiveStatementFeeAndTaxInformation

{
  "name": "cashDefinitiveStatementFeeAndTaxInformation",
  "type": "text"
}

cashDefinitiveStatementHideDownPaymentTransactions bit

{
  "name": "cashDefinitiveStatementHideDownPaymentTransactions",
  "type": "bit"
}

importedDate

{
  "name": "importedDate",
  "type": "datetime"
}

importedName

{
  "name": "importedName",
  "type": "text",
  "maxLength": 150
}

email   (Email that can be displayed on marketing places as an alternative to contacting the broker.)

{
  "name": "email",
  "type": "text",
  "maxLength": 80,
  "note": "Email that can be displayed on marketing places as an alternative to contacting the broker."
}

sellingMethodIsQuotation bit

{
  "name": "sellingMethodIsQuotation",
  "type": "bit"
}

sellingMethodQuotationDateTime

{
  "name": "sellingMethodQuotationDateTime",
  "type": "datetime"
}

sellingMethodIsBid bit

{
  "name": "sellingMethodIsBid",
  "type": "bit"
}

sellingMethodBidDateTime

{
  "name": "sellingMethodBidDateTime",
  "type": "datetime"
}

sellingMethodIsInterest bit

{
  "name": "sellingMethodIsInterest",
  "type": "bit"
}

sellingMethodInterestDateTime

{
  "name": "sellingMethodInterestDateTime",
  "type": "datetime"
}

sellingMethodIsFixedPrice bit

{
  "name": "sellingMethodIsFixedPrice",
  "type": "bit"
}

sellingMethodIsOpenBidding bit

{
  "name": "sellingMethodIsOpenBidding",
  "type": "bit"
}

sellingMethodIsPublicAuction bit

{
  "name": "sellingMethodIsPublicAuction",
  "type": "bit"
}

sellingMethodPublicAuctionDateTime

{
  "name": "sellingMethodPublicAuctionDateTime",
  "type": "datetime"
}

sellingMethodDescription

{
  "name": "sellingMethodDescription",
  "type": "text"
}

sellingMethodTermsOfPayment T

{
  "name": "sellingMethodTermsOfPayment",
  "type": "text",
  "enums": [
    "FARMING_SELLING_METHOD_TERMS1 (10 % av köpeskillingen erlägges kontant som handpenning vid kontraktstecknandet och resterande senast vid tillträdet.)",
    "FARMING_SELLING_METHOD_TERMS2 (10 % av köpeskillingen erlägges kontant som handpenning vid kontraktstecknandet och resterande senast vid tillträdet. Budgivaren skall inom 14 dagar efter avslutad budgivning vara beredd att teckna köpekontrakt, varför besiktning av objektet/fastigheten och kontroll av finansieringsmöjligheter mm bör vara klart innan bud lämnas.)",
    "FARMING_SELLING_METHOD_TERMS3 (Köparen skall i direkt anslutning till avslutad auktion teckna köpekontrakt och kontant erlägga xxx kr i handpenning, varför besiktning av objektet/fastigheten och kontroll av finansieringsmöjligheter mm bör vara klart innan bud lämnas. Resterande del av köpeskilling skall erläggas senast vid tillträdet.)"
  ]
}

residentialArea   (Used only in new development)

{
  "name": "residentialArea",
  "type": "text",
  "maxLength": 150,
  "note": "Used only in new development"
}

isNewDevelopment bit  (If set to true, the deal should be marketed as a new development deal)

{
  "name": "isNewDevelopment",
  "type": "bit",
  "note": "If set to true, the deal should be marketed as a new development deal"
}

newDevelopmentStatus E

{
  "name": "newDevelopmentStatus",
  "type": "enum",
  "enums": [
    "ENUM_DEAL_NEW_DEVELOPMENT_STATUS_ACTIVE (Försäljning pågår)",
    "ENUM_DEAL_NEW_DEVELOPMENT_STATUS_ARCHIVED (Arkiverat)",
    "ENUM_DEAL_NEW_DEVELOPMENT_STATUS_COMING (Kommande)",
    "ENUM_DEAL_NEW_DEVELOPMENT_STATUS_COMPLETED (Avslutat)",
    "ENUM_DEAL_NEW_DEVELOPMENT_STATUS_INACTIVE (Pause/uppehåll)",
    "ENUM_DEAL_NEW_DEVELOPMENT_STATUS_MARKETING (Annonsering)",
    "ENUM_DEAL_NEW_DEVELOPMENT_STATUS_NOT_READY_FOR_SALE (Ej säljstart)",
    "ENUM_DEAL_NEW_DEVELOPMENT_STATUS_PLANNED (Planerat)",
    "ENUM_DEAL_NEW_DEVELOPMENT_STATUS_SOLDOUT (Slutsålt)"
  ]
}

streetAddress   (Used only in new development)

{
  "name": "streetAddress",
  "type": "text",
  "maxLength": 100,
  "note": "Used only in new development"
}

postalCode   (Used only in new development)

{
  "name": "postalCode",
  "type": "text",
  "maxLength": 20,
  "note": "Used only in new development"
}

city   (Used only in new development)

{
  "name": "city",
  "type": "text",
  "maxLength": 100,
  "note": "Used only in new development"
}

builder   (Used only in new development)

{
  "name": "builder",
  "type": "text",
  "maxLength": 120,
  "note": "Used only in new development"
}

minNumberOfRooms   (Used only in new development)

{
  "name": "minNumberOfRooms",
  "type": "decimal",
  "digits": 4,
  "decimals": 1,
  "note": "Used only in new development"
}

maxNumberOfRooms   (Used only in new development)

{
  "name": "maxNumberOfRooms",
  "type": "decimal",
  "digits": 4,
  "decimals": 1,
  "note": "Used only in new development"
}

minLivingArea   (Used only in new development)

{
  "name": "minLivingArea",
  "type": "decimal",
  "digits": 5,
  "decimals": 1,
  "note": "Used only in new development"
}

maxLivingArea   (Used only in new development)

{
  "name": "maxLivingArea",
  "type": "decimal",
  "digits": 5,
  "decimals": 1,
  "note": "Used only in new development"
}

minOtherLivingArea   (Used only in new development)

{
  "name": "minOtherLivingArea",
  "type": "decimal",
  "digits": 5,
  "decimals": 1,
  "note": "Used only in new development"
}

maxOtherLivingArea   (Used only in new development)

{
  "name": "maxOtherLivingArea",
  "type": "decimal",
  "digits": 5,
  "decimals": 1,
  "note": "Used only in new development"
}

minPrice $$  (Used only in new development)

{
  "name": "minPrice",
  "type": "money",
  "note": "Used only in new development"
}

maxPrice $$  (Used only in new development)

{
  "name": "maxPrice",
  "type": "money",
  "note": "Used only in new development"
}

minMonthlyRent $$  (Used only in new development)

{
  "name": "minMonthlyRent",
  "type": "money",
  "note": "Used only in new development"
}

maxMonthlyRent $$  (Used only in new development)

{
  "name": "maxMonthlyRent",
  "type": "money",
  "note": "Used only in new development"
}

numberOfHomes   (Used only in new development)

{
  "name": "numberOfHomes",
  "type": "int",
  "note": "Used only in new development"
}

environment   (Used only in new development)

{
  "name": "environment",
  "type": "text",
  "note": "Used only in new development"
}

servicesAndCommunications   (Used only in new development)

{
  "name": "servicesAndCommunications",
  "type": "text",
  "note": "Used only in new development"
}

directions   (Used only in new development)

{
  "name": "directions",
  "type": "text",
  "note": "Used only in new development"
}

latitude   (Used only in new development)

{
  "name": "latitude",
  "type": "text",
  "maxLength": 22,
  "note": "Used only in new development"
}

longitude   (Used only in new development)

{
  "name": "longitude",
  "type": "text",
  "maxLength": 22,
  "note": "Used only in new development"
}

buildingStarted   (Used only in new development)

{
  "name": "buildingStarted",
  "type": "text",
  "maxLength": 200,
  "note": "Used only in new development"
}

preliminaryOccupancy   (Used only in new development)

{
  "name": "preliminaryOccupancy",
  "type": "text",
  "maxLength": 200,
  "note": "Used only in new development"
}

plotArea   (Used only in new development)

{
  "name": "plotArea",
  "type": "decimal",
  "digits": 15,
  "decimals": 1,
  "note": "Used only in new development"
}

plotDescription   (Used only in new development)

{
  "name": "plotDescription",
  "type": "text",
  "note": "Used only in new development"
}

developmentPhase   (Used only in new development)

{
  "name": "developmentPhase",
  "type": "text",
  "note": "Used only in new development"
}

objectType   (Used only in new development)

{
  "name": "objectType",
  "type": "text",
  "maxLength": 200,
  "note": "Used only in new development"
}

habitat   (Used only in new development)

{
  "name": "habitat",
  "type": "text",
  "maxLength": 200,
  "note": "Used only in new development"
}

salesStartDate   (Used only in new development)

{
  "name": "salesStartDate",
  "type": "date",
  "note": "Used only in new development"
}

objectTypeId  → objectTypes  (Used only in new development)

{
  "name": "objectTypeId",
  "type": "foreignKey",
  "table": "objectTypes",
  "schema": "mspx_admin",
  "note": "Used only in new development"
}

countryId  → countries

{
  "name": "countryId",
  "type": "foreignKey",
  "table": "countries",
  "schema": "mspx_admin"
}

accessOfficerContactId  → contacts  (Will contain the bank officer that handles the money transactions.)

{
  "name": "accessOfficerContactId",
  "type": "foreignKey",
  "table": "contacts",
  "note": "Will contain the bank officer that handles the money transactions."
}

accessLocationContactId  → contacts  (Will contain the bank location that handles the money transactions.)

{
  "name": "accessLocationContactId",
  "type": "foreignKey",
  "table": "contacts",
  "note": "Will contain the bank location that handles the money transactions."
}

buyerAccessOfficerContactId  → contacts  (Will contain the bank officer that handles the buyers transactions.)

{
  "name": "buyerAccessOfficerContactId",
  "type": "foreignKey",
  "table": "contacts",
  "note": "Will contain the bank officer that handles the buyers transactions."
}

buyerAccessLocationContactId  → contacts  (Will contain the bank location that handles the buyers transactions.)

{
  "name": "buyerAccessLocationContactId",
  "type": "foreignKey",
  "table": "contacts",
  "note": "Will contain the bank location that handles the buyers transactions."
}

buyerAccessLocation   (Buyers access location)

{
  "name": "buyerAccessLocation",
  "type": "text",
  "maxLength": 150,
  "note": "Buyers access location"
}

buyerAccessOfficer   (Name of the officer that will handle the buyers money transactions.)

{
  "name": "buyerAccessOfficer",
  "type": "text",
  "maxLength": 150,
  "note": "Name of the officer that will handle the buyers money transactions."
}

earliestAccessDateComment T

{
  "name": "earliestAccessDateComment",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_EARLIESTACCESSDATECOMMENT_URGENT (Snarast)",
    "ENUMS_EARLIESTACCESSDATECOMMENT_IMMEDIATELY (Omgående)",
    "ENUMS_EARLIESTACCESSDATECOMMENT_ACCORDING_TO_AGREEMENT (Enligt överenskommelse)",
    "ENUMS_EARLIESTACCESSDATECOMMENT_DISCUSSION (Diskuteras)"
  ]
}

sellAsCompany bit  (Only used for commercial)

{
  "name": "sellAsCompany",
  "type": "bit",
  "note": "Only used for commercial"
}

assignmentIsTerminated bit

{
  "name": "assignmentIsTerminated",
  "type": "bit"
}

assignmentTerminatedDate

{
  "name": "assignmentTerminatedDate",
  "type": "date"
}

assignmentTerminatedReason

{
  "name": "assignmentTerminatedReason",
  "type": "text"
}

valuationDate

{
  "name": "valuationDate",
  "type": "date"
}

sellerContactReferralChannelId  → contactReferralChannels

{
  "name": "sellerContactReferralChannelId",
  "type": "foreignKey",
  "table": "contactReferralChannels"
}

quotationDueDate

{
  "name": "quotationDueDate",
  "type": "date"
}

quotationComment

{
  "name": "quotationComment",
  "type": "text",
  "maxLength": 100
}

isPublished bit  (Deprecated: Use dealMarketingplaces)

{
  "name": "isPublished",
  "type": "bit",
  "isDeprecated": "true",
  "note": "Deprecated: Use dealMarketingplaces"
}

updatedDate

{
  "name": "updatedDate",
  "type": "updated"
}

Collections

[
  "buyerGroups",
  "buyerSettlementAmounts",
  "dealCostAmounts",
  "dealUrls",
  "estates",
  "filesInDeal",
  "imagesInDeals",
  "receipts",
  "sellerSettlementAmounts",
  "sellers",
  "teamRoles",
  "versions",
  "viewings"
]

Referenced by

biddings as dealId
brokerJournalEntries as dealId
buyerGroups as dealId
buyerSettlementAmounts as dealId (connection table to amounts via amountId)
contactSignatures as dealId
contacts as newDevelopmentDealId
dealAdditions as dealId
dealBrokerJournalFlowStepProgress as dealId
dealCashDefinitiveStatementAmounts as dealId
dealComments as dealId (connection table to comments via commentId)
dealContacts as dealId
dealCostAmounts as dealId (connection table to amounts via amountId)
dealDocumentBundles as dealId
dealGeographicalAreas as dealId (connection table to geographicalAreas via geographicalAreaId)
dealInvoices as dealId
dealMarketingPlaces as dealId
dealProviderServices as dealId
dealReceipts as dealId
dealSignatures as dealId
dealUrls as dealId
digitalSignatures as dealId
estates as dealId
filesInDeals as dealId (connection table to files via fileId)
finishedDealSections as dealId
formInvitations as dealId
imagesInDeals as dealId
invoicingInformation as dealId
letters as dealId
matchingHistory as dealId
newDevelopmentDeals as projectDealId, dealId
newDevelopmentProperties as dealId
newspaperAds as dealId
sellerSettlementAmounts as dealId (connection table to amounts via amountId)
sellers as dealId
servicesInDeals as dealId
teamRoles as dealId
versions as dealId
viewings as dealId