Table : organizationUnits

Raw table description

Fields

id id

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

parentUnitId  → organizationUnits

{
  "name": "parentUnitId",
  "type": "foreignKey",
  "table": "organizationUnits"
}

name M

{
  "name": "name",
  "type": "text",
  "maxLength": 60,
  "mandatory": "true"
}

legalName

{
  "name": "legalName",
  "type": "text",
  "maxLength": 60
}

identifier

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

plusgiroNumber

{
  "name": "plusgiroNumber",
  "type": "text",
  "maxLength": 15
}

bankgiroNumber

{
  "name": "bankgiroNumber",
  "type": "text",
  "maxLength": 15
}

dueDays

{
  "name": "dueDays",
  "type": "int",
  "default": "30"
}

invoiceNumber

{
  "name": "invoiceNumber",
  "type": "text",
  "maxLength": 20
}

invoiceNumberIncrement   (Not in use!)

{
  "name": "invoiceNumberIncrement",
  "type": "text",
  "maxLength": 20,
  "note": "Not in use!"
}

receiptNumber

{
  "name": "receiptNumber",
  "type": "text",
  "maxLength": 20
}

invoiceAttention

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

invoiceStreetAddress

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

invoicePostalCode

{
  "name": "invoicePostalCode",
  "type": "text",
  "maxLength": 20
}

invoiceCity

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

invoiceEmail

{
  "name": "invoiceEmail",
  "type": "text",
  "maxLength": 80
}

isInvoiceUnit bit

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

printCity

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

documentFooterLeft

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

documentFooterCenter

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

documentFooterRight

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

alias

{
  "name": "alias",
  "type": "text",
  "maxLength": 3
}

documentFooterUpperShowOrgAlias bit

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

documentFooterUpperShowBrokerAlias bit

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

documentFooterUpperShowPropertyName bit

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

documentFooterUpperShowPropertyAddress bit

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

documentFooterUpperShowDealToken bit

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

documentFooterUpperShowArchiveNumber bit

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

phoneNumber

{
  "name": "phoneNumber",
  "type": "text",
  "maxLength": 25
}

faxNumber

{
  "name": "faxNumber",
  "type": "text",
  "maxLength": 25
}

email

{
  "name": "email",
  "type": "text",
  "maxLength": 80
}

websiteUrl

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

vatPercentage

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

invoiceTermsOfPayment

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

printDocumentHeaderLogoFileId  → files

{
  "name": "printDocumentHeaderLogoFileId",
  "type": "foreignKey",
  "table": "files"
}

streetAddress

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

postalCode

{
  "name": "postalCode",
  "type": "text",
  "maxLength": 20
}

city

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

archiveNumber

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

fTaxVATDescription

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

latitude

{
  "name": "latitude",
  "type": "text",
  "maxLength": 22
}

longitude

{
  "name": "longitude",
  "type": "text",
  "maxLength": 22
}

zoomLevel

{
  "name": "zoomLevel",
  "type": "smallint"
}

defaultMapLatitude

{
  "name": "defaultMapLatitude",
  "type": "text",
  "maxLength": 22
}

defaultMapLongitude

{
  "name": "defaultMapLongitude",
  "type": "text",
  "maxLength": 22
}

customerNumber

{
  "name": "customerNumber",
  "type": "text",
  "maxLength": 10,
  "readOnly": true
}

envelopeType E  (The default size for envelopes is C5.)

{
  "name": "envelopeType",
  "type": "enum",
  "enums": [
    "ENUMS_ORGANIZATION_ENVELOPE_TYPE_V2 (V2)",
    "ENUMS_ORGANIZATION_ENVELOPE_TYPE_H2 (H2)",
    "ENUMS_ORGANIZATION_ENVELOPE_TYPE_C4V2 (C4V2)",
    "ENUMS_ORGANIZATION_ENVELOPE_TYPE_C4H2 (C4H2)"
  ],
  "note": "The default size for envelopes is C5."
}

leadForwardEmail

{
  "name": "leadForwardEmail",
  "type": "text",
  "maxLength": 80
}

businessInsideEUOutsideSweden bit

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

businessOutsideEUOutsideSweden bit

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

vatNumber

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

companyHeadquarters

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

isPublished bit  (Used to mark orgUnits that should be displayed on website)

{
  "name": "isPublished",
  "type": "bit",
  "note": "Used to mark orgUnits that should be displayed on website"
}

presentation   (Text to be displayed with the orgUnit on website)

{
  "name": "presentation",
  "type": "text",
  "note": "Text to be displayed with the orgUnit on website"
}

updatedDate

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

Collections

[
  "children",
  "staff"
]

Referenced by

contactOrganizationUnits as organizationUnitId (connection table to contacts via contactId)
customFields as organizationUnitId
customFieldsGroups as organizationUnitId
deals as organizationUnitId
documentBundles as organizationUnitId
documents as organizationUnitId
estateTenantsSubObjectTypes as organizationUnitId
housingAssociations as organizationUnitId
invoicingInformation as organizationUnitId
locationDescriptions as organizationUnitId
matchingAttributes as organizationUnitId
memoPad as organizationUnitId
organizationFiles as organizationUnitId
organizationUnitInvoices as organizationUnitId
organizationUnitSidelines as organizationUnitId (connection table to sidelines via sidelineId)
organizationUnits as parentUnitId
queryFilterOrganizationUnits as organizationUnitId (connection table to queryFilters via queryFilterId)
staff as organizationUnitId