title: "Space" category: reference tags: [entity, space, datamodel] source: Entities.xml date: 2026-04-17 status: published
Space
Type: Entity Properties: 163 Contexts: 4 Statussen: 2
DB-schema:
lookup_table_schema("Space")· ../tables/Space
Contextsbewerken
- 0: Ruimte (
SpaceContext.None) - 1: Ruimte (
SpaceContext.Space) - 2: Verhuurbare eenheid (
SpaceContext.RentableRealEstate) - 4: Parkeerplaats (
SpaceContext.ParkingSpace)
Statussenbewerken
- -1: Trash (
SpaceStatus.Trash) - 0: None (
SpaceStatus.None)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | SPCID | 40 | false | |
| Address | Address | SPCADRID | true | ||
| BimGuid | UltimoString | SPCBIMGUID | 50 | true | |
| BlockedBy | List[SpaceHierarchy] | SPCHSPCID | false | ||
| Blocks | List[SpaceHierarchy] | SPCHPARTOFSPCID | false | ||
| BuildingFloor | BuildingFloor | SPCBLDID, SPCBLDPID, SPCBLDFID | true | , , | |
| CadDocument | Document | SPCCADDOCID | true | ||
| CadHandle | UInt64 | SPCCADHANDLE | false | 0 | |
| CadHandleDocument | Document | SPCCADHANDLEDOCID | true | ||
| CadIdHandle | UInt64 | SPCCADIDHANDLE | false | 0 | |
| CadReportColor | UltimoString | SPCCADREPORTCOLOR | 6 | true | |
| CadReportPattern | CadReportPattern | SPCCRPTPID | true | ||
| CadReportPatternAngle | Int32 | SPCCADREPORTPATTERNANGLE | false | 0 | |
| CadReportPatternScale | Decimal | SPCCADREPORTPATTERNSCALE | false | 0 | |
| Capacity | Decimal | SPCCAPACITY | false | 0 | |
| Class | UltimoString | SPCCLASS | 2 | true | |
| CleanupTime | Int32 | SPCDEFCLEANINGTIME | false | 0 | |
| Context | Context | SPCCONTEXT | false | 1 | |
| CopyFromSpace | Space | SPCCOPYFROMSPCID | true | ||
| CostCenter | CostCenter | SPCCCRID | true | ||
| CostYear1 | CompanyMoney | SPCCOSTYEAR1 | false | 0 | |
| CostYear10 | CompanyMoney | SPCCOSTYEAR10 | false | 0 | |
| CostYear11 | CompanyMoney | SPCCOSTYEAR11 | false | 0 | |
| CostYear12 | CompanyMoney | SPCCOSTYEAR12 | false | 0 | |
| CostYear13 | CompanyMoney | SPCCOSTYEAR13 | false | 0 | |
| CostYear14 | CompanyMoney | SPCCOSTYEAR14 | false | 0 | |
| CostYear15 | CompanyMoney | SPCCOSTYEAR15 | false | 0 | |
| CostYear16 | CompanyMoney | SPCCOSTYEAR16 | false | 0 | |
| CostYear17 | CompanyMoney | SPCCOSTYEAR17 | false | 0 | |
| CostYear18 | CompanyMoney | SPCCOSTYEAR18 | false | 0 | |
| CostYear19 | CompanyMoney | SPCCOSTYEAR19 | false | 0 | |
| CostYear2 | CompanyMoney | SPCCOSTYEAR2 | false | 0 | |
| CostYear20 | CompanyMoney | SPCCOSTYEAR20 | false | 0 | |
| CostYear21 | CompanyMoney | SPCCOSTYEAR21 | false | 0 | |
| CostYear22 | CompanyMoney | SPCCOSTYEAR22 | false | 0 | |
| CostYear23 | CompanyMoney | SPCCOSTYEAR23 | false | 0 | |
| CostYear24 | CompanyMoney | SPCCOSTYEAR24 | false | 0 | |
| CostYear25 | CompanyMoney | SPCCOSTYEAR25 | false | 0 | |
| CostYear26 | CompanyMoney | SPCCOSTYEAR26 | false | 0 | |
| CostYear27 | CompanyMoney | SPCCOSTYEAR27 | false | 0 | |
| CostYear28 | CompanyMoney | SPCCOSTYEAR28 | false | 0 | |
| CostYear29 | CompanyMoney | SPCCOSTYEAR29 | false | 0 | |
| CostYear3 | CompanyMoney | SPCCOSTYEAR3 | false | 0 | |
| CostYear30 | CompanyMoney | SPCCOSTYEAR30 | false | 0 | |
| CostYear31 | CompanyMoney | SPCCOSTYEAR31 | false | 0 | |
| CostYear32 | CompanyMoney | SPCCOSTYEAR32 | false | 0 | |
| CostYear33 | CompanyMoney | SPCCOSTYEAR33 | false | 0 | |
| CostYear34 | CompanyMoney | SPCCOSTYEAR34 | false | 0 | |
| CostYear35 | CompanyMoney | SPCCOSTYEAR35 | false | 0 | |
| CostYear36 | CompanyMoney | SPCCOSTYEAR36 | false | 0 | |
| CostYear37 | CompanyMoney | SPCCOSTYEAR37 | false | 0 | |
| CostYear38 | CompanyMoney | SPCCOSTYEAR38 | false | 0 | |
| CostYear39 | CompanyMoney | SPCCOSTYEAR39 | false | 0 | |
| CostYear4 | CompanyMoney | SPCCOSTYEAR4 | false | 0 | |
| CostYear40 | CompanyMoney | SPCCOSTYEAR40 | false | 0 | |
| CostYear5 | CompanyMoney | SPCCOSTYEAR5 | false | 0 | |
| CostYear6 | CompanyMoney | SPCCOSTYEAR6 | false | 0 | |
| CostYear7 | CompanyMoney | SPCCOSTYEAR7 | false | 0 | |
| CostYear8 | CompanyMoney | SPCCOSTYEAR8 | false | 0 | |
| CostYear9 | CompanyMoney | SPCCOSTYEAR9 | false | 0 | |
| DataProvider | UltimoString | SPCDATAPROVIDER | 50 | true | |
| Department | Department | SPCDEPID | true | ||
| Description | UltimoString | SPCDESCR | 200 | true | |
| EmailAddress | UltimoString | SPCEMAILADDRESS | 80 | true | |
| Employees | List[Employee] | EMPSPCID | true | ||
| EquipmentFloorArea | Decimal | SPCFLOORNETTINSTM2 | false | 0 | |
| Equipments | List[Equipment] | EQMSPCID | true | ||
| ExchangeClientState | UltimoString | SPCEXCHANGECLIENTSTATE | 50 | true | |
| ExchangeDeltaLink | UltimoString | SPCEXCHANGEDELTALINK | true | ||
| ExchangePreviousPushMessageDate | DateTime? | SPCEXCHANGEPREVIOUSPUSHMESSAGEDATE | true | ||
| ExchangeSubscriptionId | UltimoString | SPCEXCHANGESUBSCRIPTIONID | 200 | true | |
| Exported | Boolean | SPCEXPORTED | false | ||
| ExternalId | UltimoString | SPCEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | SPCEXTERNALSTATUS | 50 | true | |
| Extra | UltimoString | SPCHOUSENUMBEREXTRA | 6 | true | |
| Finishings | List[SpaceFinishing] | SPCFINSPCID | true | ||
| FloorNetArea | Decimal | SPCFLOORNETTM2 | false | ||
| FloorTareArea | Decimal | SPCFLOORTAREM2 | false | ||
| FreeHeight | Decimal | SPCFREEHEIGHT | false | 0 | |
| GrossExternalArea | Decimal | SPCFLOORGROSSM2 | false | 0 | |
| GrossHeight | Decimal | SPCGROSSHEIGHT | false | 0 | |
| HorizontalCirculationArea | Decimal | SPCFLOORNETTTRAFHORM2 | false | 0 | |
| ImageFile | UltimoString | SPCIMAGEFILE | true | ||
| ImportReservationsFromExchange | Boolean | SPCIMPORTRESERVATIONSFROMEXCHANGE | false | 0 | |
| Inventories | List[SpaceInventory] | SPCISPCID | false | ||
| InvoiceGroup | InvoiceGroup | SPCINVGID | true | ||
| IsDeliverySpace | Boolean | SPCISDELIVERYSPACE | false | 0 | |
| Maintenances | List[SpaceMaintenance] | SPCMSPCID | true | ||
| MinimumCapacity | Decimal | SPCMINCAPACITY | false | 0 | |
| NetHeight | Decimal | SPCNETTHEIGHT | false | 0 | |
| NetUsableArea | Decimal | SPCFLOORNETTUSABM2 | false | 0 | |
| ObjectFeatures | List[ObjectFeature] | OBJFSPCID | true | ||
| PreparationTime | Int32 | SPCDEFPREPARETIME | false | 0 | |
| ProviderMutationDate | DateTime? | SPCPROVIDERMUTDATE | true | ||
| Purpose | Purpose | SPCPURID | true | ||
| RecordChangeDate | DateTime? | SPCRECCHANGEDATE | true | ||
| RecordCreateDate | DateTime? | SPCRECCREATEDATE | true | SYSDATETIME | |
| Rentable | Boolean | SPCRENTABLE | false | 0 | |
| RentableRealEstateStartDate | Date? | SPCRENTREALESTATESTARTDATE | true | ||
| RentalHourlyTariff | CompanyMoney | SPCRENTHOURTARIFF | false | 0 | |
| RentType | RentType | SPCRNTTID | true | ||
| Reservable | Boolean | SPCRESERVABLE | false | ||
| ReservableObject | ReservableObject | SPCRESOID | true | ||
| RoomNumber | UltimoString | SPCROOMNR | 11 | true | |
| SafetyClass | SafetyClass | SPCSFCID | true | ||
| SendReservationsToExchange | Boolean | SPCSENDRESERVATIONSTOEXCHANGE | false | 0 | |
| Setups | List[SpaceSetup] | SPCSSPCID | false | ||
| Site | Site | SPCSITID | true | ||
| SpaceSetupType | SpaceSetupType | SPCSPCSTID | true | ||
| SpaceType | SpaceType | SPCSPCTID | true | ||
| StateAgenda | StateAgenda | SPCSTATAID | true | ||
| Status | Status | SPCRECSTATUS | false | ||
| SystemCompany | Company | SPCCOMPID | false | ||
| TaxAdministrationCode | UltimoString | SPCTAXADMCODE | 14 | true | |
| TaxAdministrationDisabledHousing | Boolean | SPCTAXADMDISABLEDHOUSING | false | 0 | |
| TaxAdministrationLargeHousehold | Boolean | SPCTAXADMLARGEHOUSEHOLD | false | 0 | |
| TaxAdministrationSpaceCode | Int16 | SPCTAXADMSPACECODE | false | 0 | |
| Text | UltimoString | SPCTEXT | true | ||
| TransferNextTime | Boolean | SPCTRANSFERNEXTTIME | false | ||
| Vendor | Vendor | SPCVDRID | true | ||
| VerticalCirculationArea | Decimal | SPCFLOORNETTTRAFVERTM2 | false | 0 | |
| WallArea | Decimal | SPCWALLM2 | false | 0 | |
| Year1 | Int16 | SPCYEAR1 | false | ||
| Year10 | Int16 | SPCYEAR10 | false | ||
| Year11 | Int16 | SPCYEAR11 | false | ||
| Year12 | Int16 | SPCYEAR12 | false | ||
| Year13 | Int16 | SPCYEAR13 | false | ||
| Year14 | Int16 | SPCYEAR14 | false | ||
| Year15 | Int16 | SPCYEAR15 | false | ||
| Year16 | Int16 | SPCYEAR16 | false | ||
| Year17 | Int16 | SPCYEAR17 | false | ||
| Year18 | Int16 | SPCYEAR18 | false | ||
| Year19 | Int16 | SPCYEAR19 | false | ||
| Year2 | Int16 | SPCYEAR2 | false | ||
| Year20 | Int16 | SPCYEAR20 | false | ||
| Year21 | Int16 | SPCYEAR21 | false | ||
| Year22 | Int16 | SPCYEAR22 | false | ||
| Year23 | Int16 | SPCYEAR23 | false | ||
| Year24 | Int16 | SPCYEAR24 | false | ||
| Year25 | Int16 | SPCYEAR25 | false | ||
| Year26 | Int16 | SPCYEAR26 | false | ||
| Year27 | Int16 | SPCYEAR27 | false | ||
| Year28 | Int16 | SPCYEAR28 | false | ||
| Year29 | Int16 | SPCYEAR29 | false | ||
| Year3 | Int16 | SPCYEAR3 | false | ||
| Year30 | Int16 | SPCYEAR30 | false | ||
| Year31 | Int16 | SPCYEAR31 | false | ||
| Year32 | Int16 | SPCYEAR32 | false | ||
| Year33 | Int16 | SPCYEAR33 | false | ||
| Year34 | Int16 | SPCYEAR34 | false | ||
| Year35 | Int16 | SPCYEAR35 | false | ||
| Year36 | Int16 | SPCYEAR36 | false | ||
| Year37 | Int16 | SPCYEAR37 | false | ||
| Year38 | Int16 | SPCYEAR38 | false | ||
| Year39 | Int16 | SPCYEAR39 | false | ||
| Year4 | Int16 | SPCYEAR4 | false | ||
| Year40 | Int16 | SPCYEAR40 | false | ||
| Year5 | Int16 | SPCYEAR5 | false | ||
| Year6 | Int16 | SPCYEAR6 | false | ||
| Year7 | Int16 | SPCYEAR7 | false | ||
| Year8 | Int16 | SPCYEAR8 | false | ||
| Year9 | Int16 | SPCYEAR9 | false | ||
| Zone | Zone | SPCZONID | true |
Brondatabewerken
- Entity-definitie —
lookup_entity("Space")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("Space")· ../tables/Space DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="Space")Before/After Save events voor Space. Bron:workflows.xml.