Bewerken: Space

Sectie: Properties

Reden:

## Properties

| 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 |  |