Table : servicesInDeals

Raw table description

Fields

id id

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

dealId M  → deals

{
  "name": "dealId",
  "type": "foreignKey",
  "table": "deals",
  "mandatory": "true"
}

serviceId M  → services

{
  "name": "serviceId",
  "type": "foreignKey",
  "table": "services",
  "mandatory": "true",
  "schema": "mspx_admin"
}

contactId  → contacts

{
  "name": "contactId",
  "type": "foreignKey",
  "table": "contacts"
}

cost $$

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

externalId

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

description

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

isDelivered bit

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

isDeliveryAccepted bit

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

hasChanged bit  (Set to 0 or null when viewed.)

{
  "name": "hasChanged",
  "type": "bit",
  "note": "Set to 0 or null when viewed."
}

createdDate

{
  "name": "createdDate",
  "type": "timestamp"
}

updatedDate

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

Referenced by

serviceDeliveries as servicesInDealId