Bewerken: RentableRealEstTaxAdmLine

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `RretalId` | nvarchar(10) | Nee | — | — |
| `RretalContext` | bigint | Nee | ((0)) | — |
| `RretalRecStatus` | int | Nee | ((0)) | — |
| `RretalAction` | nvarchar(3) | Ja | — | — |
| `RretalCompId` | nvarchar(6) | Nee | — | — |
| `RretalCostBasicRent` | decimal(21,5) | Nee | ((0)) | — |
| `RretalCostBusinessSpace` | decimal(21,5) | Nee | ((0)) | — |
| `RretalCostCaravanStand` | decimal(21,5) | Nee | ((0)) | — |
| `RretalCostCaretaker` | decimal(21,5) | Nee | ((0)) | — |
| `RretalCostCleanSharedSpcs` | decimal(21,5) | Nee | ((0)) | — |
| `RretalCostEnergySharedSpcs` | decimal(21,5) | Nee | ((0)) | — |
| `RretalCostGarage` | decimal(21,5) | Nee | ((0)) | — |
| `RretalCostSrvAndRecrSpace` | decimal(21,5) | Nee | ((0)) | — |
| `RretalExported` | smallint | Nee | ((0)) | — |
| `RretalFileType` | nvarchar(3) | Ja | — | — |
| `RretalMutationEndDate` | date | Ja | — | — |
| `RretalMutationStartDate` | date | Ja | — | — |
| `RretalNewVdrId` | nvarchar(6) | Ja | — | — |
| `RretalRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `RretalRemovalReason` | smallint | Nee | ((0)) | — |
| `RretalRretarId` | nvarchar(10) | Ja | — | — |
| `RretalSpcAdrCity` | nvarchar(40) | Ja | — | — |
| `RretalSpcAdrHouseLetter` | nvarchar(1) | Ja | — | — |
| `RretalSpcAdrHouseNumber` | nvarchar(30) | Ja | — | — |
| `RretalSpcAdrHouseNumberDes` | nvarchar(2) | Ja | — | — |
| `RretalSpcAdrHouseNumberSuf` | nvarchar(10) | Ja | — | — |
| `RretalSpcAdrLocation` | nvarchar(60) | Ja | — | — |
| `RretalSpcAdrStreet` | nvarchar(80) | Ja | — | — |
| `RretalSpcAdrZipCode` | nvarchar(10) | Ja | — | — |
| `RretalSpcId` | nvarchar(40) | Ja | — | — |
| `RretalSpcTaxAdmCode` | nvarchar(14) | Ja | — | — |
| `RretalSpcTaxAdmDisHousing` | smallint | Nee | ((0)) | — |
| `RretalSpcTaxAdmLrgHousehold` | smallint | Nee | ((0)) | — |
| `RretalSpcTaxAdmSpaceCode` | smallint | Nee | ((0)) | — |
| `RretalTaxNumberNewVendor` | int | Nee | ((0)) | — |
| `RretalTaxSubNumberNewVendor` | int | Nee | ((0)) | — |
| `RretalVdrId` | nvarchar(6) | Ja | — | — |
| `RretalDataProvider` | nvarchar(50) | Ja | — | — |
| `RretalProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `RretalTransferNextTime` | smallint | Nee | ((0)) | — |
| `RretalExternalId` | nvarchar(50) | Ja | — | — |
| `RretalExternalStatus` | nvarchar(50) | Ja | — | — |