| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | ORCALC_GUID | Identification of an Option Rate Determination Run | varbinary | 16 | 0 | RAW | | No | VIITORCALC | REITORCALC_GUID | |
| 3 | OBJNR | ID of Object for which Option Rate Was Determined | nvarchar | 22 | 0 | CHAR | (N' ') | No | VIITORCOBJ | REITOBJNR | Allow NULL? |
| 4 | SUBOBJNR | ID of Subordinate Objects | nvarchar | 22 | 0 | CHAR | (N' ') | No | * | REITSUBOBJNR | Allow NULL? |
| 5 | OBJNRCN | ID of Occupancy Contract or Future Occupancy Contract | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | REITOBJNRCN | Allow NULL? |
| 6 | SUMNOTOPT | Total: Measurement Amounts Not Opting | decimal | 20 | 8 | DEC | ((0)) | Yes | | REITSUMNOTOPT | |
| 7 | SUMOPT | Total: Measurement Amounts Opting | decimal | 20 | 8 | DEC | ((0)) | Yes | | REITSUMOPT | |
| 8 | OPTRATE | Calculated Option Rate of Subobject | decimal | 9 | 6 | DEC | ((0)) | Yes | | REITOPTRATESUB | |
| 9 | ISVACANT | Rental Object Vacant | char | 1 | 0 | CHAR | (N' ') | Yes | | REITISVACANT | Allow NULL? |
| 10 | HASNXTCN | Rental Object is Vacant, Renewal Contract Sought | char | 1 | 0 | CHAR | (N' ') | Yes | | REITHASNXTCN | Allow NULL? |
| 11 | ISINDEPCN | Option Rate Independent of Contract | char | 1 | 0 | CHAR | (N' ') | Yes | | REITISINDEPCN | Allow NULL? |