| 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 | SCS_RO_GUID | Rental Object for an SU, Period and Measurement Type | varbinary | 16 | 0 | RAW | | No | | RESCROGUID | |
| 3 | SCS_SU_GUID | SU within SCS, for a Period and Measurement Type | varbinary | 16 | 0 | RAW | | Yes | VISCS_SU_SUM | RESCSUGUID | |
| 4 | OBJTYPE | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RECAOBJTYPE | Allow NULL? |
| 5 | OBJNR | Object Number of Rental Object | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RESCROOBJNR | Allow NULL? |
| 6 | POINT | Measuring Point | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | RESCPOINT | Allow NULL? |
| 7 | PFROM | Period Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECAPERIODFROM | Allow NULL? |
| 8 | PTO | Period End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECAPERIODTO | Allow NULL? |
| 9 | PURPOSE | Purpose of Apportionment | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TIVSCPURPOSE | RESCFORPURPOSE | Allow NULL? |
| 10 | MEAS | Measurement Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVBDMEAS | REBDMEAS | Allow NULL? |
| 11 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | RAW | | Yes | VISCSETTL | RECASETTLGUID | |
| 12 | PLENGTH | Number of days | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | VVATAGE | Allow NULL? |
| 13 | SCS_PERIOD_GUID | Rental Periods | varbinary | 16 | 0 | RAW | | Yes | VISCS_RENT | RESCPERIODGUID | |
| 14 | APPORTVALUE | Reference Factor | decimal | 20 | 8 | DEC | ((0)) | Yes | | RESCAPPORTVALUE | |
| 15 | APPORTVALUEOPT | Part of the Reference Factor that Opts | decimal | 20 | 8 | DEC | ((0)) | Yes | | RESCAPPORTVALUEOPTING | |
| 16 | APPORTVALUESU | Sum of Reference Factors of Lower-Level Objects | decimal | 20 | 8 | DEC | ((0)) | Yes | | RESCAPPORTVALUESUM | |
| 17 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 18 | NETAMOUNT | Net Amount | decimal | 22 | 8 | DEC | ((0)) | Yes | | RESCNETAMOUNT | |
| 19 | NONDEDTAXAMT | Non-Deductible Tax Amount | decimal | 22 | 8 | DEC | ((0)) | Yes | | RESCNONDEDTAXAMT | |
| 20 | DEDTAXAMOUNT | Deductible Tax Amount | decimal | 22 | 8 | DEC | ((0)) | Yes | | RESCDEDTAXAMT | |
| 21 | HAS_COSTS | Costs Were Posted on the Object | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCHASCOSTS | Allow NULL? |
| 22 | HASCOP | Uses Current Occupancy Principle | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCHASCOP | Allow NULL? |
| 23 | INTERNAL_OBJID | Identification of lease-out at settlement company | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ABNNR | Allow NULL? |
| 24 | EXTERNAL_OBJID | Heating expenses settlement company evaluation group | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | STECHEM | Allow NULL? |
| 25 | DISTCONSUMIND | Type of Distribution of Costs from RO | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RESCDISTROCNIND | Allow NULL? |
| 26 | DISTMEAS | Measurement Type for Distribution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVBDMEAS | RESCMPDISTMEAS | Allow NULL? |
