title: "RentableRealEstateConlCostM (table)" category: reference tags: [table, rentablerealestateconlcostm, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.RentableRealEstateConlCostM
Schema: dba
Aantal kolommen: 23
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
RntreclcmId |
nvarchar(9) | Nee | — | — |
RntreclcmDescr |
nvarchar(200) | Ja | — | — |
RntreclcmContext |
bigint | Nee | ((0)) | — |
RntreclcmRecStatus |
int | Nee | ((0)) | — |
RntreclcmCompId |
nvarchar(6) | Nee | — | — |
RntreclcmConlcmcId |
nvarchar(9) | Ja | — | — |
RntreclcmEmpId |
nvarchar(9) | Ja | — | — |
RntreclcmEndDate |
date | Ja | — | — |
RntreclcmExported |
smallint | Nee | ((0)) | — |
RntreclcmMutation |
decimal(21,5) | Nee | ((0)) | — |
RntreclcmPercentage |
decimal(21,2) | Nee | ((0)) | — |
RntreclcmPrevPrice |
decimal(21,5) | Nee | ((0)) | — |
RntreclcmPrevVatPerc |
decimal(21,2) | Nee | ((0)) | — |
RntreclcmPrevVatPrice |
decimal(21,5) | Nee | ((0)) | — |
RntreclcmPrice |
decimal(21,5) | Nee | ((0)) | — |
RntreclcmPricePerDay |
decimal(21,5) | Nee | ((0)) | — |
RntreclcmReason |
nvarchar(250) | Ja | — | — |
RntreclcmRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
RntreclcmRntreclId |
nvarchar(9) | Ja | — | — |
RntreclcmStartDate |
date | Ja | — | — |
RntreclcmVatId |
nvarchar(3) | Ja | — | — |
RntreclcmVatpercentage |
decimal(21,2) | Nee | ((0)) | — |
RntreclcmVatPrice |
decimal(21,5) | Nee | ((0)) | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("RentableRealEstateConlCostM")Alle kolommen met types, triggers, computed. Bron:database-schema.json.