| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SPC_GUID | GUID for Spaces in Real Estate | varbinary | 16 | 0 | | | | |
| 3 | OBJ_GUID | GUID for Real Estate Object | varbinary | 16 | 0 | | | | |
| 4 | SPACE_TYPE | Building Part Type ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | SPACE_COND | Condition ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | USAGE_TYPE | Usage Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | BLD_STR_TYPE | Real Estate Building Structure ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | SPACE_DESC | Description of Building Part | nvarchar | 30 | 0 | | | | Allow NULL? |
| 9 | NO_UNITS | No of units in real estate object | int | 10 | 0 | | | | Allow NULL? |
| 10 | NO_PARK_UNITS | Number of Parking Units | int | 10 | 0 | | | | Allow NULL? |
| 11 | NO_GARAGES | No of Garages in Real Estate Object | int | 10 | 0 | | | | Allow NULL? |
| 12 | AREA | Total Area of the Real Estate Object | decimal | 13 | 3 | | | | |
| 13 | AREA_UOM | Unit of Measure for Area | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | VOLUME | Volume of Real Estate Object | decimal | 13 | 3 | | | | |
| 15 | VOLUME_UOM | Unit of Measure for Volume of Real Estate | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | AREA_VALUE | Area in the Real Estate which has Collateral Value | decimal | 13 | 3 | | | | |
| 17 | AREA_VALUE_UOM | Unit of Measure for Area | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | VOLUME_VAL | Volume of Real Estate which has Collateral Value | decimal | 13 | 3 | | | | |
| 19 | VOLUME_VALUE_UOM | Unit of Measure for Volume of Real Estate | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | CREATED_BY | Real Estate Add-On User | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | CREATED_DATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | CREATED_TIME | Created At | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 0 | | | | Allow NULL? |
| 24 | LAST_CHG_BY | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | LAST_CHG_DATE | Last Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | | | Allow NULL? |
| 27 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | | | Allow NULL? |
