Table : commissions

Raw table description

Fields

id id

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

minimumCommissionFee $$

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

maximumCommissionFee $$

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

estimatedPaymentDate

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

payedDate

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

discountPercentage

{
  "name": "discountPercentage",
  "type": "percentage"
}

discountAmount $$

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

isDiscountInPercentage bit

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

isIncludeInSettlement bit

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

commissionSum $$

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

commissionBaseFee $$

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

commissionType E

{
  "name": "commissionType",
  "type": "enum",
  "enums": [
    "ENUM_COMMISSION_TYPE_FIXED_PRICE (Fastprisuppdrag)",
    "ENUM_COMMISSION_TYPE_PERCENTAGE (Procent)",
    "ENUM_COMMISSION_TYPE_MIXED (Fastprisuppdrag och procent)"
  ]
}

showBrokerAccountInSettlement bit

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

showDealTokenInSettlement bit  (Depends on, showBrokerAccountInSettlement and isIncludeInSettlement)

{
  "name": "showDealTokenInSettlement",
  "type": "bit",
  "note": "Depends on, showBrokerAccountInSettlement and isIncludeInSettlement"
}

companyCutPercentage

{
  "name": "companyCutPercentage",
  "type": "percentage"
}

showCutInReports bit

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

isSoldWithoutVAT bit

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

updatedDate

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

Collections

[
  "commissionCuts",
  "commissionIntervals"
]

Referenced by

commissionCuts as commissionId
commissionIntervals as commissionId
deals as commissionId