| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SCS_SU_GUID | SU within SCS, for a Period and Measurement Type | varbinary | 16 | 0 | | | | |
| 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | | | |
| 4 | OBJTYPE | Object Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | OBJNR | Object Number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 6 | PFROM | Period Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | PTO | Period End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | PURPOSE | Purpose of Apportionment | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | MEAS | Measurement Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | PLENGTH | Number of days | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | CC_OBJNR | Object Number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 12 | IS_MEAS_REF | Is Reference for Other SUs with Same RO + Measurement | char | 1 | 0 | | | | Allow NULL? |
| 13 | REF2EQUAL_SU | GUID on Entries of SU with Same RO and Measurement | varbinary | 16 | 0 | | | | |
| 14 | REF2SIM_SU | GUID on Entries of SU for Measurement Type for Simulation | varbinary | 16 | 0 | | | | |
| 15 | REF2REST_SU | GUID for Entries of a SU for Remaining Apportionment | varbinary | 16 | 0 | | | | |
| 16 | REF2MSUSEGUID | Settlement GUID of Separate Master SU Settlement | varbinary | 16 | 0 | | | | |
| 17 | REF2MSUSESUGUID | SU GUID in Separate Master SU Settlement | varbinary | 16 | 0 | | | | |
| 18 | MEASUSEDALT | Alternative Measurement Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | APPORTVALUE | Reference Factor | decimal | 20 | 8 | | | | |
| 20 | APPORTVALUEOPT | Part of the Reference Factor that Opts | decimal | 20 | 8 | | | | |
| 21 | SHARE_PERCENT | Share of Apportionment as Percentage | decimal | 5 | 2 | | | | |
| 22 | AFCMETHOD | Calculation Method for Reference Factor | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | VACANCY_PERCENT | Vacancy Percentage Rate, Responsibility of Landlord | decimal | 5 | 2 | | | | |
| 25 | SUM_EQUINUM | Equivalence Number | decimal | 20 | 8 | | | | |
| 26 | SUM_EQUINUMUNIT | Measurement Unit for Assignment of Participating SUs | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | SUM_PERCENT | Percentage rate predistribution cross settlement unit | decimal | 5 | 2 | | | | |
| 28 | HOW_DISTRIBUTE | Type of Predistribution | char | 1 | 0 | | | | Allow NULL? |
| 29 | REST_OBJECT | Obj. number for posting remaining amount for master SU | nvarchar | 22 | 0 | | | | Allow NULL? |
| 30 | RESTNEGALLOWED | Negative Consumption Remainder Allowed | char | 1 | 0 | | | | Allow NULL? |
| 31 | HAS_CHILD | Is Settlement Unit a Master Settlement Unit | char | 1 | 0 | | | | Allow NULL? |
| 32 | HAS_PARENT | Settlement Unit Has Superordinate Settlement Unit | char | 1 | 0 | | | | Allow NULL? |
| 33 | HAS_RESTOBJ | Remainder Object Was Defined for Master SU | char | 1 | 0 | | | | Allow NULL? |
| 34 | CURRENCY | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 35 | NETAMOUNT | Net Amount | decimal | 22 | 8 | | | | |
| 36 | NONDEDTAXAMT | Non-Deductible Tax Amount | decimal | 22 | 8 | | | | |
| 37 | DEDTAXAMOUNT | Deductible Tax Amount | decimal | 22 | 8 | | | | |
| 38 | HAS_COSTS | Costs Were Posted on the Object | char | 1 | 0 | | | | Allow NULL? |
| 39 | HEATING_SYS | Data Exchange Settlement Unit (Currently Not Used) | nvarchar | 13 | 0 | | | | Allow NULL? |
| 40 | ACCFIRM | Settlement company indicator | nvarchar | 3 | 0 | | | | Allow NULL? |
| 41 | IS_CREDITSSU | Is SU a Credit-Side Settlement Unit | char | 1 | 0 | | | | Allow NULL? |
| 42 | IS_ONLY4MEAS | Settlement Unit Data Record for Retrieval of Measurement | char | 1 | 0 | | | | Allow NULL? |
| 43 | IS_ONLY4OPTRATE | Settlement Unit Data Record for Retrieving Option Rate | char | 1 | 0 | | | | Allow NULL? |
| 44 | IS_ROOT_SU | Is Root Settlement Unit | char | 1 | 0 | | | | Allow NULL? |
| 45 | IS_RESTOBJ | Object Is Remainder Object | char | 1 | 0 | | | | Allow NULL? |
| 46 | REASONFORENTRY | Reason for Entry | nvarchar | 3 | 0 | | | | Allow NULL? |
| 47 | PROCESSGUID | Generic Key of Process | varbinary | 16 | 0 | | | | |
